Difference between revisions of "SQWareProduction:mysql:lib:sqwmys Global.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(7 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
Functions explanation:
 
Functions explanation:
 
<pre>
 
<pre>
gfsqw_BatchDuration
+
gfsqw_CheckConn =>  
gfsqw_BatchDuration =>
 
gfsqw_BeginningCom =>
 
  gfsqw_Colors
 
gfsqw_Colors =>
 
gfsqw_DisplaySample =>
 
gfsqw_EndMailError =>
 
gfsqw_EndMailError 31 "You do not have write permission on $gvsqw_LogDir !"
 
gfsqw_EndMailError 31 "You do not have write permission on $gvsqw_TmpDir !"
 
gfsqw_EndMailError 31 "You do not have write permission on $lvsqw_RootTmp !"
 
gfsqw_EndMailError 33 "Error, database $lvsqw_DbName on $MYSQL_SID does not exist or pb connection !<br>\n<pre class='edt'>\n$cat $gvsqw_TmpFile => \n</pre>"
 
gfsqw_EndMailError 99 "Error, failed to connect to $MYSQL_SID !!!<br>\n<pre class='edt'>\n$gvsqw_MysVersionMajInt\n</pre>"
 
gfsqw_EndMailError_sub
 
gfsqw_EndMailError_sub =>
 
gfsqw_EndMailError_sub 2>&1 >> $gvsqw_LogFile
 
gfsqw_EndTrt =>  
 
 
gfsqw_EvalGlobalVar
 
gfsqw_EvalGlobalVar
gfsqw_EvalGlobalVar =>
 
 
gfsqw_FormatHtmlMessages =>  
 
gfsqw_FormatHtmlMessages =>  
gfsqw_GenInfoMail
 
gfsqw_GenInfoMail =>
 
 
gfsqw_GenListDatabase =>  
 
gfsqw_GenListDatabase =>  
 
gfsqw_GetVersion =>  
 
gfsqw_GetVersion =>  
gfsqw_HeadFile =>
 
gfsqw_HtmlTablesCode =>
 
gfsqw_Init =>
 
gfsqw_JobEnd
 
gfsqw_Ptree =>
 
gfsqw_Purge
 
gfsqw_Purge =>
 
gfsqw_SourceOverloadLibs =>
 
gfsqw_SourceOverloadLibs 'sqwmys_InsertIndicators.lib'
 
gfsqw_SourceOverloadLibs 'sqwmys_SetEnv.lib'
 
gfsqw_SourceOverloadLibs $lvsqw_SpecificLib
 
 
gfsqw_SourceProfile
 
gfsqw_SourceProfile
gfsqw_StartLog =>  
+
gfsqw_TrapServer =>  
gfsqw_TempFile =>  
+
gfsqw_TrapVersion =>  
 +
gfsqw_TrapVersion 2>&1|grep -v 'password on the command line' | sed 's,  *$,,g' > $gvsqw_MailInfoProgFile.tmp
 +
gfsqw_TrapVersion 2>&1| sed 's,  *$,,g' |tee $gvsqw_TmpFile
 
</pre>
 
</pre>
 
<br>
 
<br>
 
{{SQWareProductionSurchargeLib|mysql|Mys|sqwmys_Global.lib}}
 
{{SQWareProductionSurchargeLib|mysql|Mys|sqwmys_Global.lib}}
 
<br>
 
<br>

Latest revision as of 10:37, 11 February 2023

shell functions library $gvsqw_MysBin/../lib/sqwmys_Global.lib:
central lib of generic fonctions for mysql
Functions explanation:

gfsqw_CheckConn => 
gfsqw_EvalGlobalVar
gfsqw_FormatHtmlMessages => 
gfsqw_GenListDatabase => 
gfsqw_GetVersion => 
gfsqw_SourceProfile
gfsqw_TrapServer => 
gfsqw_TrapVersion => 
gfsqw_TrapVersion 2>&1|grep -v 'password on the command line' | sed 's,  *$,,g' > $gvsqw_MailInfoProgFile.tmp
gfsqw_TrapVersion 2>&1| sed 's,  *$,,g' |tee $gvsqw_TmpFile


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_MysBin/../lib/sqwmys_Global.lib

by function with same name in $gvsqw_MysBin/../lib_cust/sqwmys_Global.lib for all your environnement
or by $HOME/sqwConfig/sqwmys_Global.lib specifically for this user .