readme.md

Migration

Prerequisites

• golang-migrate

go install -tags 'postgres' github.com/golang-migrate/migrate/v4/cmd/migrate@latest

• postgresql

Usage

# Export your postgres url:
export POSTGRESQL='postgres://user:password@host:port/dbname?sslmode=disable'
# Example:
export POSTGRESQL='postgres://postgres:postgres@localhost:5432/shopping-cart?sslmode=disable'
# Create migration step:
migrate create -ext sql -dir internal/migration/ -seq create_user_table
# Migrate up:
migrate -database ${POSTGRESQL} -path internal/migration/ up
# Migrate down:
migrate -database ${POSTGRESQL} -path internal/migration/ down