def update_status_actuator(actuatorID, actuatorstatus):
sql = "update actuators set statusactuators = %s where actuatorID = %s"
params = [actuatorstatus, actuatorID]
return Database.execute_sql(sql, params)
def create_inlezing(sensorID, time, waarde, actuatorID=None):
sql = "INSERT INTO inlezingen(sensorID, time, waarde, actuatorID) VALUES (%s,%s,%s,%s)"
params = [sensorID, time, waarde, actuatorID]
return Database.execute_sql(sql, params)