Git designed for AI agents.
package praefect
import (
"context"
"fmt"
"sort"
"github.com/feder-cr/git-ai/internal/log"
"github.com/feder-cr/git-ai/internal/praefect/datastore"
"github.com/olekukonko/tablewriter"
"github.com/urfave/cli/v3"
)
const sqlMigrateStatusCmdName = "sql-migrate-status"
func newSQLMigrateStatusCommand() *cli.Command {
return &cli.Command{
Name: sqlMigrateStatusCmdName,
Usage: "show applied database migrations",
Description: "The commands prints a table of the migration identifiers applied to the database\n" +
"with the timestamp for each when it was applied.",
Action: sqlMigrateStatusAction,
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 sqlMigrateStatusAction(ctx context.Context, cmd *cli.Command) error {
log.ConfigureCommand()
conf, err := readConfig(cmd.String(configFlagName))
if err != nil {
return err
}
migrations, err := datastore.MigrateStatus(conf)
if err != nil {
return err
}
table := tablewriter.NewWriter(cmd.Writer)
table.Header([]string{"Migration", "Applied"})
table.Configure(func(cfg *tablewriter.Config) {
cfg.MaxWidth = 60
})
// Display the rows in order of name
var keys []string
for k := range migrations {
keys = append(keys, k)
}
sort.Strings(keys)
for _, k := range keys {
m := migrations[k]
applied := "no"
if m.Unknown {
applied = "unknown migration"
} else if m.Migrated {
applied = m.AppliedAt.String()
}
if err := table.Append([]string{
k,
applied,
}); err != nil {
return fmt.Errorf("append: %w", err)
}
}
return table.Render()
}