create_and_insert.go

package main

import (
  "database/sql"
  _ "github.com/lib/pq"
)

func main() {
  db, err := sql.Open("postgres", "postgres://root@localhost:26257/goose?sslmode=disable")
  if err != nil {
    panic(err)
  }
  _, err = db.Exec("CREATE DATABASE IF NOT EXISTS goose");
  if err != nil {
    panic(err)
  }
  txn, err := db.Begin()
  if err != nil {
    panic(err)
  }
  createVersionTableSql := `
  CREATE TABLE goose_db_version (
    id serial NOT NULL,
    version_id bigint NOT NULL,
    is_applied boolean NOT NULL,
    tstamp timestamp NULL default now(),
    PRIMARY KEY(id)
  );`
  if _, err := txn.Exec(createVersionTableSql); err != nil {
    panic(err)
  }
  version := 0
  applied := true
  if _, err := db.Exec(
    "INSERT INTO goose_db_version (version_id, is_applied) VALUES ($1, $2);", version, applied,
  ); err != nil {
    txn.Rollback()
    panic(err)
  }
  txn.Commit()
}