extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. This module should be built using the build_sqlite_ext "a" a_users = User.select().where(fn.Lower(fn.Substr(User.username, 1, 1)) == 'a') # the "<<" operator signifies an "IN" query a_user_tweets = Tweet.select().where(Tweet.user << a_users) More query ||. To combine clauses using logical operators, use: Operator Meaning Example & AND (User.is_active == True) & (User.is_admin == True) | (pipe) OR (User.is_admin) | (User.is_superuser) ~ NOT (unary

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. This module should be built using the build_sqlite_ext with "a" a_users = User.select().where(fn.Lower(fn.Substr(User.username, 1, 1)) == 'a') # the "<<" operator signifies an "IN" query a_user_tweets = Tweet.select().where(Tweet.user << a_users) More query ||. To combine clauses using logical operators, use: Operator Meaning Example & AND (User.is_active == True) & (User.is_admin == True) | (pipe) OR (User.is_admin) | (User.is_superuser) ~ NOT (unary

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at '%tennis%'; query = Facility.select().where(Facility.name.contains('tennis')) # OR use the exponent operator. Note: you must include wildcards here: query = Facility.select().where(Facility.name ** '%tennis%') How can you retrieve the details of facilities with ID 1 and 5? Try to do it without using the OR operator. SELECT * FROM facilities WHERE facid IN (1, 5); query = Facility.select().where(Facility.facid

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at value. This is also the reason why “IN” queries must be expressed using .in_() rather than the in operator. Check out the table of query operations to see what types of queries are possible. Note A lot type. To combine clauses using logical operators, use: Operator Meaning Example & AND (User.is_active == True) & (User.is_admin == True) | (pipe) OR (User.is_admin) | (User.is_superuser) ~ NOT (unary

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at '%tennis%'; query = Facility.select().where(Facility.name.contains('tennis')) # OR use the exponent operator. Note: you must include wildcards here: query = Facility.select().where(Facility.name ** '%tennis%') How can you retrieve the details of facilities with ID 1 and 5? Try to do it without using the OR operator. SELECT * FROM facilities WHERE facid IN (1, 5); query = Facility.select().where(Facility.facid

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at '%tennis%'; query = Facility.select().where(Facility.name.contains('tennis')) # OR use the exponent operator. Note: you must include wildcards here: query = Facility.select().where(Facility.name ** '%tennis%') How can you retrieve the details of facilities with ID 1 and 5? Try to do it without using the OR operator. SELECT * FROM facilities WHERE facid IN (1, 5); query = Facility.select().where(Facility.facid

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text search result ranking algorithms. 1.1.1 Installing with git The project is hosted value. This is also the reason why “IN” queries must be expressed using .in_() rather than the in operator. Check out the table of query operations to see what types of queries are possible. Note: A lot type. To combine clauses using logical operators, use: Operator Meaning Example & AND (User.is_active == True) & (User.is_admin == True) | (pipe) OR (User.is_admin) | (User.is_superuser) ~ NOT (unary

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text search result ranking algorithms. 1.1.1 Installing with git The project is hosted '%tennis%'; query = Facility.select().where(Facility.name.contains('tennis')) # OR use the exponent operator. Note: you must include wildcards here: query = Facility.select().where(Facility.name ** '%tennis%') How can you retrieve the details of facilities with ID 1 and 5? Try to do it without using the OR operator. SELECT * FROM facilities WHERE facid IN (1, 5); 1.5. Query Examples 21 peewee Documentation

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REG- EXP operator, and full-text search result ranking algorithms. 1.1.1 Installing with git The project is hosted '%tennis%'; query = Facility.select().where(Facility.name.contains('tennis')) # OR use the exponent operator. Note: you must include wildcards here: query = Facility.select().where(Facility.name ** '%tennis%') How can you retrieve the details of facilities with ID 1 and 5? Try to do it without using the OR operator. SELECT * FROM facilities WHERE facid IN (1, 5); 1.5. Query Examples 21 peewee Documentation

extensions, which includes Cython implementations of the SQLite date manipulation functions, the REGEXP operator, and full-text search result ranking algorithms. Installing with git The project is hosted at value. This is also the reason why “IN” queries must be expressed using .in_() rather than the in operator. Check out the table of query operations to see what types of queries are possible. Note A lot type. To combine clauses using logical operators, use: Operator Meaning Example & AND (User.is_active == True) & (User.is_admin == True) | (pipe) OR (User.is_admin) | (User.is_superuser) ~ NOT (unary