Can you guys just provide some good documentation and some examples with mysql also?

[2kAyush]

There are literally no help for some commands like build and init.. and there is literally no documentation for initial setup Please make a good documentation. Also if possible add some example for .go file migrations with mysql as the driver.

[mfridman]

Thanks for the feedback, there's definitely room for improvement.

• installation instructions are here: https://pressly.github.io/goose/installation
• basic examples for both Go and SQL: https://github.com/pressly/goose/tree/master/examples

We've been meaning to find time to update the examples, docs and add more tutorials, examples and in-depth posts, but with a small team of maintainers it's been challenging.

[2kAyush]

Thanks for the feedback, there's definitely room for improvement.

• installation instructions are here: https://pressly.github.io/goose/installation
• basic examples for both Go and SQL: https://github.com/pressly/goose/tree/master/examples

We've been meaning to find time to update the examples, docs and add more tutorials, examples and in-depth posts, but with a small team of maintainers it's been challenging.

Actually I went through it used the same example.. but it's not working properly. I wrote simple migration in go and then did binary build of it and then ran it as said in the example but I am getting this error:

$ ./goose-custom mysql "api:password@/goose_test?parseTime=true" up
./goose-custom: line 1: syntax error near unexpected token newline' ./goose-custom: line 1: !'

my folder structure is this:

migrations
- 20231012171221_init_db.go
- goose-custom

please tell me what to do here!.

[2kAyush]

I am getting this error also even tho I did a binary build it's still saying the same.
@mfridman
I tried a lot of things but it's still not working..

2023/10/13 09:05:54 Goose failed: ERROR migrations/20231012171221_init_db.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)

[mfridman]

You typically have to do a blank import of the package your go migrations are in.

I updated a goose demo repository that does both embedding and go migrations, which can be found here:

https://github.com/mfridman/goose-demo

If you put together a reproducible example and push it up to GitHub I can take a look at what's wrong.

The most important thing is this line:

import (
	"database/sql"
	"log"
	"os"

# In this example we're importing migrations because we're also embedding, if you're not embedding, 
# then you'll need to have a blank import like so:
-	"github.com/mfridman/goose-demo/migrations"
+      _ "github.com/mfridman/goose-demo/migrations"
	"github.com/pressly/goose/v3"
	_ "modernc.org/sqlite"
)