Need help in registering and running go binary migration.

[anishjain94]

Hi all, After the latest release of goose, i wanted to use SQL + Go migrations. after building using command go build -o goose ./00054_fetch_user_data.go, a goose file is created. but when i am running goose up, it is throwing error 2022/05/10 18:05:30 goose run: ERROR 00054_fetch_user_data.go: failed to run Go migration: Go functions must be registered and built into a custom binary (see https://github.com/pressly/goose/tree/master/examples/go-migrations)

current directory structure -
all sql files are present in (/go/src/pice_client_apis/infra/database/migration/)
/go/src/pice_client_apis/infra/database/migration/00054_fetch_user_data.go

➜ migration git:(uat) ✗ go build -o goose ./00054_fetch_user_data.go
➜ migration git:(uat) ✗ goose up
2022/05/10 18:04:55 goose run: ERROR 00054_fetch_user_data.go: failed to run Go migration: Go functions must be registered and built into a custom binary (see https://github.com/pressly/goose/tree/master/examples/go-migrations)
➜ migration git:(uat) ✗ go build -o goose ./00054_fetch_user_data.go
➜ migration git:(uat) ✗ goose up
2022/05/10 18:05:30 goose run: ERROR 00054_fetch_user_data.go: failed to run Go migration: Go functions must be registered and built into a custom binary (see https://github.com/pressly/goose/tree/master/examples/go-migrations)

Please help me out. 🙏🏼

[anishjain94]

@mfridman @VojtechVitek @rliebz Do you guys might know why this is happening?

[VojtechVitek]

Add _ "YOUR-PATH/database" to your imports.

https://stackoverflow.com/questions/32465453/golang-what-is-import-side-effect

[anishjain94]

I did not understand when you say _ "YOUR-PATH/database"

I am using postgres as db. in that case do i need to add _ "database/sql"
or
Does this mean my path to migrations like _ infra/database/migration/
or
do you mean to say _ infra/database/migration/sql

project name - clientapis
My migrations are in path(containing sql files along with 00054_fetch_user_data.go) - clientapis/infra/database/migration/

[VojtechVitek]

You need to import your database pkg (#346 (reply in thread)) from your main.go file (#346 (reply in thread)).

[anishjain94]

made a mistake earlier, they are in the same package named database.
Current folder structure is
infa/database/migration

all sql and 00054_fetch_user_data.go file are in migration.

[VojtechVitek]

I'm sorry, I cannot help further without a full reproducer.

[jechols]

I could be nuts, but it looks like you're running the global goose binary in your list of commands, not the locally-compiled one. You need to run the local goose via ./goose or with a full path (e.g., /usr/local/custom-app/goose).

I'd suggest not naming the compiled binary "goose" as that'll just be way too easy to confuse with the real one. db-migrate or something unique would make it a lot clearer if you run the wrong thing.