sql

type Config ¶

type Config struct {
	Migrate bool     `help:"Enable automatic migration of the database schema."`
	DSN     *url.URL `default:"${sqldsn=postgres://postgres:secret@localhost:5432/zero?sslmode=disable}" help:"DSN for the SQL connection."`
}

type Migrations ¶ added in v0.7.0

type Migrations []fs.FS

Migrations represents a set of SQL migrations.

Create a provider that returns an fs.FS with your .sql migrations at the root of the FS. eg.

//go:embed migrations/*.sql
var migrations embed.FS

//zero:provider multi
func Migrations() Migrations {
	sub, _ := fs.Sub(migrations, "migrations")
	return []fs.FS{sub}
}