test-mitzasql.sh

#!/bin/bash

# Run the unit tests against different versions of dockerized mysql servers
# and python versions

if [ ! -f .env ]; then
    echo 'Missing .env file'
    exit 1
fi

if [ "$1" = 'help' ]; then
    echo "Usage: $0 [mysql56|mysql57|mysql8] [py36|py37|py38|py39]"
    exit 0
fi

# Download database fixtures
./download-db-fixtures.sh || exit 1

if [ -z "$1" ]; then
    mysql_services='mysql56 mysql57 mysql8'
else
    mysql_services="$1"
fi

if [ -z "$2" ]; then
    python_versions='py36 py37 py38 py39'
else
    python_versions="$2"
fi

python_services=''
for py in $python_versions; do
    service_name="python${py/py/}"
    python_services="${python_services} $service_name"
done

FILE=docker-compose-tests.yml
echo 'Building images...'
docker-compose -f "$FILE" build $python_services
docker-compose -f $FILE up -d $mysql_services

# Wait for all mysql containers to finish initialization
sleep 5
for version in $mysql_services; do
    name=$(docker-compose -f $FILE ps -q $version)
    status=$(docker inspect --format='{{.State.Health}}' $name | grep -o healthy)

    while [ "$status" != "healthy" ]; do
        status=$(docker inspect --format='{{.State.Health}}' $name | grep -o healthy)
        echo "$version server status is: $status"
        sleep 1
    done
done

echo 'All done! Running tests...'
EXIT_CODE=0

for py in $python_versions; do
    for my in $mysql_services; do
        echo "================================================================="
        echo "Running tests on: $py - $my"
        echo "================================================================="
        service_name="python${py/py/}"
        docker-compose -f $FILE run --rm -e TRAVIS="$TRAVIS" -e TRAVIS_PULL_REQUEST="$TRAVIS_PULL_REQUEST" -e TRAVIS_JOB_ID="$TRAVIS_JOB_ID" -e TRAVIS_BRANCH="$TRAVIS_BRANCH" -e DB_HOST='tcp://'$my $service_name tox -- --cov=mitzasql -x
        EXIT_CODE=$?
        if [ $EXIT_CODE != 0 ]; then
            break
        fi
    done

    if [ $EXIT_CODE != 0 ]; then
        break
    fi
done

docker-compose -f $FILE stop
exit $EXIT_CODE