Tortoise-ORM Sanic integration

We have a lightweight integration util tortoise.contrib.sanic which has a single function register_tortoise which sets up Tortoise-ORM on startup and cleans up on teardown.

See the Sanic Example

Reference

tortoise.contrib.sanic.register_tortoise(app, config=None, config_file=None, db_url=None, modules=None, generate_schemas=False)[source]

Registers before_server_start and after_server_stop hooks to set-up and tear-down Tortoise-ORM inside a Sanic webserver.

You can configure using only one of config, config_file and (db_url, modules).

Parameters:
app

Sanic app.

config=None

Dict containing config:

Example

{
    'connections': {
        # Dict format for connection
        'default': {
            'engine': 'tortoise.backends.asyncpg',
            'credentials': {
                'host': 'localhost',
                'port': '5432',
                'user': 'tortoise',
                'password': 'qwerty123',
                'database': 'test',
            }
        },
        # Using a DB_URL string
        'default': 'postgres://postgres:qwerty123@localhost:5432/events'
    },
    'apps': {
        'models': {
            'models': ['__main__'],
            # If no default_connection specified, defaults to 'default'
            'default_connection': 'default',
        }
    }
}

config_file=None

Path to .json or .yml (if PyYAML installed) file containing config with same format as above.

db_url=None

Use a DB_URL string. See DB_URL

modules=None

Dictionary of key: [list_of_modules] that defined “apps” and modules that should be discovered for models.

generate_schemas=False

True to generate schema immediately. Only useful for dev environments or SQLite :memory: databases

Raises:

ConfigurationError – For any configuration error

Return type:

None