api.yml

name: Tabroom API CI

on:
  push:
    branches:
      - main
  pull_request:
    branches:
      - main

env:
    CI: true
    TZ: 'America/Chicago'
    SLACK_WEBHOOK: ${{ secrets.SLACK_WEBHOOK }}
    NODE_ENV: 'test'

jobs:
  build:
    runs-on: ubuntu-latest

    services:
      mariadb-test:
        image: mariadb:10.11.2
        ports:
          - '3306:3306'
        env:
          MARIADB_USER: tabroom
          MARIADB_PASSWORD: tabroom
          MARIADB_DATABASE: tabroom
          MARIADB_ROOT_PASSWORD: tabroom
        options: --health-cmd="mysqladmin ping" --health-interval=5s --health-timeout=2s --health-retries=3


    steps:
    - uses: actions/checkout@v3

    - name: Shutdown Ubuntu MySQL
      run: sudo service mysql stop

    - name: Load local database
      run: mysql -h 127.0.0.1 -P 3306 -u root -ptabroom tabroom < ./tests/tabroom.sql

    - name: Get node
      uses: actions/setup-node@v1
      with:
        node-version: 18.2.0

    - name: Install packages
      run: npm install

    - name: Copy config file
      run: cp ./config/config.js.sample ./config/config.js

    - name: Lint
      run: npm run lint

    - name: Tests
      run: npm run test-ci

    - name: If tests passed change icon
      if: success()
      run: echo "SLACK_ICON=:white_check_mark:" >> $GITHUB_ENV

    - name: Send slack notification
      if: always()
      uses: speechanddebate/action-slack-notify@master