def save_sensor_data(sensor_data):
query = "INSERT INTO sensor_data(type1, value1, type2, value2, status, sensor_id, published_time) VALUES ('{}', {}, '{}', {}, '{}', {}, '{}')".format(
sensor_data['values'][0]['type'], sensor_data['values'][0]['value'],
sensor_data['values'][1]['type'], sensor_data['values'][1]['value'],
sensor_data['status'], sensor_data['sensor_id'],
sensor_data['timestamp'])
save(query)
def save_device(device: Device):
query = "INSERT INTO device(device_id, name, location, type) VALUES ({}, '{}', '{}', '{}')".format(
device.device_id, device.name, device.location.value,
device.device_type.value)
save(query)
def delete_device_by(device_id: int):
query = 'DELETE FROM device WHERE device_id={}'.format(device_id)
save(query)
def update_device(device: Device):
query = "UPDATE device SET name='{}', location='{}', type='{}' WHERE device_id={}".format(
device.name, device.location.value, device.device_type.value,
device.device_id)
save(query)
def delete_sensor_by_id(sensor_id):
sql = 'DELETE FROM sensor WHERE sensor_id={}'.format(sensor_id)
save(sql)
def save_sensor(sensor):
query = "INSERT INTO sensor(sensor_id, name, location, code, type, sampling_rate) VALUES ({}, '{}', '{}', '{}', '{}', {})".format(
sensor['id'], sensor['name'], sensor['location'], sensor['code'],
sensor['type'], sensor['sampling_rate'])
save(query)
def save_group(group: Group):
query = "INSERT INTO device_group(group_id, name, delay, ids, status) VALUES ('{}', '{}', {}, '{}', '{}')".format(
group.group_id, group.name, group.delay_in_ms,
','.join(map(str, group.ids)), group.status.value)
return save(query)
def update_sensor(sensor):
query = "UPDATE sensor SET name='{}', location='{}', code='{}', type='{}', sampling_rate={} WHERE sensor_id={}".format(
sensor['name'], sensor['location'], sensor['code'], sensor['type'],
sensor['sampling_rate'], sensor["id"])
save(query)
def update_group(group: Group):
query = "UPDATE device_group SET name='{}', delay={}, ids='{}', status='{}' WHERE group_id='{}'".format(
group.name, group.delay_in_ms, ','.join(map(str, group.ids)),
group.status.value, group.group_id)
save(query)
def delete_group(group_id: str):
query = "DELETE FROM device_group WHERE group_id='{}'".format(group_id)
save(query)
def delete_schedule(schedule_id):
query = "DELETE FROM schedule WHERE schedule_id={}".format(schedule_id)
save(query)
def update_schedule(schedule: Schedule):
query = "UPDATE schedule SET device_id='{}', status='{}', days='{}', time='{}' WHERE schedule_id={}".format(
','.join(map(str, schedule.device_id)), schedule.status, schedule.days,
schedule.time, schedule.schedule_id)
save(query)
return schedule.schedule_id
def save_device_status(device_status: DeviceStatus):
query = "INSERT INTO device_status(device_id, status) VALUES ({}, '{}')".format(
device_status.device_id, device_status.status.value)
save(query)
def delete_device_status_for(device_id: int):
query = "DELETE FROM device_status WHERE device_id={}".format(device_id)
save(query)
def update_device_status(device_status: DeviceStatus):
query = "UPDATE device_status SET status='{}' WHERE device_id={}".format(
device_status.status.value, device_status.device_id)
save(query)
