Skip to content
Snippets Groups Projects

Introduce SQL client, commit activity to db

Merged willm3 requested to merge wmalisch/dev into main
4 files
+ 39
2
Compare changes
  • Side-by-side
  • Inline
Files
4
+ 10
2
from sense_hat import SenseHat
from sense_hat import SenseHat
from scipy.signal import find_peaks
from scipy.signal import find_peaks
 
from sqlite_db_client import SQLiteDBClient
 
from pathlib import Path
 
import numpy as np
import numpy as np
import time
import time
import csv
import csv
from pathlib import Path
class Activity:
class Activity:
def __init__(self, sense):
def __init__(self, sense):
self.sense = sense
self.sense = sense
 
self.db_client = SQLiteDBClient('Activity.db')
 
self.db_client.connect()
def record(self):
def record(self):
@@ -58,7 +62,11 @@ class Activity:
@@ -58,7 +62,11 @@ class Activity:
steps, _ = find_peaks(magnitudes, height=(std_dev + mean))
steps, _ = find_peaks(magnitudes, height=(std_dev + mean))
print(len(steps))
print(len(steps))
# TODO: Update mongodb or some other database system
# Update SQLite database with the recorded activity
 
end_date = time.strftime('%Y-%m-%d')
 
end_time = time.strftime('%H:%M:%S')
 
steps_count = len(steps)
 
self.db_client.update_activity_entry(timestamp, end_date, end_time, steps_count)
return True
return True
Loading