Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database com/rogerbinns/apsw]: an optional 3rd-party SQLite binding offering greater performance and comprehensive support for SQLite’s C APIs. Use with APSWDatabase. gevent [http://www.gevent.org/] is an optional dependency

anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database SQLite. • apsw: an optional 3rd-party SQLite binding offering greater performance and comprehensive support for SQLite’s C APIs. Use with APSWDatabase. • gevent is an optional dependency for SqliteQueueDatabase are a couple other neat things going on in the example app that are worth mentioning briefly. • Support for paginating lists of results is implemented in a simple function called object_list (after it’s

There are a couple other neat things going on in the example app that are worth mentioning briefly. Support for paginating lists of results is implemented in a simple function called object_list (after it’s filter(Q(user__is_staff=True) | Q(user__is_superuser=True)) Where clause All queries except InsertQuery support the where() method. If you are familiar with Django’s ORM, it is analagous to the filter() method print sq.sql()[0] SELECT * FROM user WHERE (is_staff = ? OR is_superuser = ?) Q objects can be combined using the bitwise “or” and “and” operators. In order to negate a Q object, use the bitwise “invert”

are a couple other neat things going on in the example app that are worth mentioning briefly. • Support for paginating lists of results is implemented in a simple function called object_list (after it’s filter(Q(user__is_staff=True) | Q(user__is_superuser=True)) 1.7.2 Where clause All queries except InsertQuery support the where() method. If you are familiar with Django’s ORM, it is analagous to the filter() method print sq.sql()[0] SELECT * FROM user WHERE (is_staff = ? OR is_superuser = ?) Q objects can be combined using the bitwise “or” and “and” operators. In order to negate a Q object, use the bitwise “invert”

lightweight querying interface over sql uses sql concepts when querying, like joins and where clauses support for special extensions like hstore [http://peewee.readthedocs.org/en/latest/peewee/playhouse.ht 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 Module Index Search also share a connection across threads natively, so if you would prefer to use sqlite’s native support: native_concurrent_db = SqliteDatabase('stats.db', check_same_thread=False) Deferring initialization

querying interface 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 can also share a connection across threads natively, so if you would prefer to use sqlite’s native support: native_concurrent_db = SqliteDatabase(’stats.db’, check_same_thread=False) Deferring initialization The generated code is written to stdout. 1.3.5 Schema migrations Currently peewee does not have support for automatic schema migrations. Peewee does, however, come with a few helper functions: 14 Chapter

querying 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 selections, join types, functions, etc). In the where clause stuff gets crazy as there are args being combined with bitwise operators (“Q” expressions) and also kwargs being used with django-style “double-underscore” The generated code is written to stdout. 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

learn and intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.2+. Built-in support for SQLite, MySQL and Postgresql. numerous extensions available (postgres driver Sqlcipher backend Postgresql Extensions DataSet Fields Hybrid Attributes Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database

intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database

intuitive to use. A small, expressive ORM Written in python with support for versions 2.7+ and 3.4+ (developed with 3.6) Built-in support for SQLite, MySQL and Postgresql. numerous extensions available Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL Connection pool Test Utils Flask anything outside the standard library, since most Python distributions are compiled with SQLite support. You can test by running import sqlite3 in the Python console. If you wish to use another database