Function migrateDownCommands

cmd/migrate.go:89–124

migrateDownCommands creates the command for rolling back migrations.

()

// migrateDownCommands creates the command for rolling back migrations.
func migrateDownCommands() *cobra.Command {
	cmd := &cobra.Command{
		Use: "down",
		Run: func(cmd *cobra.Command, args []string) {
			// Define the source of the migrations.
			migrations := migrate.EmbedFileSystemMigrationSource{
				FileSystem: ledgerforge.SQLFiles,
				Root:       "sql",
			}

			// Fetch the configuration.
			cnf, err := config.Fetch()
			if err != nil {
				logrus.Errorf("Error fetching config: %v", err)
				return
			}

			// Connect to the database.
			db, err := database.ConnectDB(cnf.DataSource)
			if err != nil {
				logrus.Errorf("Error connecting to database: %v", err)
				return
			}

			// Roll back the migrations.
			n, err := migrate.Exec(db, "postgres", migrations, migrate.Down)
			if err != nil {
				logrus.Errorf("Error migrating down: %v", err)
			} else {
				logrus.Infof("Rolled back %d migrations!\n", n)
			}
		},
	}

	return cmd
}