every Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User, Relationship

every Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User

Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User

every Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User, Relationship

Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User

every Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User, Relationship

every Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) # * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User, Relationship

Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User

Person returned by the original SELECT! We can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) * Fido # Grandma L. # Herb # * Mittens Jr SQL Functions One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: expression = fn.Lower(fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): with database: database.create_tables([User

print person.name, person.birthday ... Herb 1950-05-05 One last query. This will use a SQL function to find all people whose names start with either an upper or lower-case G: >>> expression = (fn operation and can be done quickly using the interactive interpreter. We can create a small helper function to accomplish this: def create_tables(): database.connect() database.create_tables([User Support for paginating lists of results is implemented in a simple function called object_list (after it’s corollary in Django). This function is used by all the views that return lists of objects. def ob