public void ShouldMapDBTypesToDotNetTypes()
{
var columnDetail = new ColumnDetail("Id", "DATE", 10, 8, 0, 10, true);
Assert.AreEqual(typeof (DateTime).Name, columnDetail.MappedType);
Assert.AreEqual("DATE", columnDetail.DataType);
Assert.AreEqual("Id", columnDetail.ColumnName);
}
public string Map(ColumnDetail columnDetail)
{
var mappedStr = string.Format("Map(x => x.{0})", columnDetail.ColumnName);
if (columnDetail.DataLength > 0)
{
mappedStr += Constants.Dot;
mappedStr += "Length(" + columnDetail.DataLength + ")";
}
if(!columnDetail.IsNullable)
{
mappedStr += Constants.Dot;
mappedStr += "Not.Nullable()";
}
return mappedStr + Constants.SemiColon;
}
private bool IsReferenceColumn(ColumnDetail detail)
{
if(_tableReferences == null || _tableReferences.Count == 0 )
{
return false;
}
foreach (KeyValuePair<string, TableReference> pair in _tableReferences)
{
TableReference reference = pair.Value;
foreach (KeyValuePair<ColumnDetail, ColumnDetail> column in reference.TableColumns)
{
if(column.Key.ColumnName.Equals(detail.ColumnName))
return true;
}
}
return false;
}
private bool FiendInTableReference(ColumnDetail detail)
{
if(tableReferences == null || tableReferences.Count == 0) return false;
foreach (KeyValuePair<string, TableReference> pair in tableReferences)
{
Dictionary<ColumnDetail,ColumnDetail> columns = pair.Value.TableColumns;
foreach (KeyValuePair<ColumnDetail, ColumnDetail> dictionary in columns)
{
if(dictionary.Key.ColumnName.Equals(detail.ColumnName)) return true;
}
}
return false;
}
public void ShouldMapDBColumnWithProperties()
{
var mapper = new DBColumnMapper();
var columnDetail = new ColumnDetail("Name", "varchar", 16, 0, 0, false);
Assert.That(mapper.Map(columnDetail), Is.EqualTo("Map(x => x.Name).Length(16).Not.Nullable();"));
}
public void ShouldMapDBColumn()
{
var mapper = new DBColumnMapper();
var columnDetail = new ColumnDetail("Age", "Int", 0, 0, 0, true);
Assert.That(mapper.Map(columnDetail), Is.EqualTo("Map(x => x.Age);"));
}
