Git designed for AI agents.
package praefect
import (
"context"
"fmt"
"time"
"github.com/feder-cr/git-ai/internal/log"
"github.com/feder-cr/git-ai/internal/praefect/datastore/glsql"
"github.com/feder-cr/git-ai/internal/praefect/datastore/migrations"
migrate "github.com/rubenv/sql-migrate"
"github.com/urfave/cli/v3"
)
const (
sqlMigrateCmdName = "sql-migrate"
timeFmt = "2006-01-02T15:04:05"
)
func newSQLMigrateCommand() *cli.Command {
return &cli.Command{
Name: sqlMigrateCmdName,
Usage: "apply outstanding SQL migrations",
Description: "The sql-migrate subcommand applies outstanding migrations to the configured database.\n" +
"The subcommand doesn't fail if database has migrations unknown to the version of Praefect you're using.\n" +
"To make the subcommand fail on unknown migrations, use the 'ignore-unknown' flag.",
Action: sqlMigrateAction,
Flags: []cli.Flag{
&cli.BoolFlag{
Name: "ignore-unknown",
Usage: "ignore unknown migrations",
Value: true,
},
&cli.BoolFlag{
Name: "verbose",
Usage: "show text of migration query",
},
},
Before: func(ctx context.Context, cmd *cli.Command) (context.Context, error) {
if cmd.Args().Present() {
_ = cli.ShowSubcommandHelp(cmd)
return nil, cli.Exit(unexpectedPositionalArgsError{Command: cmd.Name}, 1)
}
return ctx, nil
},
}
}
func sqlMigrateAction(ctx context.Context, cmd *cli.Command) error {
log.ConfigureCommand()
conf, err := readConfig(cmd.String(configFlagName))
if err != nil {
return err
}
db, clean, err := openDB(conf.DB, cmd.ErrWriter)
if err != nil {
return err
}
defer clean()
ignoreUnknown := cmd.Bool("ignore-unknown")
migrationSet := migrate.MigrationSet{
IgnoreUnknown: ignoreUnknown,
TableName: migrations.MigrationTableName,
}
planSource := &migrate.MemoryMigrationSource{
Migrations: migrations.All(),
}
subCmd := progname + " " + cmd.Name
// Find all migrations that are currently down. A failed plan returns nil, which
// looks exactly like "nothing to do", so the error has to be checked first.
planMigrations, _, err := migrationSet.PlanMigration(db, "postgres", planSource, migrate.Up, 0)
if err != nil {
return fmt.Errorf("%s: plan migrations: %w", subCmd, err)
}
if len(planMigrations) == 0 {
fmt.Fprintf(cmd.Writer, "%s: all migrations are up\n", subCmd)
return nil
}
fmt.Fprintf(cmd.Writer, "%s: migrations to apply: %d\n\n", subCmd, len(planMigrations))
executed := 0
for _, mig := range planMigrations {
fmt.Fprintf(cmd.Writer, "= %s %v: migrating\n", time.Now().Format(timeFmt), mig.Id)
start := time.Now()
if cmd.Bool("verbose") {
fmt.Fprintf(cmd.Writer, "\t%v\n", mig.Up)
}
n, err := glsql.MigrateSome(mig.Migration, db, ignoreUnknown)
if err != nil {
return fmt.Errorf("%s: fail: %w", time.Now().Format(timeFmt), err)
}
if n > 0 {
fmt.Fprintf(cmd.Writer, "== %s %v: applied (%s)\n", time.Now().Format(timeFmt), mig.Id, time.Since(start))
// Additional migrations were run. No harm, but prevents us from tracking their execution duration.
if n > 1 {
fmt.Fprintf(cmd.Writer, "warning: %v additional migrations were applied successfully\n", n-1)
}
} else {
fmt.Fprintf(cmd.Writer, "== %s %v: skipped (%s)\n", time.Now().Format(timeFmt), mig.Id, time.Since(start))
}
executed += n
}
fmt.Fprintf(cmd.Writer, "\n%s: OK (applied %d migrations)\n", subCmd, executed)
return nil
}