From c4e9e26ac6f960e5c05e5ba6cfcb32f8c3a9a89b Mon Sep 17 00:00:00 2001 From: gamesguru Date: Sat, 29 May 2021 17:20:44 -0400 Subject: [PATCH] python 3.4.3 compliant --- sql/__init__.py | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/sql/__init__.py b/sql/__init__.py index 9769f29..77776ac 100644 --- a/sql/__init__.py +++ b/sql/__init__.py @@ -21,7 +21,7 @@ def build_ntsqlite(verbose=False): os.remove(NT_DB_NAME) if verbose: - print(f"\nPack {NT_DB_NAME}") + print("\nPack %s" % NT_DB_NAME) con = sqlite3.connect(NT_DB_NAME) cur = con.cursor() @@ -43,7 +43,10 @@ def build_ntsqlite(verbose=False): reader = csv.DictReader(csv_file) values = ",".join("?" * len(reader.fieldnames)) reader = csv.reader(csv_file) - cur.executemany(f"INSERT INTO {table_name} VALUES ({values});", reader) + query = "INSERT INTO {0} VALUES ({1});".format( # nosec: B608 + table_name, values + ) + cur.executemany(query, reader) cur.close() con.commit() -- 2.52.0