Being able to refer to any frame by a frame_id or by a movie_id and a frame_number means that I frequently need two code paths. There is no reason to do this. I want to delete the frame_id.
[ ] Remove frame_id from all API calls and verify that all code still works.
[ ] Add movie_id and frame_number to all tables that have frame_id as a key.
[ ] Fill in movie_id and frame_number with a fancy SQL update statement.
[ ] Index by movie_id and frame_number
[ ] Drop the frame_id constraints, indexes and columns.
[ ] Update all SQL statements in db.py.
[ ] Start to move to object-based API in db.py for movie and frame access.
Being able to refer to any frame by a frame_id or by a movie_id and a frame_number means that I frequently need two code paths. There is no reason to do this. I want to delete the frame_id.
movie_id
andframe_number
to all tables that haveframe_id
as a key.movie_id
andframe_number
with a fancy SQL update statement.movie_id
andframe_number
frame_id
constraints, indexes and columns.