aboutsummaryrefslogtreecommitdiffstats
path: root/todb.py
diff options
context:
space:
mode:
authordennis <d@ennis.no>2023-01-31 21:13:35 +0100
committerdennis <d@ennis.no>2023-01-31 21:13:35 +0100
commit9cb0e8739b00337dc70aa3a0909f4880f2d5b5e1 (patch)
tree077e9f0d6fc3ab236cb2d86f20416e7ef8550571 /todb.py
parentadded queue, in case db-connection is down (diff)
downloadenergyscripts-9cb0e8739b00337dc70aa3a0909f4880f2d5b5e1.tar.gz
use new db thingy
Diffstat (limited to 'todb.py')
-rw-r--r--todb.py3
1 files changed, 2 insertions, 1 deletions
diff --git a/todb.py b/todb.py
index d911a29..e5988cd 100644
--- a/todb.py
+++ b/todb.py
@@ -11,7 +11,8 @@ pg_pass = os.environ['el_pg_pass']
def todb(sql, values):
with psycopg.connect(dbname=pg_db, host=pg_host, user=pg_user, password=pg_pass) as conn:
if type(values) == list:
- conn.executemany(sql, values)
+ cur = conn.cursor()
+ cur.executemany(sql, values)
elif type(values) == tuple:
conn.execute(sql, values)
else: