aboutsummaryrefslogtreecommitdiffstats
path: root/internal/repositories/migration_db_repo.go
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-01-13 23:21:39 -0500
committerEugene Triguba <eugenetriguba@gmail.com>2024-01-13 23:21:39 -0500
commit2212743dcf34fa34aeebbb2292152cc4d9d6dcdf (patch)
treeb3b2370325f62685102ba6be01ff985ddab30b73 /internal/repositories/migration_db_repo.go
parentUpdate configuration format and env names (diff)
downloadcli-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.go107
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