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 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 com/coleifer/peewee and can be installed using git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install If you would like to build the SQLite extension in a git checkout, you can run:

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 com/coleifer/peewee and can be installed using git: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install If you would like to build the SQLite extension in a git checkout, you can run:

index next | peewee 1.0.0 documentation » peewee a small orm written in python provides a lightweight querying interface over sql uses sql concepts when querying, like joins and where clauses support peewee is a lightweight ORM [http://en.wikipedia.org/wiki/Object-relational_mapping] written in python. Examples: # a simple query selecting a user User.get(username='charles') # get the staff and tweets by editors Tweet.filter(Q(user__is_staff=True) | Q(user__is_superuser=True)) You can use python operators to create select queries: # how many active users are there? User.select().where(User

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 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 place shared libraries alongside other modules. python setup.py build_ext -i Running tests You can test your installation by running the test suite. python runtests.py You can test specific features or

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 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 place shared libraries alongside other modules. python setup.py build_ext -i Running tests You can test your installation by running the test suite. python runtests.py You can test specific features or

(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 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 place shared libraries alongside other modules. python setup.py build_ext -i Running tests You can test your installation by running the test suite. python runtests.py You can test specific features or

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 1.0.0 2 CONTENTS CHAPTER ONE CONTENTS: 1.1 Overview peewee is a lightweight ORM written in python. Examples: # a simple query selecting a user User.get(username=’charles’) # get the staff and 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

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.2+. Built-in support for SQLite, MySQL and Postgresql. numerous 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 place shared libraries alongside other modules. python setup.py build_ext -i Running tests You can test your installation by running the test suite. python runtests.py You can test specific features or

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 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 place shared libraries alongside other modules. python setup.py build_ext -i Running tests You can test your installation by running the test suite. python runtests.py You can test specific features or

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 alongside other modules. python setup.py build_ext -i 3 peewee Documentation, Release 3.5.0 1.1.2 Running tests You can test your installation by running the test suite. python runtests.py You can test