. . . . . . . . . . . . . . . . . . . . . 18 1.5 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.6 Database . . . . . . . . . . . . . . on the getting started page. Here is a visual representation of the schema used in these examples: 18 Chapter 1. Contents: peewee Documentation, Release 3.3.0 1.5.1 Model Definitions To begin working Documentation, Release 3.3.0 (continued from previous page) tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 If you would like more granular control, you can always use limit() and offset(). 1.8.13

. . . . . . . . . . . . . . . . . . . . . 18 1.5 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.6 Database . . . . . . . . . . . . . . on the getting started page. Here is a visual representation of the schema used in these examples: 18 Chapter 1. Contents: peewee Documentation, Release 3.4.0 1.5.1 Model Definitions To begin working print(tweet.message) ... tweet 10 tweet 11 tweet 12 tweet 13 tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 If you would like more granular control, you can always use limit() and offset(). 1.8.13

Contributing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.5 Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . answer for other people to find. • Ask on the mailing list, https://groups.google.com/group/peewee-orm 18 Chapter 1. Contents: peewee Documentation, Release 3.5.0 1.5 Database The Peewee Database object print(tweet.message) ... tweet 10 tweet 11 tweet 12 tweet 13 tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 If you would like more granular control, you can always use limit() and offset(). 1.7.13

print entry.title ... entry 10 entry 11 entry 12 entry 13 entry 14 entry 15 entry 16 entry 17 entry 18 entry 19 Counting records You can count the number of rows in any select query: >>> Entry.select() ame, qr, var_name=’object_list’, **kwargs): kwargs.update( page=int(request.args.get(’page’, 1)), 18 Chapter 1. Contents: peewee Documentation, Release 0.9.7 pages=qr.count() / 20 + 1 ) kwargs[var_name]

Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.6 Models and Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . and 64MB cache. sqlite_db = SqliteDatabase('/path/to/app.db', pragmas={ (continues on next page) 18 Chapter 1. Contents: peewee Documentation, Release 3.6.0 (continued from previous page) 'journal_mode': Documentation, Release 3.6.0 (continued from previous page) tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 If you would like more granular control, you can always use limit() and offset(). 1.7.13

print tweet.message ... tweet 10 tweet 11 tweet 12 tweet 13 tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 Counting records You can count the number of rows in any select query: >>> Tweet.select() 1.4.6 Schema migrations Currently peewee does not have support for automatic schema migrations. 18 Chapter 1. Contents: peewee Documentation, Release 2.0.0 1.5 Example app peewee ships with an example

Contents: peewee Documentation, Release 1.0.0 entry 12 entry 13 entry 14 entry 15 entry 16 entry 17 entry 18 entry 19 Counting records You can count the number of rows in any select query: >>> Entry.select() is taken, and if not executes a create(). try: user = User.get(username=request.form[’username’]) 18 Chapter 1. Contents: peewee Documentation, Release 1.0.0 flash(’That username is already taken’)

BaseModel(Model): class Meta: database = database class User(BaseModel): username = CharField() 18 Chapter 1. Contents: peewee Documentation, Release 2.10.2 class Tweet(BaseModel): user = ForeignKeyField(User print tweet.message ... tweet 10 tweet 11 tweet 12 tweet 13 tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 If you would like more granular control, you can always use limit() and offset(). 1.8. Querying save_optimistic() Traceback (most recent call last): File "", line 1, in File "x.py", line 18, in save_optimistic raise ValueError('No changes have been made.') ValueError: No changes have been

print(tweet.message) ... tweet 10 tweet 11 tweet 12 tweet 13 tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 If you would like more granular control, you can always use limit() and offset(). Counting slices or expressions: >>> del KV['k1'] >>> del KV['k3x':'k8'] >>> del KV[KV.key.between('k10', 'k18')] >>> list(KV[:]) [Row(key='k0', value='v0'), Row(key='k19', value='v19'), Row(key='k2', value='v2') save_optimistic() Traceback (most recent call last): File "", line 1, in File "x.py", line 18, in save_optimistic raise ValueError('No changes have been made.') ValueError: No changes have

print(tweet.message) ... tweet 10 tweet 11 tweet 12 tweet 13 tweet 14 tweet 15 tweet 16 tweet 17 tweet 18 tweet 19 If you would like more granular control, you can always use limit() and offset(). Counting slices or expressions: >>> del KV['k1'] >>> del KV['k3x':'k8'] >>> del KV[KV.key.between('k10', 'k18')] >>> list(KV[:]) [Row(key='k0', value='v0'), Row(key='k19', value='v19'), Row(key='k2', value='v2') save_optimistic() Traceback (most recent call last): File "", line 1, in File "x.py", line 18, in save_optimistic raise ValueError('No changes have been made.') ValueError: No changes have