diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-01-13 23:21:39 -0500 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-01-13 23:21:39 -0500 |
| commit | 2212743dcf34fa34aeebbb2292152cc4d9d6dcdf (patch) | |
| tree | b3b2370325f62685102ba6be01ff985ddab30b73 /internal/repositories/migration_db_repo.go | |
| parent | Update configuration format and env names (diff) | |
| download | cli-2212743dcf34fa34aeebbb2292152cc4d9d6dcdf.zip | |
Add support for turning off transaction execution
Diffstat (limited to 'internal/repositories/migration_db_repo.go')
| -rw-r--r-- | internal/repositories/migration_db_repo.go | 107 |
1 files changed, 75 insertions, 32 deletions
diff --git a/internal/repositories/migration_db_repo.go b/internal/repositories/migration_db_repo.go index 6a37e7b..42cf0e8 100644 --- a/internal/repositories/migration_db_repo.go +++ b/internal/repositories/migration_db_repo.go @@ -6,6 +6,7 @@ import ( "strings" "github.com/eugenetriguba/bolt/internal/models" + "github.com/eugenetriguba/bolt/internal/sqlparse" ) type MigrationDBRepo struct { @@ -87,27 +88,48 @@ func (mr *MigrationDBRepo) Apply( upgradeScript string, migration *models.Migration, ) error { - tx, err := mr.db.Begin() + sqlParser := sqlparse.NewSqlParser(strings.NewReader(upgradeScript)) + execOptions, err := sqlParser.Parse() if err != nil { return err } - defer tx.Rollback() - _, err = tx.Exec(upgradeScript) - if err != nil { - return err - } + if execOptions.UseTransaction { + tx, err := mr.db.Begin() + if err != nil { + return err + } + defer tx.Rollback() - _, err = tx.Exec( - `INSERT INTO bolt_migrations(version) VALUES ($1);`, - migration.Version, - ) - if err != nil { - return err - } - err = tx.Commit() - if err != nil { - return err + _, err = tx.Exec(upgradeScript) + if err != nil { + return err + } + + _, err = tx.Exec( + `INSERT INTO bolt_migrations(version) VALUES ($1);`, + migration.Version, + ) + if err != nil { + return err + } + err = tx.Commit() + if err != nil { + return err + } + } else { + _, err = mr.db.Exec(upgradeScript) + if err != nil { + return err + } + + _, err = mr.db.Exec( + `INSERT INTO bolt_migrations(version) VALUES ($1);`, + migration.Version, + ) + if err != nil { + return err + } } migration.Applied = true @@ -121,28 +143,49 @@ func (mr *MigrationDBRepo) Revert( downgradeScript string, migration *models.Migration, ) error { - tx, err := mr.db.Begin() + sqlParser := sqlparse.NewSqlParser(strings.NewReader(downgradeScript)) + execOptions, err := sqlParser.Parse() if err != nil { return err } - defer tx.Rollback() - _, err = tx.Exec(downgradeScript) - if err != nil { - return err - } + if execOptions.UseTransaction { + tx, err := mr.db.Begin() + if err != nil { + return err + } + defer tx.Rollback() - _, err = tx.Exec( - `DELETE FROM bolt_migrations WHERE version = $1;`, - migration.Version, - ) - if err != nil { - return err - } + _, err = tx.Exec(downgradeScript) + if err != nil { + return err + } - err = tx.Commit() - if err != nil { - return err + _, err = tx.Exec( + `DELETE FROM bolt_migrations WHERE version = $1;`, + migration.Version, + ) + if err != nil { + return err + } + + err = tx.Commit() + if err != nil { + return err + } + } else { + _, err = mr.db.Exec(downgradeScript) + if err != nil { + return err + } + + _, err = mr.db.Exec( + `DELETE FROM bolt_migrations WHERE version = $1;`, + migration.Version, + ) + if err != nil { + return err + } } migration.Applied = false |