aboutsummaryrefslogtreecommitdiffstats
path: root/scripts/lib/docker.sh
diff options
context:
space:
mode:
authorEugene Triguba <hello@eugenetriguba.com>2025-10-13 10:32:02 -0400
committerEugene Triguba <hello@eugenetriguba.com>2025-10-13 10:32:02 -0400
commitd79f9b3bdb1a9ee341573eb67006de0c5fbfb7fc (patch)
treee96998b3be26f5c73f13204217d059ed9c12a97a /scripts/lib/docker.sh
parentPoint go installation method to use latest stable version (diff)
downloadcli-d79f9b3bdb1a9ee341573eb67006de0c5fbfb7fc.zip
Add database older version compatibility tests
Diffstat (limited to '')
-rw-r--r--scripts/lib/docker.sh63
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"