utility-scripts/docker-exec-sap-hana-client at master · mgmorey/utility-scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
#!/bin/sh -eu

# docker-exec-sap-hana-client: run SAP HANA client in container
# Copyright (C) 2020  "Michael G. Morey" <mgmorey@gmail.com>

# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.

# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.

# You should have received a copy of the GNU General Public License
# along with this program.  If not, see <https://www.gnu.org/licenses/>.

abort() {
    printf "$@" >&2
    exit 1
}

assert() {
    "$@" || abort '%s: Assertion failed: %s\n' "$script" "$*"
}

usage_error() {
    printf "$@" >&2
    exit 2
}

script=$(basename "$0")

case "$0" in
    (*/*)
	script_dir=$(cd "$(dirname "$0")" && pwd)
	;;
    (*)
	script_dir=
	;;
esac

script_prefix=${script_dir:+$script_dir/}

. "${script_prefix}sap-hana-config.sh"

if [ $# -lt 1 ]; then
    usage_error '%s: Not enough arguments\n' "$script"
elif [ $# -gt 1 ]; then
    usage_error '%s: Too many arguments\n' "$script"
fi

if [ -r $HOME/.env-sap-hana ]; then
    . $HOME/.env-sap-hana
fi

if [ -r $HOME/${ENV_FILE-.env} ]; then
    . $HOME/${ENV_FILE-.env}
fi

docker exec -it $1 /usr/sap/HXE/HDB90/exe/hdbsql -i 90 \
       -d ${DATABASE_INSTANCE-SYSTEMDB} -u SYSTEM \
       -p ${DATABASE_PASSWORD-P455w0rd}