def get_active_alarms(self):
conn = sqlite3.connect(
'alarm.db') # create file if not exist;connect if exist
cursor = conn.cursor()
cursor.execute("""SELECT * FROM alarms WHERE ACTIVE = TRUE""")
active_alarms_tumple = cursor.fetchall()
cursor.close()
conn.commit()
conn.close()
return [
Alarm.createFromTumple(alarm_tumpe)
for alarm_tumpe in active_alarms_tumple
] #list of alarm objects
