existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating records Counting records Relationships and Joins Model definitions Performing simple joins Joining multiple tables Selecting from multiple sources Subqueries Multiple foreign-keys to the same Model Joining on arbitrary fields Self-joins Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable

existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating records Counting records Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person

existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating records Counting records Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person

Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person .select(Person include wildcards here: query = Facility.select().where(Facility.name ** '%tennis%') Matching against multiple possible values How can you retrieve the details of facilities with ID 1 and 5? Try to do it without

Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person .select(Person number of parameters and return a single value. • Aggregates - which aggregate parameters from multiple rows and return a single value. • Collations - which describe how to sort some value. Note: For

Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person .select(Person number of parameters and return a single value. • Aggregates - which aggregate parameters from multiple rows and return a single value. • Collations - which describe how to sort some value. Note: For

Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person .select(Person include wildcards here: query = Facility.select().where(Facility.name ** '%tennis%') Matching against multiple possible values How can you retrieve the details of facilities with ID 1 and 5? Try to do it without

existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating records Counting records Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person

existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating records Counting records Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable using a relational databases, if we were to do a join from Person to Pet then every person with multiple pets would be repeated, once for each pet. It would look like this: query = (Person

Databases Adding Request Hooks Additional connection initialization Advanced Connection Management Using multiple databases Database Errors Automatic Reconnect Logging queries Generating skeleton code Adding a existing records Atomic updates Deleting records Selecting a single record Create or get Selecting multiple records Filtering records Sorting records Getting random records Paginating records Counting records Person instead of People. This is a convention you should follow – even though the table will contain multiple people, we always name the class using the singular form. There are lots of field types suitable