Create import_table.py

janbodnar · web-flow · commit 6bd80fc0f1cf · 2020-10-12T12:07:37.000+02:00
diff --git a/import_table.py b/import_table.py
@@ -0,0 +1,31 @@
+#!/usr/bin/python
+
+import sqlite3
+
+
+def readData():
+
+    f = open('cars.sql', 'r')
+
+    with f:
+
+        data = f.read()
+
+        return data
+
+
+con = sqlite3.connect(':memory:')
+
+with con:
+
+    cur = con.cursor()
+
+    sql = readData()
+    cur.executescript(sql)
+
+    cur.execute("SELECT * FROM cars")
+
+    rows = cur.fetchall()
+
+    for row in rows:
+        print(row)
