fix: project stats query for postgres (resolve #531) #278

	name: ci
	on:
	push:
	pull_request:

	jobs:
	test:
	name: 'Unit- & API tests'
	runs-on: ubuntu-latest
	permissions:
	contents: read
	steps:
	- name: Set up Go 1.x
	uses: actions/setup-go@v3
	with:
	go-version: ^1.20
	id: go

	- name: Check out code into the Go module directory
	uses: actions/checkout@v3

	- name: Get dependencies
	run: go get

	- name: Unit Tests
	run: CGO_ENABLED=0 go test `go list ./... \| grep -v 'github.com/muety/wakapi/scripts'` -run ./... # skip scripts package, because not actually a package

	- name: API Tests
	run: \|
	npm -g install newman
	./testing/run_api_tests.sh

	migration:
	name: Migration tests
	runs-on: ubuntu-latest
	permissions:
	contents: read

	strategy:
	fail-fast: false
	matrix:
	db: [sqlite, postgres, mysql, mariadb]

	steps:
	- name: Set up Go 1.x
	uses: actions/setup-go@v3
	with:
	go-version: ^1.20
	id: go

	- name: Check out code into the Go module directory
	uses: actions/checkout@v3

	- run: ./testing/run_api_tests.sh ${{ matrix.db }} --migration

Provide feedback