tables Using Postgresql Using SQLite Using BerkeleyDB Using MySQL Connecting using a Database URL Multi-threaded applications Run-time database configuration Dynamically defining a database Connection Pooling ForeignKeyField(User, related_name='related_to') class Meta: indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple Note Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate

to_user = ForeignKeyField(User, related_name='related_to') class Meta: indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple one-to-many relationship: Note: Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. 1.3. Example app 13 peewee Documentation, Release 2.10.2 Making queries instance for the local MySQL 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

indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple Note Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index

indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple Note Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index

index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple one-to-many relationship: Note: Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate < 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index

index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple one-to-many relationship: Note: Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate < 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index

index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple one-to-many relationship: Note: Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate < 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index

indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple Note Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index

indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple Note Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index

index and a boolean indicating # whether the index is unique or not. indexes = ( # Specify a unique multi-column index on from/to-user. (('from_user', 'to_user'), True), ) # a dead simple one-to-many relationship: Note: Peewee uses thread local storage to manage connection state, so this pattern can be used with multi-threaded WSGI servers. Making queries In the User model there are a few instance methods that encapsulate < 10000')]) created = DateTimeField( constraints=[SQL("DEFAULT (datetime('now'))")]) Multi-column indexes Multi-column indexes may be defined as Meta attributes using a nested tuple. Each database index