Create parameterized_query.py

janbodnar · web-flow · commit a83bfa9e17ca · 2020-10-12T12:05:16.000+02:00
diff --git a/parameterized_query.py b/parameterized_query.py
@@ -0,0 +1,15 @@
+#!/usr/bin/python
+
+import sqlite3
+
+uId = 1
+uPrice = 62300
+
+con = sqlite3.connect('ydb.db')
+
+with con:
+
+    cur = con.cursor()
+    cur.execute("UPDATE cars SET price=? WHERE id=?", (uPrice, uId))
+
+    print(f"Number of rows updated: {cur.rowcount}")
