From 809fc4639e58ca9ca082ce68b5c62b463b2f1e1d Mon Sep 17 00:00:00 2001 From: Eugene Triguba Date: Sat, 30 Dec 2023 16:00:20 -0500 Subject: Add initial code --- internal/repositories/migration.go | 45 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 internal/repositories/migration.go (limited to 'internal/repositories') 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 +} -- cgit v1.2.3