Date functionality, inserting into sql

2 files changed, 14 insertions, 4 deletions

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