diff options
| author | Eugene Triguba <hello@eugenetriguba.com> | 2025-10-13 10:32:02 -0400 |
|---|---|---|
| committer | Eugene Triguba <hello@eugenetriguba.com> | 2025-10-13 10:32:02 -0400 |
| commit | d79f9b3bdb1a9ee341573eb67006de0c5fbfb7fc (patch) | |
| tree | e96998b3be26f5c73f13204217d059ed9c12a97a /scripts/lib/docker.sh | |
| parent | Point go installation method to use latest stable version (diff) | |
| download | cli-d79f9b3bdb1a9ee341573eb67006de0c5fbfb7fc.zip | |
Add database older version compatibility tests
Diffstat (limited to 'scripts/lib/docker.sh')
| -rw-r--r-- | scripts/lib/docker.sh | 63 |
1 files changed, 50 insertions, 13 deletions
diff --git a/scripts/lib/docker.sh b/scripts/lib/docker.sh index d2efaf5..ae037e7 100644 --- a/scripts/lib/docker.sh +++ b/scripts/lib/docker.sh @@ -15,6 +15,32 @@ readonly BOLT_MYSQL_ROOT_PASSWORD="${MYSQL_ROOT_PASSWORD:-testpassword}" readonly BOLT_MSSQL_SA_PASSWORD="${MSSQL_SA_PASSWORD:-TestPass123!}" +# Parse database type and version from suite name +# +# DESCRIPTION: +# Extracts base database type and version from suite names. +# Handles both simple names (postgresql) and versioned names (postgresql-15). +# +# ARGUMENTS: +# $1: Suite name (e.g., "postgresql", "postgresql-15", "mysql-8.0") +# +# OUTPUTS: +# Prints "db_type version" to stdout (version is "latest" if not specified) +# +# EXAMPLES: +# docker_parse_suite_name "postgresql" # outputs: postgresql latest +# docker_parse_suite_name "postgresql-15" # outputs: postgresql 15 +# +docker_parse_suite_name() { + local suite_name="$1" + + if [[ "$suite_name" =~ ^([a-z0-9]+)-(.+)$ ]]; then + echo "${BASH_REMATCH[1]} ${BASH_REMATCH[2]}" + else + echo "$suite_name latest" + fi +} + # Generate database DSN string for a given database type # # DESCRIPTION: @@ -22,7 +48,7 @@ readonly BOLT_MSSQL_SA_PASSWORD="${MSSQL_SA_PASSWORD:-TestPass123!}" # This ensures perfect synchronization between container setup and Go test configuration. # # ARGUMENTS: -# $1: Database type (postgresql, mysql, mssql, sqlite3) +# $1: Database suite name (postgresql, mysql, mssql, sqlite3, or versioned like postgresql-15) # # OUTPUTS: # Prints the DSN string to stdout @@ -32,7 +58,9 @@ readonly BOLT_MSSQL_SA_PASSWORD="${MSSQL_SA_PASSWORD:-TestPass123!}" # 1 - Unknown database type # docker_generate_dsn() { - local db_type="$1" + local suite_name="$1" + local db_type version + read -r db_type version <<< "$(docker_parse_suite_name "$suite_name")" case "$db_type" in "postgresql") @@ -60,11 +88,13 @@ docker_generate_dsn() { # # ARGUMENTS: # $1: Container name (default: bolt_postgresql_db) +# $2: Version tag (default: latest) # docker_start_postgresql() { local container_name="${1:-bolt_postgresql_db}" + local version="${2:-latest}" - log_info "Starting PostgreSQL container '$container_name'..." + log_info "Starting PostgreSQL $version container '$container_name'..." docker run --detach \ --name "$container_name" \ @@ -76,18 +106,20 @@ docker_start_postgresql() { --env POSTGRES_DB="$BOLT_POSTGRES_DB" \ --env POSTGRES_USER="$BOLT_POSTGRES_USER" \ --env POSTGRES_PASSWORD="$BOLT_POSTGRES_PASSWORD" \ - postgres:18-alpine + "postgres:${version}" } # Start a MySQL database container # # ARGUMENTS: # $1: Container name (default: bolt_mysql_db) +# $2: Version tag (default: latest) # docker_start_mysql() { local container_name="${1:-bolt_mysql_db}" + local version="${2:-latest}" - log_info "Starting MySQL container '$container_name'..." + log_info "Starting MySQL $version container '$container_name'..." docker run --detach \ --name "$container_name" \ @@ -100,18 +132,20 @@ docker_start_mysql() { --env MYSQL_USER="$BOLT_MYSQL_USER" \ --env MYSQL_PASSWORD="$BOLT_MYSQL_PASSWORD" \ --env MYSQL_ROOT_PASSWORD="$BOLT_MYSQL_ROOT_PASSWORD" \ - mysql:9.4 + "mysql:${version}" } # Start a MSSQL database container # # ARGUMENTS: # $1: Container name (default: bolt_mssql_db) +# $2: Version tag (default: latest) # docker_start_mssql() { local container_name="${1:-bolt_mssql_db}" + local version="${2:-latest}" - log_info "Starting MSSQL container '$container_name'..." + log_info "Starting MSSQL $version container '$container_name'..." docker run --detach \ --name "$container_name" \ @@ -123,7 +157,7 @@ docker_start_mssql() { --health-retries 10 \ --env ACCEPT_EULA=Y \ --env MSSQL_SA_PASSWORD="$BOLT_MSSQL_SA_PASSWORD" \ - mcr.microsoft.com/mssql/server:2022-latest + "mcr.microsoft.com/mssql/server:${version}" } # Stop and remove a database container @@ -195,7 +229,7 @@ docker_wait_for_healthy_container() { # # ARGUMENTS: # $1: Container name -# $2: Database type (postgresql, mysql, mssql) +# $2: Database suite name (postgresql, mysql, mssql, or versioned like postgresql-15) # $3: Keep database running (true/false) # # RETURN: @@ -204,9 +238,12 @@ docker_wait_for_healthy_container() { # docker_ensure_container_running() { local container_name="$1" - local db_type="$2" + local suite_name="$2" local keepdb="$3" + local db_type version + read -r db_type version <<< "$(docker_parse_suite_name "$suite_name")" + local container_status container_status=$(docker inspect -f '{{.State.Health.Status}}' "$container_name" 2>/dev/null || echo "not_found") @@ -225,13 +262,13 @@ docker_ensure_container_running() { case "$db_type" in "postgresql") - docker_start_postgresql "$container_name" + docker_start_postgresql "$container_name" "$version" ;; "mysql") - docker_start_mysql "$container_name" + docker_start_mysql "$container_name" "$version" ;; "mssql") - docker_start_mssql "$container_name" + docker_start_mssql "$container_name" "$version" ;; *) log_error "Unknown database type: $db_type" |