web2py database migration workflow

[Diogo Munaro]

Hey guys, I was thinking about web2py migrates and how control database version.

I did a workflow that take care of database version control and it's extensible for a lot of version controls (like git or mercurial, but by now only git) and databases (by now only mysql and postgres, but extensible too).

This workflow could be useful with Continuous Integration environment.

It's open for all kind of usage and is here for more information: https://github.com/dmvieira/web2py-migrate

I'll love collaboration and feedback ;)

Regards

[Dave S]

On Saturday, August 30, 2014 9:15:37 PM UTC-7, Diogo Munaro wrote:

Hey guys, I was thinking about web2py migrates and how control database version.

I did a workflow that take care of database version control and it's extensible for a lot of version controls (like git or mercurial, but by now only git) and databases (by now only mysql and postgres, but extensible too).

Looks interesting.  I haven't worried too much about migrations yet because I dont' have a "real production" environment, but it certainly looks like it will be worth studying the flow chart, so I printed it out.

I'm a Mercurial type myself, but I don't know how much testing I can help with.  If I can, though, I will.

(I'm also a sqlite type, though I've used Postgres in class.)

 

This workflow could be useful with Continuous Integration environment.

It's open for all kind of usage and is here for more information: https://github.com/dmvieira/web2py-migrate

I'll love collaboration and feedback ;)

Regards

Thanks!

/dps
 

[Diogo Munaro]

Thank you Dave!

Hey!! The project have an issue about mercurial [1] and you can help a lot with sqlite too!

You just need to follow developers guide that I wrote in README:

"There are dummy files inside folders version_control and databases.

These dummy files are useful if you want to extend this project because all of needed functions are there to implement new database or version control support."

If you need more help please send me PM by mail

I will enhance README for developers and post here soon

[1] https://github.com/dmvieira/web2py-migrate/issues/1

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/4z55wXvUq40/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Diogo Munaro]

Hey guys, I updated developers readme: https://github.com/dmvieira/web2py-migrate/blob/master/README.md#for-developers