cursors, placeholders

Kepka · Kepka · commit fa9923537db2 · 2022-05-18T11:55:18.000+02:00
diff --git a/createDB/checkdb.py b/createDB/checkdb.py
@@ -2,7 +2,9 @@
 
 conn = sqlite3.connect("contacts.sqlite")
 
-for row in conn.execute("SELECT * FROM contacts"):
+name = input("Please enter a name to search for: ")
+
+for row in conn.execute("SELECT * FROM contacts WHERE name = ?", (name,)):
     print(row)
 
 conn.close()
diff --git a/createDB/contacts.sqlite b/createDB/contacts.sqlite
diff --git a/createDB/contacts2.py b/createDB/contacts2.py
@@ -2,10 +2,17 @@
 
 db = sqlite3.connect("contacts.sqlite")
 
-update_sql = "UPDATE contacts SET email = 'update@update.com' WHERE contacts.phone = 1234"
+new_email = "another.update@update.com"
+phone = input("Please enter the phone number: ")
+
+# update_sql = f"UPDATE contacts SET email = {new_email} WHERE contacts.phone = {phone}"
+update_sql = f"UPDATE contacts SET email = ? WHERE contacts.phone = ?"
+print(update_sql)
+
 update_cursor = db.cursor()
-update_cursor.execute(update_sql)
-print(f"{update_cursor.rowcount} rows updated")
+update_cursor.execute(update_sql, (new_email, phone))
+# update_cursor.executescript(update_sql)
+# print(f"{update_cursor.rowcount} rows updated")
 
 update_cursor.connection.commit()
 update_cursor.close()
