aboutsummaryrefslogtreecommitdiffstats
path: root/python/db_csvheader.py
diff options
context:
space:
mode:
Diffstat (limited to 'python/db_csvheader.py')
-rw-r--r--python/db_csvheader.py13
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}")