컨테이너 생성
docker run --name some-postgres -p 5432:5432 -e POSTGRES_PASSWORD=secret -d postgres
docker exec -it postgres12 psql -U root
-it : run command as an interactive TTY sessionpostgres12 : 내가 설정한 이름docker logs <컨테이너 이름>
golang-migrate
https://github.com/golang-migrate/migrate/tree/master/cmd/migrate
list all containers
docker ps -a
CLI commands → linux
docker exec -it <컨테이너 이름> /bin/sh
컨테이너 밖에서 DB 테이블 생성하고 접속하기
docker exec -it postgres12 createdb --username=root --owner=root simple_bank
docker exec -it postgres12 psql -U root simple_bank
db migrate
migrate -path db/migration -database "postgresql://root:secret@localhost:5432/simple_bank" -verbose up/down
migrate -path
폴더명-database “postgresql://root:컨테이너비밀번호@localhost:port/DB이름" -verbose
verbose : to ask migrate to print verbose loggingMakefile
postgres:
docker run --name postgres12 -p 5432:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=secret -d postgres:12-alpine
createdb:
docker exec -it postgres12 createdb --username=root --owner=root simple_bank
dropdb:
docker exec -it postgres12 dropdb simple_bank
migrateup:
migrate -path db/migration -database "postgresql://root:secret@localhost:5432/simple_bank?sslmode=disable" -verbose up
migratedown:
migrate -path db/migration -database "postgresql://root:secret@localhost:5432/simple_bank?sslmode=disable" -verbose down
sqlc:
sqlc generate
.PHONY: postgres createdb dropdb migrateup migratedown sqlc
accounts.sql
-- name: CreateAuthor :one
INSERT INTO accounts(
owner,
balance,
currency
) VALUES (
$1, $2, $3
) RETURNING *;
-- name: GetAccount :one
SELECT * FROM accounts
WHERE id = $1 LIMIT 1;
-- name: ListAccounts :many
SELECT * FROM accounts
ORDER BY id
LIMIT $1
OFFSET $2; // to skip this many rows before starting to return the result
name : 해당 쿼리에 대한 Golang function signatureCreateAuthor : 함수의 이름one : return 1 single Account object