From b6698810b9ff40a2d91b71c61017667642db212a Mon Sep 17 00:00:00 2001 From: root Date: Sat, 22 Jan 2022 16:47:15 +0000 Subject: Date functionality, inserting into sql --- date.py | 10 ++++++++++ heating.py | 8 ++++---- 2 files changed, 14 insertions(+), 4 deletions(-) create mode 100644 date.py diff --git a/date.py b/date.py new file mode 100644 index 0000000..d04d76a --- /dev/null +++ b/date.py @@ -0,0 +1,10 @@ +import time +from datetime import datetime + +class date: + def __init__(): + pass + def day(): + int(datetime.now().strftime('%Y%m%d')) + def time(): + int(datetime.now().strftime('%H%M%S')) diff --git a/heating.py b/heating.py index ab058d6..757f877 100644 --- a/heating.py +++ b/heating.py @@ -2,6 +2,7 @@ from abc import ABC, abstractmethod from circular_queue import circular_queue import time import os +import date # Abstract Class for heating class heating(ABC): @@ -9,6 +10,7 @@ class heating(ABC): self.temperature = 0 self.target = 19 self.on = False + self.date = date.date() self.db = db self.queue = circular_queue(20) @@ -30,16 +32,14 @@ class heating(ABC): else: self.on = False self.turn_off() - """ self.db.exec( "insert into temperature values (?,?,?,?)", - (date, time, self.temperature, self.target), + (date.day(), date.time(), self.temperature, self.target), ) self.db.exec( "insert into history values (?,?,?)", - (date, time, heatingon(int)), + (date.day(), date.time(), heatingon(int)), ) - """ """ Abstract methods used so that configuration for different -- cgit v1.2.3