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: sqlalchemy@googlegroups.com > [mailto:sqlalch...@googlegroups.com] On Behalf Of > jarrod.ches...@gmail.com > 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 <mtr...@gmail.com> wrote: > > Hi, > > > > On Thu, Dec 11, 2008 at 8:12 AM, jarrod.ches...@gmail.com < > > > > > > > > jarrod.ches...@gmail.com> 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 sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
