aboutsummaryrefslogtreecommitdiffstats
path: root/internal/repositories
diff options
context:
space:
mode:
authorEugene Triguba <eugenetriguba@gmail.com>2023-12-30 16:00:20 -0500
committerEugene Triguba <eugenetriguba@gmail.com>2023-12-30 16:00:20 -0500
commit809fc4639e58ca9ca082ce68b5c62b463b2f1e1d (patch)
tree1cb7b9951a80509b827b8e5bd1eb2dd09e87aec1 /internal/repositories
parentInitial Commit (diff)
downloadcli-809fc4639e58ca9ca082ce68b5c62b463b2f1e1d.zip
Add initial code
Diffstat (limited to 'internal/repositories')
-rw-r--r--internal/repositories/migration.go45
1 files changed, 45 insertions, 0 deletions
diff --git a/internal/repositories/migration.go b/internal/repositories/migration.go
new file mode 100644
index 0000000..488d838
--- /dev/null
+++ b/internal/repositories/migration.go
@@ -0,0 +1,45 @@
+package repositories
+
+import (
+ "database/sql"
+)
+
+type MigrationRepo struct {
+ // The database connection that will be used
+ // to look up migrations that have already been
+ // applied.
+ db *sql.DB
+}
+
+// Create a new Migration Repo.
+//
+// This handles the interactions with applying
+// and reverting migrations.
+func NewMigrationRepo(db *sql.DB) (*MigrationRepo, error) {
+ _, err := db.Exec(`
+ CREATE TABLE IF NOT EXISTS bolt_migrations(
+ version CHARACTER(32) PRIMARY KEY NOT NULL
+ );
+ `)
+ if err != nil {
+ return nil, err
+ }
+
+ return &MigrationRepo{db: db}, nil
+}
+
+func (m *MigrationRepo) Apply() error {
+ tx, err := m.db.Begin()
+ if err != nil {
+ return err
+ }
+ defer tx.Rollback()
+
+ sqlStatement := `INSERT INTO applied_migration(version) VALUES ($1);`
+ _, err = m.db.Exec(sqlStatement)
+ if err != nil {
+ return err
+ }
+
+ return nil
+}