data_check/.github/workflows/ci-pr-databases.yml at develop · andrjas/data_check · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
name: Int Tests

on:
  pull_request:
    types: [opened, synchronize]

jobs:
  oracledb:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Repo
        uses: actions/checkout@v4
      - name: Install uv
        uses: astral-sh/setup-uv@v5
      - name: Run oracledb int_test
        run: |
          if [ -n "$DB_CONNECTION" ]; then
            ./scripts/run_int_test.sh oracledb
          else
            echo "DB_CONNECTION is empty. Skipping test."
          fi
        env:
          DB_CONNECTION: ${{ secrets.ORACLE_CONNECTION }}
          DB_PASSWORD: ${{ secrets.ORACLE_PASSWORD }}
          DB_USER: ${{ secrets.ORACLE_USER }}
          LANG: en_US.utf-8
          NLS_LANG: .utf8
  sqlite:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Repo
        uses: actions/checkout@v4
      - name: Install uv
        uses: astral-sh/setup-uv@v5
      - name: Run sqlite int_test
        run: ./scripts/run_int_test.sh sqlite
  mysql:
    runs-on: ubuntu-latest
    services:
      mysql:
        image: mysql:latest
        env:
          MYSQL_ROOT_PASSWORD: ${{ secrets.MYSQL_PASSWORD}}
          MYSQL_DATABASE: testdb
        options: >-
          --health-cmd "mysqladmin ping --silent"
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
    steps:
      - name: Checkout Repo
        uses: actions/checkout@v4
      - name: Install uv
        uses: astral-sh/setup-uv@v5
      - name: Run mysql int_test
        run: ./scripts/run_int_test.sh mysql
        env:
          DB_CONNECTION: mysql:3306/testdb
          DB_PASSWORD: ${{ secrets.MYSQL_PASSWORD}}
          DB_USER: root
  postgres:
    runs-on: ubuntu-latest
    services:
      postgres:
        image: postgres
        env:
          POSTGRES_PASSWORD: ${{ secrets.POSTGRES_PASSWORD}}
          POSTGRES_USER: postgres
        # Set health checks to wait until postgres has started
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
    steps:
      - name: Checkout Repo
        uses: actions/checkout@v4
      - name: Install uv
        uses: astral-sh/setup-uv@v5
      - name: Run postgres int_test
        run: ./scripts/run_int_test.sh postgres
        env:
          DB_CONNECTION: postgres:5432
          DB_PASSWORD: ${{ secrets.POSTGRES_PASSWORD}}
          DB_USER: postgres
  mssql:
    runs-on: ubuntu-latest
    services:
      sqlserver:
        image: mcr.microsoft.com/azure-sql-edge
        env:
          MSSQL_SA_PASSWORD: ${{ secrets.MSSQL_PASSWORD}}
          ACCEPT_EULA: "Y"
        options: >-
          --health-cmd "/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ${{ secrets.MSSQL_PASSWORD}} -Q 'SELECT 1'"
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
    steps:
      - name: Checkout Repo
        uses: actions/checkout@v4
      - name: Install uv
        uses: astral-sh/setup-uv@v5
      - name: Run mssql int_test
        run: ./scripts/run_int_test.sh mssql
        env:
          DB_CONNECTION: sqlserver:1433/master?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes
          DB_PASSWORD: ${{ secrets.MSSQL_PASSWORD}}
          DB_USER: SA
  duckdb:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Repo
        uses: actions/checkout@v4
      - name: Install uv
        uses: astral-sh/setup-uv@v5
      - name: Run duckdb int_test
        run: ./scripts/run_int_test.sh duckdb