/// <summary>
/// Cli generate command.
/// </summary>
protected override void CommandGenerateIntegrate(GenerateIntegrateResult result)
{
// Navigate
result.Add(Data.Query <NavigateIntegrate>().OrderBy(item => item.IdName));
result.AddKey <Navigate>(nameof(Navigate.Name));
result.AddReference <Navigate, Navigate>(nameof(Navigate.ParentId));
// LoginUser
result.Add(Data.Query <LoginUserIntegrate>().Where(item => item.IsIntegrate == true).OrderBy(item => item.IdName), isApplication: true);
result.AddKey <LoginUser>(nameof(LoginUser.Name));
// LoginRole
result.Add(Data.Query <LoginRoleIntegrate>().OrderBy(item => item.IdName), isApplication: true);
result.AddKey <LoginRole>(nameof(LoginRole.Name));
// LoginUserRole
result.Add(Data.Query <LoginUserRoleIntegrate>().Where(item => item.LoginUserIsIntegrate == true).OrderBy(item => item.LoginUserIdName).ThenBy(item => item.LoginRoleIdName));
result.AddKey <LoginUserRole>(nameof(LoginUserRole.LoginUserId), nameof(LoginUserRole.LoginRoleId));
result.AddReference <LoginUserRole, LoginUser>(nameof(LoginUserRole.LoginUserId));
result.AddReference <LoginUserRole, LoginRole>(nameof(LoginUserRole.LoginRoleId));
// NavigateLoginRole
result.Add(Data.Query <NavigateRoleIntegrate>().OrderBy(item => item.NavigateIdName).ThenBy(item => item.LoginRoleIdName));
result.AddKey <NavigateRole>(nameof(NavigateRole.NavigateId), nameof(NavigateRole.LoginRoleId));
result.AddReference <NavigateRole, Navigate>(nameof(NavigateRole.NavigateId));
result.AddReference <NavigateRole, LoginRole>(nameof(NavigateRole.LoginRoleId));
// StorageFile
result.Add(Data.Query <StorageFileIntegrate>().OrderBy(item => item.IdName));
result.AddKey <StorageFile>(nameof(StorageFile.FileName));
result.AddBlob <StorageFileIntegrate>(nameof(StorageFile.Data), (row) => row.FileName);
// Content
result.Add(Data.Query <ContentIntegrate>().OrderBy(item => item.IdName));
result.AddKey <Content>(nameof(Content.Name));
result.AddBlob <ContentIntegrate>(nameof(Content.TextMd), (row) => row.IdName + ".md");
result.AddBlob <ContentIntegrate>(nameof(Content.TextHtml), (row) => row.IdName + ".html");
// Feedback
result.Add(Data.Query <Feedback>().OrderBy(item => item.Name));
result.AddKey <Feedback>(nameof(Feedback.Name));
result.AddBlob <Feedback>(nameof(Feedback.AttachmentData), (row) => row.Name + "." + row.AttachmentFileName);
}
/// <summary>
/// Returns Integrate rows to generate CSharp code.
/// </summary>
/// <param name="isDeployDb">Method is called from command cli generate or cli deployDb.</param>
/// <param name="tableNameCSharpApplicationFilterList">TableNameCSharp defined in method AppCli.CommandGenerateFilter();</param>
internal GenerateIntegrateResult CommandGenerateIntegrateInternal(bool isDeployDb, List <string> tableNameCSharpApplicationFilterList)
{
var result = new GenerateIntegrateResult(AssemblyList(true, true));
result.AddKey <FrameworkTable>(nameof(FrameworkTable.TableNameCSharp));
// Do not generate CSharp code for table FrameworkTable and FrameworkField. Add reference for deoplyDb.
result.AddKey <FrameworkField>(nameof(FrameworkField.TableId), nameof(FrameworkField.FieldNameCSharp));
result.AddReference <FrameworkField, FrameworkTable>(nameof(FrameworkFieldIntegrate.TableId));
var tableNameCSharpFrameworkList = UtilDalType.TableNameCSharpList(AssemblyFramework); // TableNameCSharp declared in Framework assembly.
var tableNameCSharpApplicationList = UtilDalType.TableNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase); // TableNameCSharp declared in Application assembly.
var fieldNameCSharpFrameworkList = UtilDalType.FieldNameCSharpList(AssemblyFramework); // FieldNameCSharp declared in Framework assembly
var fieldNameCSharpApplicationList = UtilDalType.FieldNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase); // FieldNameCSharp declared in Framework assembly
// Filter out tables defined in method AppCli.CommandGenerateFilter();
if (tableNameCSharpApplicationFilterList != null)
{
tableNameCSharpApplicationList = tableNameCSharpApplicationList.Where(item => tableNameCSharpApplicationFilterList.Contains(item.Value)).ToDictionary(item => item.Key, item => item.Value);
fieldNameCSharpApplicationList = fieldNameCSharpApplicationList.Where(item => tableNameCSharpApplicationFilterList.Contains(item.TableNameCSharp)).ToList();
}
// Prevent build error "An expression tree may not contain a tuple literal".
var fieldNameCSharpFrameworkNoTupleList = fieldNameCSharpFrameworkList.Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp);
var fieldNameCSharpApplicationNoTupleList = fieldNameCSharpApplicationList.Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp);
// FrameworkConfigGridIntegrate
{
var rowList = Data.Query <FrameworkConfigGridIntegrate>();
// Framework (.\cli.cmd generate -f)
{
var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter Framework.
rowFilterList = rowFilterList.OrderBy(item => item.IdName);
result.Add(
isFrameworkDb: true,
isApplication: false,
typeRow: typeof(FrameworkConfigGridIntegrate),
query: rowFilterList
);
}
// Application (.\cli.cmd generate)
{
var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application).
rowFilterList = rowFilterList.OrderBy(item => item.IdName);
result.Add(
isFrameworkDb: false,
isApplication: false,
typeRow: typeof(FrameworkConfigGridIntegrate),
query: rowFilterList
);
}
result.AddKey <FrameworkConfigGrid>(nameof(FrameworkConfigGrid.TableId), nameof(FrameworkConfigGrid.ConfigName));
result.AddReference <FrameworkConfigGrid, FrameworkTable>(nameof(FrameworkConfigGrid.TableId));
}
// FrameworkConfigFieldIntegrate
{
var rowList = Data.Query <FrameworkConfigFieldIntegrate>();
// Framework (.\cli.cmd generate -f)
{
var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter FrameworkDb.
rowFilterList = rowList.Where(item => fieldNameCSharpFrameworkNoTupleList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Framework assembly.
rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName);
result.Add(
isFrameworkDb: true,
isApplication: false,
typeRow: typeof(FrameworkConfigFieldIntegrate),
query: rowFilterList
);
}
// Application (.\cli.cmd generate)
{
var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application).
rowFilterList = rowList.Where(item => fieldNameCSharpApplicationNoTupleList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Application assembly.
rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName);
result.Add(
isFrameworkDb: false,
isApplication: false,
typeRow: typeof(FrameworkConfigFieldIntegrate),
query: rowFilterList
);
}
result.AddKey <FrameworkConfigField>(nameof(FrameworkConfigField.ConfigGridId), nameof(FrameworkConfigField.FieldId), nameof(FrameworkConfigField.InstanceName));
result.AddReference <FrameworkConfigField, FrameworkConfigGrid>(nameof(FrameworkConfigField.ConfigGridId));
result.AddReference <FrameworkConfigField, FrameworkField>(nameof(FrameworkConfigField.FieldId));
}
// Application (custom) Integrate data rows to generate CSharp code from.
CommandGenerateIntegrate(result);
// Call method CommandGenerateIntegrate(); on external AppCli for deployDb only. Not for cli generate command.
if (isDeployDb)
{
UtilExternal.CommandGenerateIntegrate(this, result);
}
return(result);
}
/// <summary>
/// Returns Integrate rows to generate CSharp code.
/// </summary>
internal GenerateIntegrateResult CommandGenerateIntegrateInternal()
{
var result = new GenerateIntegrateResult(AssemblyList(true, true));
result.AddKey <FrameworkTable>(nameof(FrameworkTable.TableNameCSharp));
// Do not generate CSharp code for table FrameworkTable and FrameworkField. Add reference for deoplyDb.
result.AddKey <FrameworkField>(nameof(FrameworkField.TableId), nameof(FrameworkField.FieldNameCSharp));
result.AddReference <FrameworkField, FrameworkTable>(nameof(FrameworkFieldIntegrate.TableId));
var tableNameCSharpFrameworkList = UtilDalType.TableNameCSharpList(AssemblyFramework); // TableNameCSharp declared in Framework assembly.
var tableNameCSharpApplicationList = UtilDalType.TableNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase); // TableNameCSharp declared in Application assembly.
var fieldNameCSharpFrameworkList = UtilDalType.FieldNameCSharpList(AssemblyFramework).Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp); // FieldNameCSharp declared in Framework assembly
var fieldNameCSharpApplicationList = UtilDalType.FieldNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase).Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp); // FieldNameCSharp declared in Framework assembly
// FrameworkConfigGridIntegrate
{
var rowList = Data.Query <FrameworkConfigGridIntegrate>();
// Framework (.\cli.cmd generate -f)
{
var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter Framework.
rowFilterList = rowFilterList.OrderBy(item => item.IdName);
result.Add(
isFrameworkDb: true,
isApplication: false,
typeRow: typeof(FrameworkConfigGridIntegrate),
query: rowFilterList
);
}
// Application (.\cli.cmd generate)
{
var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application).
rowFilterList = rowFilterList.OrderBy(item => item.IdName);
result.Add(
isFrameworkDb: false,
isApplication: false,
typeRow: typeof(FrameworkConfigGridIntegrate),
query: rowFilterList
);
}
result.AddKey <FrameworkConfigGrid>(nameof(FrameworkConfigGrid.TableId), nameof(FrameworkConfigGrid.ConfigName));
result.AddReference <FrameworkConfigGrid, FrameworkTable>(nameof(FrameworkConfigGrid.TableId));
}
// FrameworkConfigFieldIntegrate
{
var rowList = Data.Query <FrameworkConfigFieldIntegrate>();
// Framework (.\cli.cmd generate -f)
{
var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter FrameworkDb.
rowFilterList = rowList.Where(item => fieldNameCSharpFrameworkList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Framework assembly.
rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName);
result.Add(
isFrameworkDb: true,
isApplication: false,
typeRow: typeof(FrameworkConfigFieldIntegrate),
query: rowFilterList
);
}
// Application (.\cli.cmd generate)
{
var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application).
rowFilterList = rowList.Where(item => fieldNameCSharpApplicationList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Application assembly.
rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName);
result.Add(
isFrameworkDb: false,
isApplication: false,
typeRow: typeof(FrameworkConfigFieldIntegrate),
query: rowFilterList
);
}
result.AddKey <FrameworkConfigField>(nameof(FrameworkConfigField.ConfigGridId), nameof(FrameworkConfigField.FieldId), nameof(FrameworkConfigField.InstanceName));
result.AddReference <FrameworkConfigField, FrameworkConfigGrid>(nameof(FrameworkConfigField.ConfigGridId));
result.AddReference <FrameworkConfigField, FrameworkField>(nameof(FrameworkConfigField.FieldId));
}
// Application (custom) Integrate data rows to generate CSharp code from.
CommandGenerateIntegrate(result);
return(result);
}
