dataset_sqlite_quickstart_crud_operations.py

1import dataset
2
3# connect to a SQLite database (creates a file if it doesn't exist)
4db = dataset.connect('sqlite:///mydatabase.db')
5
6# get a reference to the table 'user'
7table = db['user']
8
9# Insert a new record. 
10# dataset will create the table and columns automatically.
11table.insert(dict(name='John Doe', age=37, country='China'))
12
13# dataset will also helpfully create new columns as they are needed.
14table.insert(dict(name='Jane Doe', age=28, gender='female'))
15
16# Find all users
17users = table.all()
18
19# Find a specific user
20mary = table.find_one(name='Jane Doe')
21
22# Update a record
23table.update(dict(name='John Doe', age=47), ['name'])
24
25# Iterate through all records
26for user in table:
27    print(user['name'], user['age'])