Sqlite3 Tutorial Query Python Fixed

with sqlite3.connect("my_database.db") as conn: cursor = conn.cursor() # your queries here # Automatically commits and closes

: Provide the actual values as a second argument—specifically in a # The "Fixed" and Secure way = sqlite3.connect( = conn.cursor() # Alex used a '?' placeholder cookie_name Oatmeal Raisin SELECT * FROM inventory WHERE name = ? # He passed the variable in a tuple (note the comma!) cursor.execute(query, (cookie_name,)) = cursor.fetchone() print(result) Use code with caution. Copied to clipboard Advanced Fixing: The "List" Problem sqlite3 tutorial query python fixed

import csv with open("data.csv") as f, conn: reader = csv.reader(f) conn.executemany("INSERT INTO users (name,email) VALUES (?,?)", reader) with sqlite3

def add_user(name, email): with db_connection() as conn: cursor = conn.cursor() cursor.execute( "INSERT INTO users (name, email) VALUES (?, ?)", (name, email) ) return cursor.lastrowid email) VALUES (?