docker pull postgres:alpine

docker run --name postgres -p 5433:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=secret -d postgres:alpine

docker exec -it postgres psql -U root

\q

docker logs postgres

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

migrate create -ext sql -dir db/migration -seq init_schema

docker exec -it postgres /bin/sh

createdb --username=root --owner=root simple_bank

psql simple_bank

\q

dropdb simple_bank

exit

docker exec -it postgres createdb --username=root --owner=root simple_bank

docker exec -it postgres psql -U root simple_bank

docker stop postgres

docker rm postgres

make postgres

make createdb

migrate -path db/migration -database "postgresql://root:secret@localhost:5433/simple_bank?sslmode=disable" -verbose up

go install github.com/kyleconroy/sqlc/cmd/sqlc@latest

docker pull kjconroy/sqlc

docker run --rm -v ${pwd}:/src -w /src kjconroy/sqlc generate

go get github.com/lib/pq

go get github.com/stretchr/testify

# check out the Makefile