main.yml

name: CI

on:
  pull_request:
    paths-ignore:
      - '**.md'
      - '.github/ISSUE_TEMPLATE/**'
  push:
    paths-ignore:
      - '**.md'
      - '.github/ISSUE_TEMPLATE/**'
    branches:
      - main
      - pr/**/ci

concurrency:
  group: ${{ github.workflow }}-${{ github.head_ref || github.ref || github.run_id }}
  cancel-in-progress: true

env:
  CARGO_TERM_COLOR: always

jobs:

  test:
    name: Unit Test
    runs-on: ubuntu-20.04
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --workspace
            --lib

  clippy-fmt:
    name: Clippy + Fmt
    runs-on: ubuntu-20.04
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          components: clippy, rustfmt
          override: true

      # Make sure files are formatted
      - uses: actions-rs/cargo@v1
        with:
          command: fmt
          args: >
            --manifest-path starfish/Cargo.toml
            --all

      # Run clippy
      - uses: actions-rs/cargo@v1
        with:
          command: clippy
          args: >
            --manifest-path starfish/Cargo.toml
            --all-targets
            --all

  compile-mysql:
    name: Compile MySQL
    runs-on: ubuntu-20.04
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions/cache@v2
        with:
          path: |
            ~/.cargo/registry
            ~/.cargo/git
            starfish/Cargo.lock
            starfish/target
          key: ${{ github.sha }}-${{ github.run_id }}-${{ runner.os }}-mysql

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --test '*'
            --features sqlx-mysql
            --no-run

  compile-sqlite:
    name: Compile SQLite
    runs-on: ubuntu-20.04
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions/cache@v2
        with:
          path: |
            ~/.cargo/registry
            ~/.cargo/git
            starfish/Cargo.lock
            starfish/target
          key: ${{ github.sha }}-${{ github.run_id }}-${{ runner.os }}-sqlite

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --test '*'
            --features sqlx-sqlite
            --no-run

  compile-postgres:
    name: Compile PostgreSQL
    runs-on: ubuntu-20.04
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions/cache@v2
        with:
          path: |
            ~/.cargo/registry
            ~/.cargo/git
            starfish/Cargo.lock
            starfish/target
          key: ${{ github.sha }}-${{ github.run_id }}-${{ runner.os }}-postgres

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --test '*'
            --features sqlx-postgres
            --no-run

  mysql:
    name: MySQL
    needs:
      - compile-mysql
    runs-on: ubuntu-20.04
    env:
      DATABASE_URL: "mysql://root:@localhost"
    strategy:
      fail-fast: false
      matrix:
        version: [8.0, 5.7]
    services:
      mysql:
        image: mysql:${{ matrix.version }}
        env:
          MYSQL_HOST: 127.0.0.1
          MYSQL_DB: mysql
          MYSQL_USER: sea
          MYSQL_PASSWORD: sea
          MYSQL_ALLOW_EMPTY_PASSWORD: yes
          MYSQL_ROOT_PASSWORD:
        ports:
          - "3306:3306"
        options: >-
          --health-cmd="mysqladmin ping"
          --health-interval=10s
          --health-timeout=5s
          --health-retries=3
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions/cache@v2
        with:
          path: |
            ~/.cargo/registry
            ~/.cargo/git
            starfish/Cargo.lock
            starfish/target
          key: ${{ github.sha }}-${{ github.run_id }}-${{ runner.os }}-mysql

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --test '*'
            --features sqlx-mysql

  mariadb:
    name: MariaDB
    needs:
      - compile-mysql
    runs-on: ubuntu-20.04
    env:
      DATABASE_URL: "mysql://root:@localhost"
    strategy:
      fail-fast: false
      matrix:
        version: [10.6, 10.5, 10.4]
    services:
      mysql:
        image: mariadb:${{ matrix.version }}
        env:
          MYSQL_HOST: 127.0.0.1
          MYSQL_DB: mysql
          MYSQL_USER: sea
          MYSQL_PASSWORD: sea
          MYSQL_ALLOW_EMPTY_PASSWORD: yes
          MYSQL_ROOT_PASSWORD:
        ports:
          - "3306:3306"
        options: >-
          --health-cmd="mysqladmin ping"
          --health-interval=10s
          --health-timeout=5s
          --health-retries=3
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions/cache@v2
        with:
          path: |
            ~/.cargo/registry
            ~/.cargo/git
            starfish/Cargo.lock
            starfish/target
          key: ${{ github.sha }}-${{ github.run_id }}-${{ runner.os }}-mysql

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --test '*'
            --features sqlx-mysql

  sqlite:
    name: SQLite
    needs:
      - compile-sqlite
    runs-on: ubuntu-20.04
    env:
      DATABASE_URL: "sqlite:./sqlite/"
    strategy:
      fail-fast: false
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions/cache@v2
        with:
          path: |
            ~/.cargo/registry
            ~/.cargo/git
            starfish/Cargo.lock
            starfish/target
          key: ${{ github.sha }}-${{ github.run_id }}-${{ runner.os }}-sqlite

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --test '*'
            --features sqlx-sqlite

  postgres:
    name: Postgres
    needs:
      - compile-postgres
    runs-on: ubuntu-20.04
    env:
      DATABASE_URL: "postgres://root:root@localhost"
    strategy:
      fail-fast: false
      matrix:
        version: [14, 13, 12, 11, 10]
    services:
      postgres:
        image: postgres:${{ matrix.version }}
        env:
          POSTGRES_HOST: 127.0.0.1
          POSTGRES_USER: root
          POSTGRES_PASSWORD: root
        ports:
          - "5432:5432"
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
    steps:
      - uses: actions/checkout@v2

      - uses: actions-rs/toolchain@v1
        with:
          profile: minimal
          toolchain: stable
          override: true

      - uses: actions/cache@v2
        with:
          path: |
            ~/.cargo/registry
            ~/.cargo/git
            starfish/Cargo.lock
            starfish/target
          key: ${{ github.sha }}-${{ github.run_id }}-${{ runner.os }}-postgres

      - uses: actions-rs/cargo@v1
        with:
          command: test
          args: >
            --manifest-path starfish/Cargo.toml
            --test '*'
            --features sqlx-postgres