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)