SQWareProduction:postgres:lib:sqwpg GatherStructure.lib : Différence entre versions

De WikiFr_dbSQWare
Aller à : navigation, rechercher
m (Updated by BatchUser)
 
m (Updated by BatchUser)
 
(2 révisions intermédiaires par le même utilisateur non affichées)
Ligne 4 : Ligne 4 :
 
Explication des fonctions:
 
Explication des fonctions:
 
<pre>
 
<pre>
 +
gfsqw_BeginningCom
 
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
 
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
 +
gfsqw_InsertIndicators "columns informations"
 +
gfsqw_InsertIndicators "indexes '%ccnew%' or '%ccold%'"
 +
gfsqw_InsertIndicators "indexes informations"
 +
gfsqw_InsertIndicators "tables informations"
 
lfsqw_Columns =>  
 
lfsqw_Columns =>  
 
lfsqw_GatherTables =>  
 
lfsqw_GatherTables =>  
 
lfsqw_Indexes =>  
 
lfsqw_Indexes =>  
 +
lfsqw_InsertColumnsDifferences
 +
lfsqw_InsertIndexesDifferences
 +
lfsqw_InsertIndexesTemp
 +
lfsqw_InsertIndexesTemp =>
 +
lfsqw_InsertStructureOk "columns"
 +
lfsqw_InsertStructureOk "indexes"
 +
lfsqw_InsertStructureOk "tables"
 +
lfsqw_InsertTablesDifferences
 
lfsqw_PrepareColumnsDifferences
 
lfsqw_PrepareColumnsDifferences
 
lfsqw_PrepareIndexesDifferences
 
lfsqw_PrepareIndexesDifferences
lfsqw_PrepareTablesDifferences >$gvsqw_TmpFile.isOK
+
lfsqw_PrepareTablesDifferences
 
lfsqw_Tables =>  
 
lfsqw_Tables =>  
 
</pre>
 
</pre>

Version actuelle datée du 11 février 2023 à 10:30

librairies de fonctions shell $gvsqw_PgBin/../lib/sqwpg_GatherStructure.lib:
lib for sqwpg_GatherStructure.ksh
Explication des fonctions:

gfsqw_BeginningCom
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "columns informations"
gfsqw_InsertIndicators "indexes '%ccnew%' or '%ccold%'"
gfsqw_InsertIndicators "indexes informations"
gfsqw_InsertIndicators "tables informations"
lfsqw_Columns => 
lfsqw_GatherTables => 
lfsqw_Indexes => 
lfsqw_InsertColumnsDifferences
lfsqw_InsertIndexesDifferences
lfsqw_InsertIndexesTemp
lfsqw_InsertIndexesTemp => 
lfsqw_InsertStructureOk "columns"
lfsqw_InsertStructureOk "indexes"
lfsqw_InsertStructureOk "tables"
lfsqw_InsertTablesDifferences
lfsqw_PrepareColumnsDifferences
lfsqw_PrepareIndexesDifferences
lfsqw_PrepareTablesDifferences
lfsqw_Tables => 


Information.png
Information:
Vous pouvez surcharger les fonctions contenues dans $gvsqw_PgBin/../lib/sqwpg_GatherStructure.lib

en redeclarant une fonction du meme nom $gvsqw_PgBin/../lib_cust/sqwpg_GatherStructure.lib pour tous les environnements
ou dans $HOME/sqwConfig/sqwpg_GatherStructure.lib specifiquement pour ce user .