def load_all_devices_with_status_by(room: Room) -> [DeviceWithStatus]:
sql = "SELECT device.*, ds.status FROM device JOIN device_status ds on device.device_id = ds.device_id WHERE location='{}' ORDER BY device.device_id".format(
room.value)
return load_all(sql, cast_device_with_status)
def load_all_devices() -> [Device]:
sql = "SELECT * FROM device ORDER BY device_id"
return load_all(sql, cast_device)
def load_all_devices_with_status() -> [DeviceWithStatus]:
sql = "SELECT device.*, ds.status FROM device JOIN device_status ds on device.device_id = ds.device_id ORDER BY device.device_id"
return load_all(sql, cast_device_with_status)
def load_all_sensor_data() -> [SensorData]:
sql = "SELECT * FROM sensor_data ORDER BY published_time"
return load_all(sql, cast_sensor_data)
def load_sensor_data_for(sensor: Sensor, timerange) -> [SensorData]:
timerange_query = get_timerange_query(timerange)
sql = 'SELECT * FROM sensor_data WHERE sensor_id={}{} ORDER BY published_time'.format(
sensor.id, timerange_query)
return load_all(sql, cast_sensor_data)
def load_sensors_by_room(room: Room) -> [Sensor]:
sql = "SELECT * FROM sensor WHERE location='{}'".format(room.value)
return load_all(sql, cast_sensor)
def load_all_sensors() -> [Sensor]:
sql = "SELECT * FROM sensor ORDER BY sensor_id"
return load_all(sql, cast_sensor)
def load_all_groups() -> [Group]:
sql = "SELECT * FROM device_group"
return load_all(sql, cast_group)
def load_schedules_for(group_id: str) -> [Schedule]:
sql = "SELECT * FROM schedule WHERE group_id='{}'".format(group_id)
return load_all(sql, cast_schedule)
def load_all_schedules() -> [Schedule]:
sql = "SELECT * FROM schedule"
return load_all(sql, cast_schedule)