Vladimir Buzalka
15 lines
527 B
Bash
15 lines
527 B
Bash
#!/bin/bash
|
|
# Rychla kontrola obnoveneho zrcadla: verze enginu, ODS, pocet pacientu.
|
|
set -euo pipefail
|
|
NAME=firebird-medicus
|
|
PASS=masterkey
|
|
ISQL=/usr/local/firebird/bin/isql
|
|
DB=localhost:/firebird/data/medicus.fdb
|
|
|
|
docker exec -i "$NAME" "$ISQL" -user SYSDBA -password "$PASS" "$DB" <<'SQL'
|
|
SELECT rdb$get_context('SYSTEM','ENGINE_VERSION') AS ENGINE FROM rdb$database;
|
|
SELECT MON$ODS_MAJOR AS ODS_MAJOR, MON$ODS_MINOR AS ODS_MINOR, MON$PAGE_SIZE AS PAGE_SIZE FROM MON$DATABASE;
|
|
SELECT COUNT(*) AS PACIENTU FROM KAR;
|
|
QUIT;
|
|
SQL
|