private ClassType CreateClass(DatabaseTable table)
{
var name = textFormatter.FormatText(table.Name);
ClassType classType = ClassAlreadyExists(name);
if (classType != null)
{
return(classType);
}
classType = diagram.AddClass();
classType.AccessModifier = AccessModifier.Public;
classType.Modifier = ClassModifier.None;
classType.Name = name;
if (CodeGenerator.Settings.Default.GenerateNHibernateMapping)
{
if (CodeGenerator.Settings.Default.UseUnderscoreAndLowercaseInDB)
{
classType.NHMTableName = new LowercaseAndUnderscoreTextFormatter().FormatText(table.Name);
}
else
{
classType.NHMTableName = table.Name;
}
classType.IdGenerator = Enum.GetName(typeof(CodeGenerator.IdentityGeneratorType), CodeGenerator.Settings.Default.DefaultIdentityGenerator);
}
foreach (var column in table.Columns)
{
Property property = classType.AddProperty();
property.InitFromString(CreateProperty(column, classType));
if (CodeGenerator.Settings.Default.GenerateNHibernateMapping)
{
if (CodeGenerator.Settings.Default.UseUnderscoreAndLowercaseInDB)
{
property.NHMColumnName = new LowercaseAndUnderscoreTextFormatter().FormatText(column.Name);
}
else
{
property.NHMColumnName = column.Name;
}
property.IsIdentity = column.IsPrimaryKey;
if (column.IsForeignKey)
{
property.ManyToOne = textFormatter.FormatText(column.ForeignKeyTableName);
}
property.IsUnique = column.IsUniqueKey;
property.IsNotNull = !column.Nullable;
}
}
return(classType);
}
public string CompositeIdMap(IList <Column> columns, ITextFormatter formatter)
{
var builder = new StringBuilder();
switch (_language)
{
case Language.CSharp:
builder.AppendLine("ComposedId(compId =>");
builder.AppendLine("\t\t\t\t{");
foreach (var column in columns)
{
builder.AppendLine("\t\t\t\t\tcompId.Property(x => x." + formatter.FormatText(column.Name) + ", m => m.Column(\"" + column.Name + "\"));");
}
builder.Append("\t\t\t\t});");
break;
case Language.VB:
builder.AppendLine("ComposedId(Sub(compId)");
foreach (var column in columns)
{
builder.AppendLine("\t\t\t\t\tcompId.Property(Function(x) x." + formatter.FormatText(column.Name) + ", Sub(m) m.Column(\"" + column.Name + "\"))");
}
builder.AppendLine("\t\t\t\tEnd Sub)");
break;
}
return(builder.ToString());
}
//Id(x => x.Id, map =>
//{
// map.Column("ID");
// map.Generator(Generators.Sequence, g => g.Params(new { sequence = "TABLE_SEQ" }));
//});
public string IdSequenceMap(Column column, string sequenceName, ITextFormatter formatter)
{
var builder = new StringBuilder();
switch (_language)
{
case Language.CSharp:
builder.AppendFormat("Id(x => x.{0}, map => ", formatter.FormatText(column.Name));
builder.AppendLine();
builder.AppendLine("\t\t\t\t{");
builder.AppendLine("\t\t\t\t\tmap.Column(\"" + column.Name + "\");");
builder.AppendLine("\t\t\t\t\tmap.Generator(Generators.Sequence, g => g.Params(new { sequence = \"" + sequenceName + "\" }));");
builder.Append("\t\t\t\t});");
break;
case Language.VB:
builder.AppendFormat("Id(Function(x) x.{0}, Sub(map)", formatter.FormatText(column.Name));
builder.AppendLine();
builder.AppendLine("\t\t\t\t\tmap.Column(\"" + column.Name + "\")");
builder.AppendLine("\t\t\t\t\tmap.Generator(Generators.Sequence, Function(g) g.Params(New { sequence = \"" + sequenceName + "\" }))");
builder.Append("\t\t\t\tEnd Sub)");
break;
}
return(builder.ToString());
}
public string CompositeIdMap(IList<Column> columns, ITextFormatter formatter)
{
var builder = new StringBuilder();
switch (_language)
{
case Language.CSharp:
builder.AppendLine("ComposedId(compId =>");
builder.AppendLine("\t\t\t\t{");
foreach (var column in columns)
{
builder.AppendLine("\t\t\t\t\tcompId.Property(x => x." + formatter.FormatText(column.Name) + ", m => m.Column(\"" + column.Name + "\"));");
}
builder.Append("\t\t\t\t});");
break;
case Language.VB:
builder.AppendLine("ComposedId(Sub(compId)");
foreach (var column in columns)
{
builder.AppendLine("\t\t\t\t\tcompId.Property(Function(x) x." + formatter.FormatText(column.Name) + ", Sub(m) m.Column(\"" + column.Name + "\"))");
}
builder.AppendLine("\t\t\t\tEnd Sub)");
break;
}
return builder.ToString();
}
public void FormatText_DataIsDbNull_ReturnsEmptyString()
{
// setup
// execute
string result = _textFormatter.FormatText(DBNull.Value, null);
// assert
Assert.AreEqual(String.Empty, result);
}
public void FormatTextTestCaseOne(List <Word> input)
{
var output = textFormatter.FormatText(input);
Assert.IsTrue(output.StartsWith("1:Go"));
Assert.IsTrue(output.Contains("2:do\r\n"));
Assert.IsTrue(output.Contains("2:that\r\n"));
Assert.IsTrue(output.Contains("1:thing\r\n"));
Assert.IsTrue(output.Contains("1:you\r\n"));
Assert.IsTrue(output.Contains("1:so\r\n"));
Assert.IsTrue(output.EndsWith("1:well\r\n"));
Assert.AreEqual(output.Count(), 50);
}
//Property(x => x.Name, map =>
// {
// map.Column("NAME");
// map.NotNullable(true);
// map.Length(200);
// });
public string Map(Column column, ITextFormatter formatter)
{
var mappedStrBuilder = new StringBuilder();
mappedStrBuilder.AppendFormat("Property(x => x.{0}, map => ", formatter.FormatText(column.Name));
mappedStrBuilder.AppendLine();
mappedStrBuilder.AppendLine("\t\t\t\t{");
mappedStrBuilder.AppendLine("\t\t\t\t\tmap.Column(\"" + column.Name + "\");");
if (!column.IsNullable)
{
mappedStrBuilder.AppendLine("\t\t\t\t\tmap.NotNullable(true);");
}
if (column.DataLength > 0)
{
mappedStrBuilder.AppendLine("\t\t\t\t\tmap.Length(" + column.DataLength + ");");
}
if (column.DataPrecision.GetValueOrDefault(0) > 0)
{
mappedStrBuilder.AppendLine("\t\t\t\t\tmap.Precision(" + column.DataPrecision + ");");
}
if (column.DataScale.GetValueOrDefault(0) > 0)
{
mappedStrBuilder.AppendLine("\t\t\t\t\tmap.Scale(" + column.DataScale + ");");
}
mappedStrBuilder.Append("\t\t\t\t});");
return(mappedStrBuilder.ToString());
}
public string IdMap(Column column, ITextFormatter formatter)
{
var mapList = new List <string>();
var propertyName = formatter.FormatText(column.Name);
if (column.Name.ToLower() != propertyName.ToLower() || _applicationPreferences.AlwaysGenerateColumnMapping)
{
mapList.Add("map.Column(\"" + column.Name + "\")");
}
mapList.Add(column.IsIdentity ? "map.Generator(Generators.Identity)" : "map.Generator(Generators.Assigned)");
var l = GetLenght(column);
if (!string.IsNullOrWhiteSpace(l))
{
mapList.Add(l);
}
// Outer property definition
string line = FormatCode("Id", propertyName, mapList);
line += $" // {column.Format} - {column.Description}";
return(line);
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(ApplicationPreferences appPrefs, string pkColumnName, string pkColumnType, ITextFormatter formatter)
{
var dataTypeMapper = new DataTypeMapper();
bool isPkTypeIntegral = (dataTypeMapper.MapFromDBType(appPrefs.ServerType, pkColumnType, null, null, null)).IsTypeIntegral();
string idGeneratorType = (isPkTypeIntegral ? "GeneratedBy.Identity()" : "GeneratedBy.Assigned()");
return(new CodeSnippetStatement(string.Format(TABS + "Id(x => x.{0}).{1}.Column(\"{2}\");",
formatter.FormatText(pkColumnName),
idGeneratorType,
pkColumnName)));
}
public string IdMap(Column column, ITextFormatter formatter)
{
var builder = new StringBuilder();
builder.AppendFormat("Id(x => x.{0}, map => ", formatter.FormatText(column.Name));
builder.AppendLine();
builder.AppendLine("\t\t\t\t{");
builder.AppendLine("\t\t\t\t\tmap.Column(\"" + column.Name + "\");");
builder.Append("\t\t\t\t});");
return(builder.ToString());
}
//Id(x => x.Id, map =>
//{
// map.Column("ID");
// map.Generator(Generators.Sequence, g => g.Params(new { sequence = "TABLE_SEQ" }));
//});
public string IdSequenceMap(Column column, string sequenceName, ITextFormatter formatter)
{
var builder = new StringBuilder();
builder.AppendFormat("Id(x => x.{0}, map => ", formatter.FormatText(column.Name));
builder.AppendLine();
builder.AppendLine("\t\t\t\t{");
builder.AppendLine("\t\t\t\t\tmap.Column(\"" + column.Name + "\");");
builder.AppendLine("\t\t\t\t\tmap.Generator(Generators.Sequence, g => g.Params(new { sequence = \"" + sequenceName + "\" }));");
builder.Append("\t\t\t\t});");
return(builder.ToString());
}
public override void WriteLine(IDataReader reader, ColumnMetaData[] columnInfo)
{
if (_writer == null)
{
throw new InvalidOperationException("Initialise must be called to initialise the report writer");
}
for (var i = 0; i < reader.FieldCount; i++)
{
_writer.WriteField(_textFormatter.FormatText(reader.GetValue(i), reader.GetFieldType(i)));
}
_writer.NextRecord();
}
public override void WriteLine(IDataReader reader, ColumnMetaData[] columnInfo)
{
if (_writer == null)
{
throw new InvalidOperationException("Initialise must be called to initialise the report writer");
}
string[] columnValues =
Enumerable.Range(0, columnInfo.Length)
.Select(i => _textFormatter.FormatText(reader.GetValue(i), reader.GetFieldType(i)))
.ToArray();
_writer.WriteLine(string.Join(this.Delimiter, columnValues));
}
private ClassType CreateClass(DatabaseTable table)
{
var name = textFormatter.FormatText(table.Name);
ClassType classType = ClassAlreadyExists(name);
if (classType != null)
{
return(classType);
}
classType = diagram.AddClass();
classType.AccessModifier = AccessModifier.Public;
classType.Modifier = ClassModifier.None;
classType.Name = name;
foreach (var column in table.Columns)
{
classType.AddProperty().InitFromString(CreateProperty(column, classType));
}
return(classType);
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(ApplicationPreferences appPrefs, Table table, string pkColumnName, string propertyName, string pkColumnType, ITextFormatter formatter)
{
var dataTypeMapper = new DataTypeMapper();
bool isPkTypeIntegral = (dataTypeMapper.MapFromDBType(appPrefs.ServerType, pkColumnType, null, null, null)).IsTypeIntegral();
string fieldName = FixPropertyWithSameClassName(propertyName, table.Name);
int pkAlsoFkQty = (from fk in table.ForeignKeys.Where(fk => fk.UniquePropertyName == pkColumnName) select fk).Count();
if (pkAlsoFkQty > 0)
{
fieldName = fieldName + "Id";
}
string snippet = TABS + $".Property(x => x.{formatter.FormatText(fieldName)}).IsPrimaryKey()";
if (isPkTypeIntegral)
{
snippet += Environment.NewLine + TABS + $".Property(x => x.{formatter.FormatText(fieldName)}).IsIdentity()";
}
return(new CodeSnippetStatement(snippet));
}
public string IdMap(Column column, ITextFormatter formatter)
{
var mapList = new List <string>();
var propertyName = formatter.FormatText(column.Name);
if (column.Name.ToLower() != propertyName.ToLower())
{
mapList.Add("map.Column(\"" + column.Name + "\")");
}
mapList.Add(column.IsIdentity ? "map.Generator(Generators.Identity)" : "map.Generator(Generators.Assigned)");
// Outer property definition
return(FormatCode("Id", propertyName, mapList));
}
public string IdMap(Column column, ITextFormatter formatter)
{
var mapList = new List<string>();
var propertyName = formatter.FormatText(column.Name);
if (column.Name.ToLower() != propertyName.ToLower())
{
mapList.Add("map.Column(\"" + column.Name + "\")");
}
mapList.Add(column.IsIdentity ? "map.Generator(Generators.Identity)" : "map.Generator(Generators.Assigned)");
// Outer property definition
return FormatCode("Id", propertyName, mapList);
}
//Property(x => x.Name, map =>
// {
// map.Column("NAME");
// map.NotNullable(true);
// map.Length(200);
// map.Unique(true);
// });
public string Map(Column column, ITextFormatter formatter, bool includeLengthAndScale = true)
{
var propertyName = formatter.FormatText(column.Name);
var mapList = new List <string>();
// Column
if (_applicationPreferences.GenerateColumnNameMapping)
{
mapList.Add($"map.Column(\"{column.Name}\")");
}
// Not Null
if (!column.IsNullable)
{
mapList.Add("map.NotNullable(true)");
}
// Unique
if (column.IsUnique)
{
mapList.Add("map.Unique(true)");
}
// Length
if (column.DataLength.GetValueOrDefault() > 0 & includeLengthAndScale)
{
mapList.Add("map.Length(" + column.DataLength + ")");
}
else
{
// Precision
if (column.DataPrecision.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mapList.Add("map.Precision(" + column.DataPrecision + ")");
}
// Scale
if (column.DataScale.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mapList.Add("map.Scale(" + column.DataScale + ")");
}
}
// m.Access(Accessor.Field);
if (_applicationPreferences.FieldGenerationConvention == FieldGenerationConvention.Field)
{
mapList.Add("map.Access(Accessor.Field)");
}
// Outer property definition
return(FormatCode("Property", propertyName, mapList));
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(ApplicationPreferences appPrefs, Table table, string pkColumnName, string propertyName, string pkColumnType, ITextFormatter formatter)
{
var dataTypeMapper = new DataTypeMapper();
bool isPkTypeIntegral = (dataTypeMapper.MapFromDBType(appPrefs.ServerType, pkColumnType, null, null, null)).IsTypeIntegral();
string idGeneratorType = (isPkTypeIntegral ? "GeneratedBy.Identity()" : "GeneratedBy.Assigned()");
var fieldName = FixPropertyWithSameClassName(propertyName, table.Name);
var pkAlsoFkQty = (from fk in table.ForeignKeys.Where(fk => fk.UniquePropertyName == pkColumnName) select fk).Count();
//if (pkAlsoFkQty > 0) fieldName = fieldName + "Id";
return(new CodeSnippetStatement(string.Format(TABS + "Id(x => x.{0}).Column(\"{1}\").{2};",
formatter.FormatText(fieldName),
pkColumnName,
idGeneratorType)));
}
public void FormatCell_DataTypeIsDateTimeGlobalizationNotConfigured_ReturnsFormattedDateTime()
{
// setup
DateTime cellValue = DateTime.Now;
CultureInfo cultureInfo = CultureInfo.InvariantCulture;
_textFormatter = new TextFormatter(cultureInfo, null);
// execute
string result = _textFormatter.FormatText(cellValue, typeof(DateTime));
// assert
string expectedResult = cellValue.ToString(cultureInfo);
Assert.AreEqual(expectedResult, result);
}
public void FormatCell_DataTypeIsNumericAndGlobalizationNotConfigured_ReturnsFormattedNumber()
{
// setup
const decimal itemValue = 123.456789M;
CultureInfo cultureInfo = CultureInfo.InvariantCulture;
_textFormatter = new TextFormatter(null, cultureInfo);
// execute
string result = _textFormatter.FormatText(itemValue, typeof(Decimal));
// assert
string expectedResult = itemValue.ToString(cultureInfo);
Assert.AreEqual(expectedResult, result);
}
public void FormatCell_DataTypeIsSingleAndGlobalizationConfigured_ReturnsFormattedNumber(string cultureName)
{
// setup
const float itemValue = 123.456789F;
CultureInfo cultureInfo = CultureInfo.GetCultureInfo(cultureName);
_textFormatter = new TextFormatter(null, cultureInfo);
// execute
string result = _textFormatter.FormatText(itemValue, typeof(Single));
// assert
string expectedResult = itemValue.ToString(cultureInfo);
Assert.AreEqual(expectedResult, result);
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(PrimaryKey primaryKey, Table table, ITextFormatter formatter)
{
var keyPropertyBuilder = new StringBuilder(primaryKey.Columns.Count);
bool first = true;
foreach (Column pkColumn in primaryKey.Columns)
{
var propertyName = formatter.FormatText(pkColumn.Name);
var fieldName = FixPropertyWithSameClassName(propertyName, table.Name);
var pkAlsoFkQty = (from fk in table.ForeignKeys.Where(fk => fk.UniquePropertyName == pkColumn.Name) select fk).Count();
//if (pkAlsoFkQty > 0) fieldName = fieldName + "Id";
var tmp = String.Format(".KeyProperty(x => x.{0}, \"{1}\")", fieldName, pkColumn.Name);
keyPropertyBuilder.Append(first ? tmp : "\n" + TABS + " " + tmp);
first = false;
}
return(new CodeSnippetStatement(TABS + string.Format("CompositeId(){0};", keyPropertyBuilder)));
}
public string Map(Column column, ITextFormatter Formatter, bool includeLengthAndScale = true)
{
var mappedStrBuilder = new StringBuilder(string.Format("Map(x => x.{0})", Formatter.FormatText(column.Name)));
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Column(\"" + column.Name + "\")");
if (!column.IsNullable)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Not.Nullable()");
}
if (column.IsUnique)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Unique()");
}
if (column.DataLength.GetValueOrDefault() > 0 & includeLengthAndScale)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Length(" + column.DataLength + ")");
}
else
{
if (column.DataPrecision.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Precision(" + column.DataPrecision + ")");
}
if (column.DataScale.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Scale(" + column.DataScale + ")");
}
}
mappedStrBuilder.Append(Constants.SemiColon);
return mappedStrBuilder.ToString();
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(PrimaryKey primaryKey, Table table, ITextFormatter formatter)
{
var keyPropertyBuilder = new StringBuilder(primaryKey.Columns.Count);
int count = 1;
foreach (Column pkColumn in primaryKey.Columns)
{
string propertyName = formatter.FormatText(pkColumn.Name);
string fieldName = FixPropertyWithSameClassName(propertyName, table.Name);
int pkAlsoFkQty = (from fk in table.ForeignKeys.Where(fk => fk.UniquePropertyName == pkColumn.Name) select fk).Count();
if (pkAlsoFkQty > 0)
{
fieldName = fieldName + "Id";
}
string tmp = $".Property(x => x.{fieldName}).IsPrimaryKey()";
keyPropertyBuilder.Append("\n" + TABS + tmp);
count++;
}
return(new CodeSnippetStatement(keyPropertyBuilder.ToString()));
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(IApplicationSettings appPrefs, Table table, string pkColumnName, string propertyName, string pkColumnType, ITextFormatter formatter)
{
var dataTypeMapper = new DataTypeMapper();
bool isPkTypeIntegral = (dataTypeMapper.MapFromDBType(appPrefs.ServerType, pkColumnType, null, null, null)).IsTypeIntegral();
string idGeneratorType = (isPkTypeIntegral ? "GeneratedBy.Identity()" : "GeneratedBy.Assigned()");
var fieldName = FixPropertyWithSameClassName(propertyName, table.Name);
var pkAlsoFkQty = (from fk in table.ForeignKeys.Where(fk => fk.UniquePropertyName == pkColumnName) select fk).Count();
if (pkAlsoFkQty > 0)
{
fieldName = fieldName + "Id";
}
string value = TABS + $"Id(x => x.{formatter.FormatText(fieldName)}).{idGeneratorType}";
if (appPrefs.GenerateColumnNameMapping)
{
value += ".Column(\"{pkColumnName}\");";
}
return(new CodeSnippetStatement(value));
}
public void Prepare()
{
//var text = "We're going to test our CoreNLP installation!";
//var properties = new Dictionary<string, string>
//{
// {"annotators", "tokenize, ssplit, pos, lemma"},
// {"ner.useSUTime", "0"}
//};
//var stanfordCoreNlp = _stanfordCoreNlpFactory.GetStanfordCoreNlp(properties);
//var annotation = new Annotation(text);
//stanfordCoreNlp.annotate(annotation);
//using (var stream = new ByteArrayOutputStream())
//{
// stanfordCoreNlp.prettyPrint(annotation, new PrintWriter(stream));
// Console.WriteLine(stream.toString());
// stream.close();
//}
Console.WriteLine("--- Preparing Data ---");
var twitterData = Frame.ReadCsv(_appSettings.RawDataPath, hasHeaders: true);
var text = twitterData.GetColumn <string>("text");
var processedTweets = _textFormatter.FormatText(text);
twitterData.AddColumn("processed_tweet", processedTweets);
twitterData.SaveCsv(_appSettings.ProcessedDataPath);
Console.WriteLine("--- Data Preparation Complete ---");
}
public string Map(Column column, ITextFormatter Formatter, bool includeLengthAndScale = true)
{
var mappedStrBuilder = new StringBuilder(string.Format("Map(x => x.{0})", Formatter.FormatText(column.Name)));
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Column(\"" + column.Name + "\")");
if (!column.IsNullable)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Not.Nullable()");
}
if (column.IsUnique)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Unique()");
}
if (column.DataLength.GetValueOrDefault() > 0 & includeLengthAndScale)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Length(" + column.DataLength + ")");
}
else
{
if (column.DataPrecision.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Precision(" + column.DataPrecision + ")");
}
if (column.DataScale.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Scale(" + column.DataScale + ")");
}
}
mappedStrBuilder.Append(Constants.SemiColon);
return(mappedStrBuilder.ToString());
}
public void CsvReportWriterTest_CheckFileContents()
{
const string delimiter = ",";
// set up the data reader to return columns
ColumnMetaData[] headers =
{
new ColumnMetaData("Name", "varchar", 100),
new ColumnMetaData("Surname", "varchar", 100),
new ColumnMetaData("Age", "varchar", 32),
};
object[][] data =
{
new object[] { "Matt", "Salmon", 41 },
new object[] { "John", "Doe", 61 },
new object[] { "Jane", "Smith", 25 }
};
IDataReader reader = Substitute.For <IDataReader>();
reader.FieldCount.Returns(3);
reader.Read().Returns(true, true, true, false);
reader.GetValue(0).Returns(data[0][0], data[1][0], data[2][0]);
reader.GetValue(1).Returns(data[0][1], data[1][1], data[2][1]);
reader.GetValue(2).Returns(data[0][2], data[1][2], data[2][2]);
reader.GetFieldType(Arg.Any <int>()).Returns(typeof(String));
// set up the text formatter to return the value supplied
_textFormatter.FormatText(Arg.Any <object>(), Arg.Any <Type>()).Returns((c) => { return(c.ArgAt <object>(0).ToString()); });
// execute
_reportWriter.Initialise(_filePath, delimiter);
_reportWriter.WriteHeader(headers.Select(x => x.Name));
foreach (object[] line in data)
{
_reportWriter.WriteLine(reader, headers);
}
_reportWriter.Dispose();
// assert
Assert.IsTrue(File.Exists(_filePath));
List <string> lines = File.ReadLines(_filePath).ToList();
// check that the header is correct
string expectedHeader = String.Join(delimiter, headers.Select(x => x.Name));
Assert.AreEqual(expectedHeader, lines[0]);
// make sure each of the lines is written correctly
for (int i = 0; i < data.Length; i++)
{
object[] line = data[i];
string expectedLine = String.Join(delimiter, data[i]);
string actualLine = lines[i + 1];
Assert.AreEqual(expectedLine, actualLine);
}
// make sure all the data items are formatted
foreach (object[] line in data)
{
foreach (object item in line)
{
_textFormatter.Received(1).FormatText(item, typeof(String));
}
}
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(ApplicationPreferences appPrefs, string pkColumnName, string pkColumnType, ITextFormatter formatter)
{
var dataTypeMapper = new DataTypeMapper();
bool isPkTypeIntegral = (dataTypeMapper.MapFromDBType(appPrefs.ServerType, pkColumnType, null, null, null)).IsTypeIntegral();
string idGeneratorType = (isPkTypeIntegral ? "GeneratedBy.Identity()" : "GeneratedBy.Assigned()");
return new CodeSnippetStatement(string.Format(TABS + "Id(x => x.{0}).{1}.Column(\"{2}\");",
formatter.FormatText(pkColumnName),
idGeneratorType,
pkColumnName));
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(PrimaryKey primaryKey, ITextFormatter formatter)
{
var keyPropertyBuilder = new StringBuilder(primaryKey.Columns.Count);
foreach (Column pkColumn in primaryKey.Columns)
{
keyPropertyBuilder.Append(String.Format(".KeyProperty(x => x.{0}, \"{1}\")", formatter.FormatText(pkColumn.Name), pkColumn.Name));
}
return(new CodeSnippetStatement(TABS + string.Format("CompositeId(){0};", keyPropertyBuilder)));
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(PrimaryKey primaryKey, ITextFormatter formatter)
{
var keyPropertyBuilder = new StringBuilder(primaryKey.Columns.Count);
foreach (Column pkColumn in primaryKey.Columns)
{
keyPropertyBuilder.Append(String.Format(".KeyProperty(x => x.{0}, \"{1}\")", formatter.FormatText(pkColumn.Name), pkColumn.Name));
}
return new CodeSnippetStatement(TABS + string.Format("CompositeId(){0};", keyPropertyBuilder));
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(ApplicationPreferences appPrefs, Table table, string pkColumnName, string propertyName, string pkColumnType, ITextFormatter formatter)
{
var dataTypeMapper = new DataTypeMapper();
bool isPkTypeIntegral = (dataTypeMapper.MapFromDBType(appPrefs.ServerType, pkColumnType, null, null, null)).IsTypeIntegral();
string idGeneratorType = (isPkTypeIntegral ? "GeneratedBy.Identity()" : "GeneratedBy.Assigned()");
var fieldName = FixPropertyWithSameClassName(propertyName, table.Name);
var pkAlsoFkQty = (from fk in table.ForeignKeys.Where(fk => fk.UniquePropertyName == pkColumnName) select fk).Count();
if (pkAlsoFkQty > 0) fieldName = fieldName + "Id";
return new CodeSnippetStatement(string.Format(TABS + "Id(x => x.{0}).{1}.Column(\"{2}\");",
formatter.FormatText(fieldName),
idGeneratorType,
pkColumnName));
}
public string Map(Column column, ITextFormatter Formatter)
{
var mappedStrBuilder = new StringBuilder(string.Format("Map(x => x.{0})", Formatter.FormatText(column.Name)));
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Column(\"" + column.Name + "\")");
if (!column.IsNullable)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Not.Nullable()");
}
if (column.DataLength > 0)
{
mappedStrBuilder.Append(Constants.Dot);
mappedStrBuilder.Append("Length(" + column.DataLength + ")");
}
mappedStrBuilder.Append(Constants.SemiColon);
return(mappedStrBuilder.ToString());
}
public string Reference(ForeignKey fk, ITextFormatter formatter)
{
var builder = new StringBuilder();
if (fk.Columns.Count() == 1)
{
var mapList = new List <string>();
mapList.Add("map.Column(\"" + fk.Columns.First().Name + "\")");
// PropertyRef - Used with a FK that doesnt map to a primary key on referenced table.
if (!string.IsNullOrEmpty(fk.Columns.First().ForeignKeyColumnName))
{
mapList.Add("map.PropertyRef(\"" + formatter.FormatText(fk.Columns.First().ForeignKeyColumnName) + "\")");
}
if (fk.Columns.First().IsNullable)
{
mapList.Add("map.NotNullable(true)");
}
mapList.Add("map.Cascade(Cascade.None)");
builder.AppendLine(FormatCode("\t\t\tManyToOne", formatter.FormatSingular(fk.UniquePropertyName), mapList));
}
else
{
// Composite Foreign Key
// eg ManyToOne(x => x.TesteHeader, map => map.Columns(new Action<IColumnMapper>[] { x => x.Name("HeadIdOne"), x => x.Name("HeadIdTwo") }));
if (_language == Language.CSharp)
{
builder.AppendFormat(
"\t\t\tManyToOne(x => x.{0}, map => map.Columns(new Action<IColumnMapper>[] {{ ",
formatter.FormatSingular(fk.UniquePropertyName));
var lastColumn = fk.Columns.Last();
foreach (var column in fk.Columns)
{
builder.AppendFormat("x => x.Name(\"{0}\")", column.Name);
var isLastColumn = lastColumn == column;
if (!isLastColumn)
{
builder.Append(", ");
}
}
builder.Append(" }));");
}
else if (_language == Language.VB)
{
builder.AppendFormat(
"\t\t\tManyToOne(Function(x) x.{0}, Sub(map) map.Columns(new Action<IColumnMapper>[] {{",
formatter.FormatSingular(fk.UniquePropertyName));
var lastColumn = fk.Columns.Last();
foreach (var column in fk.Columns)
{
builder.AppendFormat("x.Name(\"{0}\")", column.Name);
var isLastColumn = lastColumn == column;
if (!isLastColumn)
{
builder.Append(", ");
}
}
builder.Append(" }))");
}
}
return(builder.ToString());
}
//Property(x => x.Name, map =>
// {
// map.Column("NAME");
// map.NotNullable(true);
// map.Length(200);
// map.Unique(true);
// });
public string Map(Column column, ITextFormatter formatter, bool includeLengthAndScale = true)
{
var propertyName = formatter.FormatText(column.Name);
var mapList = new List<string>();
// Column
if (column.Name.ToLower() != propertyName.ToLower())
{
mapList.Add("map.Column(\"" + column.Name + "\")");
}
// Not Null
if (!column.IsNullable)
{
mapList.Add("map.NotNullable(true)");
}
// Unique
if (column.IsUnique)
{
mapList.Add("map.Unique(true)");
}
// Length
if (column.DataLength.GetValueOrDefault() > 0 & includeLengthAndScale)
{
mapList.Add("map.Length(" + column.DataLength + ")");
}
else
{
// Precision
if (column.DataPrecision.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mapList.Add("map.Precision(" + column.DataPrecision + ")");
}
// Scale
if (column.DataScale.GetValueOrDefault(0) > 0 & includeLengthAndScale)
{
mapList.Add("map.Scale(" + column.DataScale + ")");
}
}
// m.Access(Accessor.Field);
if (_applicationPreferences.FieldGenerationConvention == FieldGenerationConvention.Field)
{
mapList.Add("map.Access(Accessor.Field)");
}
// Outer property definition
return FormatCode("Property", propertyName, mapList);
}
public string Reference(ForeignKey fk, ITextFormatter formatter)
{
var builder = new StringBuilder();
if (fk.Columns.Count() == 1)
{
var mapList = new List<string>();
mapList.Add("map.Column(\"" + fk.Columns.First().Name + "\")");
// PropertyRef - Used with a FK that doesnt map to a primary key on referenced table.
if (!string.IsNullOrEmpty(fk.Columns.First().ForeignKeyColumnName))
{
mapList.Add("map.PropertyRef(\"" + formatter.FormatText(fk.Columns.First().ForeignKeyColumnName) + "\")");
}
if (fk.Columns.First().IsNullable)
{
mapList.Add("map.NotNullable(true)");
}
mapList.Add("map.Cascade(Cascade.None)");
builder.AppendLine(FormatCode("\t\t\tManyToOne",formatter.FormatSingular(fk.UniquePropertyName),mapList));
}
else
{
// Composite Foreign Key
// eg ManyToOne(x => x.TesteHeader, map => map.Columns(new Action<IColumnMapper>[] { x => x.Name("HeadIdOne"), x => x.Name("HeadIdTwo") }));
if (_language == Language.CSharp)
{
builder.AppendFormat(
"\t\t\tManyToOne(x => x.{0}, map => map.Columns(new Action<IColumnMapper>[] {{ ",
formatter.FormatSingular(fk.UniquePropertyName));
var lastColumn = fk.Columns.Last();
foreach (var column in fk.Columns)
{
builder.AppendFormat("x => x.Name(\"{0}\")", column.Name);
var isLastColumn = lastColumn == column;
if (!isLastColumn)
{
builder.Append(", ");
}
}
builder.Append(" }));");
}
else if (_language == Language.VB)
{
builder.AppendFormat(
"\t\t\tManyToOne(Function(x) x.{0}, Sub(map) map.Columns(new Action<IColumnMapper>[] {{",
formatter.FormatSingular(fk.UniquePropertyName));
var lastColumn = fk.Columns.Last();
foreach (var column in fk.Columns)
{
builder.AppendFormat("x.Name(\"{0}\")", column.Name);
var isLastColumn = lastColumn == column;
if (!isLastColumn)
{
builder.Append(", ");
}
}
builder.Append(" }))");
}
}
return builder.ToString();
}
//Property(x => x.Name, map =>
// {
// map.Column("NAME");
// map.NotNullable(true);
// map.Length(200);
// map.Unique(true);
// });
public string Map(Column column, ITextFormatter formatter, bool includeLengthAndScale = true)
{
var propertyName = formatter.FormatText(column.Name);
var mapList = new List <string>();
// Column
if (column.Name.ToLower() != propertyName.ToLower() || _applicationPreferences.AlwaysGenerateColumnMapping)
{
mapList.Add("map.Column(\"" + column.Name + "\")");
}
// Not Null
if (!column.IsNullable)
{
mapList.Add("map.NotNullable(true)");
}
// Unique
if (column.IsUnique)
{
mapList.Add("map.Unique(true)");
}
// Length
if (_applicationPreferences.IncludeLengthTextOnly)
{
string l = GetLenght(column);
if (!string.IsNullOrWhiteSpace(l))
{
mapList.Add(l);
}
}
else
{
if (column.DataLength.GetValueOrDefault() > 0 && includeLengthAndScale)
{
mapList.Add("map.Length(" + column.DataLength + ")");
}
else
{
// Precision
if (column.DataPrecision.GetValueOrDefault(0) > 0 && includeLengthAndScale)
{
mapList.Add("map.Precision(" + column.DataPrecision + ")");
}
// Scale
if (column.DataScale.GetValueOrDefault(0) > 0 && includeLengthAndScale)
{
mapList.Add("map.Scale(" + column.DataScale + ")");
}
}
}
// m.Access(Accessor.Field);
if (_applicationPreferences.FieldGenerationConvention == FieldGenerationConvention.Field)
{
mapList.Add("map.Access(Accessor.Field)");
}
// Outer property definition
string line = FormatCode("Property", propertyName, mapList);
line += $" // {column.Format} - {column.Description}";
return(line);
}
private static CodeSnippetStatement GetIdMapCodeSnippetStatement(PrimaryKey primaryKey, Table table, ITextFormatter formatter)
{
var keyPropertyBuilder = new StringBuilder(primaryKey.Columns.Count);
bool first = true;
foreach (Column pkColumn in primaryKey.Columns)
{
var propertyName = formatter.FormatText(pkColumn.Name);
var fieldName = FixPropertyWithSameClassName(propertyName, table.Name);
var pkAlsoFkQty = (from fk in table.ForeignKeys.Where(fk => fk.UniquePropertyName == pkColumn.Name) select fk).Count();
if (pkAlsoFkQty > 0) fieldName = fieldName + "Id";
var tmp = String.Format(".KeyProperty(x => x.{0}, \"{1}\")",fieldName, pkColumn.Name);
keyPropertyBuilder.Append(first ? tmp : "\n" + TABS + " " + tmp);
first = false;
}
return new CodeSnippetStatement(TABS + string.Format("CompositeId(){0};", keyPropertyBuilder));
}
//Id(x => x.Id, map =>
//{
// map.Column("ID");
// map.Generator(Generators.Sequence, g => g.Params(new { sequence = "TABLE_SEQ" }));
//});
public string IdSequenceMap(Column column, string sequenceName, ITextFormatter formatter)
{
var builder = new StringBuilder();
switch (_language)
{
case Language.CSharp:
builder.AppendFormat("Id(x => x.{0}, map => ", formatter.FormatText(column.Name));
builder.AppendLine();
builder.AppendLine("\t\t\t\t{");
builder.AppendLine("\t\t\t\t\tmap.Column(\"" + column.Name + "\");");
builder.AppendLine("\t\t\t\t\tmap.Generator(Generators.Sequence, g => g.Params(new { sequence = \"" + sequenceName + "\" }));");
builder.Append("\t\t\t\t});");
break;
case Language.VB:
builder.AppendFormat("Id(Function(x) x.{0}, Sub(map)", formatter.FormatText(column.Name));
builder.AppendLine();
builder.AppendLine("\t\t\t\t\tmap.Column(\"" + column.Name + "\")");
builder.AppendLine("\t\t\t\t\tmap.Generator(Generators.Sequence, Function(g) g.Params(New { sequence = \"" + sequenceName + "\" }))");
builder.Append("\t\t\t\tEnd Sub)");
break;
}
return builder.ToString();
}
