diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2023-12-30 16:00:20 -0500 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2023-12-30 16:00:20 -0500 |
| commit | 809fc4639e58ca9ca082ce68b5c62b463b2f1e1d (patch) | |
| tree | 1cb7b9951a80509b827b8e5bd1eb2dd09e87aec1 /internal/repositories | |
| parent | Initial Commit (diff) | |
| download | cli-809fc4639e58ca9ca082ce68b5c62b463b2f1e1d.zip | |
Add initial code
Diffstat (limited to 'internal/repositories')
| -rw-r--r-- | internal/repositories/migration.go | 45 |
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 +} |