[]) Paginating records The paginate method makes it easy to grab a “page” or records – it takes two parameters, page_number, and items_per_page: >>> for entry in Entry.select().order_by(’id’).paginate(2 field indicating when that account was created Relationship: this is a “utility model” that contains two foreign-keys to the User model and represents “follow- ing”. Message: analagous to a tweet. this model code basically allows all our project’s models to connect to our database. 3. Declare a model or two class Blog(BaseModel): name = CharField() Model definition is pretty similar to django or sqlalchemy

[]) Paginating records The paginate method makes it easy to grab a “page” or records – it takes two parameters, page_number, and items_per_page: >>> for entry in Entry.select().order_by('id').paginate(2 field indicating when that account was created Relationship: this is a “utility model” that contains two foreign-keys to the User model and represents “following”. Message: analagous to a tweet. this model code basically allows all our project’s models to connect to our database. 3. Declare a model or two class Blog(BaseModel): name = CharField() Model definition is pretty similar to django or sqlalchemy

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a password = CharField() email = CharField() join_date = DateTimeField() # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between Flask Flask and peewee are a great combo and my go-to for projects of any size. Flask provides two hooks which we will use to open and close our db connection. We’ll open the connection when a request

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a CharField(unique=True) password = CharField() email = CharField() join_date = DateTimeField() # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between users Flask Flask and peewee are a great combo and my go-to for projects of any size. Flask provides two hooks which we will use to open and close our db connection. We’ll open the connection when a request

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analogous to a password = CharField() email = CharField() join_date = DateTimeField() # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between Flask Flask and peewee are a great combo and my go-to for projects of any size. Flask provides two hooks which we will use to open and close our db connection. We’ll open the connection when a request

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analogous to a Contents: peewee Documentation, Release 3.6.0 (continued from previous page) # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between users Flask Flask and peewee are a great combo and my go-to for projects of any size. Flask provides two hooks which we will use to open and close our db connection. We’ll open the connection when a request

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a password = CharField() email = CharField() join_date = DateTimeField() # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between EXISTS(subq)) Aggregation Aggregation is one of those capabilities that really make you appreciate the power of relational database systems. It allows you to move beyond merely persisting your data, into the

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a password = CharField() email = CharField() join_date = DateTimeField() # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between EXISTS(subq)) Aggregation Aggregation is one of those capabilities that really make you appreciate the power of relational database systems. It allows you to move beyond merely persisting your data, into the

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a password = CharField() email = CharField() join_date = DateTimeField() # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between EXISTS(subq)) Aggregation Aggregation is one of those capabilities that really make you appreciate the power of relational database systems. It allows you to move beyond merely persisting your data, into the

field indicating when that account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a CharField(unique=True) password = CharField() email = CharField() join_date = DateTimeField() # this model contains two foreign keys to user -- it essentially allows us to # model a "many-to-many" relationship between users 1.5.6 Aggregation Aggregation is one of those capabilities that really make you appreciate the power of relational database systems. It allows you to move beyond merely persisting your data, into the