Python Database.execute_sql Examples

Programming Language: Python

Namespace/Package Name: repositories.Database

Class/Type: Database

Method/Function: execute_sql

Examples at hotexamples.com: 2

Python Database.execute_sql - 2 examples found. These are the top rated real world Python examples of repositories.Database.Database.execute_sql extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

get_one_row(13)

get_rows(10)

execute_sql(2)

Example #1

Show file

 def update_status_actuator(actuatorID, actuatorstatus):
     sql = "update actuators set statusactuators = %s where actuatorID = %s"
     params = [actuatorstatus, actuatorID]
     return Database.execute_sql(sql, params)

Example #2

Show file

 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)