old. >>> delete_query = Entry.delete().where(pub_date__lt=one_year_ago) >>> delete_query.execute() 7 # <--- number of entries deleted For more information, see the documentation on DeleteQuery. Selecting >>> user_q = User.select() # <-- query is not executed >>> user_q 7f6b0810c610> >>> [u.username for u in user_q] # <-- query is evaluated here [u'admin', u'staff', u'editor'] see the discussion here [https://groups.google.com/forum/?fromgroups#!topic/peewee- orm/RLd2r-eKp7w]. Speeding up simple select queries Simple select queries can get a performance boost (especially

ne_year_ago) >>> delete_query.execute() 7 # <--- number of entries deleted For more information, see the documentation on DeleteQuery. 1.3. Peewee Cookbook 7 peewee Documentation, Release 0.9.7 Selecting >>> user_q = User.select() # <-- query is not executed >>> user_q 7f6b0810c610> >>> [u.username for u in user_q] # <-- query is evaluated here [u’admin’, u’staff’, u’editor’] User.delete().where(active=False) # <-- returns a DeleteQuery >>> dq 7fc866ada4d0> >>> dq.execute() # <-- executes the query and returns number of rows deleted 3 >>> uq =

which were created in the last week. last_week = datetime.datetime.now() - datetime.timedelta(days=7) # 1.0 Tweet.select().where(created_date__gt=last_week).join(User).where( Q(username=’charlie’) | Q(username=’peewee database-related tasks with peewee. Examples will use the following models: 1.4. Peewee Cookbook 7 peewee Documentation, Release 2.0.0 from peewee import * class User(Model): username = CharField() >>> delete_query = Tweet.delete().where(Tweet.pub_date < one_year_ago) >>> delete_query.execute() 7 # <--- number of rows deleted For more information, see the documentation on DeleteQuery. Selecting

exists, otherwise it will open a new connection. >>> db.connection() 7f94e9362f10> Connection Pooling Connection pooling is provided by the pool module, included in the AttributeError: type object 'Person' has no attribute 'Meta' >>> Person._meta 7f51a2f03790> The ModelOptions class implements several methods which may be of use for retrieving model 7f51a2e92750>, 'name': 7f51a2f0a510>} >>> Person._meta.primary_key 7f51a2e92750> >>> Person._meta.database

join(Person) .where(Pet.animal_type == 'cat')) for pet in query: (continues on next page) 1.2. Quickstart 7 peewee Documentation, Release 3.4.0 (continued from previous page) print(pet.name, pet.owner.name) exists, otherwise it will open a new connection. >>> db.connection() 7f94e9362f10> 1.6.9 Connection Pooling Connection pooling is provided by the pool module, included in AttributeError: type object 'Person' has no attribute 'Meta' >>> Person._meta 7f51a2f03790> The ModelOptions class implements several methods which may be of use for retrieving model

exists, otherwise it will open a new connection. >>> db.connection() 7f94e9362f10> Connection Pooling Connection pooling is provided by the pool module, included in the AttributeError: type object 'Person' has no attribute 'Meta' >>> Person._meta 7f51a2f03790> The ModelOptions class implements several methods which may be of use for retrieving model 7f51a2e92750>, 'name': 7f51a2f0a510>} >>> Person._meta.primary_key 7f51a2e92750> >>> Person._meta.database

join(Person) .where(Pet.animal_type == 'cat')) for pet in query: (continues on next page) 1.2. Quickstart 7 peewee Documentation, Release 3.5.0 (continued from previous page) print(pet.name, pet.owner.name) exists, otherwise it will open a new connection. >>> db.connection() 7f94e9362f10> 1.5.9 Connection Pooling Connection pooling is provided by the pool module, included in AttributeError: type object 'Person' has no attribute 'Meta' >>> Person._meta 7f51a2f03790> The ModelOptions class implements several methods which may be of use for retrieving model

join(Person) .where(Pet.animal_type == 'cat')) for pet in query: (continues on next page) 1.2. Quickstart 7 peewee Documentation, Release 3.3.0 (continued from previous page) print(pet.name, pet.owner.name) exists, otherwise it will open a new connection. >>> db.connection() 7f94e9362f10> 1.6.9 Connection Pooling Connection pooling is provided by the pool module, included in AttributeError: type object 'Person' has no attribute 'Meta' >>> Person._meta 7f51a2f03790> The ModelOptions class implements several methods which may be of use for retrieving model

exists, otherwise it will open a new connection. >>> db.connection() 7f94e9362f10> Connection Pooling Connection pooling is provided by the pool module, included in the AttributeError: type object 'Person' has no attribute 'Meta' >>> Person._meta 7f51a2f03790> The ModelOptions class implements several methods which may be of use for retrieving model 7f51a2e92750>, 'name': 7f51a2f0a510>} >>> Person._meta.primary_key 7f51a2e92750> >>> Person._meta.database

join. query = (Pet .select(Pet, Person) .join(Person) (continues on next page) 1.2. Quickstart 7 peewee Documentation, Release 3.6.0 (continued from previous page) .where(Pet.animal_type == 'cat')) exists, otherwise it will open a new connection. >>> db.connection() 7f94e9362f10> 1.5.9 Connection Pooling Connection pooling is provided by the pool module, included in AttributeError: type object 'Person' has no attribute 'Meta' >>> Person._meta 7f51a2f03790> The ModelOptions class implements several methods which may be of use for retrieving model