Docker (windows only for running sqlc)
Install sqlc
go install github.com/kyleconroy/sqlc/cmd/sqlc@latest
Install Goose
go install github.com/pressly/goose/v3/cmd/goose@latest
Start
docker-compose up -d
Stop
docker-compose down
Run the following from the root of the project
using a cmd
shell
docker run --rm -v "%cd%:/src" -w /src kjconroy/sqlc generate
Create migrations
goose -dir ./sql/schema create migration_name sql
Create seed
goose -dir ./sql/seeds create seed_name sql
Run migrations
goose -dir ./sql/schema {up|down}
Run Seeds
goose -dir ./schema/seed -no-versioning up