iterated the same as any other SelectQuery: >>> for tweet in user.tweets: ... print tweet.message ... hello world this is fun look at this picture of my food The tweets attribute is just another select query order_by(Tweet.created_date.desc()): ... print tweet.message ... look at this picture of my food this is fun hello world Filtering records You can filter for particular records using normal python operators. >>> is_published == True): ... print ’%s: %s (%s)’ % (tweet.user.username, tweet.message) ... Charlie: hello world Charlie: this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime.datetime(2011

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other SelectQuery: >>> for tweet in user.tweets: ... print tweet.message ... hello world this is fun look at this picture of my food Filtering records You can filter for particular is_published == True): ... print '%s: %s' % (tweet.user.username, tweet.message) ... Charlie: hello world Charlie: this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other SelectQuery: >>> for tweet in user.tweets: ... print tweet.message ... hello world this is fun look at this picture of my food 1.8.9 Filtering records You can filter for particular Tweet.is_published == True): ... print '%s: %s' % (tweet.user.username, tweet.message) ... Charlie: hello world Charlie: this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime.datetime(2011

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other Select: >>> for tweet in user.tweets: ... print(tweet.message) ... hello world this is fun look at this picture of my food Filtering records You can filter for particular Tweet.is_published == True): ... print(tweet.user.username, '->', tweet.message) ... Charlie -> hello world Charlie -> this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other Select: >>> for tweet in user.tweets: ... print(tweet.message) ... hello world this is fun look at this picture of my food In addition to returning model instances, Select Tweet.is_published == True): ... print(tweet.user.username, '->', tweet.message) ... Charlie -> hello world Charlie -> this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other Select: >>> for tweet in user.tweets: ... print(tweet.message) ... hello world this is fun look at this picture of my food In addition to returning model instances, Select Tweet.is_published == True): ... print(tweet.user.username, '->', tweet.message) ... Charlie -> hello world Charlie -> this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other Select: >>> for tweet in user.tweets: ... print(tweet.message) ... hello world this is fun look at this picture of my food Filtering records You can filter for particular Tweet.is_published == True): ... print(tweet.user.username, '->', tweet.message) ... Charlie -> hello world Charlie -> this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other Select: >>> for tweet in user.tweets: ... print(tweet.message) ... hello world this is fun look at this picture of my food In addition to returning model instances, Select (continued from previous page) ... print(tweet.user.username, '->', tweet.message) ... Charlie -> hello world Charlie -> this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other Select: >>> for tweet in user.tweets: ... print(tweet.message) ... hello world (continues on next page) 1.8. Querying 85 peewee Documentation, Release 3.3.0 (continued Tweet.is_published == True): ... print(tweet.user.username, '->', tweet.message) ... Charlie -> hello world Charlie -> this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime

tweet = Tweet.create(user=huey, message='Hello!') You can also use the value of the related object’s primary key: >>> tweet = Tweet.create(user=2, message='Hello again!') If you simply wish to insert back-reference just like any other Select: >>> for tweet in user.tweets: ... print(tweet.message) ... hello world this is fun look at this picture of my food In addition to returning model instances, Select Tweet.is_published == True): ... print(tweet.user.username, '->', tweet.message) ... Charlie -> hello world Charlie -> this is fun >>> for tweet in Tweet.select().where(Tweet.created_date < datetime