Python Practice › SQLite Programs › Program 8
Rows as dictionaries
Write a Python program to read rows by column name.
Output
Asha Pune {'name': 'Asha', 'city': 'Pune'}Approach
conn.row_factory = sqlite3.Row.
Solution
import sqlite3 conn = sqlite3.connect(":memory:")conn.row_factory = sqlite3.Rowconn.execute("CREATE TABLE users (name TEXT, city TEXT)")conn.execute("INSERT INTO users VALUES ('Asha', 'Pune')")row = conn.execute("SELECT * FROM users").fetchone()print(row["name"], row["city"], dict(row))Output
Asha Pune {'name': 'Asha', 'city': 'Pune'}Learn the concept
New to this topic? Read the lesson, then come back.