SQLALchemy doesn't (directly) contain functions for altering tables. You may be interested in the sqlalchemy-migrate project:
http://code.google.com/p/sqlalchemy-migrate/ The first example on this page shows how to add a column: http://code.google.com/p/sqlalchemy-migrate/wiki/MigrateChangeset Hope that helps, Simon > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected] > Sent: 12 December 2008 07:08 > To: sqlalchemy > Subject: [sqlalchemy] Re: Create tables with metadata > > > Doesn't get created in the database. > How do i add columns to tables already defined in the database after i > have reflected them into the metadata > > > > On Dec 12, 12:59 am, Empty <[email protected]> wrote: > > Hi, > > > > On Thu, Dec 11, 2008 at 8:12 AM, [email protected] < > > > > > > > > [email protected]> wrote: > > > > > Hi > > > I've scoured the documentation and i can't find any info on how to > > > create a column using metadata. > > > > > from sqlalchemy import engine > > > from sqlalchemy import schema > > > from sqlalchemy import types > > > > > _config_dbengine = engine.create_engine('sqlite:////tmp/db') > > > _config_metadata = schema.MetaData(_config_dbengine, reflect=True) > > > table = _config_metadata.tables['table_name'] > > > table.append_column(schema.Column('id', types.Integer, > > > primary_key=True, autoincrement=True)) > > > > > This is the steps i'm using but the column doesn't get created. > > > > Doesn't get created where? In the database? That's not > going to happen. > > Are you saying it's not included as part of the table definition? > > > > Michael > --~--~---------~--~----~------------~-------~--~----~ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
