using sqlite with json

1
import sqlite3
2
import json
3

4
# Connect to the database
5
conn = sqlite3.connect('mydb.db')
6
cursor = conn.cursor()
7

8
# Execute query
9
cursor.execute("SELECT * FROM users")
10
columns = [description[0] for description in cursor.description]
11
rows = cursor.fetchall()
12

13
# Convert to list of dictionaries
14
results = [dict(zip(columns, row)) for row in rows]
15

16
# Convert to JSON
17
json_output = json.dumps(results, indent=2)
18
print(json_output)