kamailio/utils/kamctl/kamctl.pgsql

#
#
# control tool for maintaining Kamailio
#
#===================================================================

##### ----------------------------------------------- #####
### PGSQL specific variables and functions
#

##### ----------------------------------------------- #####
### load SQL base
#
if [ -f "$MYLIBDIR/kamctl.sqlbase" ]; then
	. "$MYLIBDIR/kamctl.sqlbase"
else
	echo "Cannot load SQL core functions '$MYLIBDIR/kamctl.sqlbase' - exiting ..."
	exit -1
fi

##### ----------------------------------------------- #####
### binaries
if [ -z "$PGSQL" ] ; then
	if [ -z "$DBCLI" ] ; then
		locate_tool psql
		if [ -z "$TOOLPATH" ] ; then
			echo "error: 'psql' tool not found: set PGSQL variable to correct tool path"
			exit
		fi
		PGSQL="$TOOLPATH"
	else
		PGSQL="$DBCLI"
	fi
fi


# input: sql query, optional pgsql command-line params
pgsql_query() {
	# if password not yet queried, query it now
	prompt_pw "PgSQL password for user '$DBRWUSER@$DBHOST'"
	mecho "pgsql_query: $PGSQL $2 -A -q -t -P fieldsep='	' -h $DBHOST -U $DBRWUSER $DBNAME -c '$1'"
	if [ -z "$DBPORT" ] ; then
		PGPASSWORD="$DBRWPW" $PGSQL $DBCLIPARAMS $2 \
			-A -q -t \
			-P fieldsep="	" \
			-h $DBHOST \
			-U $DBRWUSER \
			$DBNAME \
			-c "$1"
	else
		PGPASSWORD="$DBRWPW" $PGSQL $DBCLIPARAMS $2 \
			-A -q -t \
			-P fieldsep="	" \
			-h $DBHOST \
			-p $DBPORT \
			-U $DBRWUSER \
			$DBNAME \
			-c "$1"
	fi
}

# input: sql query, optional pgsql command-line params
pgsql_ro_query() {
	mdbg "pgsql_ro_query: $PGSQL $2 -A -q -t -h $DBHOST -U $DBROUSER $DBNAME -c '$1'"
	if [ -z "$DBPORT" ] ; then
		PGPASSWORD="$DBROPW" $PGSQL $DBCLIPARAMS $2 \
			-A -q -t \
			-h $DBHOST \
			-U $DBROUSER \
			$DBNAME \
			-c "$1"
	else
		PGPASSWORD="$DBROPW" $PGSQL $DBCLIPARAMS $2 \
			-A -q -t \
			-h $DBHOST \
			-p $DBPORT \
			-U $DBROUSER \
			$DBNAME \
			-c "$1"
	fi
}

DBCMD=pgsql_query
DBROCMD=pgsql_ro_query
DBRAWPARAMS="-A -q -t"