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"
