when a request is started and close it when the response is delivered: database = SqliteDatabase('my_app.db') def before_request_handler(): database.connect() def after_request_handler(): database database object you wish to use, and then all your models will extend it: database = SqliteDatabase('my_app.db') class BaseModel(Model): class Meta: database = database class User(BaseModel): parameters [http://initd.org/psycopg/docs/module.html#psycopg2.connect]. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

when a request is started and close it when the response is delivered: database = SqliteDatabase('my_app.db') def before_request_handler(): database.connect() def after_request_handler(): database.close() database object you wish to use, and then all your models will extend it: database = SqliteDatabase('my_app.db') class BaseModel(Model): class Meta: database = database class User(BaseModel): username database, and after that you can specify arbitrary psycopg2 parameters. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: Postgresql parameters [http://initd.org/psycopg/docs/module.html#psycopg2.connect]. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

network. mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres', password='secret' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: • database, and after that you can specify arbitrary psycopg2 parameters. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: Postgresql parameters [http://initd.org/psycopg/docs/module.html#psycopg2.connect]. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

network. mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres', password='secret' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: • database, and after that you can specify arbitrary psycopg2 parameters. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): (continues on next page) 40 Chapter 1. Contents:

mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: Postgresql parameters [http://initd.org/psycopg/docs/module.html#psycopg2.connect]. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

network. mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres', password='secret' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) 1.6. Database 39 peewee Documentation, Release 3.3.0 database, and after that you can specify arbitrary psycopg2 parameters. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: Postgresql parameters [http://initd.org/psycopg/docs/module.html#psycopg2.connect]. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql

mysql_db = MySQLDatabase('my_app', user='app', password='db_password', host='10.1.0.8', port=3316) # Connect to a Postgres database. pg_db = PostgresqlDatabase('my_app', user='postgres' PostgresqlExtDatabase # Use Postgres (and register hstore extension). db = PostgresqlExtDatabase('my_app', user='postgres', register_hstore=True) For more information on database extensions, see: Postgresql parameters [http://initd.org/psycopg/docs/module.html#psycopg2.connect]. psql_db = PostgresqlDatabase('my_database', user='postgres') class BaseModel(Model): """A base model that will use our Postgresql