SQWareProduction:postgres:lib:sqwpg GatherStructure.lib : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Ligne 7 : | Ligne 7 : | ||
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst | gfsqw_GenListDatabase > $gvsqw_TmpFile.lst | ||
gfsqw_InsertIndicators "columns informations" | gfsqw_InsertIndicators "columns informations" | ||
+ | gfsqw_InsertIndicators "indexes '%ccnew%' or '%ccold%'" | ||
gfsqw_InsertIndicators "indexes informations" | gfsqw_InsertIndicators "indexes informations" | ||
gfsqw_InsertIndicators "tables informations" | gfsqw_InsertIndicators "tables informations" | ||
Ligne 14 : | Ligne 15 : | ||
lfsqw_InsertColumnsDifferences | lfsqw_InsertColumnsDifferences | ||
lfsqw_InsertIndexesDifferences | lfsqw_InsertIndexesDifferences | ||
+ | lfsqw_InsertIndexesTemp | ||
+ | lfsqw_InsertIndexesTemp => | ||
lfsqw_InsertStructureOk "columns" | lfsqw_InsertStructureOk "columns" | ||
lfsqw_InsertStructureOk "indexes" | lfsqw_InsertStructureOk "indexes" |
Version actuelle datée du 11 février 2023 à 09: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 =>