On Sep 6, 2011, at 9:38 AM, Martijn Moeling wrote: > Hi! > > As a big fan of SQLA I am looking for a way to implement something which > would in fact be something like phpmysqladmin but based on SQLA and not as > big. I know about "migrate" but that is not the way to go for me. > > Basically I would like to generate: > databases > tables > Python objects (reflecting those tables) > > In my own (web) framework I have the ability to load python objects > dynamically from a database so that is not the problem. I could use the > generated SQLAlchemy objects as a base class for the programmer to extend > (which can be done from the web-interface). Something like class > Customer(Customer_SQLABase)…. > > The problem I have is in updating the record structure in the database. To > keep things in sync with SQLA development I'm puzzled which approach to take. > Should I customize DDL? as described in /docs/core/schema.html? > > Any thoughts, hint or tips would be very nice…
I have a library that serves as the "base" for a bunch of new ALTER constructs and such called Alembic: https://bitbucket.org/zzzeek/alembic/overview . It uses the @compiled system to achieve this. I wrote most of it over a year ago and its basically a project needing some more work to write basic documentation and flesh it out some more (though I have used it on the job to a minimal extent). It's a migration tool, but also can be used just for the DDL constructs which you can see in alembic.ddl (i.e. same philosophy as SQLAlchemy - provide more rudimental tools as well as functionality on top). You can check it out to see some of the ALTERs, and also any code/documentation/beta tester contributions are entirely welcome as well (it just would require some source code reading since there's no docs yet). -- 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.
