add column to SQLAlchemy Table

Question

I made a table using SQLAlchemy and forgot to add a column. I basically want to do this:

users.addColumn('user_id', ForeignKey('users.user_id')) 

What's the syntax for this? I couldn't find it in the docs.

Answer 1

I have the same problem, and a thought of using migration library only for this trivial thing makes me
tremble. Anyway, this is my attempt so far:

def add_column(engine, table_name, column):     column_name = column.compile(dialect=engine.dialect)     column_type = column.type.compile(engine.dialect)     engine.execute('ALTER TABLE %s ADD COLUMN %s %s' % (table_name, column_name, column_type))  column = Column('new_column_name', String(100), primary_key=True) add_column(engine, table_name, column) 

Still, I don't know how to insert primary_key=True into raw SQL request.

Answer 2

This is referred to as database migration (SQLAlchemy doesn't support migration out of the box). You can look at using sqlalchemy-migrate to help in these kinds of situations, or you can just ALTER TABLE through your chosen database's command line utility,