like joins and where clauses support for special extensions like hstore [http://peewee.readthedocs.org/en/latest/peewee/playhouse.html#postgresql-extensions-hstore-ltree] and full-text search [http://peewee collection of addons apsw, an advanced sqlite driver Postgresql Extensions (hstore, ltree) pwiz, a model generator Signal support Sqlite Extensions Swee’pea, syntactic sugar for peewee Indices and tables Index atomic update TweetCount.update(count=F('count') + 1).where(user=charlie) You can use django-style syntax to create select queries: # how many active users are there? User.filter(active=True).count() #

over sql • uses sql concepts when querying, like joins and where clauses • support for special extensions like hstore and full-text search For flask integration, including an admin interface and RESTful atomic update TweetCount.update(count=F(’count’) + 1).where(user=charlie) You can use django-style syntax to create select queries: # how many active users are there? User.filter(active=True).count() # Another Entry If you are already familiar with Django’s ORM, you can use the “double underscore” syntax: 1.3. Peewee Cookbook 9 peewee Documentation, Release 1.0.0 >>> for entry in Entry.filter(blog__name=’My

interface over sql • uses sql concepts when querying, like joins and where clauses • support for some extensions, like hstore For flask integration, including an admin interface and RESTful API, check out flask-peewee never thought of 1.3.2 Changes from version 1.0 The biggest changes between 1.0 and 2.0 are in the syntax used for constructing queries. The first iteration of peewee I threw up on github was about 600 lines and experience, I decided to rewrite and unify the API a bit. The result is a tradeoff. The newer syntax may be a bit more verbose at times, but at least it will be consistent. 4 Chapter 1. Contents:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 1.13 Playhouse, extensions to Peewee . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 1.14 API support for versions 2.6+ and 3.2+. • built-in support for sqlite, mysql and postgresql • numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more) simply install the latest version, hosted on PyPI: pip install peewee Peewee comes with two C extensions that can optionally be compiled: • Speedups, which includes miscellaneous functions re-implemented

support for versions 2.6+ and 3.2+. built-in support for sqlite, mysql and postgresql numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) Mode Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver BerkeleyDB backend Sqlcipher backend Postgresql Extensions DataSet Django Integration simply install the latest version, hosted on PyPI: pip install peewee Peewee comes with two C extensions that can optionally be compiled: Speedups, which includes miscellaneous functions re-implemented

. . . . . . . . . 90 1.10 SQLite Extensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155 1.11 Playhouse, extensions to Peewee . . . . . . . . . . . . and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more) Peewee comes with a couple C extensions that will be built if Cython is available. • Speedups, which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython

. . . . . . . . . 115 1.15 SQLite Extensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179 1.16 Playhouse, extensions to Peewee . . . . . . . . . . . . and 3.4+ (developed with 3.6) • Built-in support for SQLite, MySQL and Postgresql. • numerous extensions available (postgres hstore/json/arrays, sqlite full-text-search, schema migrations, and much more) Peewee comes with a couple C extensions that will be built if Cython is available. • Speedups, which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython

2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) and Testing Installing with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing Manager Model Query-builder Internals Constants and Helpers SQLite Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced

2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres hstore/json/arrays, sqlite full-text- search, schema migrations, and much more) and Testing Installing with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing Manager Model Query-builder Internals Constants and Helpers SQLite Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced

. . . . . . . . . 106 1.11 SQLite Extensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 1.12 Playhouse, extensions to Peewee . . . . . . . . . . . . • python 2.7+ and 3.4+ (developed with 3.6) • supports sqlite, mysql and postgresql • tons of extensions Peewee’s source code hosted on GitHub. New to peewee? These may help: • Quickstart • Example Peewee comes with a couple C extensions that will be built if Cython is available. • Speedups, which includes miscellaneous functions re-implemented with Cython. • Sqlite extensions, which includes Cython