/// <summary>
/// Console log Integrate table relation.
/// </summary>
private static void Run(GenerateIntegrateResult generateIntegrateResult)
{
bool isFirst = true;
List <string> result = new List <string>();
foreach (var item in generateIntegrateResult.Result)
{
var fieldList = UtilDalUpsertIntegrate.FieldIntegrateList(item.TypeRow, generateIntegrateResult.ResultReference);
foreach (var field in fieldList)
{
if (field.IsId)
{
UtilDalType.TypeRowToTableNameSql(item.TypeRow, out string schemaNameSql, out string tableNameSql);
UtilDalType.TypeRowToTableNameSql(field.TypeRowReference, out string schemaNameSqlReference, out string tableNameSqlReference);
if (isFirst)
{
isFirst = false;
Console.WriteLine("Integrate Table Relation");
}
result.Add(string.Format("[{0}].[{1}].[{2}] --> [{3}].[{4}]", schemaNameSql, tableNameSql, field.FieldNameIdSql, schemaNameSqlReference, tableNameSqlReference));
}
}
}
foreach (var item in result.Distinct().OrderBy(item => item))
{
Console.WriteLine(item);
}
}
/// <summary>
/// Populate sql Integrate tables.
/// </summary>
private void Integrate()
{
var generateIntegrateResult = AppCli.CommandGenerateIntegrateInternal();
var deployDbResult = new DeployDbIntegrateResult(generateIntegrateResult);
List <Assembly> assemblyList = AppCli.AssemblyList(isIncludeApp: true, isIncludeFrameworkCli: true);
// Populate sql tables FrameworkTable, FrameworkField.
UtilCli.ConsoleWriteLineColor("Update FrameworkTable, FrameworkField tables", ConsoleColor.Green);
Meta(deployDbResult);
UtilDalUpsertIntegrate.UpsertAsync(deployDbResult.Result, assemblyList).Wait();
// Populate sql Integrate tables.
UtilCli.ConsoleWriteLineColor("Update Integrate tables", ConsoleColor.Green);
AppCli.CommandDeployDbIntegrateInternal(deployDbResult);
UtilDalUpsertIntegrate.UpsertAsync(deployDbResult.Result, assemblyList).Wait();
}
/// <summary>
/// Populate sql Integrate tables.
/// </summary>
private void Integrate(int?reseed)
{
var generateIntegrateResult = AppCli.CommandGenerateIntegrateInternal(isDeployDb: true, null);
var deployDbResult = new DeployDbIntegrateResult(generateIntegrateResult);
List <Assembly> assemblyList = AppCli.AssemblyList(isIncludeApp: true, isIncludeFrameworkCli: true);
// Populate sql tables FrameworkTable, FrameworkField.
UtilCli.ConsoleWriteLineColor("Update FrameworkTable, FrameworkField tables", ConsoleColor.Green);
Meta(deployDbResult);
IntegrateReseed(deployDbResult.Result, reseed, assemblyList);
UtilDalUpsertIntegrate.UpsertAsync(deployDbResult.Result, assemblyList).Wait();
// Populate sql Integrate tables.
UtilCli.ConsoleWriteLineColor("Update Integrate tables ", ConsoleColor.Green, isLine: false);
AppCli.CommandDeployDbIntegrateInternal(deployDbResult);
IntegrateReseed(deployDbResult.Result, reseed, assemblyList);
UtilDalUpsertIntegrate.UpsertAsync(deployDbResult.Result, assemblyList, (typeRow) => UtilCli.ConsoleWriteLineColor(".", ConsoleColor.Green, isLine: false)).Wait(); // See also property IsDeploy
Console.WriteLine();
}
