summaryrefslogtreecommitdiffstats
path: root/data_model/TimeSlot.gd
diff options
context:
space:
mode:
Diffstat (limited to 'data_model/TimeSlot.gd')
-rw-r--r--data_model/TimeSlot.gd78
1 files changed, 39 insertions, 39 deletions
diff --git a/data_model/TimeSlot.gd b/data_model/TimeSlot.gd
index 80b7671..ac1a008 100644
--- a/data_model/TimeSlot.gd
+++ b/data_model/TimeSlot.gd
@@ -1,39 +1,39 @@
-class_name TimeSlot
-
-class TimeSlot_data:
- var id
- var schedule_id
- var start_time
- var end_time
- var name
- var date_completed
-
- func _init(record):
- self.id = record['id']
- self.schedule_id = record['schedule_id']
- self.start_time = record['start_time']
- self.end_time = record['end_time']
- self.name = record['name']
- self.date_completed = record['date_completed']
-
-static func get_by_id(id):
- var record = DBMS.query("""
- SELECT * FROM "TimeSlots"
- WHERE id = ?
- """,
- [id])
- record = record[0]
- return TimeSlot_data.new(record)
-
-static func get_by_schedule_name(schedule_name):
- var records = DBMS.query("""
- SELECT "TimeSlots".* FROM "TimeSlots"
- JOIN "Schedules" ON "TimeSlots".schedule_id = "Schedules".id
- WHERE "Schedules".name = ?
- ORDER BY "TimeSlots".start_time
- """,
- [schedule_name])
- var timeslots = []
- for record in records:
- timeslots.push_back(TimeSlot_data.new(record))
- return timeslots
+class_name TimeSlot
+
+class TimeSlot_data:
+ var id
+ var schedule_id
+ var start_time
+ var end_time
+ var name
+ var date_completed
+
+ func _init(record):
+ self.id = record['id']
+ self.schedule_id = record['schedule_id']
+ self.start_time = record['start_time']
+ self.end_time = record['end_time']
+ self.name = record['name']
+ self.date_completed = record['date_completed']
+
+static func get_by_id(id):
+ var record = DBMS.query("""
+ SELECT * FROM "TimeSlots"
+ WHERE id = ?
+ """,
+ [id])
+ record = record[0]
+ return TimeSlot_data.new(record)
+
+static func get_by_schedule_name(schedule_name):
+ var records = DBMS.query("""
+ SELECT "TimeSlots".* FROM "TimeSlots"
+ JOIN "Schedules" ON "TimeSlots".schedule_id = "Schedules".id
+ WHERE "Schedules".name = ?
+ ORDER BY "TimeSlots".start_time
+ """,
+ [schedule_name])
+ var timeslots = []
+ for record in records:
+ timeslots.push_back(TimeSlot_data.new(record))
+ return timeslots