Python MySQLdb.complete_statement Beispiele

Beispiel #1

Datei: initialize_DB_Tables.py Projekt: tfischer4765/Store_MQTT_Data_in_Database

TableSchema = """
drop table if exists DHT22_Temperature_Data ;
create table DHT22_Temperature_Data (
  id integer primary key autoincrement,
  SensorID text,
  Date_n_Time text,
  Temperature text
);


drop table if exists DHT22_Humidity_Data ;
create table DHT22_Humidity_Data (
  id integer primary key autoincrement,
  SensorID text,
  Date_n_Time text,
  Humidity text
);
"""

# Connect or Create DB File
conn = MySQLdb.connect(DB_Name)
curs = conn.cursor()

# Create Tables
MySQLdb.complete_statement(TableSchema)
curs.executescript(TableSchema)

# Close DB
curs.close()
conn.close()