dataset_sqlite_quickstart_insert_and_query.py

1import dataset
2
3# Connect to a SQLite database (creates it if it doesn't exist)
4db = dataset.connect('sqlite:///:memory:')
5
6# Get a reference to the table 'user'
7table = db['user']
8
9# Insert a new record into the 'user' table
10table.insert(dict(name='John Doe', age=37, country='China'))
11
12# Insert another record
13table.insert(dict(name='Jane Doe', age=28, country='France', gender='female'))
14
15# Find all users
16users = db['user'].all()
17
18# Print the results
19for user in users:
20    print(user)