• list original filename, then buttons for archive / delete / purge

For each file in the import directory, check to see if it doesn't already exist in the redis queue. If it doesn't exist in the redis import queue, add it for importing.

Advise it's an inferior quality, and advise what quality prevented it from importing.

See https://developer.apple.com/library/archive/documentation/AppleApplications/Reference/SafariWebContent/ConfiguringWebApplications/ConfiguringWebApplications.html#//apple_ref/doc/uid/TP40002051-CH3-SW1

• Create a form for the Reviews page
• Search the library to see if that movie already exists; if so, add the review, if not, pull the movie info from TMDb and add the review

I'm not entirely certain but it feels like when I try to have files in the Import directory added on first startup, that it also delays any background tasks as they also try to import when they start up. Add a button to the Admin page to scan the Import directory and add any files that aren't currently in the import / localization queue, so it's possible to add those files but not have it performed automatically.

• Add navigation tabs for small screen
• Replace spaces in search string with '%' (searching for "Spider Man" should bring up "Spider-Man")
• Create new list filter to show digital versions without a physical equivalent

Physical quality files are only deleted when they're being replaced with another physical-quality file. Send an email to the admin when a physical quality file is replaced so they can pull it from their library for selling/donation.

Add ability to save encoding presets on a movie / tv series / episode / file basis.

• Show last week's worth of imports + 10 latest imports regardless of import date
• Add import date for each entry
• Add link to movie or TV show/season page
• Add special feature type
• Update navigation tabs so it doesn't overflow the screen on small devices

reset_password_request.html and reset_password.html pages are both using Flask WTForms to generate their forms, but it's incompatible with the current version of Bootstrap.

• reset_password_request.html
• reset_password.html

Create a page to show all the actors/actresses across all films, and clicking one should show all the films they were in.

When the watchdog task finds a file in the import directory, it adds the same file to the localization queue multiple times; it appears to be a side-effect of using gunicorn to run the app via multiple workers. It doesn't appear to harm anything, because the redis worker creates a lock on the file so only a single worker can process it at a time, and if a worker gets the task but the file no longer exists in the import directory, the task is discarded. The only issue this appears to cause is the count of items currently in the queue is inflated by ~4x.

Currently, if a movie changes its title or year, the local file and any uploaded files are renamed to match. The problem is that if the uploaded file has been migrated to Glacier Deep Archive, it can't easily be renamed; it needs to be restored, copied to the new name, and the original upload deleted. Since we're not currently checking the storage class status, we just assume that all the remote files are in Deep Archive, and we get an error when we try to restore one of these files for renaming.

To fix this, for any file that needs to be renamed:

• Get the current storage class for the uploaded file
• If the storage class is Standard, copy the file to the new name, delete the original upload, and update the database
• If the storage class is not Standard, request the file to be restored, and schedule a copy/delete/database update task in the future

Files in AWS will be deleted if they're not listed in the Fitzflix database. Make sure this is something that the admin really wants to do before they do it.

Opposite of #45. If a file is in the library database, but isn't in AWS, alert the admin and upload the file if possible.

Adding a rating for a movie should post to the provided Twitter account with the title, year, brief review, and rating.

Right now the index page is the Recently Added page; there should be a user-specific Index page with recommendations.

• Add navigation tabs to small screen sizes

Since this section of the file modification form iterates over all the subtitles, it displays the header "Forced subtitle tracks", but has nothing to iterate.

Non-import tasks are showing up in the Task queue; create an import-only queue to be displayed instead of the Task queue.

It'd be nice to be able to see all the films I have in a particular quality, whether or not it's the best quality for that film (e.g. see all the films I have on DVD).

• Get a list of all AWS objects with the untouched/ prefix
• Search the File table for each object; if it doesn't exist in the File table as aws_untouched_key, delete it from AWS S3 storage

• Add form to delete the file completely

Right now the currently-running tasks don't appear until the page has been open for 5 seconds. They should appear on the initial page load.

• Require admin account and password to proceed
• Add to SQL queue instead of task queue
• Add to start of queue

• Add search field to page
• Update navigation tabs so it doesn't overflow the screen on small devices

Show a random frame from a random movie and let the user try to guess what film it's from.

Three levels of difficulty:

• Easy (select only from movies that have been rated by the user, and provide a limited selection of possible options)
• Difficult (select from all movies, but provide a list of films to choose from)
• "Siracusa" (select from all movies, user has to enter the movie title themselves, do a fuzzy match on the user's input when matching against the movie title)

Bash code to get a random frame:

ms=$(mediainfo --Inform="Video;%Duration%" input.mkv)
secs=$(( ${ms%.*} / 1000 ))
ffmpeg -y -ss $(( $RANDOM % ${secs} )) -i input.mkv -vf "scale='min(1080,iw)':-1" -vframes 1 -q:v 2 output.jpg

It seems like it might delete files from AWS when it shouldn't! Need to scrutinize the logic for migrating a file from one movie to another to make sure it works as expected.