Create no_commit.py

janbodnar · web-flow · commit 63aaffac654b · 2020-10-12T12:07:52.000+02:00
diff --git a/no_commit.py b/no_commit.py
@@ -0,0 +1,32 @@
+#!/usr/bin/python
+
+import sqlite3
+import sys
+
+con = None
+
+try:
+    con = sqlite3.connect('ydb.db')
+    
+    cur = con.cursor()
+    cur.execute("DROP TABLE IF EXISTS friends")
+    cur.execute("CREATE TABLE friends(id INTEGER PRIMARY KEY, name TEXT)")
+    cur.execute("INSERT INTO friends(name) VALUES ('Tom')")
+    cur.execute("INSERT INTO friends(name) VALUES ('Rebecca')")
+    cur.execute("INSERT INTO friends(name) VALUES ('Jim')")
+    cur.execute("INSERT INTO friends(name) VALUES ('Robert')")
+
+    #con.commit()
+
+except sqlite3.Error as e:
+
+    if con:
+        con.rollback()
+
+    print(e)
+    sys.exit(1)
+
+finally:
+
+    if con:
+        con.close()
