Michael, Looks promising but I need some time to get clues about the workings.
I lost my password for bitbucket, I have a project there too, mp2mwsgi to run mod_python code on top of mod_wsgi (or any other wsgi but not tested) I might very well extend alembic and put an frond-end on it using extjs which I use for my project. I'll be in touch! Martijn On Sep 6, 2011, at 16:09 , Michael Bayer wrote: > > 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. > -- 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.
