forked from mtusi2026/mtusi2026lab3
68 lines
1.2 KiB
Go
68 lines
1.2 KiB
Go
package main
|
|
|
|
import (
|
|
"database/sql"
|
|
"fmt"
|
|
"os"
|
|
|
|
_ "github.com/lib/pq"
|
|
)
|
|
|
|
const (
|
|
upFile = "internal/migrate/sql/001_init.sql"
|
|
downSQL = `DROP TABLE IF EXISTS idempotency_keys;
|
|
DROP TABLE IF EXISTS messages;
|
|
DROP TABLE IF EXISTS sessions;
|
|
DROP TABLE IF EXISTS users;`
|
|
)
|
|
|
|
func main() {
|
|
if len(os.Args) < 2 {
|
|
fail("usage: migrate [up|down]")
|
|
}
|
|
|
|
databaseURL := os.Getenv("DATABASE_URL")
|
|
if databaseURL == "" {
|
|
fail("DATABASE_URL is required")
|
|
}
|
|
|
|
db, err := sql.Open("postgres", databaseURL)
|
|
if err != nil {
|
|
fail("open database: " + err.Error())
|
|
}
|
|
defer db.Close()
|
|
|
|
if err := db.Ping(); err != nil {
|
|
fail("ping database: " + err.Error())
|
|
}
|
|
|
|
switch os.Args[1] {
|
|
case "up":
|
|
if err := migrateUp(db); err != nil {
|
|
fail("migrate up: " + err.Error())
|
|
}
|
|
fmt.Println("migrate up: done")
|
|
case "down":
|
|
if _, err := db.Exec(downSQL); err != nil {
|
|
fail("migrate down: " + err.Error())
|
|
}
|
|
fmt.Println("migrate down: done")
|
|
default:
|
|
fail("unknown command: " + os.Args[1])
|
|
}
|
|
}
|
|
|
|
func migrateUp(db *sql.DB) error {
|
|
script, err := os.ReadFile(upFile)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
_, err = db.Exec(string(script))
|
|
return err
|
|
}
|
|
|
|
func fail(message string) {
|
|
fmt.Fprintln(os.Stderr, message)
|
|
os.Exit(1)
|
|
}
|