SQWareProduction:mssql:lib:sqwmsq GatherStructure.lib : Différence entre versions
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_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile. | + | gfsqw_BeginningCom |
| + | gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst_db | ||
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 | gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 | ||
gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 | gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 | ||
| + | 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 | + | lfsqw_PrepareTablesDifferences |
lfsqw_Tables => | lfsqw_Tables => | ||
</pre> | </pre> | ||
Version actuelle datée du 14 janvier 2023 à 20:30
librairies de fonctions shell $gvsqw_MsqBin/../lib/sqwmsq_GatherStructure.lib:
lib for sqwmsq_GatherStructure.ksh
Explication des fonctions:
gfsqw_BeginningCom gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst_db gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 gfsqw_GenericExecFisql $gvsqw_TmpFile.sql 2>&1 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 =>
