Talk:Databases: Difference between revisions
Jump to navigation
Jump to search
>TiloWiki No edit summary |
>TiloWiki |
||
| Line 15: | Line 15: | ||
==Example for update on Watched== | ==Example for update on Watched== | ||
* [[User:TiloWiki|TiloWiki]] 20:25, 31 March 2013 (EDT) | * [[User:TiloWiki|TiloWiki]] 20:25, 31 March 2013 (EDT) | ||
* Here a simple example to update the watched flag based on a folder | * Here a simple example to update the watched flag based on a folder path of the movie/TV show | ||
** I couldn’t update with the movieview (DB view) therefore I used the "where .. in (Select ..." | |||
* With slight modification you can use this to set watched for movies added before date X. | |||
<syntaxhighlight lang="SQL"> | <syntaxhighlight lang="SQL"> | ||
--Check with this SQL | --Check with this SQL | ||
Revision as of 05:02, 1 April 2013
TO-DO (what needs to be added to this database article)
- The layout, etc. will be explained in more detail here later.
- Need to add music database information
These don't exist in MyMusic32 or MyVideos75, but will need confirmation as to whether or not they will be in the future: MyMusic32:
- exartistablum - Links artists to albums
- exartistsong - Links artists to songs
- exgenrealbum - Links genres to albums
- exgenresong - Links genres to songs
- thumb
MyVideos75
- tvshowlinkepisode - This table links TV shows (series) to episodes.
Example for update on Watched
- TiloWiki 20:25, 31 March 2013 (EDT)
- Here a simple example to update the watched flag based on a folder path of the movie/TV show
- I couldn’t update with the movieview (DB view) therefore I used the "where .. in (Select ..."
- With slight modification you can use this to set watched for movies added before date X.
--Check with this SQL select * from files where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%') --Update with this SQL update files set playcount = '1', lastplayed = '2013-03-30 17:55:55' where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%')