def postRuuvitagDoor(): content = request.get_json() query = '''INSERT INTO Door_status (OpenOrNot, Door_idDoor) VALUES ("{}", "{}")'''.format(content['OpenOrNot'], content['Door_idDoor']) db.sqlInsert(query) return "Post successful"
def postDevicesImage64(): content = request.get_json() query = '''INSERT INTO Images (Devices_idDevice, Names, images) VALUES ("{}", "{}", "{}")'''.format( content['Devices_idDevice'], content['Names'], content['images']) db.sqlInsert(query) return "Post successful"
def postUpdateDoor(): content = request.get_json() query = '''UPDATE Door SET Devices_idDevice = "{}" WHERE DoorName = "{}"'''.format( content['Devices_idDevice'], content['DoorName']) db.sqlInsert(query) return "Post successful"
def postNewDeviceName(): content = request.get_json() query = '''UPDATE Devices SET DeviceName = "{}" WHERE idDevice = "{}"'''.format(content['DeviceName'], content['idDevice']) db.sqlInsert(query) return "Post successful"
def postDroneDetails(): content = request.get_json() query = '''INSERT INTO Drone_Status (Status, Speed, FlyHeight, Acceleration, Devices_idDevice) VALUES ("{}", "{}", "{}", "{}", "{}")'''.format( content['Status'], content['Speed'], content['FlyHeight'], content['Acceleration'], content['Devices_idDevice']) db.sqlInsert(query) return "Post successful"
def postRuuvitagMessage(): content = request.get_json() query = '''INSERT INTO Message (Messagetype, Explanation, Devices_idDevice) VALUES ("{}", "{}", "{}")'''.format( content['Messagetype'], content['Explanation'], content['Devices_idDevice']) db.sqlInsert(query) return "Post successful"
def postRuuvitagDetails(): content = request.get_json() query = '''INSERT INTO Measurements (Devices_idDevice, Temperature, Humidity, AirPressure) VALUES ("{}", "{}", "{}", "{}")'''.format( content['Devices_idDevice'], content['Temperature'], content['Humidity'], content['AirPressure']) db.sqlInsert(query) return "Post successful"
def postBattery(): content = request.get_json() query = '''INSERT INTO Battery (BatteryStatus, Devices_idDevice) values ('{}','{}')'''.format(content['BatteryStatus'], content['Devices_idDevice']) db.sqlInsert(query) return "Post successful"
def postLocation(): content = request.get_json() query = '''INSERT INTO Location (Segment, Devices_idDevice) values ('{}','{}')'''.format(content['Segment'], content['Devices_idDevice']) db.sqlInsert(query) return "Post successful"
def postNewDoor(): content = request.get_json() query = '''INSERT INTO Door (DoorName, Devices_idDevice) values ('{}','{}')'''.format(content['DoorName'], content['Devices_idDevice']) db.sqlInsert(query) return "Post successful"
def postRuuvitagLimits(): content = request.get_json() query = '''UPDATE Measurements_Limits SET Temperature_max = "{}", Temperature_min = "{}", Humidity_max = "{}", Humidity_min = "{}", AirPressure_max = "{}", AirPressure_min = "{}", Batterylimit = "{}" WHERE Devices_idDevice = "{}"'''.format( content['Temperature_max'], content['Temperature_min'], content['Humidity_max'], content['Humidity_min'], content['AirPressure_max'], content['AirPressure_min'], content['Batterylimit'], content['Devices_idDevice']) db.sqlInsert(query) return "Post successful"
def postEventInactive(): content = request.get_json() query = '''UPDATE Door_status JOIN Door ON Door_status.Door_idDoor = Door.idDoor JOIN Devices ON Door.Devices_idDevice = Devices.idDevice JOIN Location ON Devices.idDevice = Location.Devices_idDevice SET Door_status.Active = "0" WHERE Door_status.Active = "1" AND Location.Segment = "{}"'''.format( content['Segment']) db.sqlInsert(query) return "Post successful"
def postDevicesImage(): content = request.get_json() devID = content["Devices_idDevice"] fileName = content["Names"] fileData = content["images"] # Save image ifh.saveImage(fileName, fileData) query = '''INSERT INTO Images (Devices_idDevice, Names) VALUES ("{}", "{}")'''.format(devID, fileName) db.sqlInsert(query) return "Post successful"
def postDeviceID(): print(request.is_json) content = request.get_json() print(content) query = '''INSERT INTO Testi (testinumeroInt, testichar, testiTeksti, testiTeksti2) values ('{}','{}','{}','{}')'''.format( content['testinumeroINT'], content['testichar'], content['testiTeksti'], content['testiTeksti2']) db.sqlInsert(query) return "Post successful"
def postDooriID(): print(request.is_json) content = request.get_json() print(content) query = '''INSERT INTO doori (DoorName, OpenOrNot) values ('{}','{}')'''.format( content['DoorName'], content['OpenOrNot'], ) db.sqlInsert(query) return "Post successful"
def postInactive(): content = request.get_json() query = '''UPDATE Message SET Active = "0" WHERE idMessage = {}'''.format(content['idMessage']) db.sqlInsert(query) return "Post successful"
def postGopigoBatteryLimits(): content = request.get_json() query = '''UPDATE Measurements_Limits SET Batterylimit = "{}" WHERE Devices_idDevice = "{}"'''.format( content['Batterylimit'], content['Devices_idDevice']) db.sqlInsert(query) return "Post successful"