Template for postgres aerich-compatible tortoise ORM configuration file #tortoise-orm #postgres #asyncpg

orm.py

from tortoise import Tortoise

project_db = "test"

TORTOISE_ORM = {
    "connections": {
        "default": {
            "engine": "tortoise.backends.asyncpg",
            "credentials": {
                "user": project_db,
                "password": project_db,
                "database": project_db,
                "host": "localhost",
                "port": 5432,
            },
        },
    },
    "apps": {
        "models": {
            "models": [__name__, "aerich.models"],
            "default_connection": "default",
        },
    },
    "use_tz": True,
    "maxsize": 20,
}


async def init():
    """Initialize the ORM."""
    # Here we connect to a SQLite DB file.
    # also specify the app name of "models"
    # which contain models from "app.models"
    await Tortoise.init(TORTOISE_ORM)