Transaction support about ragtime

[danielcompton]

@codahale just to confirm, are you talking about running multiple different migrations inside a single transaction, or running a single migration inside a transaction?

[codahale]

Sorry if I wasn't clear; I meant running all of the statements of a individual migration in a single, per-migration transaction.

I think it should be as simple as wrapping execute-sql! in a transaction, but it's possible some databases which don't support transactional DDL may throw an exception.

[danielcompton]

Is it possible to do this already with the current SQL migration support? I'm guessing this is the kind of thing you've already tried, but it doesn't work because each command is sent separately (hence this issue)?:

{:up   ["BEGIN"
        "CREATE TABLE foo (name VARCHAR(100))"
        "INSERT INTO foo VALUES ('alice'), ('bob')"
        "COMMIT"]
 :down ["DROP TABLE foo"]}

[codahale]

I actually hadn't thought of that, but I can run transactional DDLs inside migration statements. Thanks for pointing that out; that totally solves my problem. I'll go ahead and close the issue.