Keep set/rep history in SQLite db

[tlancon]

Keep set/rep history in SQLite db

[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 #8
• Add ability to flag rep as false positive in UI #7
• Change log and video filepaths to depend on the rep ID and exercise name #20
• Integrate specific pass/fail criteria default for each lift #18
• Add p/f metric/condition to rep DB #26

[tlancon]

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