#!/usr/bin/sh
set -e
PHP="/usr/local/synconix/php70/usr/bin/php"
MOD="sqlsrv"
echo "== php70 ${MOD} doctor =="
echo "PHP: $("$PHP" -v | head -n1)"
"$PHP" -m | /usr/bin/grep -i "^${MOD}$" >/dev/null
"$PHP" --ri "$MOD" >/dev/null
echo "OK: ${MOD} loads and reports module info"
if command -v odbcinst >/dev/null 2>&1; then
  if odbcinst -q -d 2>/dev/null | /usr/bin/grep -Eq 'ODBC Driver (17|18) for SQL Server|FreeTDS'; then
    echo "OK: SQL Server ODBC driver entry exists"
  else
    echo "WARN: no SQL Server ODBC driver entry found; install/configure msodbcsql18 or compatible driver before connecting"
  fi
fi
