private string GenerateParserClass(ILInterface ifa)
{
string code = $" public class {ifa.ShortName}Loader : IInterfaceLayerLoader {{\n";
//
// Properties
//
code += " public string Folder { get; set; }\n";
code += " public string FileName { get; set; }\n\n";
//
// Konstruktor
//
code += $" public {ifa.ShortName}Loader(string folder) {{\n";
code += $" this.FileName = \"{ifa.ShortName}.csv\";\n";
code += " this.Folder = folder;\n";
code += " }\n\n";
//
// Methoden
//
code += GenerateExecuteMethod(ifa);
code += GenerateLoadMethod(ifa);
code += GenerateParseLineMethod(ifa);
code += GenerateDeleteMethod(ifa);
code += GenerateInsertSQLMethod(ifa);
//
// Schluss
//
code += " }\n\n";
return(code);
}
///
/// Execute-Funktion
///
private string GenerateExecuteMethod(ILInterface ifa)
{
string code = "";
code += " public void Execute(DbConnection con) {\n";
code += " string filename = Path.Combine(this.Folder, this.FileName);\n";
code += " if(con == null) {\n";
code += " // Ausgabe zwecks Debugging\n";
code += " foreach(var line in Load(filename)) {\n";
code += " Console.WriteLine(GetInsertSQL(line));\n";
code += " }\n";
code += " } else {\n";
code += " // Tabelleninhalt löschen\n";
code += " DeleteFromTable(con);\n";
code += " int i = 0;\n";
// TODO: Kopfzeile sollte später auf Korrektheit geprüft werden!
code += " // Tatsächliche Verarbeitung: 1. Zeile wird als Kopfzeile ausgelassen\n";
code += " using(var cmd = con.CreateCommand()) {\n";
code += " foreach(var line in Load(filename)) {\n";
code += " cmd.CommandText = GetInsertSQL(line);\n";
code += " if(i > 0) {\n";
code += " cmd.ExecuteNonQuery();\n";
code += " }\n";
code += " i += 1;\n";
code += " }\n";
code += " }\n";
code += " }\n";
code += " }\n\n";
return(code);
}
public ILInterface GetILInterface()
{
if (ilInterface == null)
{
ilInterface = new IL.ILInterface(this.coreInterface, this.coreInterface.CoreModel);
}
return(ilInterface);
}
private string GenerateSubstateEnum(ILInterface ifa)
{
string code = $" public enum {ifa.ShortName}ParserSubstate {{\n";
code += " INITIAL, IN_STRING\n";
code += " }\n\n";
return(code);
}
private string GenerateDataClass(ILInterface ifa)
{
string code = $" public class {ifa.ShortName}Line {{\n";
foreach (var attr in ifa.NonCalculatedAttributes)
{
code += $" public string {attr.Name} {{ get; set; }}\n";
}
code += " }\n\n";
return(code);
}
private string GenerateDummyData(ILInterface ifa)
{
StringBuilder sb = new StringBuilder();
GenerateHeadline(ifa, sb);
for (int i = 0; i < MAX_NUM; i++)
{
GenerateDataLine(ifa, sb, i);
}
return(sb.ToString());
}
///
/// Delete-Funktion
///
private string GenerateDeleteMethod(ILInterface ifa)
{
string code = "";
code += $" public void DeleteFromTable(DbConnection con) {{\n";
code += " using(var cmd = con.CreateCommand()) {\n";
code += $" cmd.CommandText = \"truncate table {ifa.FullName}\";\n";
code += " cmd.ExecuteNonQuery();\n";
code += " }\n";
code += " }\n\n";
return(code);
}
private string GenerateCsvEnum(ILInterface ifa)
{
string code = $" public enum {ifa.ShortName}ParserState {{\n ";
foreach (var attr in ifa.NonCalculatedAttributes)
{
code += $"IN_{attr.Name.ToUpper()}";
code += ", ";
}
code += "FINAL\n }\n\n";
return(code);
}
private void GenerateDataLine(ILInterface ifa, StringBuilder sb, int i)
{
foreach (var attr in ifa.NonCalculatedAttributes)
{
switch (attr.CDataType)
{
case CoreDataType.INT:
sb.Append($"\"{i}\"");
break;
case CoreDataType.DECIMAL:
sb.Append($"\"{i}.{i}\"");
break;
case CoreDataType.DATE:
sb.Append("\"2012-01-01\"");
break;
case CoreDataType.DATETIME:
sb.Append("\"2013-01-01 12:00:00\"");
break;
case CoreDataType.TIME:
sb.Append("\"12:11:22\"");
break;
case CoreDataType.VARCHAR:
if (attr.Name.Equals("Mandant_KNZ"))
{
sb.Append("\"9999\"");
}
else
{
sb.Append($"\"TXT{i}\"");
}
break;
default:
throw new InvalidDataTypeException();
}
if (ifa.NonCalculatedAttributes.Last() != attr)
{
sb.Append(";");
}
else
{
sb.Append("\n");
}
}
}
///
/// Line to SQL Funktion
///
private string GenerateInsertSQLMethod(ILInterface ifa)
{
string code = "";
code += $" public string GetInsertSQL({ifa.ShortName}Line line) {{\n";
code += $" string sql = \"insert into {ifa.FullName} (\";\n";
code += " sql += \"";
foreach (var attr in ifa.NonCalculatedAttributes)
{
code += attr.Name;
if (!attr.Equals(ifa.NonCalculatedAttributes.Last()))
{
code += ", ";
}
}
code += "\";\n";
code += " sql += \") values (\";\n";
foreach (var attr in ifa.NonCalculatedAttributes)
{
code += $" if(!string.IsNullOrEmpty(line.{attr.Name})) {{\n";
code += $" sql += \"\'\" + (line.{attr.Name}.Length>{GetMaxLength(attr)}?line.{attr.Name}{GetSubstringIfNeeded(attr, ifa)}:line.{attr.Name}).Replace(\"'\", \"''\") + \"\'";
if (attr.Equals(ifa.NonCalculatedAttributes.Last()))
{
code += ")\\n\";\n";
}
else
{
code += ", \";\n";
}
code += " } else {\n";
code += " sql += \"\'\'";
if (attr.Equals(ifa.NonCalculatedAttributes.Last()))
{
code += ")\\n\";\n";
}
else
{
code += ", \";\n";
}
code += " }\n";
}
code += " return sql;\n";
code += " }\n\n";
return(code);
}
private void GenerateHeadline(ILInterface ifa, StringBuilder sb)
{
foreach (var attr in ifa.NonCalculatedAttributes)
{
sb.Append($"\"{attr.Name}\"");
if (ifa.NonCalculatedAttributes.Last() != attr)
{
sb.Append(";");
}
else
{
sb.Append("\n");
}
}
}
private string GenerateIfaCode(ILInterface ifa)
{
string code = $"create table {ifa.Name} (\n";
foreach (var attr in ifa.Attributes)
{
code += $" {attr.Name} {attr.DataType}{attr.DataTypeParameters}";
if (!ifa.Attributes.Last().Equals(attr))
{
code += ",";
}
code += "\n";
}
code += ");\n\n";
return(code);
}
private string GenerateRelations(ILInterface ifa)
{
string code = "# Beziehungen \n";
foreach (var r in ifa.Attributes.Where(a => a.Core is CoreRefAttribute))
{
var core = ((CoreRefAttribute)r.Core);
if (core.ReferencedInterface.Type != CoreInterfaceType.DEF_TABLE &&
core.ReferencedInterface.Type != CoreInterfaceType.TEMPORAL_TABLE &&
core.ReferencedInterface.Type != CoreInterfaceType.DIM_VIEW)
{
code += $"{ifa.Core.Name}:{r.Core.Name} -- {core.ReferencedInterface.Name}:{core.ReferencedAttribute.Name}\n";
}
}
return(code);
}
///
/// Load-Funktion
///
private string GenerateLoadMethod(ILInterface ifa)
{
string code = "";
code += $" public IEnumerable<{ifa.ShortName}Line> Load(string filename) {{\n";
code += " if(!File.Exists(filename)) {\n";
code += " throw new FileNotFoundException(filename);\n";
code += " }\n\n";
code += " using(var fs = new StreamReader(new FileStream(filename, FileMode.Open))) {\n";
code += " string line = \"\";\n";
code += " long i = 0;\n\n";
code += " while((line = fs.ReadLine()) != null) {\n";
code += " i += 1;\n";
code += " yield return ParseLine(line, i);\n";
code += " }\n";
code += " }\n";
code += " }\n\n";
return(code);
}
///
/// Load-Funktion
///
private string GenerateParseLineMethod(ILInterface ifa)
{
string code = "";
code += $" public {ifa.ShortName}Line ParseLine(string line, long lineNumber) {{\n";
//
// Zustandsvariablen des Automaten
//
code += " // Zustands- und Hilfsvariablen\n";
code += $" var state = {ifa.ShortName}ParserState.IN_{ifa.NonCalculatedAttributes[0].Name.ToUpper()};\n";
code += $" var substate = {ifa.ShortName}ParserSubstate.INITIAL;\n";
code += $" var content = new {ifa.ShortName}Line();\n";
code += " char c = ' ';\n";
code += " string buf = \"\";\n\n";
//
// Schleife zur Verarbeitung der Daten
//
code += " // Verarbeitung\n";
code += " for(int i = 0; i < line.Length; i++) {\n";
code += " c = line[i];\n";
code += " switch(state) {\n";
foreach (var attr in ifa.NonCalculatedAttributes)
{
// Generierung der Cases
code += GenerateParseAttributeCase(ifa, attr);
}
code += $" case {ifa.ShortName}ParserState.FINAL:\n";
code += $" return content;\n";
code += " }\n";
code += " }\n";
code += $" if(state == {ifa.ShortName}ParserState.FINAL) {{\n";
code += " return content;\n";
code += " } else {\n";
code += " throw new InvalidOperationException($\"Ungültiger State am Ende der Zeile {lineNumber} => {state}\");\n";
code += " }\n";
code += " }\n\n";
return(code);
}
///
/// Generierung eines einzelnen Cases (zu ParserState)
///
private string GenerateParseAttributeCase(ILInterface ifa, ILAttribute attr)
{
string code = "";
code += $"case {ifa.ShortName}ParserState.IN_{attr.Name.ToUpper()}:\n";
/// Vor Anführungszeichen
code += $" if(substate == {ifa.ShortName}ParserSubstate.INITIAL) {{\n";
code += " if(c == '\"') {\n";
code += $" substate = {ifa.ShortName}ParserSubstate.IN_STRING;\n";
code += " } else if(c == ';') {\n";
// Zum nächsten Attribut weiterschalten
if (attr == ifa.NonCalculatedAttributes.Last())
{
code += $" state = {ifa.ShortName}ParserState.FINAL;\n";
}
else
{
var nextAttr = ifa.NonCalculatedAttributes[ifa.NonCalculatedAttributes.IndexOf(attr) + 1];
code += $" state = {ifa.ShortName}ParserState.IN_{nextAttr.Name.ToUpper()};\n";
}
code += " } else {\n";
code += $" throw new InvalidDataException($\"Ungültiges Zeichen vor {ifa.Name}.{attr.Name} Zeile {{i}}\");\n";
code += " }\n";
/// Nach Anführungszeichen
code += $" }} else if(substate == {ifa.ShortName}ParserSubstate.IN_STRING) {{\n";
code += " if(c == '\"') {\n";
code += $" content.{attr.Name} = buf;\n";
code += " buf = \"\";\n";
code += $" substate = {ifa.ShortName}ParserSubstate.INITIAL;\n";
if (attr == ifa.NonCalculatedAttributes.Last())
{
code += $" state = {ifa.ShortName}ParserState.FINAL;\n";
}
code += " } else {\n";
code += " buf += c;\n";
code += " }\n";
code += " }\n";
code += $" break;\n";
return(code.Indent(" "));
}
private string GenerateInterface(ILInterface ifa)
{
string code = $"{ifa.Core.Name}[label=<\n";
code += "<table border=\"0\" cellborder=\"1\" cellspacing=\"0\">\n";
code += $"<tr><td><b>{ifa.Name}:{ToText(ifa.Core.Type)}</b></td></tr>\n";
foreach (var attr in ifa.Attributes)
{
if (attr.Core is CoreBaseAttribute)
{
code += $"<tr><td port=\"{attr.Core.Name}\">{attr.Name}:{attr.DataType}{GetCalculated((CoreBaseAttribute)attr.Core)}</td></tr>\n";
}
else
{
code += $"<tr><td port=\"{attr.Name}\">{attr.Name}:{attr.DataType}</td></tr>\n";
}
}
code += "</table>>];\n\n";
return(code);
}
private GeneratorResult GenerateLoadCsvClasses(ILInterface ifa)
{
string code = "using System;\n";
code += "using System.Collections.Generic;\n";
code += "using System.IO;\n";
code += "using System.Data.Common;\n";
if (!model.Namespace.Equals("Kdv.Loader"))
{
code += "using Kdv.Loader;\n";
}
code += "\n";
code += $"namespace {model.Namespace} {{\n";
code += GenerateCsvEnum(ifa);
code += GenerateSubstateEnum(ifa);
code += GenerateDataClass(ifa);
code += GenerateParserClass(ifa);
code += "}";
return(new GeneratorResult($"{ifa.ShortName}Loader.cs", code));
}
private string GetSubstringIfNeeded(ILAttribute attr, ILInterface ifa)
{
return($".Substring(0, {GetMaxLength(attr)})");
}
