aerich
aerich copied to clipboard
A database migrations tool for TortoiseORM, ready to production.
I have a [zalando postgres-operator](https://github.com/zalando/postgres-operator) based database cluster on my k8 cluster. I have a separate FastAPI + tortoise ORM app. Tortoise uses the postgres db generated by the operator....
The mysql migration that aerich generates for enums has a problem with defaults This state here causes an error: ```sql ALTER TABLE `station` ALTER COLUMN `connection` SET DEFAULT 'Connection.OFFLINE' ```...
Aerich tries to drop constraint "fk_balance_person_a8a4fbbc" that does not exist. 1_20220725214250_test.sql ```sql -- upgrade -- ALTER TABLE "balance" DROP CONSTRAINT "fk_balance_person_a8a4fbbc"; ALTER TABLE "balance" RENAME COLUMN "person_id_id" TO "person_id"; ALTER...
If you have/add a `OnetoOneNullableRelation` to a model, you get the following error with both `aerich init-db` and `aerich migrate`: ```py Traceback (most recent call last): File "/usr/local/bin/aerich", line 8,...
Fix for Windows incompatibility On Windows, Psycopg is not compatible with the default [ProactorEventLoop](https://docs.python.org/3/library/asyncio-eventloop.html#asyncio.ProactorEventLoop). Please use a different loop, for instance the [SelectorEventLoop](https://docs.python.org/3/library/asyncio-eventloop.html#asyncio.SelectorEventLoop). For instance, you can use, early in...
Hi, I'm having issues when running `aerich migrate` using version `0.6.3`. However, when downgrading to `0.6.2` the commands works properly. Here is the complete traceback: ```bash Traceback (most recent call...
I set my tortoise ORM like this `TORTOISE_ORM_CONFIG = \ { 'connections': { # Using a DB_URL string 'default': 'mysql://root:123456@localhost:3306/SchoolManage' }, 'apps': { 'models': { 'models': ['database.models', "aerich.models"], # #...
Is aerich going to support datamigrations? I mean when you can write your migration logic in python, not only SQL. Django and alembic support them, but aerich not :(
Hi, The aerich automatically create `id` field as an IntField when I didn't define the `id` field. But I defined `id` as a BigIntField specifically but the aerich doesn't upgrade...