flags

[Ivoc]

Hi
sorry for my english
I need to know how to delete in one shot all the flags on "saw movie"
Is it any possibility? one by one is a big job

thanks
cheers
Ivo

[mike]

Direct changing via sql should be possible:

Code:

griffith --shell
>>> from sqlalchemy.sql import update
>>> query = update(db.tables.movies, values={'seen': False})
>>> sess.execute(query)
>>> sess.commit()

[Ivoc]

Thanks for your reply, but this is it very complicate. Can you explain me step by step? I really don't know how to do this.

Many thanks in advance
cheers
Ivo

[Hernals]

In my german version I activated "Ansicht" - "Erweiterungen", then a new toolbar appeared with three buttons. One  is to "mark all currently selected movies as seen".

By the way, is it possible to preselect (predefine) new movies as "seen"?

[CinéphOli]

In sqliteman:

Code:

UPDATE movies SET seen=0 ;

Thanks for your reply, but this is it very complicate. Can you explain me step by step? I really don't know how to do this.

• open a console/terminal
• type griffith --shell
• you get the prompt >>>
• type in the four lines indicated by mike (do not type >>>, press enter/return after each line)
• you are done.
• type quit() to quit the Griffith shell.
• close the console/terminal.

If you are not sure of yourself, test first on a copy of your database.

[CinéphOli]

By the way, is it possible to preselect (predefine) new movies as "seen"?

CAUTION: tempering with the data structure itself is potentially hazardous… Test on a copy!

Well, in theory it is very simple, all you have to do is ALTER the structure of the table movies so that the field seen has a default value of 1:

Code:

ALTER TABLE movies
      MODIFY seen BOOLEAN NOT NULL DEFAULT (1) ;

But I don't think sqlite3 (sqliteman?) allows ALTERing the tables, it copies all the data to a new temporary table with the new structure then deletes the old table and renames the new one. But when I tried this with sqliteman, all info concerning the FOREIGN KEYS were lost in the process, so bad idea I would say…

Maybe SQL Alchemy handles this better ?

Now, if your database happens to be in PostgreSQL / MySQL / MSQL instead of sqlite3, then you are lucky, because I think those formats will handle the ALTER command properly. Not sure though, to be verified…

[mike]

@CinéphOli
Thanks for your good explanations.

@Hernals
In rev. 1562 I added the ability to set a default value for the field "seen it". It will be available with the next version of griffith.