Ways to manage DB migrations with SQLAlchemy?

python sqlalchemy database-migration
Jeremy Cantrell picture Jeremy Cantrell · Mar 14, 2011 · Viewed 10.3k times · Source

I've looked at sqlalchemy-migrate, but it just seems like a lot of work and I haven't been able to find any useful examples.

Anyone care to share how they handle this?

Answer

Dmitry Nedbaylo picture Dmitry Nedbaylo · Nov 11, 2011

Check out new project Alembic: http://readthedocs.org/docs/alembic/en/latest/index.html

Related questions

sqlalchemy : executing raw sql with parameter bindings

I'm trying to run this simple raw sql statement with parameters with SQLALchemy (within an alembic script) : from alembic import op t = {"code": "123", "description": "one two three"} op.execute("insert into field_tags (id, field_id, code, description) "+ "values (1,'zasz', :…

Read More
SQLAlchemy ORDER BY DESCENDING?

How can I use ORDER BY descending in a SQLAlchemy query like the following? This query works, but returns them in ascending order: query = (model.Session.query(model.Entry) .join(model.ClassificationItem) .join(model.EnumerationValue) .filter_by(id=c.row.…

Read More
How to execute raw SQL in Flask-SQLAlchemy app

How do you execute raw SQL in SQLAlchemy? I have a python web app that runs on flask and interfaces to the database through SQLAlchemy. I need a way to run the raw SQL. The query involves multiple table joins …

Read More