Fela Maslen 5a20c3effa fix: consistent migration directory in tests vs migrate tool 5 年之前
..
cmd 5a20c3effa fix: consistent migration directory in tests vs migrate tool 5 年之前
migrations bc244d1138 chore: moved migrations directory to root of project 5 年之前
pkg 5a20c3effa fix: consistent migration directory in tests vs migrate tool 5 年之前
.gitignore 01354895ae feat: directory structure with dummy db package 5 年之前
Dockerfile 01354895ae feat: directory structure with dummy db package 5 年之前
Makefile 443c36ee05 feat: database method to insert songs from a channel 5 年之前
README.md 443c36ee05 feat: database method to insert songs from a channel 5 年之前
docker-compose.yml 9f1f3b5101 feat: database migrations and docker compose test DB setup 5 年之前
example.env 9f1f3b5101 feat: database migrations and docker compose test DB setup 5 年之前
go.mod 443c36ee05 feat: database method to insert songs from a channel 5 年之前
go.sum 370f54fb09 feat: database pooling, migrations in test 5 年之前
init.sql 9f1f3b5101 feat: database migrations and docker compose test DB setup 5 年之前
test.env 9f1f3b5101 feat: database migrations and docker compose test DB setup 5 年之前

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 make test inside this directory, to run unit and integration tests.

Migrations

First, make sure the following environment variables are set:

  • POSTGRES_HOST
  • POSTGRES_USER
  • POSTGRES_PASSWORD
  • POSTGRES_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