id	summary	reporter	owner	description	type	status	priority	milestone	component	resolution	keywords	cc	parents
459	Improve migration framework	Elrond		"We had a problem with two migrations not working nicely on sqlite, because the second one wanted to do an {{{alter table}}} and sqlite doesn't like to do that in a bigger transaction. Long story: Every migration should say ""I'm done"" and {{{commit}}}. This happened for the existing migrations.

So. In my opinion, the migration framework should run a {{{rollback}}} after each migration ""just in case"" to clean up any cruft left over from a (possibly broken) migration.
{{{
- migration_func(self.session)
+ try:
+   migration_func(self.session)
+ finally:
+   self.session.rollback()
}}}

I have NOT TESTED this patch. This is just to show the idea. I want some feedback on it, and possibly someone to test it."	enhancement	closed	minor		programming	wontfix	patch	berkerpeksag