bukumanga-api

How to use

Develop

Connect Web

docker-compose exec web bash

Connect DB

docker-compose exec db bash
psql -U pguser bukumanga

Debug Log

docker-compose logs -f

Migration

docker-compose exec web bash

# create migration
migrate create -ext sql -dir db/migrations -seq {migration_name}

# migrate
migrate -database ${POSTGRESQL_URL} -path db/migrations up N

# rollback
migrate -database ${POSTGRESQL_URL} -path db/migrations down N

# fix dirty 
migrate -database ${POSTGRESQL_URL} -path db/migrations force N

Seed

docker-compose exec web bash
psql -h db -U pguser bukumanga -f ./db/seeds/publishers.sql
psql -h ${POSTGRES_HOST} -U ${POSTGRES_USER} ${POSTGRES_DB} -f ./db/seeds/publishers.sql