Keep set/rep history in SQLite db

[tlancon]

No description provided.

[tlancon]

What to log

Per set

• Set ID (datetime as YYMMDDHHMMSS)
• Video filepath
• Log filepath
• Lift
• Weight
• Calibration colors
• Nominal diameter
• Pixel calibration factor
• Number of reps
• Lifter name

Per rep

• Rep ID
• Average velocity
• Peak velocity
• Peak power
• Height at peak
• X ROM
• Y ROM
• Concentric time
• Lift
• False
• Pass/fail

Prerequisites

• Add mechanism for user to input name in UI; save it to settings
• Write the pixel calibration factor back to the set metadata
• Break the rep metadata out into its own dictionary
• Create rep ID string
• Add ability to relabel exercise in UI Add ability to label exercises in log interface correctly #8
• Add ability to flag rep as false positive in UI Add ability to flag false or failed reps in log interface #7
• Change log and video filepaths to depend on the rep ID and exercise name Move build_filepaths into utilities.py #20
• Integrate specific pass/fail criteria default for each lift Make setting to control pass/fail criteria of each exercise #18
• Add p/f metric/condition to rep DB Add pass/fail, pf_metric, and pf_condition to rep table in DB #26

[tlancon]

This is implemented and is successful in initial testing. Any bugs that arise can be logged and fixed as they occur