columns. For the twitter clone, there are just three models: User: Represents a user account and stores the username and password, an email address for generating avatars using gravatar, and a datetime that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a tweet. The Message model stores the text content of the tweet, when it was created, MySQL database my_db. More examples in the db_url documentation. Multi-threaded applications peewee stores the connection state in a thread local, so each thread gets its own separate connection. If you prefer

columns. For the twitter clone, there are just three models: User: Represents a user account and stores the username and password, an email address for generating avatars using gravatar, and a datetime that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a tweet. The Message model stores the text content of the tweet, when it was created, and database my_db. • More examples in the db_url documentation. 1.6.7 Multi-threaded applications peewee stores the connection state in a thread local, so each thread gets its own separate connection. If you prefer

mended): concurrent_db = SqliteDatabase(’stats.db’, threadlocals=True) The above implementation stores connection state in a thread local and will only use that connection for a given thread. Pysqlite schema. For the twitter clone, there are just three models: User: represents a user account and stores the username and password, an email address for generating avatars using gravatar, and a datetime foreign-keys to the User model and represents “follow- ing”. Message: analagous to a tweet. this model stores the text content of the message, when it was created, and who posted it (foreign key to User). If

threadlocals=True: concurrent_db = SqliteDatabase('stats.db', threadlocals=True) The above implementation stores connection state in a thread local and will only use that connection for a given thread. Sqlite can schema. For the twitter clone, there are just three models: User: represents a user account and stores the username and password, an email address for generating avatars using gravatar, and a datetime foreign-keys to the User model and represents “following”. Message: analagous to a tweet. this model stores the text content of the message, when it was created, and who posted it (foreign key to User). If

threadlocals=True) 6 Chapter 1. Contents: peewee Documentation, Release 1.0.0 The above implementation stores connection state in a thread local and will only use that connection for a given thread. Sqlite can schema. For the twitter clone, there are just three models: User: represents a user account and stores the username and password, an email address for generating avatars using gravatar, and a datetime foreign-keys to the User model and represents “follow- ing”. Message: analagous to a tweet. this model stores the text content of the message, when it was created, and who posted it (foreign key to User). 1

schema. For the twitter clone, there are just three models: User: represents a user account and stores the username and password, an email address for generating avatars using gravatar, and a datetime foreign-keys to the User model and represents “following”. Message: analagous to a tweet. this model stores the text content of the message, when it was created, and who posted it (foreign key to User). If exists on has been created. class CharField Stores: small strings (0-255 bytes) class TextField Stores: arbitrarily large strings class DateTimeField Stores: python datetime.datetime instances Accepts

schema. For the twitter clone, there are just three models: User: represents a user account and stores the username and password, an email address for generating avatars using gravatar, and a datetime foreign-keys to the User model and represents “follow- ing”. Message: analagous to a tweet. this model stores the text content of the message, when it was created, and who posted it (foreign key to User). If exists on has been created. class CharField Stores: small strings (0-255 bytes) class TextField Stores: arbitrarily large strings class DateTimeField Stores: python datetime.datetime instances Accepts

new ones) and that you’d like the changes to be stored as a migration. Migrations are how Django stores changes to your models (and thus your database schema) - they’re just files on disk. You can read wanted to know the lowest and highest price of any book that is available for sale in any of the stores, you could use the aggregate: >>> Store.objects.aggregate(min_price=Min('books__price'), max_pr matters because a middleware can depend on other middleware. For instance, AuthenticationMiddleware stores the authenticated user in the session; therefore, it must run after SessionMiddleware. See Middleware

new ones) and that you’d like the changes to be stored as a migration. Migrations are how Django stores changes to your models (and thus your database schema) - they’re just files on disk. You can read wanted to know the lowest and highest price of any book that is available for sale in any of the stores, you could use the aggregate: 126 Chapter 3. Using Django Django Documentation, Release 2.1.16 matters because a middleware can depend on other middleware. For instance, AuthenticationMiddleware stores the authenticated user in the session; therefore, it must run after SessionMiddleware. See Middleware

new ones) and that you’d like the changes to be stored as a migration. Migrations are how Django stores changes to your models (and thus your database schema) - they’re just files on disk. You can read wanted to know the lowest and highest price of any book that is available for sale in any of the stores, you could use the aggregate: >>> Store.objects.aggregate(min_price=Min('books__price'), max_pr matters because a middleware can depend on other middleware. For instance, AuthenticationMiddleware stores the authenticated user in the session; therefore, it must run after SessionMiddleware. See Middleware