Fela Maslen
9f1f3b5101
feat: database migrations and docker compose test DB setup
|
5 gadi atpakaļ | |
|---|---|---|
| .. | ||
| cmd | 5 gadi atpakaļ | |
| pkg | 5 gadi atpakaļ | |
| .gitignore | 5 gadi atpakaļ | |
| Dockerfile | 5 gadi atpakaļ | |
| Makefile | 5 gadi atpakaļ | |
| README.md | 5 gadi atpakaļ | |
| docker-compose.yml | 5 gadi atpakaļ | |
| example.env | 5 gadi atpakaļ | |
| go.mod | 5 gadi atpakaļ | |
| go.sum | 5 gadi atpakaļ | |
| init.sql | 5 gadi atpakaļ | |
| test.env | 5 gadi atpakaļ | |
README.md
music-scanner
This is the backend part of the music player, written in Golang.
Building
Run make build inside this directory. Binaries will be built and output to the bin directory (which will be created if it does not exist).
Testing
Run the following commands to run unit tests:
make test.read: tests the file reader module
Migrations
First, make sure the following environment variables are set:
POSTGRES_HOSTPOSTGRES_USERPOSTGRES_PASSWORDPOSTGRES_PORT(optional, defaults to 5432)POSTGRES_DATABASE
Then, run:
make migrate
Creating migrations
After getting the migrate CLI tool, run:
migrate create -ext sql -dir pkg/db/migrations -seq create_some_table
Components
Music scanner
This is intended to be run as a scheduled job. It will scan a directory and add relevant metadata to a PostgreSQL database.
Usage
bin/scan