/// <summary>
/// Generate CSharp property for every database field.
/// </summary>
private static void FieldNameProperty(MetaCSharp metaCSharp, string schemaName, string tableName, StringBuilder result)
{
var fieldNameList = metaCSharp.List.Where(item => item.Schema.SchemaName == schemaName && item.Schema.TableName == tableName).ToArray();
bool isFirst = true;
foreach (var item in fieldNameList)
{
if (isFirst)
{
isFirst = false;
}
else
{
result.AppendLine();
}
if (item.FrameworkTypeEnum == FrameworkTypeEnum.None)
{
UtilCli.ConsoleWriteLineColor(string.Format("Warning! Type not supported by framework. ({0}.{1}.{2})", item.Schema.SchemaName, item.Schema.TableName, item.Schema.FieldName), ConsoleColor.Yellow);
}
else
{
string typeCSharp = UtilGenerate.SqlTypeToCSharpType(item.Schema.SqlType, item.Schema.IsNullable);
if (item.IsPrimaryKey == false)
{
result.AppendLine(string.Format(" [SqlField(\"{0}\", {2})]", item.Schema.FieldName, item.TableNameCSharp + "_" + item.FieldNameCSharp, nameof(FrameworkTypeEnum) + "." + item.FrameworkTypeEnum.ToString()));
}
else
{
result.AppendLine(string.Format(" [SqlField(\"{0}\", {2}, {3})]", item.Schema.FieldName, item.TableNameCSharp + "_" + item.FieldNameCSharp, item.IsPrimaryKey.ToString().ToLower(), nameof(FrameworkTypeEnum) + "." + item.FrameworkTypeEnum.ToString()));
}
result.AppendLine(string.Format(" public " + typeCSharp + " {0} {{ get; set; }}", item.FieldNameCSharp));
}
}
}
/// <summary>
/// Generate CSharp class for every database table.
/// </summary>
private static void TableNameClass(MetaCSharp metaCSharp, string schemaName, StringBuilder result)
{
var tableNameList = metaCSharp.List.Where(item => item.Schema.SchemaName == schemaName).GroupBy(item => new { item.Schema.SchemaName, item.Schema.TableName, item.TableNameCSharp }, (key, group) => key).ToArray();
List <string> nameExceptList = new List <string>();
bool isFirst = true;
foreach (var item in tableNameList)
{
if (isFirst)
{
isFirst = false;
}
else
{
result.AppendLine();
}
result.AppendLine(string.Format(" [SqlTable(\"{0}\", \"{1}\")]", item.SchemaName, item.TableName));
result.AppendLine(string.Format(" public class {0} : Row", item.TableNameCSharp));
result.AppendLine(" {");
FieldNameProperty(metaCSharp, schemaName, item.TableName, result);
result.AppendLine(" }");
// result.AppendLine();
// FieldNameClass(metaCSharp, schemaName, item.TableName, result);
}
}
/// <summary>
/// Script to generate CSharp code. Returns true, if succsesful.
/// </summary>
/// <param name="isFrameworkDb">If true, generate CSharp code for Framework library (internal use only) otherwise generate code for Application.</param>
public static bool Run(bool isFrameworkDb, AppCli appCli)
{
bool isSuccessful = true;
MetaSql metaSql = new MetaSql(isFrameworkDb, appCli);
MetaCSharp metaCSharp = new MetaCSharp(metaSql);
// Generate CSharp classes from database schema and save (*.cs) files.
new CSharpGenerate(metaCSharp).Run(isFrameworkDb, out string cSharp);
if (isFrameworkDb == false)
{
UtilFramework.FileSave(UtilFramework.FolderName + "Application.Database/Database/Database.cs", cSharp);
}
else
{
UtilFramework.FileSave(UtilFramework.FolderName + "Framework/Framework/Database/Database.cs", cSharp);
}
UtilCli.ConsoleWriteLineColor("Generate CSharp classes from database schema and write (*.cs) files succsesful!", ConsoleColor.Green);
// Read Integrate data from database and save (*.cs) files.
GenerateIntegrateResult generateIntegrateResult = null;
try
{
generateIntegrateResult = appCli.CommandGenerateIntegrateInternal();
}
catch (SqlException exception)
{
isSuccessful = false;
string message = string.Format("Read Integrate data from database failed! This can happen after an sql schema change. Try to run generate script again! ({0})", exception.Message);
UtilCli.ConsoleWriteLineColor(message, ConsoleColor.Red);
}
if (generateIntegrateResult != null)
{
Run(generateIntegrateResult);
new GenerateCSharpIntegrate().Run(out string cSharpCli, isFrameworkDb, isApplication: false, integrateList: generateIntegrateResult.Result);
new GenerateCSharpIntegrate().Run(out string cSharpApplication, isFrameworkDb, isApplication: true, integrateList: generateIntegrateResult.Result);
if (isFrameworkDb == false)
{
UtilFramework.FileSave(UtilFramework.FolderName + "Application.Cli/Database/DatabaseIntegrate.cs", cSharpCli);
UtilFramework.FileSave(UtilFramework.FolderName + "Application.Database/Database/DatabaseIntegrate.cs", cSharpApplication);
}
else
{
UtilFramework.FileSave(UtilFramework.FolderName + "Framework/Framework.Cli/Database/DatabaseIntegrate.cs", cSharpCli);
UtilFramework.FileSave(UtilFramework.FolderName + "Framework/Framework/Database/DatabaseIntegrate.cs", cSharpApplication);
}
UtilCli.ConsoleWriteLineColor("Generate CSharp code for Integrate data and write to (*.cs) files successful!", ConsoleColor.Green);
}
return(isSuccessful);
}
/// <summary>
/// Generate CSharp class for every database field.
/// </summary>
private static void FieldNameClass(MetaCSharp metaCSharp, string schemaName, string tableName, StringBuilder result)
{
var fieldNameList = metaCSharp.List.Where(item => item.Schema.SchemaName == schemaName && item.Schema.TableName == tableName).ToArray();
bool isFirst = true;
foreach (var item in fieldNameList)
{
if (isFirst)
{
isFirst = false;
}
else
{
result.AppendLine();
}
result.AppendLine(" public class " + item.TableNameCSharp + "_" + item.FieldNameCSharp + " : Cell<" + item.TableNameCSharp + "> { }");
}
}
/// <summary>
/// Generate CSharp namespace for every database schema.
/// </summary>
private static void SchemaName(bool isFrameworkDb, MetaCSharp metaCSharp, StringBuilder result)
{
var schemaNameList = metaCSharp.List.GroupBy(item => new { item.Schema.SchemaName, item.SchemaNameCSharp }, (key, group) => key).ToArray();
bool isFirst = true;
foreach (var item in schemaNameList)
{
if (isFirst)
{
isFirst = false;
}
else
{
result.AppendLine();
}
result.AppendLine(string.Format("namespace Database.{0}", item.SchemaNameCSharp));
result.AppendLine("{");
result.AppendLine(" using Framework.DataAccessLayer;");
result.AppendLine(" using System;");
result.AppendLine();
TableNameClass(metaCSharp, item.SchemaName, result);
result.AppendLine("}");
}
}
/// <summary>
/// Script to generate CSharp code. Returns true, if succsesful.
/// </summary>
/// <param name="isFrameworkDb">If true, generate CSharp code for Framework library (internal use only) otherwise generate code for Application.</param>
public static bool Run(bool isFrameworkDb, AppCli appCli)
{
bool isSuccessful = true;
MetaSql metaSql = new MetaSql(isFrameworkDb);
// Custom sql table and field filtering for code generation.
var list = metaSql.List;
var typeRowCalculatedList = new List <Type>(); // Calculated row.
if (isFrameworkDb == false)
{
// Call method CommandGenerateFilter();
Run(ref list, ref typeRowCalculatedList, appCli);
}
MetaCSharp metaCSharp = new MetaCSharp(list);
// Generate CSharp classes from database schema and save (*.cs) files.
UtilCli.ConsoleWriteLineColor("Generate CSharp classes from database schema and write (*.cs) files", ConsoleColor.Green);
new CSharpGenerate(metaCSharp).Run(isFrameworkDb, out string cSharp);
if (isFrameworkDb == false)
{
UtilFramework.FileSave(UtilFramework.FolderName + "Application.Database/Database/Database.cs", cSharp);
}
else
{
UtilFramework.FileSave(UtilFramework.FolderName + "Framework/Framework/Database/Database.cs", cSharp);
}
UtilCli.ConsoleWriteLineColor("Generate CSharp classes from database schema and write (*.cs) files succsesful!", ConsoleColor.Green);
// Read Integrate data from database and save (*.cs) files.
UtilCli.ConsoleWriteLineColor("Generate CSharp code for Integrate data and write to (*.cs) files", ConsoleColor.Green);
GenerateIntegrateResult generateIntegrateResult = null;
try
{
// TableNameCSharp defined in method AppCli.CommandGenerateFilter();
List <string> tableNameCSharpApplicationFilterList = null;
if (isFrameworkDb == false)
{
tableNameCSharpApplicationFilterList = metaCSharp.List.GroupBy(item => item.SchemaNameCSharp + "." + item.TableNameCSharp).Select(item => item.Key).ToList();
var tableNameCSharpCalculatedList = typeRowCalculatedList.Select(item => UtilDalType.TypeRowToTableNameCSharp(item)).ToList();
tableNameCSharpApplicationFilterList.AddRange(tableNameCSharpCalculatedList);
}
generateIntegrateResult = appCli.CommandGenerateIntegrateInternal(isDeployDb: false, tableNameCSharpApplicationFilterList);
}
catch (SqlException exception)
{
isSuccessful = false;
string message = string.Format("Read Integrate data from database failed! This can happen after an sql schema change. Try to run generate script again! ({0})", exception.Message);
UtilCli.ConsoleWriteLineColor(message, ConsoleColor.Red);
}
if (generateIntegrateResult != null)
{
Run(generateIntegrateResult);
new GenerateCSharpIntegrate().Run(out string cSharpCli, isFrameworkDb, isApplication: false, integrateList: generateIntegrateResult.Result);
new GenerateCSharpIntegrate().Run(out string cSharpApplication, isFrameworkDb, isApplication: true, integrateList: generateIntegrateResult.Result);
if (isFrameworkDb == false)
{
UtilFramework.FileSave(UtilFramework.FolderName + "Application.Cli/Database/DatabaseIntegrate.cs", cSharpCli);
UtilFramework.FileSave(UtilFramework.FolderName + "Application.Database/Database/DatabaseIntegrate.cs", cSharpApplication);
}
else
{
UtilFramework.FileSave(UtilFramework.FolderName + "Framework/Framework.Cli/Database/DatabaseIntegrate.cs", cSharpCli);
UtilFramework.FileSave(UtilFramework.FolderName + "Framework/Framework/Database/DatabaseIntegrate.cs", cSharpApplication);
}
UtilCli.ConsoleWriteLineColor("Generate CSharp code for Integrate data and write to (*.cs) files successful!", ConsoleColor.Green);
}
return(isSuccessful);
}
public CSharpGenerate(MetaCSharp metaCSharp)
{
this.MetaCSharp = metaCSharp;
}