like UML, these are the tables and relationships: In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=((‘foreign_keys’, ‘on’),) when you instantiate SqliteDatabase. Traversing foreign keys Referring back to the User and Tweet models, note that

like UML, these are the tables and relationships: In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. Traversing foreign keys Referring back to the User and Tweet models, note that

like UML, these are the tables and relationships: In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. Traversing foreign keys Referring back to the User and Tweet models, note that

like UML, these are the tables and relationships: In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. Traversing foreign keys Referring back to the User and Tweet models, note that

1. Contents: peewee Documentation, Release 3.5.0 In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. 74 Chapter 1. Contents: peewee Documentation, Release 3.5.0 Traversing foreign

1. Contents: peewee Documentation, Release 3.3.0 In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. 1.10.1 Traversing foreign keys Referring back to the User and Tweet models, note

1. Contents: peewee Documentation, Release 3.4.0 In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. 1.10.1 Traversing foreign keys Referring back to the User and Tweet models, note

like UML, these are the tables and relationships: In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential referencing_key=UserRelations.user) 4. In your application code, make sure you load the extension when you instantiate your Database object. This is done by passing the path to the shared library to the load_extension()

like UML, these are the tables and relationships: In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential referencing_key=UserRelations.user) 4. In your application code, make sure you load the extension when you instantiate your Database object. This is done by passing the path to the shared library to the load_extension()

like UML, these are the tables and relationships: In order to create these models we need to instantiate a SqliteDatabase object. Then we define our model classes, specifying the columns as Field instances which links a child object to its parent. Because the model class is not defined at the time you instantiate the self-referential foreign key, use the special string 'self' to indicate a self-referential overall to ensure that foreign keys are enabled with pragmas=(('foreign_keys', 'on'),) when you instantiate SqliteDatabase. Performing simple joins As an exercise in learning how to perform joins with