On Friday 09 May 2008 16:32:25 Lukasz Szybalski wrote:
> 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),
well, then see that one.
> > have a look at dbcook/dbcook/misc/metadata/autoload.py
> > at dbcook.sf.net
running 'python autoload.py dburl' will dump the db-metadata into
src-text, trying to convert some types into their generic form.
see also other files in that directory, copyall.py and copydata.py,
for copying stuff between dburls.
ciao
svil
> >> 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
-~----------~----~----~----~------~----~------~--~---
