SQWareProduction:postgres:lib:sqwpg GatherStructure.lib: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
 
m Updated by BatchUser
Line 5: Line 5:
<pre>
<pre>
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "columns informations"
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_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>

Revision as of 19:34, 8 March 2020

shell functions library $gvsqw_PgBin/../lib/sqwpg_GatherStructure.lib:
lib for sqwpg_GatherStructure.ksh
Functions explanation:

gfsqw_GenListDatabase > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "columns informations"
gfsqw_InsertIndicators "indexes informations"
gfsqw_InsertIndicators "tables informations"
lfsqw_Columns => 
lfsqw_GatherTables => 
lfsqw_Indexes => 
lfsqw_InsertColumnsDifferences
lfsqw_InsertIndexesDifferences
lfsqw_InsertStructureOk "columns"
lfsqw_InsertStructureOk "indexes"
lfsqw_InsertStructureOk "tables"
lfsqw_InsertTablesDifferences
lfsqw_PrepareColumnsDifferences
lfsqw_PrepareIndexesDifferences
lfsqw_PrepareTablesDifferences
lfsqw_Tables => 


Note:
You can overload functions contained in $gvsqw_PgBin/../lib/sqwpg_GatherStructure.lib

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