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() # get tweets .. class Meta: ... database = custom_db ... >>> custom_db.connect() >>> CustomModel.create_table() Best practice: define a base model class that points at the database object you wish to Reading, Updating and Deleting Creating a new record You can use the Model.create() method on the model: >>> Blog.create(creator='Charlie', name='My Blog') <__main__.Blog object at 0x2529350> This

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() # get tweets 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.active == True).count() .. class Meta: ... database = custom_db ... >>> custom_db.connect() >>> CustomModel.create_table() Best practice: define a base model class that points at the database object you wish to

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() # get tweets CharField() ... ... class Meta: ... database = custom_db ... >>> custom_db.connect() >>> CustomModel.create_table() Best practice: define a base model class that points at the database object you wish to Creating a new record You can use the Model.create() method on the model: 6 Chapter 1. Contents: peewee Documentation, Release 0.9.7 >>> Blog.create(creator=’Charlie’, name=’My Blog’) <__main__.Blog

CharField() ... ... class Meta: ... database = custom_db ... >>> custom_db.connect() >>> CustomModel.create_table() Best practice: define a base model class that points at the database object you wish to Reading, Updating and Deleting Creating a new record You can use the Model.create() method on the model: >>> User.create(username=’Charlie’) <__main__.User object at 0x2529350> This will INSERT a new autocommit off when instantiating your database: db = SqliteDatabase(’:memory:’, autocommit=False) User.create(username=’somebody’) db.commit() 1.4.4 Non-integer Primary Keys and other Tricks Non-integer primary

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() # get tweets 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.active == True).count() CharField() ... ... class Meta: ... database = custom_db ... >>> custom_db.connect() >>> CustomModel.create_table() Best practice: define a base model class that points at the database object you wish to

Bulk inserts Updating existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating options, use: python runtests.py --help Note To run tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To use Peewee, you typically won’t need anything

Bulk inserts Updating existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating options, use: python runtests.py --help Note To run tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To use Peewee, you typically won’t need anything

options, use: python runtests.py --help Note: To run tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; 1.1.3 Optional dependencies Note: To use Peewee, you typically won’t need anything the database that will store our data. This will create the tables with the appropriate columns, indexes, sequences, and foreign key constraints: db.create_tables([Person, Pet]) 1.2.2 Storing data Let’s

options, use: python runtests.py --help Note: To run tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; 1.1.3 Optional dependencies Note: To use Peewee, you typically won’t need anything the database that will store our data. This will create the tables with the appropriate columns, indexes, sequences, and foreign key constraints: db.create_tables([Person, Pet]) 1.2.2 Storing data Let’s

Bulk inserts Updating existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating options, use: python runtests.py --help Note To run tests against Postgres or MySQL you need to create a database named “peewee_test”. To test the Postgres extension module, you will also want to install extension in the postgres test database: -- install the hstore extension on the peewee_test postgres db. CREATE EXTENSION hstore; Optional dependencies Note To use Peewee, you typically won’t need anything