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)