ci.yml

name: CI

on:
  push:
    branches: [ "main" ]
  pull_request:
    branches: [ "main" ]
  # Allows you to run this workflow manually from the Actions tab
  workflow_dispatch:

jobs:
  build:

    runs-on: ubuntu-latest

    steps:
    - uses: actions/checkout@v3
    - name: Set up MySQL server
      run: |
        docker run -d -p 3306:3306 -e MYSQL_ALLOW_EMPTY_PASSWORD=yes --name test-mysql mysql:8.0
        echo "MySQL startup ..."
        until docker exec test-mysql mysql -u root -e "SELECT 1;"; do \
          echo "..."; \
          sleep 1; \
        done;
        docker exec -u root test-mysql mysql -u root -e "CREATE DATABASE testdb;"
        docker exec -u root -t test-mysql mysql -u root testdb -e "CREATE TABLE test_source (i integer, b boolean, f float, v varchar(32), c char(32), lv varchar(9999), bn binary(32), vb varbinary(32), lvb varbinary(9999), d date, t time, ts timestamp null, tz varchar(80), tsz varchar(80), n numeric(20,4));"
        docker exec -u root test-mysql /bin/bash -c "(echo \"INSERT INTO test_source VALUES (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);\"; for i in \`seq 1 9\`; do echo \"INSERT INTO test_source VALUES (\$i, 1, \$i.5, 'test \$i', 'test \$i', 'test \$i', 'test \$i', 'test \$i', 'test \$i', '\$((\$i+11))00/1/\$i', '4:0\$i', '2038-01-0\$i 03:14:07', '1:2\$i:00', 'June 1, \$((\$i+11))00 03:2\$i EST', '123456.7890');\"; done) | mysql -u root testdb"
        docker exec -u root test-mysql mysql -u root testdb -e "select * from test_source;"
    - name: Set up a Vertica server
      timeout-minutes: 15
      run: |
        docker run -d -p 5433:5433 -p 5444:5444 \
          -e ODBCSYSINI=/var/odbc-loader/tests/config \
          --add-host=host.docker.internal:host-gateway \
          --name vertica_docker \
          vertica/vertica-ce:23.4.0-0
        echo "Vertica startup ..."
        until docker exec vertica_docker test -f /data/vertica/VMart/agent_start.out; do \
          echo "..."; \
          sleep 3; \
        done;
        echo "Vertica is up"
        docker exec -u dbadmin vertica_docker /opt/vertica/bin/vsql -c "\l"
        docker exec -u dbadmin vertica_docker /opt/vertica/bin/vsql -c "select version()"
    - name: Build & Install UDx
      run: |
        docker exec -u root vertica_docker yum -y install centos-release-scl
        docker exec -u root vertica_docker yum -y install devtoolset-7
        docker exec -u root vertica_docker yum -y install unixODBC-devel
        docker exec -u root vertica_docker yum -y install pcre-devel
        docker cp ${{ github.workspace }} vertica_docker:/var/odbc-loader
        docker exec -u dbadmin vertica_docker /bin/bash -c "sudo chown -R dbadmin:verticadba /var/odbc-loader"
        docker exec -w /var/odbc-loader -u dbadmin vertica_docker /bin/bash -c "source /opt/rh/devtoolset-7/enable; \
        make; \
        make install"
    - name: Install ODBC clients
      run: |
        docker exec -w /var/odbc-loader -u root vertica_docker wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.31-1.el7.x86_64.rpm
        docker exec -w /var/odbc-loader -u root vertica_docker rpm -i mysql-connector-odbc-8.0.31-1.el7.x86_64.rpm
    - name: Run Tests
      run: |
        docker exec -w /var/odbc-loader -u dbadmin vertica_docker make test