ci.yml

name: CI

on:
  push:
  pull_request:
  schedule:
    - cron: '0 0 * * 0'

jobs:
  test:
    runs-on: ubuntu-latest

    strategy:
      matrix:
        jdk-version:
          - 17

    steps:
      - name: Checkout repository
        uses: actions/checkout@v4

      - name: Set up JDK ${{ matrix.jdk-version }}
        uses: actions/setup-java@v4
        with:
          java-version: ${{ matrix.jdk-version }}
          distribution: adopt
          cache: maven

      - name: Test with Maven
        run: mvn -B test

#  test-postgres:
#    runs-on: ubuntu-latest
#
#    services:
#      postgres:
#        image: postgres
#        env:
#          POSTGRES_PASSWORD: postgres
#        options: >-
#          --health-cmd pg_isready
#          --health-interval 10s
#          --health-timeout 5s
#          --health-retries 5
#        ports:
#          - 5432:5432
#
#    steps:
#      - name: Checkout repository
#        uses: actions/checkout@v4
#
#      - name: Set up JDK 17
#        uses: actions/setup-java@v4
#        with:
#          java-version: 17
#          distribution: adopt
#          cache: maven
#
#      - name: Test with Maven
#        run: mvn -B test
#        env:
#          spring_profiles_active: pgsql
#
#  test-mysql:
#    runs-on: ubuntu-latest
#
#    services:
#      mysql:
#        image: mysql:5.7
#        env:
#          MYSQL_DATABASE: test
#          MYSQL_ROOT_PASSWORD: changeit
#        options: >-
#          --health-cmd="mysqladmin ping"
#          --health-interval 10s
#          --health-timeout 5s
#          --health-retries 5
#        ports:
#          - 3306:3306
#
#    steps:
#      - name: Checkout repository
#        uses: actions/checkout@v4
#
#      - name: Set up JDK 17
#        uses: actions/setup-java@v4
#        with:
#          java-version: 17
#          distribution: adopt
#          cache: maven
#
#      - name: Test with Maven
#        run: mvn -B test
#        env:
#          spring_profiles_active: mysql

  test-sqlserver:
    runs-on: ubuntu-latest

    services:
      sqlserver:
        image: mcr.microsoft.com/mssql/server:2022-latest
        ports:
          - 1433:1433
        env:
          ACCEPT_EULA: Y
          MSSQL_SA_PASSWORD: "Changeit_123"

    steps:
      - name: Checkout repository
        uses: actions/checkout@v4

      - name: Set up JDK 17
        uses: actions/setup-java@v4
        with:
          java-version: 17
          distribution: adopt
          cache: maven

      - name: Test with Maven
        run: mvn -B test
        env:
          spring_profiles_active: sqlserver