Create create_table.py

janbodnar · web-flow · commit 4a2b0995e170 · 2020-10-12T12:02:07.000+02:00
diff --git a/create_table.py b/create_table.py
@@ -0,0 +1,20 @@
+#!/usr/bin/python
+
+import sqlite3
+
+con = sqlite3.connect('ydb.db')
+
+with con:
+
+    cur = con.cursor()
+
+    cur.execute("DROP TABLE IF EXISTS cars;")
+    cur.execute("CREATE TABLE cars(id INT, name TEXT, price INT)")
+    cur.execute("INSERT INTO cars VALUES(1,'Audi',52642)")
+    cur.execute("INSERT INTO cars VALUES(2,'Mercedes',57127)")
+    cur.execute("INSERT INTO cars VALUES(3,'Skoda',9000)")
+    cur.execute("INSERT INTO cars VALUES(4,'Volvo',29000)")
+    cur.execute("INSERT INTO cars VALUES(5,'Bentley',350000)")
+    cur.execute("INSERT INTO cars VALUES(6,'Citroen',21000)")
+    cur.execute("INSERT INTO cars VALUES(7,'Hummer',41400)")
+    cur.execute("INSERT INTO cars VALUES(8,'Volkswagen',21600)")
