todo-app

A sample todo app example written in go

Create .env file in the root of the project with DB_PASSWOD property:

DB_PASSWORD=qwert

Run postgres in docker container

docker run --name todo-db -e POSTGRES_PASSWORD=qwert -p 5432:5432 -d postgres

Database migration

Migrate is used for Database migrations.

Create migration files

migrate create -ext sql -dir db/migrations -seq init

Run DB migrations

Via Docker:

docker run -v /full-path-to/todo-app/db/migrations:/migrations --network host migrate/migrate -path=/migrations/ -database 'postgres://postgres:qwert@localhost:5432/postgres?sslmode=disable' up

or via binary file from the root of the project

migrate -path db/migrations -database 'postgres://postgres:qwert@localhost:5432/postgres?sslmode=disable' up

In case of error error: Dirty database version 1. Fix and force version. during migration run

migrate -path db/migrations -database 'postgres://postgres:qwert@localhost:5432/postgres?sslmode=disable' force 1

where 1 is a failed version of migration (see the name of sql file with migrations in db/migrations)

More details here: golang-migrate/migrate#282 (comment)

Swagger

Swagg is used for Swagger documentation.

Generate swagger

swag init -g cmd/main.go