📝 feat: optimize event preview query #1302
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Backend | |
| permissions: read-all | |
| on: | |
| push: | |
| paths: | |
| - backend/** | |
| - config/** | |
| - .github/workflows/backend.yml | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.ref }} | |
| cancel-in-progress: true | |
| jobs: | |
| format: | |
| name: Format | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Checkout Repository | |
| uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v4 | |
| with: | |
| go-version: "1.22" | |
| - name: Cache Go Modules | |
| uses: actions/cache@v4 | |
| with: | |
| path: ~/go/pkg/mod | |
| key: ${{ runner.os }}-go-${{ hashFiles('**/go.sum') }} | |
| restore-keys: | | |
| ${{ runner.os }}-go | |
| - name: Install gofumpt | |
| run: go install mvdan.cc/gofumpt@latest | |
| - name: templ | |
| run: go install github.com/a-h/templ/cmd/templ@latest && templ generate | |
| - name: Check code formatting | |
| run: | | |
| unformatted_files=$(gofumpt -l ./backend/) | |
| if [ -n "$unformatted_files" ]; then | |
| echo "Files not formatted:" | |
| echo "$unformatted_files" | |
| exit 1 | |
| fi | |
| lint: | |
| name: Lint | |
| runs-on: ubuntu-latest | |
| permissions: | |
| contents: read | |
| pull-requests: read | |
| checks: write | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - uses: actions/setup-go@v4 | |
| with: | |
| go-version: "1.22" | |
| - name: Cache Go Modules | |
| uses: actions/cache@v4 | |
| with: | |
| path: ~/go/pkg/mod | |
| key: ${{ runner.os }}-go-${{ hashFiles('**/go.sum') }} | |
| restore-keys: | | |
| ${{ runner.os }}-go | |
| - name: templ | |
| run: go install github.com/a-h/templ/cmd/templ@latest && templ generate | |
| - name: golangci-lint | |
| uses: golangci/golangci-lint-action@v4 | |
| with: | |
| version: latest | |
| working-directory: ./backend/ | |
| args: --timeout=5m | |
| test: | |
| name: Test | |
| runs-on: ubuntu-latest | |
| services: | |
| postgres: | |
| image: postgres:15 | |
| env: | |
| POSTGRES_USER: postgres | |
| POSTGRES_PASSWORD: password | |
| POSTGRES_DB: sac | |
| ports: | |
| - 5432:5432 | |
| steps: | |
| - name: Checkout Repository | |
| uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v4 | |
| with: | |
| go-version: "1.22" | |
| - name: Cache Go Modules | |
| uses: actions/cache@v4 | |
| with: | |
| path: ~/go/pkg/mod | |
| key: ${{ runner.os }}-go-${{ hashFiles('**/go.sum') }} | |
| restore-keys: | | |
| ${{ runner.os }}-go | |
| - name: Install Dependencies | |
| run: cd ./backend/ && go install github.com/a-h/templ/cmd/templ@latest && templ generate && go get ./... | |
| - name: Increase max_connections in PostgreSQL | |
| run: | | |
| CONTAINER_ID=$(docker ps --filter "publish=5432" --format "{{.ID}}") | |
| docker exec $CONTAINER_ID bash -c "sed -i 's/^#* *max_connections *= *[0-9]*/max_connections = 512/' /var/lib/postgresql/data/postgresql.conf" | |
| docker exec $CONTAINER_ID cat /var/lib/postgresql/data/postgresql.conf | grep max_connections | |
| - name: Restart PostgreSQL Container | |
| run: docker restart $(docker ps --filter "publish=5432" --format "{{.ID}}") | |
| - name: Install migrate CLI | |
| run: go install -tags 'postgres' github.com/golang-migrate/migrate/v4/cmd/migrate@latest | |
| - name: Migrate Database | |
| run: SKIP_DOCKER=true ./scripts/init_db.sh | |
| - name: Run Tests with Coverage | |
| run: cd ./backend/ && go test -v -race -coverprofile=coverage.txt ./... | |
| - name: Print Coverage | |
| run: cd ./backend/ && go tool cover -func=coverage.txt |