On Jan 1, 2008, at 10:43 AM, braydon fuller wrote:
>
> Hello,
>
> Is there a way to use SQLAlchemy to update my already created database
> tables,
> so that if I were to take:
>
> audio_table = Table('objects_audio', metadata,
> Column('id', Integer, primary_key=True),
> Column('oid',Integer, ForeignKey("objects.oid")),
> Column('src', String(1000))
> )
>
> and add, or modify a few columns:
>
> audio_table = Table('objects_audio', metadata,
> Column('id', Integer, primary_key=True),
> Column('oid',Integer, ForeignKey("objects.oid")),
> Column('src', String(1000)),
> Column('format', String(1000)),
> Column('length', String(1000)),
> Column('size', String(1000))
> )
>
> it would create the new columns,
> as well as update changes with existing columns?
this is something Migrate is intended to do:
http://code.google.com/p/sqlalchemy-migrate/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
