On Fri, May 9, 2008 at 4:46 AM, <[EMAIL PROTECTED]> wrote: > > 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?
Yes. The Final output I would like is the txt version of db definitions. autoload ---> sqlalchemy.Column('Address_Sid', sqlalchemy.Integer, primary_key=True), > 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 > > > > -- Automotive Recall Database. Cars, Trucks, etc. http://www.lucasmanual.com/recall/ TurboGears Manual-Howto http://lucasmanual.com/pdf/TurboGears-Manual-Howto.pdf --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---