tomcat/db.sh at master · simplicitesoftware/tomcat · 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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
#!/bin/bash
# =========================================================================== #
#   ___ _            _ _    _ _         ___       __ _                        #
#  / __(_)_ __  _ __| (_)__(_) |_ ___  / __| ___ / _| |___ __ ____ _ _ _ ___  #
#  \__ \ | '  \| '_ \ | / _| |  _/ -_) \__ \/ _ \  _|  _\ V  V / _` | '_/ -_) #
#  |___/_|_|_|_| .__/_|_\__|_|\__\___| |___/\___/_|  \__|\_/\_/\__,_|_| \___| #
#              |_|                                                            #
# =========================================================================== #

if [ "$1" = "--help" ]
then
	echo "Usage $(basename $0)" >&2
	exit -1
fi

[ "$JAVA_HOME" = "" ] && JAVA_HOME="/usr/lib/jvm/java"
if [ ! -d $JAVA_HOME ]
then
	echo "ERROR: JAVA_HOME = $JAVA_HOME is not correctly configured" >&2
	exit 1
fi
echo "Java home: $JAVA_HOME"
export PATH=$JAVA_HOME/bin:$PATH

[ "$TOMCAT_ROOT" = "" ] && TOMCAT_ROOT=$(dirname $0)
TOMCAT_ROOT=$(realpath $TOMCAT_ROOT)
echo "Tomcat root: $TOMCAT_ROOT"

export JAVA_OPTS="$JAVA_OPTS -Dfile.encoding=UTF-8"

[ "$DB_VENDOR" = "" ] && DB_VENDOR=hsqldb
[ "$DB_VENDOR" = "mariadb" ] && DB_VENDOR=mysql
[ "$DB_VENDOR" = "pgsql" -o "$DB_VENDOR" = "postgres" ] && DB_VENDOR=postgresql
[ "$DB_VENDOR" = "sqlserver" ] && DB_VENDOR=mssql
echo "Database vendor: $DB_VENDOR"

if [ $DB_VENDOR = "hsqldb" ]
then
	WEBINF_DIR=$TOMCAT_ROOT/webapps/${TOMCAT_WEBAPP:-ROOT}/WEB-INF
	if [ -d $WEBINF_DIR/db ]
	then
		echo "HSQLDB database: Embedded"
		DRIVER=$(find $WEBINF_DIR -name hsqldb-\*.jar -print)
		SQLTOOL=$(find $WEBINF_DIR -name sqltool-\*.jar -print)
		java $JAVA_OPTS -cp $DRIVER:$SQLTOOL org.hsqldb.cmdline.SqlTool --inlineRc="url=jdbc:hsqldb:file:$TOMCAT_ROOT/webapps/${TOMCAT_WEBAPP:-ROOT}/WEB-INF/db/simplicite;shutdown=true;sql.ignore_case=true,user=sa,password="
		exit $?
	else
		echo "ERROR: No database directory ($WEBINF_DIR/db)" >&2
		exit 3
	fi
elif [ $DB_VENDOR = "mysql" ]
then
	[ "$DB_HOST" = "" ] && DB_HOST=127.0.0.1
	[ "$DB_PORT" = "" ] && DB_PORT=3306
	echo "MySQL database: $DB_HOST / $DB_PORT / $DB_NAME / $DB_USER"
	mysql --host=$DB_HOST --port=$DB_PORT --user=$DB_USER --password=$DB_PASSWORD --database=$DB_NAME
	exit $?
elif [ $DB_VENDOR = "postgresql" ]
then
	[ "$DB_HOST" = "" ] && DB_HOST=127.0.0.1
	[ "$DB_PORT" = "" ] && DB_PORT=5432
	echo "PostgreSQL database: $DB_HOST / $DB_PORT / $DB_NAME / $DB_USER"
	PGPASSWORD=$DB_PASSWORD psql --host=$DB_HOST --port=$DB_PORT --username=$DB_USER --dbname=$DB_NAME
	exit $?
elif [ $DB_VENDOR = "oracle" ]
then
	[ "$DB_HOST" = "" ] && DB_HOST=127.0.0.1
	[ "$DB_PORT" = "" ] && DB_PORT=1521
	echo "Oracle database: $DB_HOST / $DB_PORT / $DB_NAME / $DB_USER"
	sqlplus $DB_USER/$DB_PASSWORD@//$DB_HOST:$DB_PORT/$DB_NAME
	exit $?
elif [ $DB_VENDOR = "sqlserver" ]
then
	[ "$DB_HOST" = "" ] && DB_HOST=127.0.0.1
	[ "$DB_PORT" = "" ] && DB_PORT=1433
	echo "SQLServer database: $DB_HOST / $DB_PORT / $DB_NAME / $DB_USER"
	sqlcmd -S $DB_HOST,$DB_PORT -U $DB_USER -P $DB_PASSWORD
	exit $?
else
	echo "ERROR: Unknown database vendor ($DB_VENDOR)" >&2
	exit 3
fi