-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Lele Gaifax ha scritto: > Manlio Perillo <manlio.peri...@gmail.com> writes: > >> Michael Bayer ha scritto: >>> Similarly, the concept of a "version" as an integer number is not really >>> flexible enough - >> The idea was to keep it simple. > > IMHE, there's no such a beast! > >>> I would like to investigate the creation of migration >>> scripts between branches as well. >> The version can then be a string, but it needs to sortable (see >> setuptool as an example). >> >>> The mechanism of schema versioning is >>> not at all something that belongs in SQLAlchemy core. > > I'm all with Michael here. Sure, for *very* simple projects, it'd be > nice to have a mechanism that spits out the needed statements, but at > least in my experience (going from very little to moderately big and > complex schemas), maintaining an upgradable path is something better > done at another level. Some steps needs an hand-crafted solution, that > maybe involve dropping/recreating dependencies, temporary data-space to > upgrade existing contents and so on. >
I think you have misunderstod my propose. The propose was not to to spits out the needed statements, but to call user defined functions for a migration path from version x to version y. That's why it should be kept simple: different users need different features, and this is up to high level applications that are built on top of the base support to migration. You can have very simple upgrade functions that use SQLAlchemy builtin DDL, or you can have complex scripts with hand written SQL. I'm interested in a reusable core. The more is simple, the more is reusable (unless it is too simple, and thus useless) > [...] Regards Manlio -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkuQ/UMACgkQscQJ24LbaUSxxwCePPm9N6e+oZAqf/Zwo/kt5f9M cOsAn2UzpxfSmg3W+lOWuWADds60D/Xs =B6HL -----END PGP SIGNATURE----- -- 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=en.