Do you guys know what would give me column definition of table?
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
-~----------~----~----~----~------~----~------~--~---
