using alembic migration

[nbraun-wolf]

Hi, I am having a lot of trouble using the databases package with SQL alchemy, so I am looking for alternatives. Is it possible to use this ORM with alembic?

Edit:
Sorry, I haven't seen this sentence in the README. So, seems like it's possible. Are there any examples how to do that?

Because ORM is built on SQLAlchemy core, you can use Alembic to provide database migrations.

[aminalaee]

Yes that's possible, but it's a bit complicated for now, we need to fix it:

You run alembic init obviously.
You need to specify target_metadata in alembic env.py so in your models you have:

# models.py
...
class Product(orm.Model):
    tablename = "products"
    registry = models
    fields = {
        "id": orm.Integer(primary_key=True),
        "name": orm.String(max_length=100),
        "rating": orm.Integer(minimum=1, maximum=5),
        "in_stock": orm.Boolean(default=False),
    }

metadata = models.metadata

And for alembic:

# env.py
...
from models import metadata
target_metadata = metadata

And then running alembic revision --autogenerate works.

[Kokoserver]

i tried it, id does not work for me

[aminalaee]

You need to provide more information so that people can help. Please provide some information on how it's not working, are you seeing errors?

[aminalaee]

And if you're interested to contribute:

We need to change this:

orm/orm/models.py

Line 28 in c6b9c0e

self.metadata = sqlalchemy.MetaData()

To:

self._metadata = sqlalchemy.MetaData() 

And add a metadata property:

@property
def metadata():
    for model_cls in self.models.values():
            model_cls.build_table()
    return metadata

We need this in a few other places too. If you have any feedback or would like to contribute, feel free.

[bluebrown]

OK, thanks. I have forked the project, and I am checking it out.

[aminalaee]

If you need any help, feel free to ask here.