sqlite3.py 437 B

123456789101112131415
  1. import sqlite3
  2. from structures.measurement import CurrentMeasurement
  3. class Database():
  4. def __init__(self):
  5. self.con = sqlite3.connect('sqlite3.db')
  6. with self.con.cursor() as cur:
  7. cur.execute("CREATE TABLE current (timestamp text, source text, channel int, value real")
  8. cur.commit()
  9. def write(self, meas: CurrentMeasurement):
  10. with self.con.cursor() as cur:
  11. cur.execute("INSERT INTO current VALUES (")