Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand database: for person in Person.select(): print(person.name) # prints: # Bob # Grandma L. # Herb Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type == 'cat') is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

Exercises Joins and Subqueries Modifying Data Aggregation Recursion Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic Locking Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand database: for person in Person.select(): print(person.name) # prints: # Bob # Grandma L. # Herb Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type == 'cat')

Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

Exercises Joins and Subqueries Modifying Data Aggregation Recursion Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic Locking Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type

Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic Locking Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type

Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic Locking Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type

Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries More Hacks Optimistic Locking Top object per the database. To get a single record from the database, use SelectQuery.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand Model.get(): person in Person.select(): print person.name, person.is_relative # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type

database. To get a single record from the database, use SelectQuery. get(): >>> grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand Model.get(): person in Person.select(): ... print person.name, person.is_relative ... Bob True Grandma L. True Herb False Let’s list all the cats and their owner’s name: >>> query = Pet.select().where(Pet.animal_type is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this value in our original query, peewee will have to perform an additional query to retrieve the