Rodney Haynie wrote:
> In SQLAlchemy, is there some process available that will create the
> following code from an existing database/table?  i.e. the database has
> one table, the name of the table is users.
> After running the process, the following code would be created in a file:
>
> users = Table('users', metadata,
>     Column('user_id', Integer, primary_key=True),
>     Column('name', String(40)),
>     Column('age', Integer),
>     Column('password', String),
> )
>
> I understand SQLAlchemy has Reflection, but I am basically talking about
> creating all of this metadata code automatically as a jump start for
> large existing databases.  And something that could be run to keep the
> metadata code in sync after running schema migrations.
>   

I haven't used it myself, but here is a project that will auto-generate
your model:
http://code.google.com/p/sqlautocode/

Can't help you with the sync issue, unless rerunning sqlautocode counts.

-Conor

--

You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=.


Reply via email to