aboutsummaryrefslogtreecommitdiffstats
path: root/internal/commands
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/commands
parentInitial Commit (diff)
downloadcli-809fc4639e58ca9ca082ce68b5c62b463b2f1e1d.zip
Add initial code
Diffstat (limited to 'internal/commands')
-rw-r--r--internal/commands/create.go45
-rw-r--r--internal/commands/migrate.go45
2 files changed, 90 insertions, 0 deletions
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
+}