[Request] Cleaning out library and removing non existing items

[UnR34L]

Is there a way to remove old junk items without having to go through it all and manually removing ?
From what I can see there's no indication in library view if the item has a file on disk.

To maintain large libraries over time we need a way to see (at least) and remove old junk items. Ideally a feature that checked the database for stale items would be amazing.

[nosmokingbandit]

Depends on what you mean by "junk." You can go into library/manage and select movies based on quality profile or status and remove them in bulk there.

…

On Mon, Jul 9, 2018 at 10:13 AM UnR34L ***@***.***> wrote: Is there a way to remove old junk items without having to go through it all and manually removing ? From what I can see there's no indication in library view if the item has a file on disk. To maintain large libraries over time we need a way to see (at least) and remove old junk items. Ideally a feature that checked the database for stale items would be amazing. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#258>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKX1SShoWPBmipkcAkfeqLhAqGWC4Y_fks5uE2T9gaJpZM4VHyE4> .

[UnR34L]

non existing items

Delete a bunch of files, it's a decent sized library, how would I go about removing that stuff from watcher ?

If it showed the status (if there's a file for that item) in watcher, I could see that and bulk remove them.

[nosmokingbandit]

Added in
9a6d136.

See settings/system to configure.

[UnR34L]

Waiting on #264 before I can test.

[UnR34L]

I'm getting hit with errors, turned on debugging, this is the relevant entries.

INFO [2018-07-29 18:11:00,043] core.ajax.manual_task_execute.1326: Manually executing task Missing Files Scan.
INFO [2018-07-29 18:11:00,043] CPTaskScheduler._task.248: == Executing Task: Missing Files Scan Per User Command ==
DEBUG [2018-07-29 18:11:00,047] core.sqldb.execute.156: Executing SQL command: ['SELECT * FROM MOVIES WHERE finished_file is not null']
WARNING [2018-07-29 18:11:00,049] CPTaskScheduler._task.266: Scheduled Task Missing Files Scan Failed:
Traceback (most recent call last):
File "/usr/local/Watcher3/lib/cherrypyscheduler.py", line 264, in _task
self.task()
File "/usr/local/Watcher3/core/library.py", line 718, in scanmissingfiles
movies = core.sql.proxy_to_dict(movies)
AttributeError: 'SQL' object has no attribute 'proxy_to_dict'
DEBUG [2018-07-29 18:11:00,053] core.sqldb.row_exists.580: Checking if name="Missing Files Scan" exists in database table TASKS
DEBUG [2018-07-29 18:11:00,053] core.sqldb.execute.156: Executing SQL command: ['SELECT 1 FROM TASKS WHERE name="Missing Files Scan"']
DEBUG [2018-07-29 18:11:00,055] core.sqldb.update.235: Updating last_execution to 2018-07-29 18:11:00 for rows that match name:Missing Files Scan in TASKS.
DEBUG [2018-07-29 18:11:00,056] core.sqldb.execute.156: Executing SQL command: ['UPDATE TASKS SET last_execution=? WHERE name=?', ('2018-07-29 18:11:00', 'Missing Files Scan')]
INFO [2018-07-29 18:11:00,062] CPTaskScheduler._task.273: == Finished Task: Missing Files Scan ==
INFO [2018-07-29 18:11:06,886] core.ajax.get_log_text.512: Dumping log file log.txt to text.

Thanks for working on this.

[nosmokingbandit]

Should be working as expected in 0d99d98 Just a careless error on my part, easy enough to correct. Let me know if this gives the results you were looking for.

…

On Sun, Jul 29, 2018 at 1:15 PM UnR34L ***@***.***> wrote: I'm getting hit with errors, turned on debugging, this is the relevant entries. INFO [2018-07-29 18:11:00,043] core.ajax.manual_task_execute.1326: Manually executing task Missing Files Scan. INFO [2018-07-29 18:11:00,043] CPTaskScheduler._task.248: == Executing Task: Missing Files Scan Per User Command == DEBUG [2018-07-29 18:11:00,047] core.sqldb.execute.156: Executing SQL command: ['SELECT * FROM MOVIES WHERE finished_file is not null'] WARNING [2018-07-29 18:11:00,049] CPTaskScheduler._task.266: Scheduled Task Missing Files Scan Failed: Traceback (most recent call last): File "/usr/local/Watcher3/lib/cherrypyscheduler.py", line 264, in _task self.task() File "/usr/local/Watcher3/core/library.py", line 718, in scanmissingfiles movies = core.sql.proxy_to_dict(movies) AttributeError: 'SQL' object has no attribute 'proxy_to_dict' DEBUG [2018-07-29 18:11:00,053] core.sqldb.row_exists.580: Checking if name="Missing Files Scan" exists in database table TASKS DEBUG [2018-07-29 18:11:00,053] core.sqldb.execute.156: Executing SQL command: ['SELECT 1 FROM TASKS WHERE name="Missing Files Scan"'] DEBUG [2018-07-29 18:11:00,055] core.sqldb.update.235: Updating last_execution to 2018-07-29 18:11:00 for rows that match name:Missing Files Scan in TASKS. DEBUG [2018-07-29 18:11:00,056] core.sqldb.execute.156: Executing SQL command: ['UPDATE TASKS SET last_execution=? WHERE name=?', ('2018-07-29 18:11:00', 'Missing Files Scan')] INFO [2018-07-29 18:11:00,062] CPTaskScheduler._task.273: == Finished Task: Missing Files Scan == INFO [2018-07-29 18:11:06,886] core.ajax.get_log_text.512: Dumping log file log.txt to text. Thanks for working on this. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#258 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKX1SQ_6mRRbxYVeapKpoHMbp1DK3p3qks5uLe3OgaJpZM4VHyE4> .

[UnR34L]

Works great, thanks!