On Friday 09 May 2008 03:05, Lukasz Szybalski wrote: > Do you guys know what would give me column definition of table? do u want it as generated source-text or what? have a look at dbcook/dbcook/misc/metadata/autoload.py at dbcook.sf.net
> I have a table that I autoload and I would like to get this: > > address_table = sqlalchemy.Table('address', metadata, > sqlalchemy.Column('Address_Sid', sqlalchemy.Integer, primary_key=True), > sqlalchemy.Column('FirstName', sqlalchemy.Unicode(40),nullable=False), > sqlalchemy.Column('LastName', sqlalchemy.Unicode(40),nullable=False), > sqlalchemy.Column('MaidenLastName', sqlalchemy.Unicode(40)), > sqlalchemy.Column('Email', sqlalchemy.Unicode(80),nullable=False), > > > So: > I can get a list of tables: > for i in metadata.tables: > ... print i > > list of columns: > for i in metadata.tables['WMI'].original_columns: > ... print i > > How do I get column type, indexes and primary keys? > > Lucas > > On Tue, Apr 15, 2008 at 7:44 PM, Lukasz Szybalski <[EMAIL PROTECTED]> wrote: > > Hello, > > Is there maybe a feature in sqlalchemy that would allow me to autoload > > table from one database, and move it over to another database? > > > > 1. I would like to print data structure from autoload table. (then > > copy and paste it into new file and use it to create new > > table)(without typing every data structure) > > 2. And/or autoload via one engine and autoupload via different engine > > and create_all() > > 3. Analyze csv files and create sqlalchemy definition like structure. > > > > Ideas? > > > > Lucas --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---