5 Commits (mike/database/initial)

Author	SHA1	Message	Date
Mike Lang	0a31ba2590	database: Add column video_id for storing upload-location-specific metadata for identifying video ... ie. for youtube, the video id.	6 years ago
Mike Lang	47868f956d	database: Rename start/end to event_start/end, add channel and quality ... * Had to rename `end` as `end` is a reserved word in postgres SQL. `event_end` is more consistent with `video_end` anyway. Updated `start` to match. * Added ability to specify channel and stream quality in the editor, which may prove useful if we have issues with a particular stream quality, or if content needs to be captured from other channels.	6 years ago
Mike Lang	437d38e646	DATABASE.md: Add image_links column ... This solves the problem of rows which don't need a full cut video, but we'd like to link to an image or a short gif or clip of it. It is a sheet input that is only used in the output sheet, so it doesn't affect the wubloader itself.	6 years ago
Mike Lang	ef0a78fce3	Updates to database states and columns ... Split UPLOADED into TRANSCODING and DONE, to represent the time after upload that youtube is transcoding the video and it's not viewable. Any cutter can poll for the state of a transcoding video and mark it as done. Add some extra sheet input columns.	6 years ago
Mike Lang	6b3a0fea9f	Add a doc covering how the database is used ... I fully expect the exact list of sheet inputs, edit inputs and outputs to change. The important thing I wanted to codify here was the state machine and the behaviour of the cutters.	6 years ago