users are there? User.select().where(User.active == True).count() # paginate the user table and show me page 3 (users 41-60) User.select().order_by(User.username).paginate(3, 20) # order users by number e) Get me a list of all tweets by a user named “charlie”: # 1.0 Tweet.select().join(User).where(username=’charlie’) # 2.0 Tweet.select().join(User).where(User.username == ’charlie’) Get me a list of ’desc’)) # 2.0 Tweet.select().join(User).order_by(User.username, Tweet.created_date.desc()) Get me a list of tweets created by users named “charlie” or “peewee herman”, and which were created in the

active users are there? User.select().where(active=True).count() # paginate the user table and show me page 3 (users 41- 60) User.select().order_by(('username', 'asc')).paginate(3, 20) # order users by User.select().where(User.active == True).count() # get me all users in their thirties User.select().where((User.age >= 30) & (User.age < 40)) # get me tweets from today by active users Tweet.select().join(User) query, a DoesNotExist exception will be raised. >>> Blog.get(id=1) <__main__.Blog object at 0x25294d0> >>> Blog.get(id=1).name u'My Blog' >>> Blog.get(creator='Chuck') <__main__.Blog object at 0x2529410>

active users are there? User.select().where(active=True).count() # paginate the user table and show me page 3 (users 41-60) User.select().order_by((’username’, ’asc’)).paginate(3, 20) # order users by User.select().where(User.active == True).count() # get me all users in their thirties User.select().where((User.age >= 30) & (User.age < 40)) # get me tweets from today by active users Tweet.select().join(User) query, a DoesNotExist exception will be raised. >>> Blog.get(id=1) <__main__.Blog object at 0x25294d0> >>> Blog.get(id=1).name u’My Blog’ >>> Blog.get(creator=’Chuck’) <__main__.Blog object at 0x2529410>

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing primary features. This guide will cover: Model Definition Storing data Retrieving Data Note If you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app (grandma) after 1959 (bob) d1940 = date(1940, 1, 1) d1960 = date(1960, 1, 1) query = (Person .select() .where((Person.birthday < d1940) | (Person.birthday > d1960))) for person in query:

1. Contents: peewee Documentation, Release 3.6.0 • Storing data • Retrieving Data Note: If you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app peewee Documentation, Release 3.6.0 d1940 = date(1940, 1, 1) d1960 = date(1960, 1, 1) query = (Person .select() .where((Person.birthday < d1940) | (Person.birthday > d1960))) for person in query: print(person whose birthday is between 1940 and 1960: query = (Person .select() .where(Person.birthday.between(d1940, d1960))) for person in query: print(person.name, person.birthday) # prints: # Herb 1950-05-05

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing primary features. This guide will cover: Model Definition Storing data Retrieving Data Note If you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app (grandma) after 1959 (bob) d1940 = date(1940, 1, 1) d1960 = date(1960, 1, 1) query = (Person .select() .where((Person.birthday < d1940) | (Person.birthday > d1960))) for person in query:

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing primary features. This guide will cover: Model Definition Storing data Retrieving Data Note If you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app (grandma) after 1959 (bob) d1940 = date(1940, 1, 1) d1960 = date(1960, 1, 1) query = (Person .select() .where((Person.birthday < d1940) | (Person.birthday > d1960))) for person in query:

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing primary features. This guide will cover: Model Definition Storing data Retrieving Data Note If you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app (grandma) after 1959 (bob) d1940 = date(1940, 1, 1) d1960 = date(1960, 1, 1) query = (Person .select() .where((Person.birthday < d1940) | (Person.birthday > d1960))) for person in query:

hesitate to open an issue [https://github.com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing primary features. This guide will cover: Model Definition Storing data Retrieving Data Note If you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app (grandma) after 1959 (bob) d1940 = date(1940, 1, 1) d1960 = date(1960, 1, 1) query = (Person .select() .where((Person.birthday < d1940) | (Person.birthday > d1960))) for person in query:

1. Contents: peewee Documentation, Release 3.5.0 • Storing data • Retrieving Data Note: If you’d like something a bit more meaty, there is a thorough tutorial on creating a “twitter”-style web app all the people whose birthday was either: • before 1940 (grandma) • after 1959 (bob) d1940 = date(1940, 1, 1) d1960 = date(1960, 1, 1) query = (Person .select() (continues on next page) 8 Chapter 1 Documentation, Release 3.5.0 (continued from previous page) .where((Person.birthday < d1940) | (Person.birthday > d1960))) for person in query: print(person.name, person.birthday) # prints: # Bob 1960-01-15