marchchad / keg-server Goto Github PK

Set up a local mysql database on the raspberry pi.
Database will be used to store information for a configurable amount of time (i.e., n days, weeks, months, etc.).

Implement a method to archive and/or delete local records when confirmation of data present on remote database.

Create local admin application to set for each configured flow meter:

• Keg ID
• Flow rate
• GPIO Pin
• Units (pints vs liters)
• Volume kegged

Expand class to regenerate new JWT every 24 hours.
Ideas:

• create a timing method/class in script
• create a cron job that gets JWT and writes it to config. Update GetToken method to read token from config.

Update any method that uses the socket connections to check for the socket heartbeat.
If no heartbeat is present, establish a new connection.

Related to #6
If no connection can be established, modify storage parameters to keep data for a longer period of time in the event the issue persists.

Create a local config and update .gitignore to exclude it from the repo.

• Config should contain application user name and password.
• Create a template config to include in the repo.

Refactor test script into a production level script using classes and methods.

The class should include:

• Database access to get parameters for:
  • Flow rate
  • Keg id
  • GPIO Pin
  • Units (pints vs liters)
  • Volume kegged

Related to #5
Log info, debug, and error information to database.

Related to #9
Keep file logging as backup in event local database is inaccessible.

Create a method to emit pour data at intervals.
Experiment with different pour intervals.
Likely emit on every 2 - 3 ounces.