SQWareProduction:generic:etc:sqwgen IndicatorsVar.cfg

From Wiki_dbSQWare
Revision as of 18:55, 23 February 2018 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to: navigation, search

Configuration file $gvsqw_GenBin/../etc/sqwgen_IndicatorsVar.cfg:
Generic global var for indicators scripts
It contains the operating variables of SQWareProduction.

File content:

#!/bin/ksh
###################################################################
# SQWareProduction Generic module of dbSQWare
# 
# dbSQWare 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
# CGU/CGA for more details.
# 
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	Generic global var for indicators scripts
## @Copyright	Copyright 2010-2024, dbSQWare (www.dbsqware.com)

if [ "$gvsqw_Debug" != "" ]
then
	echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../generic/etc/sqwgen_IndicatorsVar.cfg"
fi

#for Check backups
if [ "$(date +'%a')" = "Mon" ]
then
	export gvsqw_NbDaysFull=3
else
	export gvsqw_NbDaysFull=2
fi

#for purge indicators tables (in number of month)
export gvsqw_PurgeLongTerm=24
export gvsqw_PurgeMediumTerm=4
export gvsqw_PurgeShortTerm=2

###################################################################################################
###################################################################################################

# Source generic custom
eval lvsqw_Tmp="\$gvsqw_${gvsqw_RdbmsTrigram}Bin"
if [ -r $gvsqw_GenPath/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg ]
then
	if [ "$gvsqw_Debug" != "" ]
	then
		echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg"
	fi
	. $gvsqw_GenPath/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg
elif  [ -r $lvsqw_Tmp/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg ]
then
	if [ "$gvsqw_Debug" != "" ]
	then
		echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg"
	fi
	. $lvsqw_Tmp/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg
elif  [ -r $(dirname $0)/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg ]
then
	if [ "$gvsqw_Debug" != "" ]
	then
		echo $gvsqw_EchoOpt "sourcing cfg file : $(dirname $0)/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg"
	fi
	. $(dirname $0)/../../generic/etc_cust/sqwgen_IndicatorsVar.cfg
fi

# For not normed environnement
if [ -r $HOME/sqwConfig/sqwgen_IndicatorsVar.cfg ]
	if [ "$gvsqw_Debug" != "" ]
	then
		echo $gvsqw_EchoOpt "sourcing cfg file : $HOME/sqwConfig/sqwgen_IndicatorsVar.cfg"
	fi
	. $HOME/sqwConfig/sqwgen_IndicatorsVar.cfg
fi

if [ "$gvsqw_RdbmsType" != "generic" ]
then
	# Source rdbms global
	if [ -r $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg"
		fi
		. $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg
	elif  [ -r $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg"
		fi
		. $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg
	elif  [ -r $(dirname $0)/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $(dirname $0)/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg"
		fi
		. $(dirname $0)/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg
	fi
	# Source rdbms custom
	if [ -r $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg"
		fi
		. $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg
	elif  [ -r $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg"
		fi
		. $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg
	elif  [ -r $(dirname $0)/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg ]
	then
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $(dirname $0)/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg"
		fi
		. $(dirname $0)/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg
	fi
	# For not normed environnement
	if [ -r $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg ]
		if [ "$gvsqw_Debug" != "" ]
		then
			echo $gvsqw_EchoOpt "sourcing cfg file : $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg"
		fi
		. $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_IndicatorsVar.cfg
	fi
fi


Variables explanation:


Nuvola apps information.png
Note:
You can overload variables contain in $gvsqw_GenBin/../etc/sqwgen_IndicatorsVar.cfg

by the same variables in $gvsqw_GenBin/../etc_cust/sqwgen_IndicatorsVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwgen_IndicatorsVar.cfg specifically for this user.