From 1a00106ace53373b82daca5fdb1fbb133260ec37 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Chrisu=20J=C3=A4hnl?= Date: Thu, 10 May 2018 21:12:56 +0000 Subject: [PATCH] =?utf8?q?Anpassungen=20f=C3=BCr=20mysql=20Datenbankfelder?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- seewasser.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/seewasser.py b/seewasser.py index a65d8c7..40d2455 100755 --- a/seewasser.py +++ b/seewasser.py @@ -68,9 +68,9 @@ def writesensordatadb(config, sensor_id, sensor_name, timestamp, value_type, val host = config.get('database','hostname') db = config.get('database','database') - engine = create_engine('mysql+mysqldb://{}:{}@{}/{}'.format(user, pwd, host, db), echo=True) + engine = create_engine('mysql+mysqldb://{}:{}@{}/{}'.format(user, pwd, host, db), echo=False) conn = engine.connect() - conn.execute("insert into sensors (sensor_id, sensor_name, value_type, value_raw, value, timestamp) values (?,?,?,?,?,?)", sensor_id, sensor_name, value_type, value_raw, value, timestamp) + conn.execute("insert into sensors (sensor_id, sensor_name, value_type, value_raw, value, timestamp) values (%s,%s,%s,%s,%s,%s)", sensor_id, sensor_name, value_type, value_raw, value, timestamp) conn.close() -- 2.47.3