app/backend_init.py - master - durovcode/backend

import asyncio

from sqlalchemy import select

from app.database import alchemy_engine
from app.models import AlchemyBase


async def verify_connection() -> None:
    async with alchemy_engine.connect() as connection:
        await connection.execute(statement=select(1))


async def init_database_metadata() -> None:
    async with alchemy_engine.begin() as session:
        await session.run_sync(fn=AlchemyBase.metadata.create_all)


async def main() -> None:
    await verify_connection()
    await init_database_metadata()


if __name__ == '__main__':
    asyncio.run(main=main())