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/commands/create.go | 45 ++++++++++++++++++++++++++++++++++++++++++++ internal/commands/migrate.go | 45 ++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 90 insertions(+) create mode 100644 internal/commands/create.go create mode 100644 internal/commands/migrate.go (limited to 'internal/commands') diff --git a/internal/commands/create.go b/internal/commands/create.go new file mode 100644 index 0000000..ab37eca --- /dev/null +++ b/internal/commands/create.go @@ -0,0 +1,45 @@ +package commands + +import ( + "context" + "flag" + "fmt" + "os" + + "github.com/eugenetriguba/bolt/internal/db" + "github.com/google/subcommands" +) + +type CreateCmd struct{} + +func (*CreateCmd) Name() string { return "create" } +func (*CreateCmd) Synopsis() string { return "Create a new database migration." } +func (*CreateCmd) Usage() string { + return `create: + Create a new database migration. + ` +} + +func (m *CreateCmd) SetFlags(f *flag.FlagSet) {} + +func (m *CreateCmd) Execute(_ context.Context, f *flag.FlagSet, _ ...interface{}) subcommands.ExitStatus { + db, err := db.Connect() + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + defer db.Close() + + sqlStatement := ` + CREATE TABLE IF NOT EXISTS applied_migration( + version CHARACTER(32) PRIMARY KEY NOT NULL + ); + ` + _, err = db.Exec(sqlStatement) + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + + return subcommands.ExitSuccess +} diff --git a/internal/commands/migrate.go b/internal/commands/migrate.go new file mode 100644 index 0000000..fdbddfe --- /dev/null +++ b/internal/commands/migrate.go @@ -0,0 +1,45 @@ +package commands + +import ( + "context" + "flag" + "fmt" + "os" + + "github.com/eugenetriguba/bolt/internal/db" + "github.com/google/subcommands" +) + +type MigrateCmd struct{} + +func (*MigrateCmd) Name() string { return "migrate" } +func (*MigrateCmd) Synopsis() string { return "Migrate the database to the latest migration." } +func (*MigrateCmd) Usage() string { + return `migrate: + Migrate the database to the latest migration. + ` +} + +func (m *MigrateCmd) SetFlags(f *flag.FlagSet) {} + +func (m *MigrateCmd) Execute(_ context.Context, f *flag.FlagSet, _ ...interface{}) subcommands.ExitStatus { + db, err := db.Connect() + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + defer db.Close() + + sqlStatement := ` + CREATE TABLE IF NOT EXISTS applied_migration( + version CHARACTER(32) PRIMARY KEY NOT NULL + ); + ` + _, err = db.Exec(sqlStatement) + if err != nil { + fmt.Fprintln(os.Stderr, err) + return subcommands.ExitFailure + } + + return subcommands.ExitSuccess +} -- cgit v1.2.3