> You need to create new Column objects for each table because the table > objects take ownership of the passed in columns. I think that is what i'm doing,creating new column objects for 2 columns and first appending it to the table object and then trying to create those columns using create_column,please correct me if i'm wrong.
On 21 Sep, 20:24, AM <age...@themactionfaction.com> wrote: > On Sep 21, 2011, at 6:30 AM, pravin battula wrote: > Hi, > > > How can i create columns in bulk? > > I tried as below but doesn't work. > > > migrate_engine = create_engine('mysql://root:root@localhost/ > > payroll', echo=False) > > metadata = MetaData(bind = migrate_engine) > > metadata.reflect(bind = migrate_engine, schema = 'payroll') > > > tableObj = metadata.tables.get('test.salary') > > > colList = > > [Column('description',String(100)),Column('information',String(50))] > > > tableObj.append_column(colList) > > tableObj.create_column(colList) > > You need to create new Column objects for each table because the table > objects take ownership of the passed in columns. > > Cheers, > M -- 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.