blob: ac1a0085405952c5dd6d6de5ef7bb262dd4fac58 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
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
|
