where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) database". As mentioned above, this only happens when you access the databse, so if you need to know right away whether the passphrase was correct, you can trigger this check by calling [e.g.] get_tables() model subclasses class Person(BaseModel): name = CharField(primary_key=True) right_passphrase = False while not right_passphrase: db.init( 'testsqlcipher.db', passphrase=get_passphrase_from_user())

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) database". As mentioned above, this only happens when you access the databse, so if you need to know right away whether the passphrase was correct, you can trigger this check by calling [e.g.] get_tables() our model subclasses class Person(BaseModel): name = CharField(primary_key=True) right_passphrase = False while not right_passphrase: db.init( 102 Chapter 1. Contents: peewee Documentation, Release 2

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) use as join predicate. a Join instance. Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Parameters: Parameters: Perform a FULL OUTER join on dest. __mul__(dest)

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) use as join predicate. a Join instance. Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) use as join predicate. a Join instance. Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) use as join predicate. a Join instance. Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER Parameters: Returns: Parameters: JOIN.CROSS left_outer_join(dest[ INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) predicate. Returns a Join instance. Join type may be one of: • JOIN.INNER • JOIN.LEFT_OUTER • JOIN.RIGHT_OUTER • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS left_outer_join(dest[, on=None]) Parameters INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) predicate. Returns a Join instance. Join type may be one of: • JOIN.INNER • JOIN.LEFT_OUTER • JOIN.RIGHT_OUTER • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS 1.14. API Documentation 127 peewee Documentation INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS

where(User.username == 'charlie') By default peewee will use an INNER join, but you can use LEFT OUTER, RIGHT OUTER, FULL, or CROSS joins as well: users = (User .select(User, fn.Count(Tweet.id).alias('num_tweets')) predicate. Returns a Join instance. Join type may be one of: • JOIN.INNER • JOIN.LEFT_OUTER • JOIN.RIGHT_OUTER • JOIN.FULL • JOIN.FULL_OUTER • JOIN.CROSS left_outer_join(dest[, on=None]) Parameters INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS

use as join predicate. a Join instance. Join type may be one of: JOIN.INNER JOIN.LEFT_OUTER JOIN.RIGHT_OUTER JOIN.FULL JOIN.FULL_OUTER JOIN.CROSS left_outer_join(dest[, on=None]) dest (Source) – Join INNER join on dest. __add__(dest) Perform a LEFT OUTER join on dest. __sub__(dest) Perform a RIGHT OUTER join on dest. __or__(dest) Perform a FULL OUTER join on dest. __mul__(dest) Perform a CROSS alias=None]]]) Represent a JOIN between to table-like objects. lhs – Left-hand side of the join. rhs – Right-hand side of the join. join_type – Type of join. e.g. JOIN.INNER, JOIN.LEFT_OUTER, etc. on – Expression