I'm pleased to announce the first release of my open source (Apache V2 License) fantom-migrations library - a database migrations library loosely based on ruby's migrations and the scala-migrations library. It's available on google-code at http://code.google.com/p/fantom-migrations/.
The work for this was sponsored in part by a client who wants to remain anonymous (but thanks - you know who you are!).
The library has been relatively well tested on a fairly small schema with a dozen or migrations, but I'd love for it to get a bit more abuse to make it robust.
It has only been tested against MySql for now (discovered 762 tonight when starting to bring PostgreSql into the picture), so there will be some work there to expand it out to more databases in the near future.
Otherwise, the documentation on google-code is pretty much non-existant, but the test cases and example code should be enough to get you going... and feel free to get in touch with questions.
Martin
KevinKelleyThu 18 Feb 2010
Impressive, very nice. I was wishing for something like this.
SqlService constructor (as in ManagerTest.setup) now needs a MySqlDialect() parameter or it defaults to something other than MySql ( #753) ... with that it runs purfectly for me on 1.0.51. Much thanks for this work!
mslTue 11 Jan 2011
Hi All,
A quick heads up that I've bumped the version of this to 0.2. No new features per se, however it does bring the migrations APIs inline with the new (1.0.57) sql pod changes and deprecation.
As a result of this, there may be some breaking changes around no longer using the sql::SqlService but instead just defining the JDBC uri, username and password to use in connecting to the database (trivial to fix).
If you're using this code -- drop me a message, I suspect that I'm the only one :)
msl Thu 18 Feb 2010
Hi All,
I'm pleased to announce the first release of my open source (Apache V2 License) fantom-migrations library - a database migrations library loosely based on ruby's migrations and the scala-migrations library. It's available on google-code at http://code.google.com/p/fantom-migrations/.
The work for this was sponsored in part by a client who wants to remain anonymous (but thanks - you know who you are!).
The library has been relatively well tested on a fairly small schema with a dozen or migrations, but I'd love for it to get a bit more abuse to make it robust.
It has only been tested against MySql for now (discovered 762 tonight when starting to bring PostgreSql into the picture), so there will be some work there to expand it out to more databases in the near future.
Otherwise, the documentation on google-code is pretty much non-existant, but the test cases and example code should be enough to get you going... and feel free to get in touch with questions.
Martin
KevinKelley Thu 18 Feb 2010
Impressive, very nice. I was wishing for something like this.
SqlService constructor (as in ManagerTest.setup) now needs a MySqlDialect() parameter or it defaults to something other than MySql ( #753) ... with that it runs purfectly for me on 1.0.51. Much thanks for this work!
msl Tue 11 Jan 2011
Hi All,
A quick heads up that I've bumped the version of this to 0.2. No new features per se, however it does bring the migrations APIs inline with the new (1.0.57) sql pod changes and deprecation.
As a result of this, there may be some breaking changes around no longer using the sql::SqlService but instead just defining the JDBC uri, username and password to use in connecting to the database (trivial to fix).
If you're using this code -- drop me a message, I suspect that I'm the only one :)
M
kaushik Tue 11 Jan 2011
Thanks.