How to use "validate" command?

[nurwanto-fazz]

I tried to use validate command as in the readme file
goose [OPTIONS] mysql DBSTRING validate but return
goose run: "validate": no such command.

Commands:
    up                   Migrate the DB to the most recent version available
    ....
    validate             Check migration files without running them

is it implemented already?

[mfridman]

What version of goose are you using --version, and how are you structuring your command?

[nurwanto-fazz]

I am using v3.21.1
my command:
goose -dir ./db/migrations mysql "user:password@/local_db?parseTime=true" validate

[mfridman]

This command doesn't need the dialect (mysql) or the connection string. Apologies this isn't documented well.

Here's an example from the root of this repository:

$ goose -dir ./testdata/no-versioning/migrations -v validate
Type   Txn   Up   Down   Name          
────   ───   ──   ────   ────          
sql    ✔     1    1      00001_a.sql   
sql    ✔     1    1      00002_b.sql   
sql    ✔     1    1      00003_c.sql

[nurwanto-fazz]

It works now.
Thanks for your help 🙏