an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet alias('log') Then when iterating over the query, we were able to directly access the joined ActivityLog without incurring an additional query: for user in user_log: print(user.username, user.log.description)

an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet alias('log') Then when iterating over the query, we were able to directly access the joined ActivityLog without incurring an additional query: for user in user_log: print(user.username, user.log.description)

Field, we will join using an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( (ActivityLog.activity_type == 'user_activity') 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet charlie retweeted alias('log') Then when iterating over the query, we were able to directly access the joined ActivityLog without incurring an additional query: for user in user_log: print(user.username, user.log.description)

Field, we will join using an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( (ActivityLog.activity_type == 'user_activity') 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### (continues on next page) 102 Chapter 1. Contents: peewee alias('log') Then when iterating over the query, we were able to directly access the joined ActivityLog without incurring an additional query: for user in user_log: print(user.username, user.log.description)

If you are unsure how many queries are being executed, you can add the following code, which will log all queries to the console: import logging logger = logging.getLogger('peewee') logger.addHandler(logging will join using an Expression. user_log = (User .select(User, ActivityLog) .join(ActivityLog, on=(User.id == ActivityLog.object_id), attr='log') .where( 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet

If you are unsure how many queries are being executed, you can add the following code, which will log all queries to the console: import logging logger = logging.getLogger('peewee') logger.addHandler(logging Field, we will join using an Expression. user_log = (User .select(User, ActivityLog) .join(ActivityLog, on=(User.id == ActivityLog.object_id), attr='log') .where( (ActivityLog.activity_type == 'user_activity') 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet charlie retweeted

an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet alias('log') Then when iterating over the query, we were able to directly access the joined ActivityLog without incurring an additional query: for user in user_log: print(user.username, user.log.description)

an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet alias('log') Then when iterating over the query, we were able to directly access the joined ActivityLog without incurring an additional query: for user in user_log: print(user.username, user.log.description)

Field, we will join using an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( (ActivityLog.activity_type == 'user_activity') 'user_activity') & (User.username == 'charlie'))) for user in user_log: print(user.username, user.log.description) #### Print something like #### charlie logged in charlie posted a tweet charlie retweeted to. In the previous example, we used the following join: (User.id == ActivityLog.object_id).alias('log') 1.10. Foreign Keys 101 peewee Documentation, Release 3.3.0 Then when iterating over the query

an Expression. user_log = (User .select(User, ActivityLog) .join( ActivityLog, on=(User.id == ActivityLog.object_id).alias('log')) .where( 'user_activity') & (User.username == 'charlie'))) for user in user_log: print user.username, user.log.description #### Print something like #### charlie logged in charlie posted a tweet alias('log') Then when iterating over the query, we were able to directly access the joined ActivityLog without incurring an additional query: for user in user_log: print user.username, user.log.description