# prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = (

pets 1.2. Quickstart 9 peewee Documentation, Release 3.6.0 Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == backref='related_to') class Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique

# prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = (

# prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == backref='related_to') class Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique

# prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = (

# prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == backref='related_to') class Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique

# prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == backref='related_to') class Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique

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.Lower(fn.Substr(Person.name, 1, code to connect to an in-memory SQLite database, as well as blank model definitions for the model names specified on the command line. Here is a more complete example, which will use the PostgresqlExtDatabase specify a default ordering, the syntax is similar to that of Django. Meta.order_by is a tuple of field names, and to indicate descending ordering, the field name is prefixed by a '-'. class Person(Model):

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.Lower(fn.Substr(Person.name, 1, code to connect to an in-memory SQLite database, as well as blank model definitions for the model names specified on the command line. Here is a more complete example, which will use the PostgresqlExtDatabase specify a default ordering, the syntax is similar to that of Django. Meta.order_by is a tuple of field names, and to indicate descending ordering, the field name is prefixed by a '-'. class Person(Model): first_name

# prints: # Bob 2 pets # Grandma L. 0 pets # Herb 1 pets Now let’s list all the people and the names of all their pets. As you may have guessed, this could easily turn into another N+1 situation if we’re 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.Substr(Person.name, 1, 1)) == Meta: # `indexes` is a tuple of 2-tuples, where the 2-tuples are # a tuple of column names to index and a boolean indicating # whether the index is unique or not. indexes = (