From 6963eb6cb0f7d15c97f44b9ca439be321edb8a8f Mon Sep 17 00:00:00 2001
From: dusoleil <howcansocksbereal@gmail.com>
Date: Fri, 26 Aug 2022 20:43:03 -0400
Subject: accidentally wasn't tracking any of the data model objects

---
 data_model/Task.gd | 49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 data_model/Task.gd

(limited to 'data_model/Task.gd')

diff --git a/data_model/Task.gd b/data_model/Task.gd
new file mode 100644
index 0000000..3da0840
--- /dev/null
+++ b/data_model/Task.gd
@@ -0,0 +1,49 @@
+class_name Task
+
+class Task_data:
+    var id
+    var name
+    var description
+    var frequency
+    var estimated_length
+    var date_completed
+
+    func _init(record):
+        self.id = record['id']
+        self.name = record['name']
+        self.description = record['description']
+        self.frequency = record['frequency']
+        self.estimated_length = record['estimated_length']
+        self.date_completed = record['date_completed']
+
+static func get_by_id(id):
+    var record = DBMS.query("""
+            SELECT * FROM "Tasks"
+            WHERE id = ?
+        """,
+        [id])
+    record = record[0]
+    return Task_data.new(record)
+
+static func get_by_timeslot(timeslot_id):
+    var records = DBMS.query("""
+            SELECT "Tasks".* FROM "Tasks"
+            INNER JOIN "TimeSlotTasks" ON "Tasks".id = "TimeSlotTasks".task_id
+            WHERE "TimeSlotTasks".timeslot_id = ?
+        """,
+        [timeslot_id])
+    var tasks = []
+    for record in records:
+        tasks.push_back(Task_data.new(record))
+    return tasks
+
+static func get_by_frequency(frequency):
+    var records = DBMS.query("""
+            SELECT * FROM "Tasks"
+            WHERE frequency = ?
+        """,
+        [frequency])
+    var tasks = []
+    for record in records:
+        tasks.push_back(Task_data.new(record))
+    return tasks
-- 
cgit v1.2.3