public static EntityModel GenerateModel(IDbConnection connection, string tableSchema, string table,
string module, string connectionKey, string entityClass, string permission, GeneratorConfig config)
{
var model = new EntityModel();
model.Module = module;
if (connection.GetDialect().ServerType.StartsWith("MySql", StringComparison.OrdinalIgnoreCase))
{
model.Schema = null;
}
else
{
model.Schema = tableSchema;
}
model.Permission = permission;
model.ConnectionKey = connectionKey;
model.RootNamespace = config.RootNamespace;
var className = entityClass ?? ClassNameFromTableName(table);
model.ClassName = className;
model.RowClassName = className + "Row";
model.Title = Inflector.Inflector.Titleize(className);
model.Tablename = table;
model.Fields = new List <EntityField>();
model.Joins = new List <EntityJoin>();
model.Instance = true;
var schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType);
var fields = schemaProvider.GetFieldInfos(connection, tableSchema, table).ToList();
if (!fields.Any(x => x.IsPrimaryKey))
{
var primaryKeys = new HashSet <string>(schemaProvider.GetPrimaryKeyFields(connection, tableSchema, table));
foreach (var field in fields)
{
field.IsPrimaryKey = primaryKeys.Contains(field.FieldName);
}
}
if (!fields.Any(x => x.IsIdentity))
{
var identities = new HashSet <string>(schemaProvider.GetIdentityFields(connection, tableSchema, table));
foreach (var field in fields)
{
field.IsIdentity = identities.Contains(field.FieldName);
}
}
var foreigns = schemaProvider.GetForeignKeys(connection, tableSchema, table)
.ToLookup(x => x.FKName)
.Where(x => x.Count() == 1)
.SelectMany(x => x)
.ToList();
foreach (var field in fields)
{
var fk = foreigns.FirstOrDefault(x => x.FKColumn == field.FieldName);
if (fk != null)
{
field.PKSchema = fk.PKSchema;
field.PKTable = fk.PKTable;
field.PKColumn = fk.PKColumn;
}
}
var prefix = DeterminePrefixLength(fields, x => x.FieldName);
model.FieldPrefix = fields.First().FieldName.Substring(0, prefix);
var identity = fields.FirstOrDefault(f => f.IsIdentity == true);
if (identity == null)
{
identity = fields.FirstOrDefault(f => f.IsPrimaryKey == true);
}
if (identity != null)
{
model.Identity = GenerateVariableName(identity.FieldName.Substring(prefix));
}
else
{
identity = fields.FirstOrDefault(f => f.IsPrimaryKey == true) ??
fields.FirstOrDefault();
if (identity != null)
{
model.Identity = GenerateVariableName(identity.FieldName.Substring(prefix));
}
}
string baseRowMatch = null;
HashSet <string> baseRowFieldset = null;
List <string> baseRowFieldList = new List <string>();
foreach (var k in config.BaseRowClasses ?? new List <GeneratorConfig.BaseRowClass>())
{
var b = k.ClassName;
var f = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
var fl = new List <string>();
bool skip = false;
foreach (var s in k.Fields ?? new List <string>())
{
string n = s.TrimToNull();
if (n == null || !fields.Any(z => z.FieldName.Substring(prefix) == n))
{
skip = true;
break;
}
f.Add(n);
fl.Add(n);
}
if (skip)
{
continue;
}
if (baseRowFieldset == null || f.Count > baseRowFieldset.Count)
{
baseRowFieldset = f;
baseRowFieldList = fl;
baseRowMatch = b;
}
}
var removeForeignFields = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
foreach (var s in config.RemoveForeignFields ?? new List <string>())
{
string n = s.TrimToNull();
if (n != null)
{
removeForeignFields.Add(n);
}
}
if (baseRowFieldset != null &&
baseRowFieldset.Count > 0)
{
model.RowBaseClass = baseRowMatch;
model.FieldsBaseClass = baseRowMatch + "Fields";
model.RowBaseFields = new List <EntityField>();
fields = fields.Where(f =>
{
if (baseRowFieldset.Contains(f.FieldName.Substring(prefix)))
{
var ef = ToEntityField(f, prefix);
ef.Flags = null;
model.RowBaseFields.Add(ef);
return(false);
}
return(true);
}).ToList();
}
else
{
model.RowBaseClass = "Row";
model.RowBaseFields = new List <EntityField>();
model.FieldsBaseClass = "RowFieldsBase";
}
var fieldByIdent = new Dictionary <string, EntityField>(StringComparer.OrdinalIgnoreCase);
foreach (var field in fields)
{
var f = ToEntityField(field, prefix);
if (f.Ident == model.IdField)
{
f.ColAttributes = "EditLink, DisplayName(\"Db.Shared.RecordId\"), AlignRight";
}
int i = 0;
string ident = f.Ident;
while (fieldByIdent.ContainsKey(ident))
{
ident = f.Ident + ++i;
}
f.Ident = ident;
fieldByIdent[ident] = f;
if (f.Name == className && f.FieldType == "String")
{
model.NameField = f.Name;
f.ColAttributes = f.ColAttributes ?? "EditLink";
}
var foreign = foreigns.Find((k) => k.FKColumn.Equals(field.FieldName, StringComparison.OrdinalIgnoreCase));
if (foreign != null)
{
if (f.Title.EndsWith(" Id") && f.Title.Length > 3)
{
f.Title = f.Title.SafeSubstring(0, f.Title.Length - 3);
}
f.PKSchema = foreign.PKSchema;
f.PKTable = foreign.PKTable;
f.PKColumn = foreign.PKColumn;
var frgfld = schemaProvider.GetFieldInfos(connection, foreign.PKSchema, foreign.PKTable).ToList();
int frgPrefix = RowGenerator.DeterminePrefixLength(frgfld, z => z.FieldName);
var j = new EntityJoin();
j.Fields = new List <EntityField>();
j.Name = GenerateVariableName(f.Name.Substring(prefix));
if (j.Name.EndsWith("Id") || j.Name.EndsWith("ID"))
{
j.Name = j.Name.Substring(0, j.Name.Length - 2);
}
f.ForeignJoinAlias = j.Name;
j.SourceField = f.Ident;
frgfld = frgfld.Where(y => !removeForeignFields.Contains(y.FieldName)).ToList();
foreach (var frg in frgfld)
{
if (frg.FieldName.Equals(foreign.PKColumn, StringComparison.OrdinalIgnoreCase))
{
continue;
}
var k = ToEntityField(frg, frgPrefix);
k.Flags = null;
k.Title = Inflector.Inflector.Titleize(JU(j.Name, frg.FieldName.Substring(frgPrefix)));
k.Ident = JI(j.Name, k.Ident);
i = 0;
ident = k.Ident;
while (fieldByIdent.ContainsKey(ident))
{
ident = k.Ident + ++i;
}
k.Ident = ident;
fieldByIdent[ident] = k;
var atk = new List <string>();
atk.Add("DisplayName(\"" + k.Title + "\")");
k.Expression = "j" + j.Name + ".[" + k.Name + "]";
atk.Add("Expression(\"" + k.Expression + "\")");
k.Attributes = String.Join(", ", atk);
if (f.TextualField == null && k.FieldType == "String")
{
f.TextualField = k.Ident;
}
j.Fields.Add(k);
}
model.Joins.Add(j);
}
model.Fields.Add(f);
}
if (model.NameField == null)
{
var fld = model.Fields.FirstOrDefault(z => z.FieldType == "String");
if (fld != null)
{
model.NameField = fld.Ident;
fld.ColAttributes = fld.ColAttributes ?? "EditLink";
}
}
foreach (var x in model.Fields)
{
var attrs = new List <string>();
attrs.Add("DisplayName(\"" + x.Title + "\")");
if (x.Ident != x.Name)
{
attrs.Add("Column(\"" + x.Name + "\")");
}
if ((x.Size ?? 0) > 0)
{
attrs.Add("Size(" + x.Size + ")");
}
if (x.Scale > 0)
{
attrs.Add("Scale(" + x.Scale + ")");
}
if (!String.IsNullOrEmpty(x.Flags))
{
attrs.Add(x.Flags);
}
if (!String.IsNullOrEmpty(x.PKTable))
{
attrs.Add("ForeignKey(\"" + (string.IsNullOrEmpty(x.PKSchema) ? x.PKTable : ("[" + x.PKSchema + "].[" + x.PKTable + "]")) + "\", \"" + x.PKColumn + "\")");
attrs.Add("LeftJoin(\"j" + x.ForeignJoinAlias + "\")");
}
if (model.NameField == x.Ident)
{
attrs.Add("QuickSearch");
}
if (x.TextualField != null)
{
attrs.Add("TextualField(\"" + x.TextualField + "\")");
}
x.Attributes = String.Join(", ", attrs.ToArray());
}
return(model);
}
private void ConnectionsCombo_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this._tables.Clear();
GenerateCodeButton.IsEnabled = false;
if (this.ConnectionsCombo.SelectedItem != null)
{
var conn = (GeneratorConfig.Connection) this.ConnectionsCombo.SelectedItem;
try
{
using (var connection = SqlConnections.New(conn.ConnectionString, conn.ProviderName))
{
connection.Open();
var schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType);
foreach (var t in schemaProvider.GetTableNames(connection))
{
var table = conn != null?conn.Tables.FirstOrDefault(x => x.Tablename == t.Tablename) : null;
var identifier = (table == null || table.Identifier.IsEmptyOrNull()) ?
RowGenerator.ClassNameFromTableName(t.Table) : table.Identifier;
var permission = table == null ? "Administration:General" : table.PermissionKey;
var connectionKey = (table != null && !table.ConnectionKey.IsEmptyOrNull()) ?
table.ConnectionKey : conn.Key;
var module = (table != null && table.Module != null) ? table.Module :
(Inflector.Inflector.Pascalize(connectionKey) ?? "").Replace(" ", "");
var tableItem = new TableItem
{
IsChecked = false,
ConnectionKey = conn.Key,
Module = module,
Identifier = identifier,
PermissionKey = permission,
FullName = t.Tablename
};
_tables.Add(tableItem);
tableItem.PropertyChanged += (s, e2) =>
{
var t2 = conn.Tables.FirstOrDefault(x => x.Tablename == tableItem.FullName);
if (t2 == null)
{
t2 = new GeneratorConfig.Table();
t2.Tablename = tableItem.FullName;
conn.Tables.Add(t2);
}
t2.Identifier = tableItem.Identifier;
t2.Module = tableItem.Module;
t2.ConnectionKey = tableItem.ConnectionKey;
t2.PermissionKey = tableItem.PermissionKey;
this.config.Save();
GenerateCodeButton.IsEnabled = _tables.Any(x => x.IsChecked);
};
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
public void Run(string projectJson, string[] args)
{
var projectDir = Path.GetDirectoryName(projectJson);
var outFile = args.FirstOrDefault(x => x.StartsWith("-o:"))?.Substring(3).TrimToNull();
var connectionKey = args.FirstOrDefault(x => x.StartsWith("-c:"))?.Substring(3).TrimToNull();
var table = args.FirstOrDefault(x => x.StartsWith("-t:"))?.Substring(3).TrimToNull();
var what = args.FirstOrDefault(x => x.StartsWith("-w:"))?.Substring(3).TrimToNull();
var module = args.FirstOrDefault(x => x.StartsWith("-m:"))?.Substring(3).TrimToNull();
var identifier = args.FirstOrDefault(x => x.StartsWith("-i:"))?.Substring(3).TrimToNull();
var permissionKey = args.FirstOrDefault(x => x.StartsWith("-p:"))?.Substring(3).TrimToNull();
if (identifier != null)
{
CodeFileHelper.Overwrite = true;
}
var config = GeneratorConfig.LoadFromFile(Path.Combine(projectDir, "sergen.json"));
var connectionKeys = config.Connections
.Where(x => !x.ConnectionString.IsEmptyOrNull())
.Select(x => x.Key).ToList();
var appSettingsFile = Path.Combine(projectDir, "appsettings.json");
AppSettingsFormat appSettings;
if (File.Exists(appSettingsFile))
{
appSettings = JSON.ParseTolerant <AppSettingsFormat>(File.ReadAllText(appSettingsFile).TrimToNull() ?? "{}");
}
else
{
appSettings = new AppSettingsFormat();
}
connectionKeys.AddRange(appSettings.Data.Keys);
var appSettingsFile2 = Path.Combine(projectDir, "appsettings.machine.json");
if (File.Exists(appSettingsFile2))
{
var appSettings2 = JSON.ParseTolerant <AppSettingsFormat>(File.ReadAllText(appSettingsFile2).TrimToNull() ?? "{}");
foreach (var pair in appSettings2.Data)
{
appSettings.Data[pair.Key] = pair.Value;
}
}
connectionKeys.AddRange(appSettings.Data.Keys);
connectionKeys = connectionKeys.Distinct(StringComparer.OrdinalIgnoreCase).OrderBy(x => x).ToList();
if (connectionKeys.Count == 0)
{
Console.Error.WriteLine("No connections in appsettings.json or sergen.json!");
Environment.Exit(1);
}
if (outFile == null && connectionKey == null)
{
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine("=== Table Code Generation ===");
Console.WriteLine("");
Console.ResetColor();
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Available Connections:");
Console.ResetColor();
foreach (var x in connectionKeys)
{
Console.WriteLine(x);
}
Console.ResetColor();
Console.WriteLine();
}
else if (connectionKey == null)
{
File.WriteAllText(outFile, JSON.Stringify(connectionKeys));
Environment.Exit(0);
}
string userInput = null;
if (outFile == null && connectionKey == null)
{
userInput = connectionKeys.Count == 1 ? connectionKeys[0] : null;
while (connectionKey == null ||
!connectionKeys.Contains(connectionKey, StringComparer.OrdinalIgnoreCase))
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Connection: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
connectionKey = Hinter.ReadHintedLine(connectionKeys, userInput: userInput);
userInput = connectionKey;
if (connectionKey == "!")
{
Console.ResetColor();
return;
}
}
}
userInput = connectionKey;
connectionKey = connectionKeys.Find(x => string.Compare(x, userInput, StringComparison.OrdinalIgnoreCase) == 0);
if (connectionKey == null)
{
Console.Error.WriteLine("Can't find connection with key: " + userInput + "!");
Environment.Exit(1);
}
if (outFile == null)
{
Console.ResetColor();
Console.WriteLine();
}
var dataConnection = appSettings.Data.ContainsKey(connectionKey) ?
appSettings.Data[connectionKey] : null;
var confConnection = config.Connections.FirstOrDefault(x =>
string.Compare(x.Key, connectionKey, StringComparison.OrdinalIgnoreCase) == 0);
var connectionString = dataConnection != null?dataConnection.ConnectionString.TrimToNull() : null;
if (connectionString == null && confConnection != null)
{
connectionString = confConnection.ConnectionString.TrimToNull();
}
var providerName = dataConnection != null?dataConnection.ProviderName.TrimToNull() : null;
if (providerName == null && confConnection != null)
{
providerName = confConnection.ProviderName.TrimToNull();
}
providerName = providerName ?? "System.Data.SqlClient";
DbProviderFactories.RegisterFactory("System.Data.SqlClient", SqlClientFactory.Instance);
DbProviderFactories.RegisterFactory("Microsoft.Data.Sqlite", Microsoft.Data.Sqlite.SqliteFactory.Instance);
DbProviderFactories.RegisterFactory("Npgsql", Npgsql.NpgsqlFactory.Instance);
DbProviderFactories.RegisterFactory("FirebirdSql.Data.FirebirdClient", FirebirdSql.Data.FirebirdClient.FirebirdClientFactory.Instance);
DbProviderFactories.RegisterFactory("MySql.Data.MySqlClient", MySql.Data.MySqlClient.MySqlClientFactory.Instance);
if (connectionString.IndexOf("../../..") >= 0)
{
connectionString = connectionString.Replace("../../..", Path.GetDirectoryName(projectJson));
}
else if (connectionString.IndexOf(@"..\..\..\") >= 0)
{
connectionString = connectionString.Replace(@"..\..\..\", Path.GetDirectoryName(projectJson));
}
ISchemaProvider schemaProvider;
List <TableName> tableNames;
using (var connection = SqlConnections.New(connectionString, providerName))
{
schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType);
tableNames = schemaProvider.GetTableNames(connection).ToList();
}
var tables = tableNames.Select(x => x.Tablename).ToList();
if (outFile == null && table == null)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Available Tables:");
Console.ResetColor();
foreach (var x in tables)
{
Console.WriteLine(x);
}
}
else if (table == null)
{
File.WriteAllText(outFile, JSON.Stringify(tableNames.Select(x =>
{
var xct = confConnection == null ? null : confConnection.Tables.FirstOrDefault(z => string.Compare(z.Tablename, table, StringComparison.OrdinalIgnoreCase) == 0);
return(new
{
name = x.Tablename,
module = xct == null || xct.Module.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(connectionKey) : xct.Module,
permission = xct == null || xct.PermissionKey.IsTrimmedEmpty() ? "Administration:General" : xct.PermissionKey,
identifier = xct == null || xct.Identifier.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(x.Table) : xct.Identifier,
});
})));
Environment.Exit(0);
}
userInput = tables.Count == 1 ? tables[0] : null;
if (userInput == null && schemaProvider.DefaultSchema != null &&
tables.Any(x => x.StartsWith(schemaProvider.DefaultSchema + ".")))
{
userInput = schemaProvider.DefaultSchema + ".";
}
if (outFile == null)
{
Console.WriteLine();
while (table == null ||
!tables.Contains(table, StringComparer.OrdinalIgnoreCase))
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
table = Hinter.ReadHintedLine(tables, userInput: userInput);
userInput = table;
if (table == "!")
{
Console.ResetColor();
return;
}
}
}
userInput = table;
var tableName = tableNames.First(x => string.Compare(x.Tablename, userInput, StringComparison.OrdinalIgnoreCase) == 0);
if (tableName == null)
{
Console.Error.WriteLine("Can't find table with name: " + userInput + "!");
Environment.Exit(1);
}
var confTable = confConnection == null ? null : confConnection.Tables.FirstOrDefault(x =>
string.Compare(x.Tablename, table, StringComparison.OrdinalIgnoreCase) == 0);
if (module == null)
{
userInput = confTable == null || confTable.Module.IsEmptyOrNull() ?
RowGenerator.ClassNameFromTableName(connectionKey) : confTable.Module;
Console.WriteLine();
while (module.IsTrimmedEmpty())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Module name for table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
module = Hinter.ReadHintedLine(new string[0], userInput: userInput);
userInput = module;
if (module == "!")
{
Console.ResetColor();
return;
}
}
}
if (identifier == null)
{
userInput = confTable == null || confTable.Identifier.IsEmptyOrNull() ?
RowGenerator.ClassNameFromTableName(tableName.Table) : confTable.Identifier;
Console.WriteLine();
while (identifier.IsTrimmedEmpty())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a class Identifier for table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
identifier = Hinter.ReadHintedLine(new string[0], userInput: userInput);
userInput = identifier;
if (identifier == "!")
{
Console.ResetColor();
return;
}
}
}
if (permissionKey == null)
{
userInput = confTable == null || confTable.PermissionKey.IsTrimmedEmpty() ?
"Administration:General" : confTable.PermissionKey;
Console.WriteLine();
while (permissionKey.IsTrimmedEmpty())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Permission Key for table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
permissionKey = Hinter.ReadHintedLine(new string[0], userInput: userInput);
userInput = permissionKey;
if (permissionKey == "!")
{
Console.ResetColor();
return;
}
}
}
if (what == null)
{
Console.WriteLine();
userInput = "RSU";
while (what.IsEmptyOrNull())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Choose What to Generate (R:Row, S:Repo+Svc, U=Cols+Form+Page+Grid+Dlg+Css)");
Console.ForegroundColor = ConsoleColor.Yellow;
what = Hinter.ReadHintedLine(new string[0], userInput: userInput);
userInput = what;
if (what == "!")
{
Console.ResetColor();
return;
}
}
}
config.GenerateRow = what.IndexOf("R", StringComparison.OrdinalIgnoreCase) >= 0;
config.GenerateService = what.IndexOf("S", StringComparison.OrdinalIgnoreCase) >= 0;
config.GenerateUI = what.IndexOf("U", StringComparison.OrdinalIgnoreCase) >= 0;
Console.ResetColor();
Console.WriteLine();
if (confConnection == null)
{
confConnection = new GeneratorConfig.Connection
{
Key = connectionKey
};
config.Connections.Add(confConnection);
}
if (confTable == null)
{
confTable = new GeneratorConfig.Table
{
Identifier = identifier,
Module = module,
PermissionKey = permissionKey,
Tablename = tableName.Tablename
};
confConnection.Tables.Add(confTable);
}
else
{
confTable.Identifier = identifier;
confTable.Module = module;
confTable.PermissionKey = permissionKey;
}
File.WriteAllText(Path.Combine(projectDir, "sergen.json"), config.SaveToJson());
using (var connection = SqlConnections.New(connectionString, providerName))
{
connection.Open();
var rowModel = RowGenerator.GenerateModel(connection, tableName.Schema, tableName.Table,
module, connectionKey, identifier, permissionKey, config);
new EntityCodeGenerator(rowModel, config, projectJson).Run();
}
}
public static EntityModel GenerateModel(IDbConnection connection, string tableSchema, string table,
string module, string connectionKey, string entityClass, string permission, GeneratorConfig config)
{
var model = new EntityModel();
model.Module = module;
if (connection.GetDialect().ServerType.StartsWith("MySql", StringComparison.OrdinalIgnoreCase))
{
model.Schema = null;
}
else
{
model.Schema = tableSchema;
}
model.Permission = permission;
model.ConnectionKey = connectionKey;
model.RootNamespace = config.RootNamespace;
var className = entityClass ?? ClassNameFromTableName(table);
model.ClassName = className;
model.RowClassName = className + "Row";
model.Title = Inflector.Inflector.Titleize(className);
model.Tablename = table;
model.Fields = new List <EntityField>();
model.Joins = new List <EntityJoin>();
model.Instance = true;
model.DialogAttributes = new DialogAttributes(); /*ROLEMBERG FILHO*/
model.DialogAttributes.Attrs01 = new List <string>(); /*ROLEMBERG FILHO*/
model.DialogAttributes.Attrs02 = new List <string>(); /*ROLEMBERG FILHO*/
model.DialogAttributes.Attrs03 = new List <string>(); /*ROLEMBERG FILHO*/
model.DialogAttributes.AttrsConstructor = new List <string>(); /*ROLEMBERG FILHO*/
model.DialogAttributes.AttrsValidacao = new List <string>(); /*ROLEMBERG FILHO*/
//model.DialogAttributes.AttrsConfirmSave = new List<string>(); /*ROLEMBERG FILHO*/
//model.DialogAttributes.Attrs03 = processAdvancedTips_Model(ref model); /*ROLEMBERG FILHO*/
processAdvancedTips_Model(ref model); /*ROLEMBERG FILHO*/
var schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType);
var fields = schemaProvider.GetFieldInfos(connection, tableSchema, table).ToList();
if (!fields.Any(x => x.IsPrimaryKey))
{
var primaryKeys = new HashSet <string>(schemaProvider.GetPrimaryKeyFields(connection, tableSchema, table));
foreach (var field in fields)
{
field.IsPrimaryKey = primaryKeys.Contains(field.FieldName);
}
}
if (!fields.Any(x => x.IsIdentity))
{
var identities = new HashSet <string>(schemaProvider.GetIdentityFields(connection, tableSchema, table));
foreach (var field in fields)
{
field.IsIdentity = identities.Contains(field.FieldName);
}
}
var foreigns = schemaProvider.GetForeignKeys(connection, tableSchema, table)
.ToLookup(x => x.FKName)
.Where(x => x.Count() == 1)
.SelectMany(x => x)
.ToList();
foreach (var field in fields)
{
var fk = foreigns.FirstOrDefault(x => x.FKColumn == field.FieldName);
if (fk != null)
{
field.PKSchema = fk.PKSchema;
field.PKTable = fk.PKTable;
field.PKColumn = fk.PKColumn;
}
}
var prefix = DeterminePrefixLength(fields, x => x.FieldName);
model.FieldPrefix = fields.First().FieldName.Substring(0, prefix);
var identity = fields.FirstOrDefault(f => f.IsIdentity == true);
if (identity == null)
{
identity = fields.FirstOrDefault(f => f.IsPrimaryKey == true);
}
if (identity != null)
{
model.Identity = GenerateVariableName(identity.FieldName.Substring(prefix));
}
else
{
identity = fields.FirstOrDefault(f => f.IsPrimaryKey == true) ??
fields.FirstOrDefault();
if (identity != null)
{
model.Identity = GenerateVariableName(identity.FieldName.Substring(prefix));
}
}
string baseRowMatch = null;
HashSet <string> baseRowFieldset = null;
List <string> baseRowFieldList = new List <string>();
foreach (var k in config.BaseRowClasses ?? new List <GeneratorConfig.BaseRowClass>())
{
var b = k.ClassName;
var f = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
var fl = new List <string>();
bool skip = false;
foreach (var s in k.Fields ?? new List <string>())
{
string n = s.TrimToNull();
if (n == null || !fields.Any(z => z.FieldName.Substring(prefix) == n))
{
skip = true;
break;
}
f.Add(n);
fl.Add(n);
}
if (skip)
{
continue;
}
if (baseRowFieldset == null || f.Count > baseRowFieldset.Count)
{
baseRowFieldset = f;
baseRowFieldList = fl;
baseRowMatch = b;
}
}
var removeForeignFields = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
foreach (var s in config.RemoveForeignFields ?? new List <string>())
{
string n = s.TrimToNull();
if (n != null)
{
removeForeignFields.Add(n);
}
}
if (baseRowFieldset != null &&
baseRowFieldset.Count > 0)
{
model.RowBaseClass = baseRowMatch;
model.FieldsBaseClass = baseRowMatch + "Fields";
model.RowBaseFields = new List <EntityField>();
fields = fields.Where(f =>
{
if (baseRowFieldset.Contains(f.FieldName.Substring(prefix)))
{
var ef = ToEntityField(f, prefix, config);
ef.Flags = null;
model.RowBaseFields.Add(ef);
return(false);
}
return(true);
}).ToList();
}
else
{
model.RowBaseClass = "Row";
model.RowBaseFields = new List <EntityField>();
model.FieldsBaseClass = "RowFieldsBase";
}
var fieldByIdent = new Dictionary <string, EntityField>(StringComparer.OrdinalIgnoreCase);
foreach (var field in fields)
{
var f = ToEntityField(field, prefix, config);
if (f.Ident == model.IdField)
{
f.ColAttributes = "EditLink, DisplayName(\"Db.Shared.RecordId\"), AlignRight";
}
int i = 0;
string ident = f.Ident;
while (fieldByIdent.ContainsKey(ident))
{
ident = f.Ident + ++i;
}
f.Ident = ident;
fieldByIdent[ident] = f;
if (f.Name == className && f.FieldType == "String")
{
model.NameField = f.Name;
f.ColAttributes = f.ColAttributes ?? "EditLink";
}
//ROLEMBERG FILHO - processa advanced tips para COLUNAS
f.ColAttributes += processAdvancedTips_Columns(f);
//ROLEMBERG FILHO - processa advanced tips para COLUNAS
var foreign = foreigns.Find((k) => k.FKColumn.Equals(field.FieldName, StringComparison.OrdinalIgnoreCase));
if (foreign != null)
{
if (f.Title.EndsWith(" Id") && f.Title.Length > 3)
{
f.Title = f.Title.SafeSubstring(0, f.Title.Length - 3);
}
f.PKSchema = foreign.PKSchema;
f.PKTable = foreign.PKTable;
f.PKColumn = foreign.PKColumn;
var frgfld = schemaProvider.GetFieldInfos(connection, foreign.PKSchema, foreign.PKTable).ToList();
int frgPrefix = RowGenerator.DeterminePrefixLength(frgfld, z => z.FieldName);
var j = new EntityJoin();
j.Fields = new List <EntityField>();
j.Name = GenerateVariableName(f.Name.Substring(prefix));
if (j.Name.EndsWith("Id") || j.Name.EndsWith("ID"))
{
j.Name = j.Name.Substring(0, j.Name.Length - 2);
}
f.ForeignJoinAlias = j.Name;
j.SourceField = f.Ident;
frgfld = frgfld.Where(y => !removeForeignFields.Contains(y.FieldName)).ToList();
foreach (var frg in frgfld)
{
if (frg.FieldName.Equals(foreign.PKColumn, StringComparison.OrdinalIgnoreCase))
{
continue;
}
var k = ToEntityField(frg, frgPrefix, config);
k.Flags = null;
//ROLEMBERG FILHO - trata o Tilte de acordo com as regras de AcertaPalavras
//k.Title = Inflector.Inflector.Titleize(JU(j.Name, frg.FieldName.Substring(frgPrefix)));
k.Title = config.ReplaceStringinDisplayName ? ToolsHeper.AcertaPalavra(Inflector.Inflector.Titleize(JU(j.Name, frg.FieldName.Substring(frgPrefix)))) :
Inflector.Inflector.Titleize(JU(j.Name, frg.FieldName.Substring(frgPrefix)));
//ROLEMBERG FILHO - trata o Tilte de acordo com as regras de AcertaPalavras
k.Ident = JI(j.Name, k.Ident);
i = 0;
ident = k.Ident;
while (fieldByIdent.ContainsKey(ident))
{
ident = k.Ident + ++i;
}
k.Ident = ident;
fieldByIdent[ident] = k;
var atk = new List <string>();
atk.Add("DisplayName(\"" + k.Title + "\")");
k.Expression = "j" + j.Name + ".[" + k.Name + "]";
atk.Add("Expression(\"" + k.Expression + "\")");
k.Attributes = String.Join(", ", atk);
if (f.TextualField == null && k.FieldType == "String")
{
f.TextualField = k.Ident;
}
j.Fields.Add(k);
}
model.Joins.Add(j);
}
model.Fields.Add(f);
}
if (model.NameField == null)
{
var fld = model.Fields.FirstOrDefault(z => z.FieldType == "String");
if (fld != null)
{
model.NameField = fld.Ident;
fld.ColAttributes = fld.ColAttributes ?? "EditLink";
}
}
foreach (var x in model.Fields)
{
var attrs = new List <string>();
//ROLEMBERG FILHO - lookup Editor Form
var attrsLookupEditorForm = new List <string>();
//ROLEMBERG FILHO - lookup Editor Form
attrs.Add("DisplayName(\"" + x.Title + "\")");
if (x.Ident != x.Name)
{
attrs.Add("Column(\"" + x.Name + "\")");
}
if ((x.Size ?? 0) > 0)
{
attrs.Add("Size(" + x.Size + ")");
}
if (x.Scale > 0)
{
attrs.Add("Scale(" + x.Scale + ")");
}
if (!String.IsNullOrEmpty(x.Flags))
{
attrs.Add(x.Flags);
}
if (!String.IsNullOrEmpty(x.PKTable))
{
attrs.Add("ForeignKey(\"" + (string.IsNullOrEmpty(x.PKSchema) ? x.PKTable : ("[" + x.PKSchema + "].[" + x.PKTable + "]")) + "\", \"" + x.PKColumn + "\")");
attrs.Add("LeftJoin(\"j" + x.ForeignJoinAlias + "\")");
//ROLEMBERG FILHO - trata o LOOKUPEDITOR
attrsLookupEditorForm.Add("LookupEditor(typeof(" + model.Module + ".Entities." + Serenity.CodeGenerator.RowGenerator.ClassNameFromTableName(x.PKTable) + "Row), InplaceAdd = true)");
//ROLEMBERG FILHO - trata o LOOKUPEDITOR
}
if (model.NameField == x.Ident)
{
attrs.Add("QuickSearch");
}
if (x.TextualField != null)
{
attrs.Add("TextualField(\"" + x.TextualField + "\")");
}
//ROLEMBERG FILHO - trata o PLACEHOLDER e ADVANCED TIPS
//if (config.FieldDescriptionasPlaceholder)
//{
if (!string.IsNullOrEmpty(x.FieldDescription))
{
if (x.DataType == "Boolean")
{
attrs.Add("Hint(\"" + x.FieldDescription + "\")");
}
else
{
attrs.Add("Placeholder(\"" + x.FieldDescription + "\")");
}
}
//}
//if (config.GenerateRowswithAdvancedTips)
//{
string attr = processAdvancedTips(x);
if (!string.IsNullOrEmpty(attr))
{
attrs.Add(attr);
}
//}
//ROLEMBERG FILHO - trata o PLACEHOLDER e ADVANCED TIPS
x.Attributes = String.Join(", ", attrs.ToArray());
x.AttrsLookupEditorForm = String.Join(", ", attrsLookupEditorForm.ToArray());
x.AttrsFileUpload = processAdvancedTips_Image_File(x, model.Tablename);
x.FormAttributes = processAdvancedTips_Forms(x);
//x.DialogAttributes = processAdvancedTips_Dialog(x, model.RootNamespace);
processAdvancedTips_Dialog(x, ref model);
}
return(model);
}
public void Run(string csproj, string[] args)
{
var projectDir = Path.GetDirectoryName(csproj);
var outFile = GetOption(args, "o").TrimToNull();
var connectionKey = GetOption(args, "c").TrimToNull();
var table = GetOption(args, "t").TrimToNull();
var what = GetOption(args, "w").TrimToNull();
var module = GetOption(args, "m").TrimToNull();
var identifier = GetOption(args, "i").TrimToNull();
var permissionKey = GetOption(args, "p").TrimToNull();
if (identifier != null)
{
CodeFileHelper.Overwrite = true;
}
var config = GeneratorConfig.LoadFromFile(Path.Combine(projectDir, "sergen.json"));
var connectionStringOptions = new ConnectionStringOptions();
if (!string.IsNullOrEmpty(config.CustomTemplates))
{
Templates.TemplatePath = Path.Combine(projectDir, config.CustomTemplates);
}
foreach (var x in config.Connections.Where(x => !x.ConnectionString.IsEmptyOrNull()))
{
connectionStringOptions[x.Key] = new ConnectionStringEntry
{
ConnectionString = x.ConnectionString,
ProviderName = x.ProviderName,
Dialect = x.Dialect
};
}
foreach (var name in config.GetAppSettingsFiles())
{
var path = Path.Combine(projectDir, name);
if (File.Exists(name))
{
var appSettings = JSON.ParseTolerant <AppSettingsFormat>(File.ReadAllText(path).TrimToNull() ?? "{}");
if (appSettings.Data != null)
{
foreach (var data in appSettings.Data)
{
// not so nice fix for relative paths, e.g. sqlite etc.
if (data.Value.ConnectionString.Contains("../../..", StringComparison.Ordinal))
{
data.Value.ConnectionString = data.Value
.ConnectionString.Replace("../../..", Path.GetDirectoryName(csproj), StringComparison.Ordinal);
}
else if (data.Value.ConnectionString.Contains(@"..\..\..\", StringComparison.Ordinal))
{
data.Value.ConnectionString = data.Value.ConnectionString.Replace(@"..\..\..\",
Path.GetDirectoryName(csproj), StringComparison.Ordinal);
}
connectionStringOptions[data.Key] = data.Value;
}
}
}
}
if (connectionStringOptions.Count == 0)
{
Console.Error.WriteLine("No connections in appsettings files or sergen.json!");
Environment.Exit(1);
}
var connectionKeys = connectionStringOptions.Keys.OrderBy(x => x).ToArray();
if (outFile == null && connectionKey == null)
{
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine("=== Table Code Generation ===");
Console.WriteLine("");
Console.ResetColor();
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Available Connections:");
Console.ResetColor();
foreach (var x in connectionKeys)
{
Console.WriteLine(x);
}
Console.ResetColor();
Console.WriteLine();
}
else if (connectionKey == null)
{
File.WriteAllText(outFile, JSON.Stringify(connectionStringOptions.Keys.OrderBy(x => x)));
Environment.Exit(0);
}
string userInput = null;
if (outFile == null && connectionKey == null)
{
userInput = connectionKeys.Length == 1 ? connectionKeys[0] : null;
while (connectionKey == null ||
!connectionKeys.Contains(connectionKey, StringComparer.OrdinalIgnoreCase))
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Connection: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
connectionKey = Hinter.ReadHintedLine(connectionKeys, userInput: userInput);
userInput = connectionKey;
if (connectionKey == "!")
{
Console.ResetColor();
return;
}
}
}
userInput = connectionKey;
if (!connectionStringOptions.ContainsKey(userInput))
{
Console.Error.WriteLine("Can't find connection with key: " + userInput + "!");
Environment.Exit(1);
}
if (outFile == null)
{
Console.ResetColor();
Console.WriteLine();
}
DbProviderFactories.RegisterFactory("Microsoft.Data.SqlClient",
Microsoft.Data.SqlClient.SqlClientFactory.Instance);
DbProviderFactories.RegisterFactory("System.Data.SqlClient",
Microsoft.Data.SqlClient.SqlClientFactory.Instance);
DbProviderFactories.RegisterFactory("Microsoft.Data.Sqlite",
Microsoft.Data.Sqlite.SqliteFactory.Instance);
DbProviderFactories.RegisterFactory("Npgsql",
Npgsql.NpgsqlFactory.Instance);
DbProviderFactories.RegisterFactory("FirebirdSql.Data.FirebirdClient",
FirebirdSql.Data.FirebirdClient.FirebirdClientFactory.Instance);
DbProviderFactories.RegisterFactory("MySql.Data.MySqlClient",
MySqlConnector.MySqlConnectorFactory.Instance);
var sqlConnections = new DefaultSqlConnections(
new DefaultConnectionStrings(connectionStringOptions));
ISchemaProvider schemaProvider;
List <TableName> tableNames;
using (var connection = sqlConnections.NewByKey(connectionKey))
{
schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType);
tableNames = schemaProvider.GetTableNames(connection).ToList();
}
var tables = tableNames.Select(x => x.Tablename).ToList();
var confConnection = config.Connections.FirstOrDefault(x =>
string.Compare(x.Key, connectionKey, StringComparison.OrdinalIgnoreCase) == 0);
if (outFile == null && table == null)
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Available Tables:");
Console.ResetColor();
foreach (var x in tables)
{
Console.WriteLine(x);
}
}
else if (table == null)
{
File.WriteAllText(outFile, JSON.Stringify(tableNames.Select(x =>
{
var xct = confConnection == null ? null : confConnection.Tables.FirstOrDefault(z => string.Compare(z.Tablename, table, StringComparison.OrdinalIgnoreCase) == 0);
return(new
{
name = x.Tablename,
module = xct == null || xct.Module.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(connectionKey) : xct.Module,
permission = xct == null || xct.PermissionKey.IsTrimmedEmpty() ? "Administration:General" : xct.PermissionKey,
identifier = xct == null || xct.Identifier.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(x.Table) : xct.Identifier,
});
})));
Environment.Exit(0);
}
userInput = tables.Count == 1 ? tables[0] : null;
if (userInput == null && schemaProvider.DefaultSchema != null &&
tables.Any(x => x.StartsWith(schemaProvider.DefaultSchema + ".", StringComparison.Ordinal)))
{
userInput = schemaProvider.DefaultSchema + ".";
}
if (outFile == null)
{
Console.WriteLine();
while (table == null ||
!tables.Contains(table, StringComparer.OrdinalIgnoreCase))
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
table = Hinter.ReadHintedLine(tables, userInput: userInput);
userInput = table;
if (table == "!")
{
Console.ResetColor();
return;
}
}
}
userInput = table;
var tableName = tableNames.First(x => string.Compare(x.Tablename, userInput, StringComparison.OrdinalIgnoreCase) == 0);
if (tableName == null)
{
Console.Error.WriteLine("Can't find table with name: " + userInput + "!");
Environment.Exit(1);
}
var confTable = confConnection == null ? null : confConnection.Tables.FirstOrDefault(x =>
string.Compare(x.Tablename, table, StringComparison.OrdinalIgnoreCase) == 0);
if (module == null)
{
userInput = confTable == null || confTable.Module.IsEmptyOrNull() ?
RowGenerator.ClassNameFromTableName(connectionKey) : confTable.Module;
Console.WriteLine();
while (module.IsTrimmedEmpty())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Module name for table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
module = Hinter.ReadHintedLine(Array.Empty <string>(), userInput: userInput);
userInput = module;
if (module == "!")
{
Console.ResetColor();
return;
}
}
}
if (identifier == null)
{
userInput = confTable == null || confTable.Identifier.IsEmptyOrNull() ?
RowGenerator.ClassNameFromTableName(tableName.Table) : confTable.Identifier;
Console.WriteLine();
while (identifier.IsTrimmedEmpty())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a class Identifier for table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
identifier = Hinter.ReadHintedLine(Array.Empty <string>(), userInput: userInput);
userInput = identifier;
if (identifier == "!")
{
Console.ResetColor();
return;
}
}
}
if (permissionKey == null)
{
userInput = confTable == null || confTable.PermissionKey.IsTrimmedEmpty() ?
"Administration:General" : confTable.PermissionKey;
Console.WriteLine();
while (permissionKey.IsTrimmedEmpty())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Enter a Permission Key for table: ('!' to abort)");
Console.ForegroundColor = ConsoleColor.Yellow;
permissionKey = Hinter.ReadHintedLine(Array.Empty <string>(), userInput: userInput);
userInput = permissionKey;
if (permissionKey == "!")
{
Console.ResetColor();
return;
}
}
}
if (what == null)
{
Console.WriteLine();
userInput = "RSUC";
while (what.IsEmptyOrNull())
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Choose What to Generate (R:Row, S:Repo+Svc, U=UI, C=Custom)");
Console.ForegroundColor = ConsoleColor.Yellow;
what = Hinter.ReadHintedLine(Array.Empty <string>(), userInput: userInput);
userInput = what;
if (what == "!")
{
Console.ResetColor();
return;
}
}
}
config.GenerateRow = what.IndexOf("R", StringComparison.OrdinalIgnoreCase) >= 0;
config.GenerateService = what.IndexOf("S", StringComparison.OrdinalIgnoreCase) >= 0;
config.GenerateUI = what.IndexOf("U", StringComparison.OrdinalIgnoreCase) >= 0;
config.GenerateCustom = what.IndexOf("C", StringComparison.OrdinalIgnoreCase) >= 0;
Console.ResetColor();
Console.WriteLine();
if (confConnection == null)
{
confConnection = new GeneratorConfig.Connection
{
Key = connectionKey
};
config.Connections.Add(confConnection);
}
if (confTable == null)
{
confTable = new GeneratorConfig.Table
{
Identifier = identifier,
Module = module,
PermissionKey = permissionKey,
Tablename = tableName.Tablename
};
confConnection.Tables.Add(confTable);
}
else
{
confTable.Identifier = identifier;
confTable.Module = module;
confTable.PermissionKey = permissionKey;
}
File.WriteAllText(Path.Combine(projectDir, "sergen.json"), config.SaveToJson());
using (var connection = sqlConnections.NewByKey(connectionKey))
{
connection.Open();
var csprojContent = File.ReadAllText(csproj);
var net5Plus = !new Regex(@"\<TargetFramework\>.*netcoreapp.*\<\/TargetFramework\>", RegexOptions.Multiline | RegexOptions.Compiled)
.IsMatch(csprojContent);
var rowModel = RowGenerator.GenerateModel(connection, tableName.Schema, tableName.Table,
module, connectionKey, identifier, permissionKey, config, net5Plus);
rowModel.AspNetCore = true;
rowModel.NET5Plus = net5Plus;
var kdiff3Paths = new[]
{
config.KDiff3Path
};
CodeFileHelper.Kdiff3Path = kdiff3Paths.FirstOrDefault(File.Exists);
CodeFileHelper.TSCPath = config.TSCPath ?? "tsc";
new EntityCodeGenerator(rowModel, config, csproj).Run();
}
}
private void ConnectionsCombo_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this._tables.Clear();
GenerateCodeButton.IsEnabled = false;
if (this.ConnectionsCombo.SelectedItem != null)
{
var conn = (GeneratorConfig.Connection) this.ConnectionsCombo.SelectedItem;
try
{
using (var connection = SqlConnections.New(conn.ConnectionString, conn.ProviderName))
{
connection.Open();
var schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType);
//foreach (var t in schemaProvider.GetTableNames(connection))
List <Data.Schema.TableName> excluiTabelas = new List <Data.Schema.TableName>();
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "EXCEPTIONS"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "LANGUAGES"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "ROLEPERMISSIONS"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "ROLES"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "USERPERMISSIONS"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "USERPREFERENCES"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "USERROLES"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "USERS"
});
excluiTabelas.Add(new Data.Schema.TableName()
{
Table = "VERSIONINFO"
});
//foreach (var t in schemaProvider.GetTableNames(connection).Where(x => x.Table != "Exceptions"))
foreach (var t in schemaProvider.GetTableNames(connection).Where(x => !excluiTabelas.Any(t => t.Table == x.Table.ToUpper())))
{
//INICIO - ROLEMBERG FILHO - NÃO MOSTRA AS TABELAS PADRÃO DO SERENITY !!!
//switch (t.Table.ToUpper())
//{
// case "EXCEPTIONS":
// case "LANGUAGES":
// case "ROLEPERMISSIONS":
// case "ROLES":
// case "USERPERMISSIONS":
// case "USERPREFERENCES":
// case "USERROLES":
// case "USERS":
// case "VERSIONINFO":
// // TABELAS PADRÃO DO SERENITY. NÃO MOSTRA NO SERGEN!!!!
// continue;
// default:
// break;
//}
//FIM - ROLEMBERG FILHO - NÃO MOSTRA AS TABELAS PADRÃO DO SERENITY !!!
var table = conn != null?conn.Tables.FirstOrDefault(x => x.Tablename == t.Tablename) : null;
var identifier = (table == null || table.Identifier.IsEmptyOrNull()) ?
RowGenerator.ClassNameFromTableName(t.Table) : table.Identifier;
var permission = table == null ? "Administration:General" : table.PermissionKey;
var connectionKey = (table != null && !table.ConnectionKey.IsEmptyOrNull()) ?
table.ConnectionKey : conn.Key;
var module = (table != null && table.Module != null) ? table.Module :
(Inflector.Inflector.Pascalize(connectionKey) ?? "").Replace(" ", "");
var tableItem = new TableItem
{
IsChecked = false,
ConnectionKey = conn.Key,
Module = module,
Identifier = identifier,
PermissionKey = permission,
FullName = t.Tablename
};
_tables.Add(tableItem);
tableItem.PropertyChanged += (s, e2) =>
{
var t2 = conn.Tables.FirstOrDefault(x => x.Tablename == tableItem.FullName);
if (t2 == null)
{
t2 = new GeneratorConfig.Table();
t2.Tablename = tableItem.FullName;
conn.Tables.Add(t2);
}
t2.Identifier = tableItem.Identifier;
t2.Module = tableItem.Module;
t2.ConnectionKey = tableItem.ConnectionKey;
t2.PermissionKey = tableItem.PermissionKey;
this.config.Save();
GenerateCodeButton.IsEnabled = _tables.Any(x => x.IsChecked);
};
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
public static EntityModel GenerateModel(IDbConnection connection, string tableSchema, string table,
string module, string connectionKey, string entityClass, string permission, GeneratorConfig config)
{
var model = new EntityModel();
model.Module = module;
if (connection.GetDialect().ServerType.StartsWith("MySql", StringComparison.OrdinalIgnoreCase))
{
model.Schema = null;
}
else
{
model.Schema = tableSchema;
}
model.Permission = permission;
model.ConnectionKey = connectionKey;
model.RootNamespace = config.RootNamespace;
var className = entityClass ?? ClassNameFromTableName(table);
model.ClassName = className;
model.RowClassName = className + "Row";
model.Title = Inflector.Inflector.Titleize(className);
model.Tablename = table;
model.Fields = new List <EntityField>();
model.Joins = new List <EntityJoin>();
model.Instance = true;
var schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType);
var fields = schemaProvider.GetFieldInfos(connection, tableSchema, table).ToList();
if (!fields.Any(x => x.IsPrimaryKey))
{
var primaryKeys = new HashSet <string>(schemaProvider.GetPrimaryKeyFields(connection, tableSchema, table));
foreach (var field in fields)
{
field.IsPrimaryKey = primaryKeys.Contains(field.FieldName);
}
}
if (!fields.Any(x => x.IsIdentity))
{
var identities = new HashSet <string>(schemaProvider.GetIdentityFields(connection, tableSchema, table));
foreach (var field in fields)
{
field.IsIdentity = identities.Contains(field.FieldName);
}
}
var foreigns = schemaProvider.GetForeignKeys(connection, tableSchema, table)
.ToLookup(x => x.FKName)
.Where(x => x.Count() == 1)
.SelectMany(x => x)
.ToList();
foreach (var field in fields)
{
var fk = foreigns.FirstOrDefault(x => x.FKColumn == field.FieldName);
if (fk != null)
{
field.PKSchema = fk.PKSchema;
field.PKTable = fk.PKTable;
field.PKColumn = fk.PKColumn;
}
}
var prefix = DeterminePrefixLength(fields, x => x.FieldName);
model.FieldPrefix = fields.First().FieldName.Substring(0, prefix);
var identity = fields.FirstOrDefault(f => f.IsIdentity == true);
if (identity == null)
{
identity = fields.FirstOrDefault(f => f.IsPrimaryKey == true);
}
if (identity != null)
{
model.Identity = GenerateVariableName(identity.FieldName.Substring(prefix));
}
else
{
identity = fields.FirstOrDefault(f => f.IsPrimaryKey == true);
if (identity != null)
{
model.Identity = GenerateVariableName(identity.FieldName.Substring(prefix));
}
}
string baseRowMatch = null;
HashSet <string> baseRowFieldset = null;
List <string> baseRowFieldList = new List <string>();
foreach (var k in config.BaseRowClasses ?? new List <GeneratorConfig.BaseRowClass>())
{
var b = k.ClassName;
var f = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
var fl = new List <string>();
bool skip = false;
foreach (var s in k.Fields ?? new List <string>())
{
string n = s.TrimToNull();
if (n == null || !fields.Any(z => z.FieldName.Substring(prefix) == n))
{
skip = true;
break;
}
f.Add(n);
fl.Add(n);
}
if (skip)
{
continue;
}
if (baseRowFieldset == null || f.Count > baseRowFieldset.Count)
{
baseRowFieldset = f;
baseRowFieldList = fl;
baseRowMatch = b;
}
}
var removeForeignFields = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
foreach (var s in config.RemoveForeignFields ?? new List <string>())
{
string n = s.TrimToNull();
if (n != null)
{
removeForeignFields.Add(n);
}
}
if (baseRowFieldset != null &&
baseRowFieldset.Count > 0)
{
model.RowBaseClass = baseRowMatch;
model.FieldsBaseClass = baseRowMatch + "Fields";
model.RowBaseFields = new List <EntityField>();
fields = fields.Where(f =>
{
if (baseRowFieldset.Contains(f.FieldName.Substring(prefix)))
{
var ef = ToEntityField(f, prefix);
ef.Flags = null;
model.RowBaseFields.Add(ef);
return(false);
}
return(true);
}).ToList();
}
else
{
model.RowBaseClass = "Row";
model.RowBaseFields = new List <EntityField>();
model.FieldsBaseClass = "RowFieldsBase";
}
foreach (var field in fields)
{
var f = ToEntityField(field, prefix);
if (f.Name == className && f.FieldType == "String")
{
model.NameField = f.Name;
}
var foreign = foreigns.Find((k) => k.FKColumn.Equals(field.FieldName, StringComparison.OrdinalIgnoreCase));
if (foreign != null)
{
if (f.Title.EndsWith(" Id") && f.Title.Length > 3)
{
f.Title = f.Title.SafeSubstring(0, f.Title.Length - 3);
}
f.PKSchema = foreign.PKSchema;
f.PKTable = foreign.PKTable;
f.PKColumn = foreign.PKColumn;
var frgfld = schemaProvider.GetFieldInfos(connection, foreign.PKSchema, foreign.PKTable).ToList();
int frgPrefix = RowGenerator.DeterminePrefixLength(frgfld, z => z.FieldName);
var j = new EntityJoin();
j.Fields = new List <EntityField>();
j.Name = GenerateVariableName(f.Name.Substring(prefix));
if (j.Name.EndsWith("Id") || j.Name.EndsWith("ID"))
{
j.Name = j.Name.Substring(0, j.Name.Length - 2);
}
f.ForeignJoinAlias = j.Name;
j.SourceField = f.Ident;
frgfld = frgfld.Where(y => !removeForeignFields.Contains(y.FieldName)).ToList();
foreach (var frg in frgfld)
{
if (frg.FieldName.Equals(foreign.PKColumn, StringComparison.OrdinalIgnoreCase))
{
continue;
}
var k = ToEntityField(frg, frgPrefix);
k.Flags = null;
k.Title = Inflector.Inflector.Titleize(JU(j.Name, frg.FieldName.Substring(frgPrefix)));
if (f.TextualField == null && k.FieldType == "String")
{
f.TextualField = JI(j.Name, k.Ident);
}
j.Fields.Add(k);
}
model.Joins.Add(j);
}
model.Fields.Add(f);
}
if (model.NameField == null)
{
var fld = model.Fields.FirstOrDefault(z => z.FieldType == "String");
if (fld != null)
{
model.NameField = fld.Ident;
}
}
return(model);
}
