public void UpdateConnectionsFrom(string configFilePath,
Action <Connection> added)
{
if (!string.IsNullOrEmpty(configFilePath) &&
File.Exists(configFilePath))
{
try
{
var xml = new XmlDocument();
xml.LoadXml(File.ReadAllText(configFilePath));
var nodes = xml.SelectNodes("//configuration/connectionStrings/add");
foreach (XmlElement node in nodes)
{
var name = node.Attributes["name"];
var conn = node.Attributes["connectionString"];
var prov = node.Attributes["providerName"];
if (name != null &&
!string.IsNullOrWhiteSpace(name.Value) &&
conn != null &&
!string.IsNullOrWhiteSpace(conn.Value) &&
prov != null &&
!string.IsNullOrWhiteSpace(prov.Value))
{
var connection = Connections.FirstOrDefault(x => String.Compare(x.Key, name.Value, StringComparison.OrdinalIgnoreCase) == 0);
if (connection == null)
{
connection = new GeneratorConfig.Connection();
connection.Key = name.Value;
Connections.Add(connection);
connection.ConnectionString = conn.Value;
connection.ProviderName = prov.Value;
if (added != null)
{
added(connection);
}
}
else
{
connection.ConnectionString = conn.Value;
connection.ProviderName = prov.Value;
}
}
}
}
catch (Exception ex)
{
ex.Log();
}
}
}
private void AddConnection_Click(object sender, RoutedEventArgs e)
{
var dlg = new AddConnectionStringWindow();
if (dlg.ShowDialog() == true)
{
var cstr = dlg.Key.Text.Trim();
if (cstr.Length < 0)
{
throw new ArgumentNullException("connectionKey");
}
var connection = config.Connections.FirstOrDefault(x => String.Compare(x.Key, cstr, StringComparison.OrdinalIgnoreCase) == 0);
if (connection == null)
{
connection = new GeneratorConfig.Connection
{
Key = cstr,
ConnectionString = dlg.ConnectionString.Text.Trim(),
ProviderName = dlg.Provider.Text.Trim(),
Tables = new List <GeneratorConfig.Table>
{
}
};
config.Connections.Add(connection);
_connections.Clear();
_connections.AddRange(config.Connections);
}
else
{
connection.ConnectionString = dlg.ConnectionString.Text.Trim();
connection.ProviderName = dlg.Provider.Text.Trim();
}
this.ConnectionsCombo.SelectedItem = connection;
config.Save();
}
}
public void UpdateConnectionsFrom(string configFilePath,
Action<Connection> added)
{
if (!string.IsNullOrEmpty(configFilePath) &&
File.Exists(configFilePath))
{
try
{
var xml = new XmlDocument();
xml.LoadXml(File.ReadAllText(configFilePath));
var nodes = xml.SelectNodes("//configuration/connectionStrings/add");
foreach (XmlElement node in nodes)
{
var name = node.Attributes["name"];
var conn = node.Attributes["connectionString"];
var prov = node.Attributes["providerName"];
if (name != null &&
!string.IsNullOrWhiteSpace(name.Value) &&
conn != null &&
!string.IsNullOrWhiteSpace(conn.Value) &&
prov != null &&
!string.IsNullOrWhiteSpace(prov.Value))
{
var connection = Connections.FirstOrDefault(x => String.Compare(x.Key, name.Value, StringComparison.OrdinalIgnoreCase) == 0);
if (connection == null)
{
connection = new GeneratorConfig.Connection();
connection.Key = name.Value;
Connections.Add(connection);
connection.ConnectionString = conn.Value;
connection.ProviderName = prov.Value;
if (added != null)
added(connection);
}
else
{
connection.ConnectionString = conn.Value;
connection.ProviderName = prov.Value;
}
}
}
}
catch (Exception ex)
{
ex.Log();
}
}
}
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 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 Ekle_Click(object sender, RoutedEventArgs e)
{
var dlg = new AddConnectionStringWindow();
if (dlg.ShowDialog() == true)
{
var cstr = dlg.Key.Text.Trim();
if (cstr.Length < 0)
throw new ArgumentNullException("connectionKey");
var connection = config.Connections.FirstOrDefault(x => String.Compare(x.Key, cstr, StringComparison.OrdinalIgnoreCase) == 0);
if (connection == null)
{
connection = new GeneratorConfig.Connection
{
Key = cstr,
ConnectionString = dlg.ConnectionString.Text.Trim(),
ProviderName = dlg.Provider.Text.Trim(),
Tables = new List<GeneratorConfig.Table>
{
}
};
config.Connections.Add(connection);
_connections.Clear();
_connections.AddRange(config.Connections);
}
else
{
connection.ConnectionString = dlg.ConnectionString.Text.Trim();
connection.ProviderName = dlg.Provider.Text.Trim();
}
this.ConnectionsCombo.SelectedItem = connection;
SaveConfig();
}
}
public void UpdateConnectionsFrom(string configFilePath,
Action <Connection> added)
{
if (!string.IsNullOrEmpty(configFilePath) &&
File.Exists(configFilePath))
{
try
{
var xml = new XmlDocument();
xml.LoadXml(File.ReadAllText(configFilePath));
var nodes = xml.SelectNodes("//configuration/connectionStrings/add");
foreach (XmlElement node in nodes)
{
var name = node.Attributes["name"];
var conn = node.Attributes["connectionString"];
var prov = node.Attributes["providerName"];
if (name != null &&
!string.IsNullOrWhiteSpace(name.Value) &&
conn != null &&
!string.IsNullOrWhiteSpace(conn.Value) &&
prov != null &&
!string.IsNullOrWhiteSpace(prov.Value))
{
var connection = Connections.FirstOrDefault(x => String.Compare(x.Key, name.Value, StringComparison.OrdinalIgnoreCase) == 0);
if (connection == null)
{
connection = new GeneratorConfig.Connection();
connection.Key = name.Value;
Connections.Add(connection);
connection.ConnectionString = conn.Value;
connection.ProviderName = prov.Value;
if (added != null)
{
added(connection);
}
}
else
{
connection.ConnectionString = conn.Value;
connection.ProviderName = prov.Value;
}
}
}
//read TablePrefixSettings
var tablePrefixSettingsNode = xml.SelectSingleNode("//configuration/appSettings/add[@key='TablePrefixSettings']");
if (tablePrefixSettingsNode != null)
{
var value = tablePrefixSettingsNode.Attributes["value"].Value;
this.TablePrefixSettings = JSON.ParseTolerant <TablePrefixSettings>(value);
}
else
{
this.TablePrefixSettings = new TablePrefixSettings {
ModulePrefixes = new Dictionary <string, string>()
};
}
}
catch (Exception ex)
{
ex.Log();
}
}
}
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";
// TODO: register other factories from config file?
DbProviderFactories.RegisterFactory("System.Data.SqlClient", SqlClientFactory.Instance);
List<TableName> tableNames;
using (var connection = SqlConnections.New(connectionString, providerName))
tableNames = SqlSchemaInfo.GetTableNames(connection);
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 && tables.Any(x => x.StartsWith("dbo.")))
userInput = "dbo.";
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 ExitCodes Run()
{
AnsiConsole.WriteLine();
AnsiConsole.Write(new Spectre.Console.Rule($"[bold springgreen3_1]Table Code Generation[/]")
{
Alignment = Justify.Left
});
var csproj = SelectCsProj();
if (csproj is null)
{
return(ExitCodes.NoProjectFiles);
}
var projectDir = Path.GetDirectoryName(csproj);
var config = GeneratorConfig.LoadFromFile(Path.Combine(projectDir, "sergen.json"));
if (!string.IsNullOrEmpty(config.CustomTemplates))
{
Templates.TemplatePath = Path.Combine(projectDir, config.CustomTemplates);
}
var connectionString = SelectConnectionString(config, projectDir);
if (connectionString.connectionKey is null)
{
return(ExitCodes.NoConnectionString);
}
var confConnection = config.Connections?.FirstOrDefault(x =>
string.Compare(x.Key, connectionString.connectionKey, StringComparison.OrdinalIgnoreCase) == 0);
var tables = SelectedTables(connectionString.sqlConnections, connectionString.connectionKey);
var module = string.Empty;
var permissionKey = "Administration:General";
var generateData = new Dictionary <string, (string module, string identifier, string permissionKey, TableName table)>();
foreach (var table in tables.selectedTables)
{
var confTable = confConnection?.Tables.FirstOrDefault(x => string.Compare(x.Tablename, table.Tablename, StringComparison.OrdinalIgnoreCase) == 0);
if (string.IsNullOrEmpty(module))
{
module = confTable?.Module?.TrimToNull() is null?
RowGenerator.ClassNameFromTableName(connectionString.connectionKey) : confTable.Module;
}
module = SelectModule(table.Tablename, module);
var defaultIdentifier = confTable?.Identifier?.TrimToNull() is null?
RowGenerator.ClassNameFromTableName(table.Table) : confTable.Identifier;
var identifier = SelectIdentifier(table.Tablename, defaultIdentifier);
permissionKey = SelectPermissionKey(table.Tablename, confTable?.PermissionKey?.TrimToNull() ?? permissionKey);
generateData.Add(table.Tablename, (module, identifier, permissionKey, table));
}
var whatToGenerate = SelectWhatToGenerate();
config.GenerateRow = whatToGenerate.Contains("Row");
config.GenerateService = whatToGenerate.Contains("Repository & Service");
config.GenerateUI = whatToGenerate.Contains("User Interface");
config.GenerateCustom = whatToGenerate.Contains("Custom");
foreach (var data in generateData)
{
var confTable = confConnection?.Tables.FirstOrDefault(x => string.Compare(x.Tablename, data.Key, StringComparison.OrdinalIgnoreCase) == 0);
if (confConnection == null)
{
confConnection = new GeneratorConfig.Connection
{
Key = connectionString.connectionKey
};
config.Connections.Add(confConnection);
}
if (confTable == null)
{
confTable = new GeneratorConfig.Table
{
Identifier = data.Value.identifier,
Module = data.Value.module,
PermissionKey = data.Value.permissionKey,
Tablename = data.Key
};
confConnection.Tables.Add(confTable);
}
else
{
confTable.Identifier = data.Value.identifier;
confTable.Module = data.Value.module;
confTable.PermissionKey = data.Value.permissionKey;
}
File.WriteAllText(Path.Combine(projectDir, "sergen.json"), config.SaveToJson());
using var connection = connectionString.sqlConnections.NewByKey(connectionString.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, data.Value.table.Schema, data.Value.table.Table,
data.Value.module, connectionString.connectionKey, data.Value.identifier, data.Value.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();
}
return(ExitCodes.Success);
}
