Convert to library about pgmgr HOT 3 CLOSED

@SharkFourSix if your concern is just having an easier way to run pgmgr after adding it to your go.mod, you can run the version pinned by a particular module with go run github.com/rnubel/pgmgr. That is, suppose you make a new Go project and install a specific version of pgmgr:

$ go mod init github.com/rnubel/mynewproject
$ go get github.com/rnubel/[email protected]
$ echo {} > .pgmgr.json

You can run the installed version with the go run command:

$ go run github.com/rnubel/pgmgr -v
pgmgr version 1.1.4

So, e.g., go run github.com/rnubel/pgmgr db create, go run github.com/rnubel/pgmgr db migrate, should all work and use the exact version you have pinned.

I also will add that it is possible to import the pgmgr package and use it directly, but you have to build your config struct by hand:

package main

import (
	"fmt"
	"log"

	"github.com/rnubel/pgmgr/pgmgr"
)

func main() {
	config := pgmgr.Config{
		Host:            "localhost",
		Port:            5432,
		Username:        "rnubel",
		Database:        "mydb",
		MigrationDriver: "psql",
		MigrationFolder: "migrations",
		MigrationTable:  "schema_migrations",
		SslMode:         "disable",
	}

	if err := pgmgr.Create(&config); err != nil {
		log.Fatal(fmt.Errorf("failed to create db: %w", err))
	}

	if err := pgmgr.Migrate(&config); err != nil {
		log.Fatal(fmt.Errorf("failed to migrate: %w", err))
	}
}

Let me know if the above addresses your problem or if there's more you're looking for!

from pgmgr.

Thanks. I just ended up whipping up my own library that works for me out of frustration 😆

https://github.com/SharkFourSix/dsync

from pgmgr.

@SharkFourSix good luck with that! I'll close this issue for now.

from pgmgr.