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=.