search

mwheelerjr / mptvseries

Automatically exported from code.google.com/p/mptvseries
0 stars 0 forks source link

Maintenance option on files and database #604

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
It would be nice if the plugin could run some maintenance functions.

Check for any 0-byte files on artwork for example.

Or run the following SQL Query to clean up 'ghost' episodes from a bad deleted 
series:

DELETE FROM local_episodes WHERE (SELECT COUNT(*) FROM local_series WHERE 
local_series.id = local_episodes.seriesid) = 0;

The maintenance function could be run automatic like once a week and then an 
option inside configuration screen to force a run, which would be useful on 
issues of re-importing when there are those ghost-dbase entries.

Original issue reported on code.google.com by RoChess....@gmail.com on 16 Sep 2011 at 1:38