migrate_downto.go 843 B

123456789101112131415161718192021222324252627282930313233343536373839
  1. package main
  2. import (
  3. "os"
  4. _ "code.osinet.fr/fgm/kurz/migrations"
  5. "github.com/pressly/goose"
  6. "github.com/spf13/cobra"
  7. )
  8. var cmdMigrateDownTo = &cobra.Command{
  9. Args: migrateVersionValidator,
  10. Long: "Roll the Kurz schema back to a specific version. Kurz version of 'goose down-to'.",
  11. Run: migrateDownToHandler,
  12. Short: "Roll back to specific version",
  13. Use: "down-to <version>",
  14. }
  15. func init() {
  16. cmdMigrate.AddCommand(cmdMigrateDownTo)
  17. }
  18. // migrateDownToHandler implements the "kurzd migrate down-to" command.
  19. func migrateDownToHandler(cmd *cobra.Command, args []string) {
  20. dbDriver, dbDsn := parseDbCred()
  21. db, err := dbDial(dbDriver, dbDsn)
  22. if err != nil {
  23. panic(err)
  24. }
  25. defer db.Close()
  26. cwd, err := os.Getwd()
  27. if err != nil {
  28. panic(err)
  29. }
  30. goose.SetDialect(dbDriver)
  31. goose.DownTo(db, cwd, migrateTargetVersion)
  32. }