Transaction Support about ruckusing-migrations HOT 2 CLOSED

Yes probably a good idea. Although I think MySQL still doesn't support DDL
statements in transactions.

On Fri, Jun 6, 2014 at 12:50 AM, Jeremy [email protected] wrote:

I would like the up and down methods to be wrapped in SQL transactions, if
the backend supports it (and I believe they all do).

I was surprised to see that a table was left in my database after an
execute statement errored out.

—
Reply to this email directly or view it on GitHub
#132.

from ruckusing-migrations.

Cody,

You are right. While it would be WONDERFUL to run up/down()'s with
transaction support, this is not possible for DDL type statements
(statements that change the schema). Good idea though, Jeremy.

http://dev.mysql.com/doc/refman/5.0/en/cannot-roll-back.html

Cheers,
Kevin

Cody Caughlan mailto:[email protected]
June 6, 2014 at 5:19 PM
Yes probably a good idea. Although I think MySQL still doesn't support
DDL
statements in transactions.

On Fri, Jun 6, 2014 at 12:50 AM, Jeremy [email protected] wrote:

I would like the up and down methods to be wrapped in SQL
transactions, if
the backend supports it (and I believe they all do).

I was surprised to see that a table was left in my database after an
execute statement errored out.

—
Reply to this email directly or view it on GitHub
#132.

—
Reply to this email directly or view it on GitHub
#132 (comment).

from ruckusing-migrations.