instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. Check the documentation on querying for more info. Working with request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. Check the documentation on querying for more info. 1.2.5 Working request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request def

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: • request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request def

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: • request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request def

instead: >>> for pet in Pet.select().where(Pet.owner == uncle_bob): ... print pet.name Let’s make sure these are sorted alphabetically by adding an order_by() clause: >>> for pet in Pet.select() done with our database, let’s close the connection: >>> db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print pet.name Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request

instead: for pet in Pet.select().where(Pet.owner == uncle_bob): print(pet.name) Sorting Let’s make sure these are sorted alphabetically by adding an order_by() clause: for pet in Pet.select().where(Pet done with our database, let’s close the connection: db.close() This is just the basics! You can make your queries as complex as you like. All the other SQL clauses are available as well, such as: • request/response cycle we need to create a connection to the database. Flask provides some handy decorators to make this a snap: @app.before_request def before_request(): database.connect() @app.after_request def