aboutsummaryrefslogtreecommitdiffstats
path: root/internal/services
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2024-01-06 16:23:02 -0500
committerEugene Triguba <eugenetriguba@gmail.com>2024-01-06 16:23:02 -0500
commit263ce3e4b368a50efee1a53af11a76a12af0a119 (patch)
tree8917754f3b43830604f6ad4c7115934ed633f1d8 /internal/services
parentFix syntax (diff)
downloadcli-263ce3e4b368a50efee1a53af11a76a12af0a119.zip
Break up migration repo into fs and db with a service
Diffstat (limited to 'internal/services')
-rw-r--r--internal/services/migration.go109
1 files changed, 109 insertions, 0 deletions
diff --git a/internal/services/migration.go b/internal/services/migration.go
new file mode 100644
index 0000000..622ffc3
--- /dev/null
+++ b/internal/services/migration.go
@@ -0,0 +1,109 @@
+package services
+
+import (
+ "sort"
+
+ "github.com/eugenetriguba/bolt/internal/models"
+ "github.com/eugenetriguba/bolt/internal/repositories"
+)
+
+type MigrationService struct {
+ dbRepo *repositories.MigrationDBRepo
+ fsRepo *repositories.MigrationFsRepo
+}
+
+func NewMigrationService(
+ dbRepo *repositories.MigrationDBRepo,
+ fsRepo *repositories.MigrationFsRepo,
+) *MigrationService {
+ return &MigrationService{dbRepo: dbRepo, fsRepo: fsRepo}
+}
+
+type sortOrder int
+
+const (
+ SortOrderDesc sortOrder = iota
+ SortOrderAsc
+)
+
+func (ms *MigrationService) ApplyAllMigrations() error {
+ migrations, err := ms.ListMigrations(SortOrderAsc)
+ if err != nil {
+ return err
+ }
+
+ for _, migration := range migrations {
+ if !migration.Applied {
+ ms.ApplyMigration(migration)
+ }
+ }
+
+ return nil
+}
+
+func (ms *MigrationService) ApplyMigration(migration *models.Migration) error {
+ scriptContents, err := ms.fsRepo.ReadUpgradeScript(migration)
+ if err != nil {
+ return err
+ }
+
+ err = ms.dbRepo.Apply(scriptContents, migration)
+ if err != nil {
+ return err
+ }
+
+ return nil
+}
+
+func (ms *MigrationService) RevertMigration(migration *models.Migration) error {
+ scriptContents, err := ms.fsRepo.ReadDowngradeScript(migration)
+ if err != nil {
+ return err
+ }
+
+ err = ms.dbRepo.Revert(scriptContents, migration)
+ if err != nil {
+ return err
+ }
+
+ return nil
+}
+
+func (ms *MigrationService) CreateMigration(migration *models.Migration) error {
+ return ms.fsRepo.Create(migration)
+}
+
+func (ms *MigrationService) ListMigrations(order sortOrder) ([]*models.Migration, error) {
+ // Assumption: All migration versions that have been applied
+ // to the database exist locally in the list of filesystem migrations.
+ // This would hold true unless someone decided to apply a migration and,
+ // for whatever reason, delete it later from their filesystem.
+ migrations, err := ms.fsRepo.List()
+ if err != nil {
+ return nil, err
+ }
+
+ appliedMigrations, err := ms.dbRepo.List()
+ if err != nil {
+ return nil, err
+ }
+
+ var flatMigrations []*models.Migration
+ for _, migration := range migrations {
+ _, ok := appliedMigrations[migration.Version]
+ if ok {
+ migration.Applied = true
+ }
+ flatMigrations = append(flatMigrations, migration)
+ }
+
+ sort.Slice(flatMigrations, func(i, j int) bool {
+ if order == SortOrderAsc {
+ return flatMigrations[i].Version < flatMigrations[j].Version
+ } else {
+ return flatMigrations[i].Version > flatMigrations[j].Version
+ }
+ })
+
+ return flatMigrations, nil
+}