diff options
Diffstat (limited to 'python/db_csvheader.py')
| -rw-r--r-- | python/db_csvheader.py | 13 |
1 files changed, 2 insertions, 11 deletions
diff --git a/python/db_csvheader.py b/python/db_csvheader.py index 4f286584..e476b305 100644 --- a/python/db_csvheader.py +++ b/python/db_csvheader.py @@ -14,14 +14,5 @@ if __name__ == "__main__": with open(f"/home/serenitas/flint/{args.fname}.csv") as csvfile: csvreader = csv.reader(csvfile) for row in csvreader: - sql_str = "INSERT INTO csv_templates values (%s, %s) ON CONFLICT DO NOTHING" - with conn.cursor() as c: - c.execute(sql_str, (args.fname, row)) - c.execute( - "SELECT headers FROM csv_templates where template_name=%s", - (args.fname,), - ) - for row in c: - print(row.headers) - conn.commit() - break + with open(f"headers/bond_upload.py", "w") as template_file: + template_file.write(f"{args.fname}={row}") |
