Worflow for code in production?

[hellow554]

Hey everyone,

I have a (hopefully) simple question, which is not covered by the Readme IMHO.

I develop my app and use migrate all the time. The migration folders grows, I commit it to git -- nothing special so far.

My code looks something like this:

async def start_database() -> None:
    async with Command(
        tortoise_config=TORTOISE_ORM,
        app="windfish",
    ) as command:
        await command.upgrade()
        await command.init()

Now I have a server that I want my app to run. Typically that server does not have a database to start with. So I add something like await command.init_db(safe=True) to the code snippet above as the first line.

That does not work with the following error:

  File "src/windfish/__main__.py", line 19, in main
    await start_database()
  File "src/windfish/models/__init__.py", line 22, in start_database
    await command.init_db(safe=True)
  File ".venv/lib/python3.14/site-packages/aerich/__init__.py", line 237, in init_db
    await self._do_init(safe, pre_sql)
  File ".venv/lib/python3.14/site-packages/aerich/__init__.py", line 257, in _do_init
    raise FileExistsError(str(unexpected_file))
FileExistsError: migrations/windfish/__pycache__

That is unfortunate.

How is the workflow supposed to work? Should I check in advance if the database exists (works for me, because I use sqlite)?
Is there something I'm missing here?!

[waketzheng]

For sqlite:

• If you have migration files in migrations/windfish, run upgrade will auto create database, code can be:

async def start_database() -> None:
    async with Command(
        tortoise_config=TORTOISE_ORM,
        app="windfish",
    ) as command:
        await command.upgrade()
        # No need to call init()
        # await command.init()

• If you does not have any migration file yet, remove the __pycache__ and keep migrations/windfish/ empty, code can be:

from aerich.migrate import Migrate

async def start_database() -> None:
    async with Command(tortoise_config=TORTOISE_ORM, app="windfish") as command:
         if Migrate.get_all_version_modules():
             await command.upgrade()
         else:
             await command.init_db(safe=True)