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 [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.
