extensions to Peewee . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 1.14 API Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . concepts, making it easy to learn and intuitive to use. • A small, expressive ORM • Written in python with support for versions 2.6+ and 3.2+. • built-in support for sqlite, mysql and postgresql • If you wish to also build the SQLite Cython extension, you must manually run: python setup.py build_sqlite_ext python setup.py install 1.1.1 Installing with git The project is hosted at https://github

expressive) concepts, making it easy to learn and intuitive to use. A small, expressive ORM Written in python with support for versions 2.6+ and 3.2+. built-in support for sqlite, mysql and postgresql numerous Migrations Reflection Database URL CSV Utils Connection pool Read Slaves Test Utils pskel Flask Utils API Reference Models Fields Query Types Database and its subclasses Transaction, Savepoint and ExecutionContext If you wish to also build the SQLite Cython extension, you must manually run: python setup.py build_sqlite_ext python setup.py install Installing with git The project is hosted at https://github.com/coleifer/peewee

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 1.9 API Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . concepts, making it easy to learn and 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 git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 1.14 API Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . concepts, making it easy to learn and 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 git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would

and Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 1.10 API Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . expressive) concepts, making it easy to learn and intuitive to use. • a small, expressive ORM • python 2.7+ and 3.4+ (developed with 3.6) • supports sqlite, mysql and postgresql • tons of extensions git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111 1.14 API Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . concepts, making it easy to learn and 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 git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note: On some systems you may need to use sudo python setup.py install to install peewee system- wide. If you would

expressive) concepts, making it easy to learn and 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 logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Manager Model Query-builder Internals Constants git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note On some systems you may need to use sudo python setup.py install to install peewee system-wide. If you would

expressive) concepts, making it easy to learn and 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 Transactions Explicit transaction Autocommit Mode Changes in 3.0 Backwards-incompatible New stuff API Documentation Database Query-builder Fields Schema Manager Model Query-builder Internals Constants git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note On some systems you may need to use sudo python setup.py install to install peewee system-wide. If you would

(but expressive) concepts, making it easy to learn and intuitive to use. a small, expressive ORM python 2.7+ and 3.4+ (developed with 3.6) supports sqlite, mysql and postgresql tons of extensions same Model Joining on arbitrary fields Self-joins Implementing Many to Many Avoiding the N+1 problem API Documentation Database Query-builder Fields Schema Manager Model Query-builder Internals Constants git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install Note On some systems you may need to use sudo python setup.py install to install peewee system-wide. If you would

January 12, 2013 CONTENTS i ii peewee Documentation, Release 1.0.0 • a small orm • written in python • provides a lightweight querying interface over sql • uses sql concepts when querying, like joins and RESTful API, check out flask-peewee. CONTENTS 1 peewee Documentation, Release 1.0.0 2 CONTENTS CHAPTER ONE CONTENTS: 1.1 Overview peewee is a lightweight ORM written in python. Examples: filter(Q(user__is_staff=True) | Q(user__is_superuser=True)) 3 peewee Documentation, Release 1.0.0 You can use python operators to create select queries: # how many active users are there? User.select().where(User