main.yml

name: "CI"
on:
  pull_request:
  push:
    branches:
      - master

jobs:

  Unit_Tests:
    name: Unit Tests
    strategy:
      fail-fast: false
      matrix:
        os: [ubuntu-latest, macos-latest, windows-latest]
    runs-on: ${{ matrix.os }}
    steps:
      - name: Checkout Code
        uses: actions/checkout@v4
      - name: Install Node
        uses: actions/setup-node@v4
        with:
          node-version: '*'
      - name: Install Dependencies
        run: npm ci
      - name: Run Tests 👩🏽‍💻
        run: npm run test:unit

  Unit_Coverage:
    name: Unit Coverage
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Code
        uses: actions/checkout@v4
      - name: Install Node
        uses: actions/setup-node@v4
        with:
          node-version: 'lts/*'
      - name: Install Dependencies
        run: npm ci
      - name: Check Coverage 🏁
        run: npm run test:cover

  MySQL_Tests:
    name: MySQL Tests
    strategy:
      fail-fast: false
      matrix:
        version: ['8.0']
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Code
        uses: actions/checkout@v4
      - name: Shutdown Default MySQL
        run: sudo service mysql stop
      - name: Set up MySQL
        env:
          MYSQL_VERSION: ${{ matrix.version }}
        run: |
          sudo docker run -e MYSQL_RANDOM_ROOT_PASSWORD=true -e MYSQL_USER=sequelizr_test -e MYSQL_PASSWORD=sequelizr_test -e MYSQL_DATABASE=sequelizr_test -d -p 3306:3306 --name mysql --health-cmd 'mysqladmin ping --silent' mysql:$MYSQL_VERSION
      - name: Install Node
        uses: actions/setup-node@v4
        with:
          node-version: 'lts/*'
      - name: Install Dependencies
        run: npm ci
      - name: Run Tests 👩🏽‍💻
        env:
          SEQ_DB: sequelizr_test
          SEQ_USER: sequelizr_test
          SEQ_PW: sequelizr_test
          SEQ_HOST: localhost
          SEQ_PORT: 3306
        run: npm run test:mysql

  MSSQL_Tests:
    name: MSSQL Tests
    strategy:
      fail-fast: false
      matrix:
        version: [2017-latest]
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Code
        uses: actions/checkout@v4
      - name: Set up MSSQL
        env:
          MSSQL_VERSION: ${{ matrix.version }}
        run: |
          sudo chmod +x ./scripts/mssql/entrypoint.sh
          sudo chmod +x ./scripts/mssql/configure-db.sh
          sudo docker build --build-arg MSSQL_VERSION=$MSSQL_VERSION -t sequelizr-mssql ./scripts/mssql
          sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password32!' -p 1433:1433 --name mssql -d sequelizr-mssql
      - name: Install Node
        uses: actions/setup-node@v4
        with:
          node-version: 'lts/*'
      - name: Install Dependencies
        run: npm ci
      - name: Run Tests 👩🏽‍💻
        env:
          SEQ_DB: sequelizr_test
          SEQ_USER: sequelizr_test
          SEQ_PW: Sequelizr_test32!
          SEQ_HOST: localhost
          SEQ_PORT: 1433
        run: npm run test:mssql

  Lint:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Code
        uses: actions/checkout@v4
      - name: Install Node
        uses: actions/setup-node@v4
        with:
          node-version: 'lts/*'
      - name: Install Dependencies
        run: npm ci
      - name: Lint ✨
        run: npm run lint

  Release:
    needs: [Unit_Tests, Unit_Coverage, MySQL_Tests, Lint]
    if: |
      github.ref == 'refs/heads/master' &&
      github.event.repository.fork == false
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Code
        uses: actions/checkout@v4
      - name: Install Node
        uses: actions/setup-node@v4
        with:
          node-version: 'lts/*'
      - name: Install Dependencies
        run: npm ci
      - name: Release 🎉
        env:
          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
          NPM_TOKEN: ${{ secrets.NPM_TOKEN }}
        run: npx semantic-release