Import sql dumb in correct schema if cusom schema is defined

Manuel · Manuel · commit bc7487ff9258 · 2025-10-05T20:06:41.000+02:00
diff --git a/ansible-rerun.sh b/ansible-rerun.sh
@@ -0,0 +1,86 @@
+#!/usr/bin/env bash
+set -euo pipefail
+
+# Run a playbook directly against Molecule's *existing* containers,
+# reusing Molecule's ephemeral inventory and the docker connection.
+#
+# Usage:
+#   ./ansible-rerun.sh [SCENARIO] [PLAYBOOK] [-- EXTRA_ANSIBLE_ARGS...]
+#
+# Defaults:
+#   SCENARIO = zabbix_server
+#   PLAYBOOK = molecule/$SCENARIO/converge.yml
+#
+# Examples:
+#   ./ansible-rerun.sh zabbix_server
+#   ./ansible-rerun.sh zabbix_server 
+#   ./ansible-rerun.sh zabbix_server molecule/zabbix_server/converge.yml -vvv
+#
+# Notes:
+# - Requires that you've already done at least one `molecule converge` so the
+#   ephemeral inventory exists and the containers are running.
+# - If a Python venv (.venv) exists, it will be used automatically.
+
+SCENARIO="${1:-zabbix_server}"; shift || true
+PLAYBOOK="${1:-}"; if [[ -z "${PLAYBOOK:-}" || "${PLAYBOOK:-}" == "--" ]]; then
+  PLAYBOOK="molecule/${SCENARIO}/converge.yml"
+else
+  shift || true
+fi
+
+# Anything left gets passed straight to ansible-playbook
+EXTRA_ARGS=("$@")
+
+# Activate venv if present
+if [[ -d ".venv" ]]; then
+  # shellcheck disable=SC1091
+  source .venv/bin/activate
+fi
+
+# Make sure ansible-playbook is available
+if ! command -v ansible-playbook >/dev/null 2>&1; then
+  echo "ERROR: ansible-playbook not found. Activate your venv or install Ansible." >&2
+  exit 1
+fi
+
+# Try to find Molecule's latest ephemeral inventory for this scenario
+find_inv_dir() {
+  local patt1 patt2 cand
+  patt1="$HOME/.ansible/tmp/molecule.*.${SCENARIO}"
+  patt2="/root/.ansible/tmp/molecule.*.${SCENARIO}"   # fallback (common in sudo runs)
+  cand="$(ls -td $patt1 2>/dev/null | head -1 || true)"
+  [[ -z "$cand" ]] && cand="$(ls -td $patt2 2>/dev/null | head -1 || true)"
+  echo "$cand"
+}
+
+INV_ROOT="$(find_inv_dir)"
+INV_DIR="${INV_ROOT:+$INV_ROOT/inventory}"
+
+if [[ -z "${INV_ROOT:-}" || ! -d "$INV_DIR" ]]; then
+  echo "ERROR: Could not locate Molecule inventory for scenario '$SCENARIO'." >&2
+  echo "       Run 'molecule converge -s $SCENARIO' once, then retry." >&2
+  exit 2
+fi
+
+# Helpful defaults
+export ANSIBLE_REMOTE_TMP="${ANSIBLE_REMOTE_TMP:-/tmp/.ansible/tmp}"
+# If you keep roles locally, make resolution snappy
+if [[ -d "./roles" ]]; then
+  export ANSIBLE_ROLES_PATH="${ANSIBLE_ROLES_PATH:-$(pwd)/roles}"
+fi
+
+# Build the ansible-playbook command
+cmd=(ansible-playbook -i "$INV_DIR" "$PLAYBOOK")
+
+
+
+# Append any extra args the user provided
+if [[ ${#EXTRA_ARGS[@]} -gt 0 ]]; then
+  cmd+=("${EXTRA_ARGS[@]}")
+fi
+
+echo "[INFO] Inventory: $INV_DIR"
+echo "[INFO] Playbook : $PLAYBOOK"
+echo "[INFO] CMD      : ${cmd[*]}"
+
+"${cmd[@]}"
diff --git a/run_molecule.sh b/run_molecule.sh
@@ -0,0 +1,122 @@
+#!/usr/bin/env bash
+set -euo pipefail
+
+# Usage:
+#   ./run_molecule.sh ROLE_NAME [test|converge|verify|lint] [DB_FILTER]
+# Examples:
+#   ./run_molecule.sh zabbix_proxy
+#   ./run_molecule.sh zabbix_proxy test pgsql
+#   KEEP=1 ./run_molecule.sh zabbix_proxy converge pgsql
+
+ROLE="${1:-}"
+ACTION="${2:-test}"
+DB_FILTER="${3:-}"   # e.g. pgsql | mysql | mariadb
+
+if [[ -z "$ROLE" ]]; then
+  echo "Usage: ./run_molecule.sh ROLE_NAME [test|converge|verify|lint] [DB_FILTER]" >&2
+  exit 1
+fi
+
+# Ensure we're at the repo root (must see molecule/)
+if [[ ! -d molecule ]]; then
+  echo "ERROR: Run from repo root (molecule/ not found)." >&2
+  exit 1
+fi
+
+# Bootstrap venv
+PY="${PYTHON_BIN:-python3}"
+if ! command -v "$PY" >/dev/null 2>&1; then
+  echo "ERROR: $PY not found (set PYTHON_BIN=... if needed)." >&2
+  exit 1
+fi
+
+if [[ ! -d ".venv" ]]; then
+  "$PY" -m venv .venv
+fi
+# shellcheck disable=SC1091
+source .venv/bin/activate
+
+# Ensure toolchain (idempotent)
+python -m pip install -U pip >/dev/null
+python - <<'PY'
+import importlib.util, sys, subprocess
+def have(mod): return importlib.util.find_spec(mod) is not None
+def pip(*args): subprocess.check_call([sys.executable, "-m", "pip", *args])
+
+# core
+if not have("ansible"):            pip("install","ansible-core>=2.15")
+if not have("molecule"):           pip("install","molecule")
+# docker driver plugin
+if not have("molecule_plugins"):   pip("install","molecule-plugins[docker]")
+# verifier deps
+if not have("pytest"):             pip("install","pytest")
+if not have("testinfra"):          pip("install","testinfra")
+PY
+
+# Molecule must be on PATH from the venv
+if ! command -v molecule >/dev/null 2>&1; then
+  echo "ERROR: 'molecule' CLI not found in PATH (venv). Check installation." >&2
+  exit 1
+fi
+
+# Find scenarios referencing the role
+mapfile -t SCENARIOS < <(find molecule -maxdepth 1 -mindepth 1 -type d -printf "%f\n")
+MATCHED=()
+for scen in "${SCENARIOS[@]}"; do
+  cfg="molecule/$scen/converge.yml"
+  [[ -f "$cfg" ]] || continue
+  if grep -Eiq "(role\s*:\s*${ROLE}\b|name\s*:\s*${ROLE}\b|community\.zabbix\.${ROLE}\b|role\s*:\s*community\.zabbix\.${ROLE}\b|include_role:\s*name:\s*${ROLE}\b)" "$cfg"; then
+    MATCHED+=("$scen")
+  fi
+done
+
+# Also support role-local scenarios under roles/<role>/molecule/*
+if [[ -d "roles/$ROLE/molecule" ]]; then
+  while IFS= read -r scen; do
+    [[ -z "$scen" || "$scen" == "." ]] && continue
+    MATCHED+=("$scen")
+  done < <(find "roles/$ROLE/molecule" -maxdepth 1 -mindepth 1 -type d -printf "%f\n")
+fi
+
+if [[ ${#MATCHED[@]} -eq 0 ]]; then
+  echo "ERROR: No scenarios found referencing role '$ROLE'." >&2
+  exit 2
+fi
+
+echo "[INFO] Will run scenarios: ${MATCHED[*]}"
+if [[ -n "$DB_FILTER" ]]; then
+  echo "[INFO] DB filter active: _database_groups=['$DB_FILTER'] and --tags $DB_FILTER"
+fi
+if [[ "${KEEP:-}" == "1" && "$ACTION" == "converge" ]]; then
+  echo "[INFO] KEEP=1 set: containers will be preserved after converge."
+fi
+
+for scen in "${MATCHED[@]}"; do
+  echo "=== Running: molecule $ACTION -s $scen ==="
+
+  # Limit pytest collection to this scenario's tests & move its cache locally
+  export PYTEST_ADDOPTS="-o testpaths=$(pwd)/molecule/$scen/tests -o cache_dir=$(pwd)/.pytest_cache_$scen"
+
+  # Build the command
+  cmd=(molecule "$ACTION" -s "$scen")
+
+  # Keep containers (only meaningful on converge)
+  if [[ "$ACTION" == "converge" && "${KEEP:-}" == "1" ]]; then
+    cmd+=("--destroy=never")
+  fi
+
+  # Append extra Ansible args after the '--' separator
+  if [[ -n "$DB_FILTER" ]]; then
+    cmd+=("--" "--tags" "$DB_FILTER" "-e" "_database_groups=['$DB_FILTER']")
+    # Limit to DB-specific instances only for actions that operate on running hosts.
+    case "$ACTION" in (converge|prepare|verify|idempotence|side_effect|cleanup|check)
+      cmd+=("--limit" "*$DB_FILTER*")
+      ;;
+    esac
+  fi
+
+  echo "[INFO] CMD: ${cmd[*]}"
+  ANSIBLE_REMOTE_TMP="${ANSIBLE_REMOTE_TMP:-/tmp/.ansible/tmp}" "${cmd[@]}"
+done
+
+echo "All done."
