the other SQL clauses are available as well, such as: group_by() having() limit() and offset() Check the documentation on Querying for more info. Working with existing databases If you already have blog_models.py What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. Example app We’ll be building a simple twitter-like site. The source code for single module, examples/twitter/app.py. For a guide on structuring larger Flask apps with peewee, check out Structuring Flask Apps [http://charlesleifer.com/blog/structuring-flask-apps-a- how-to-for-t

group_by() 1.2. Quickstart 9 peewee Documentation, Release 2.10.2 • having() • limit() and offset() Check the documentation on Querying for more info. 1.2.4 Working with existing databases If you already blog_models.py 1.2.5 What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. 1.3 Example app We’ll be building a simple twitter-like site. The source code single module, examples/twitter/app.py. For a guide on structuring larger Flask apps with peewee, check out Structuring Flask Apps. Models In the spirit of the popular web framework Django, peewee uses

JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person the other SQL clauses are available as well, such as: group_by() having() limit() and offset() Check the documentation on Querying for more info. Working with existing databases If you already have blog_models.py What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. Example app We’ll be building a simple twitter-like site. The source code for

JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person the other SQL clauses are available as well, such as: group_by() having() limit() and offset() Check the documentation on Querying for more info. Working with existing databases If you already have blog_models.py What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. Example app We’ll be building a simple twitter-like site. The source code for

JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person the other SQL clauses are available as well, such as: group_by() having() limit() and offset() Check the documentation on Querying for more info. Working with existing databases If you already have blog_models.py What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. Example app We’ll be building a simple twitter-like site. The source code for

join(Pet, JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person, 'pet'): other SQL clauses are available as well, such as: • group_by() • having() • limit() and offset() Check the documentation on Querying for more info. 1.2.5 Working with existing databases If you already blog_models.py 1.2.6 What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. 1.3 Example app We’ll be building a simple twitter-like site. The source code

join(Pet, JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person, 'pet'): other SQL clauses are available as well, such as: • group_by() • having() • limit() and offset() Check the documentation on Querying for more info. 1.2.5 Working with existing databases If you already blog_models.py 1.2.6 What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. 1.3 Example app We’ll be building a simple twitter-like site. The source code

JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person the other SQL clauses are available as well, such as: group_by() having() limit() and offset() Check the documentation on Querying for more info. Working with existing databases If you already have blog_models.py What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. Example app We’ll be building a simple twitter-like site. The source code for

join(Pet, JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person, 'pet'): other SQL clauses are available as well, such as: • group_by() • having() • limit() and offset() Check the documentation on Querying for more info. 1.2.5 Working with existing databases If you already blog_models.py 1.2.6 What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. 1.3 Example app We’ll be building a simple twitter-like site. The source code

JOIN.LEFT_OUTER) .order_by(Person.name, Pet.name)) for person in query: # We need to check if they have a pet instance attached, since not all # people have pets. if hasattr(person 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 existing databases If you already have blog_models.py What next? That’s it for the quickstart. If you want to look at a full web-app, check out the Example app. Example app We’ll be building a simple twitter-like site. The source code for