pip install the git clone: pip install -e git+https://github.com/coleifer/peewee.git If you don’t want to use pip: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install SqliteDatabase('stats.db') >>> database.connect() It is possible to use multiple databases (provided that you don’t try and mix models from each): >>> custom_db = peewee.SqliteDatabase('custom.db') >>> class CustomModel(peewee (Entry, 'pub_date', 'DESC'), ... ) >>> qry.sql() ('SELECT t1.* FROM entry AS t1 INNER JOIN blog AS t2 ON t1.blog_id = t2.id ORDER BY t2.name ASC, t1.pub_date DESC', []) Paginating records The paginate

pip install the git clone: pip install -e git+https://github.com/coleifer/peewee.git If you don’t want to use pip: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install class Meta: database = database It is possible to use multiple databases (provided that you don’t try and mix models from each): >>> custom_db = peewee.SqliteDatabase('custom.db') >>> class CustomModel(peewee (Entry, 'pub_date', 'DESC'), ... ) >>> qry.sql() ('SELECT t1.* FROM entry AS t1 INNER JOIN blog AS t2 ON t1.blog_id = t2.id ORDER BY t2.name ASC, t1.pub_date DESC', []) Paginating records The paginate

can pip install the git clone: pip install -e git+https://github.com/coleifer/peewee.git If you don’t want to use pip: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install and saner. I also cleaned up the primary key business. Basically it works like this: • if you don’t specify a primary key, one will be created named “id” • if you do specify a primary key and it is a CharField() class Meta: database = database It is possible to use multiple databases (provided that you don’t try and mix models from each): >>> custom_db = SqliteDatabase(’custom.db’) >>> class CustomModel(Model):

can pip install the git clone: pip install -e git+https://github.com/coleifer/peewee.git If you don’t want to use pip: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install SqliteDatabase(’stats.db’) >>> database.connect() It is possible to use multiple databases (provided that you don’t try and mix models from each): >>> custom_db = peewee.SqliteDatabase(’custom.db’) >>> class CustomModel(peewee Documentation, Release 0.9.7 ... ) >>> qry.sql() (’SELECT t1.* FROM entry AS t1 INNER JOIN blog AS t2 ON t1.blog_id = t2.id ORDER BY t2.name ASC, t1.pub_date DESC’, []) Paginating records The paginate method

can pip install the git clone: pip install -e git+https://github.com/coleifer/peewee.git If you don’t want to use pip: git clone https://github.com/coleifer/peewee.git cd peewee python setup.py install CharField() class Meta: database = database It is possible to use multiple databases (provided that you don’t try and mix models from each): >>> custom_db = peewee.SqliteDatabase(’custom.db’) >>> class CustomModel(peewee (Entry, ’pub_date’, ’DESC’), ... ) >>> qry.sql() (’SELECT t1.* FROM entry AS t1 INNER JOIN blog AS t2 ON t1.blog_id = t2.id ORDER BY t2.name ASC, t1.pub_date DESC’, []) Paginating records The paginate method

with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please don’t hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact options, use: python runtests.py --help Optional dependencies Note To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite have stored 3 people in the database. Let’s give them some pets. Grandma doesn’t like animals in the house, so she won’t have any, but Herb is an animal lover: >>> bob_kitty = Pet.create(owner=uncle_bob

use: python runtests.py --help 1.1.3 Optional dependencies Note: To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite have stored 3 people in the database. Let’s give them some pets. Grandma doesn’t like animals in the house, so she won’t have any, but Herb is an animal lover: >>> bob_kitty = Pet.create(owner=uncle_bob liking. The example app uses the flask web framework which is very easy to get started with. If you don’t have flask already, you will need to install it to run the example: pip install flask 1.3.1 Running

with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please don’t hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact postgres db. CREATE EXTENSION hstore; Optional dependencies Note To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite have stored 3 people in the database. Let’s give them some pets. Grandma doesn’t like animals in the house, so she won’t have any, but Herb is an animal lover: bob_kitty = Pet.create(owner=uncle_bob,

with SQLite Note If you find any bugs, odd behavior, or have an idea for a new feature please don’t hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact postgres db. CREATE EXTENSION hstore; Optional dependencies Note To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite have stored 3 people in the database. Let’s give them some pets. Grandma doesn’t like animals in the house, so she won’t have any, but Herb is an animal lover: bob_kitty = Pet.create(owner=uncle_bob,

New stuff Note If you find any bugs, odd behavior, or have an idea for a new feature please don’t hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact postgres db. CREATE EXTENSION hstore; Optional dependencies Note To use Peewee, you typically won’t need anything outside the standard library, since most Python distributions are compiled with SQLite have stored 3 people in the database. Let’s give them some pets. Grandma doesn’t like animals in the house, so she won’t have any, but Herb is an animal lover: bob_kitty = Pet.create(owner=uncle_bob,