public void TableNameSetToValueSpecified()
{
var typeDefinition = new TypeDefinition(typeof(User));
var map = new Map<User>(typeDefinition);
map.TableName("Users");
Assert.AreEqual("Users", typeDefinition.TableName);
}
public void ExplicitColumnConfigurationSetToValuePassedIn()
{
var typeDefinition = new TypeDefinition(typeof(User));
var map = new Map<User>(typeDefinition);
map.Columns(x => x.Column(y => y.Age).Ignore(), true);
Assert.AreEqual(true, typeDefinition.ExplicitColumns);
}
public void SequenceNameSetIfSpecified()
{
var typeDefinition = new TypeDefinition(typeof(User));
var map = new Map<User>(typeDefinition);
map.PrimaryKey(x => x.UserId, "userid_seq");
Assert.AreEqual("userid_seq", typeDefinition.SequenceName);
}
public void CompositeKeySetToBothPropertiesJoinedByAComma()
{
var typeDefinition = new TypeDefinition(typeof(User));
var map = new Map<User>(typeDefinition);
map.CompositePrimaryKey(x => x.UserId, x => x.Name);
Assert.AreEqual("UserId,Name", typeDefinition.PrimaryKey);
}
public void AutoIncrementSetToValueSpecified()
{
var typeDefinition = new TypeDefinition(typeof(User));
var map = new Map<User>(typeDefinition);
map.PrimaryKey(x => x.UserId, false);
Assert.AreEqual(false, typeDefinition.AutoIncrement);
}
public void PrimaryKeyValueSetToPropertyName()
{
var typeDefinition = new TypeDefinition(typeof(User));
var map = new Map<User>(typeDefinition);
map.PrimaryKey(x => x.UserId);
Assert.AreEqual("UserId", typeDefinition.PrimaryKey);
Assert.AreEqual(true, typeDefinition.AutoIncrement);
}
public void PrimaryKeyAndColumnNameSet()
{
var typeDefinition = new TypeDefinition(typeof(User));
var map = new Map<User>(typeDefinition);
map
.PrimaryKey(x => x.UserId)
.Columns(x =>
{
x.Column(y => y.UserId).WithName("Id");
});
Assert.AreEqual("UserId", typeDefinition.PrimaryKey);
Assert.AreEqual("Id", typeDefinition.ColumnConfiguration["UserId"].DbColumnName);
}
private static Mappings CreateMappings(ConventionScannerSettings scannerSettings, Type[] typesOverride)
{
var types = typesOverride ?? FindTypes(scannerSettings);
var config = new Dictionary<Type, TypeDefinition>();
foreach (var type in types)
{
var pocoDefn = new TypeDefinition(type)
{
AutoIncrement = scannerSettings.PrimaryKeysAutoIncremented(type),
PrimaryKey = scannerSettings.PrimaryKeysNamed(type),
TableName = scannerSettings.TablesNamed(type),
SequenceName = scannerSettings.SequencesNamed(type),
ExplicitColumns = true
};
foreach (var prop in ReflectionUtils.GetFieldsAndPropertiesForClasses(type))
{
var column = new ColumnDefinition();
column.MemberInfo = prop;
column.DbColumnName = scannerSettings.PropertiesNamed(prop);
column.DbColumnAlias = scannerSettings.AliasNamed(prop);
column.IgnoreColumn = scannerSettings.IgnorePropertiesWhere.Any(x => x.Invoke(prop));
column.DbColumnType = scannerSettings.DbColumnTypesAs(prop);
column.ResultColumn = scannerSettings.ResultPropertiesWhere(prop);
column.ComputedColumn = scannerSettings.ComputedPropertiesWhere(prop);
column.VersionColumn = scannerSettings.VersionPropertiesWhere(prop);
column.VersionColumnType = scannerSettings.VersionColumnTypeAs(prop);
column.ForceUtc = scannerSettings.ForceDateTimesToUtcWhere(prop);
if (!pocoDefn.ColumnConfiguration.ContainsKey(prop.Name))
pocoDefn.ColumnConfiguration.Add(prop.Name, column);
}
config.Add(type, pocoDefn);
}
MergeOverrides(config, scannerSettings.MappingOverrides);
//if (scannerSettings.OverrideWithAttributes)
//{
// MergeAttributeOverrides(config);
//}
var pocoMappings = new Mappings {Config = config};
return pocoMappings;
}
private static Mappings CreateMappings(ConventionScannerSettings scannerSettings, Type[] typesOverride)
{
var types = typesOverride ?? FindTypes(scannerSettings);
var config = new Dictionary<Type, TypeDefinition>();
foreach (var type in types)
{
var pocoDefn = new TypeDefinition(type)
{
AutoIncrement = scannerSettings.PrimaryKeysAutoIncremented(type),
PrimaryKey = scannerSettings.PrimaryKeysNamed(type),
TableName = scannerSettings.TablesNamed(type),
PersistedType = scannerSettings.PersistedTypesBy(type),
SequenceName = scannerSettings.SequencesNamed(type),
UseOutputClause = scannerSettings.UseOutputClauseWhere(type),
ExplicitColumns = true
};
foreach (var columnDefinition in GetColumnDefinitions(scannerSettings, type, new List<MemberInfo>()))
{
var key = PocoColumn.GenerateKey(columnDefinition.MemberInfoChain);
if (!pocoDefn.ColumnConfiguration.ContainsKey(key))
pocoDefn.ColumnConfiguration.Add(key, columnDefinition);
}
config.Add(type, pocoDefn);
}
foreach (var mappingOverride in scannerSettings.MappingOverrides)
{
MergeOverrides(config, mappingOverride);
}
//if (scannerSettings.OverrideWithAttributes)
//{
// MergeAttributeOverrides(config);
//}
var pocoMappings = new Mappings {Config = config};
return pocoMappings;
}
private static Mappings CreateMappings(ConventionScannerSettings scannerSettings, Type[] typesOverride)
{
var types = typesOverride ?? FindTypes(scannerSettings);
var config = new Dictionary<Type, TypeDefinition>();
foreach (var type in types)
{
var pocoDefn = new TypeDefinition(type)
{
AutoIncrement = scannerSettings.PrimaryKeysAutoIncremented(type),
PrimaryKey = scannerSettings.PrimaryKeysNamed(type),
TableName = scannerSettings.TablesNamed(type),
SequenceName = scannerSettings.SequencesNamed(type),
};
foreach (var prop in type.GetProperties())
{
var column = new ColumnDefinition();
column.PropertyInfo = prop;
column.DbColumnName = scannerSettings.PropertiesNamed(prop);
column.IgnoreColumn = scannerSettings.IgnorePropertiesWhere.Any(x => x.Invoke(prop));
column.ResultColumn = scannerSettings.ResultPropertiesWhere(prop);
column.VersionColumn = scannerSettings.VersionPropertiesWhere(prop);
column.ForceUtc = scannerSettings.ForceDateTimesToUtcWhere(prop);
pocoDefn.ColumnConfiguration.Add(prop.Name, column);
}
config.Add(type, pocoDefn);
}
MergeOverrides(config, scannerSettings.MappingOverrides);
var pocoMappings = new Mappings {Config = config};
return pocoMappings;
}
public FluentMappingsPocoData(Type t, TypeDefinition typeConfig, IMapper mapper)
{
Mapper = mapper;
type = t;
TableInfo = new TableInfo();
// Get the table name
var a = typeConfig.TableName ?? "";
TableInfo.TableName = a.Length == 0 ? t.Name : a;
// Get the primary key
a = typeConfig.PrimaryKey ?? "";
TableInfo.PrimaryKey = a.Length == 0 ? "ID" : a;
a = typeConfig.SequenceName ?? "";
TableInfo.SequenceName = a.Length == 0 ? null : a;
TableInfo.AutoIncrement = typeConfig.AutoIncrement ?? true;
// Set autoincrement false if primary key has multiple columns
TableInfo.AutoIncrement = TableInfo.AutoIncrement ? !TableInfo.PrimaryKey.Contains(',') : TableInfo.AutoIncrement;
// Call column mapper
if (mapper != null)
mapper.GetTableInfo(t, TableInfo);
// Work out bound properties
bool explicitColumns = typeConfig.ExplicitColumns ?? false;
Columns = new Dictionary<string, PocoColumn>(StringComparer.OrdinalIgnoreCase);
foreach (var mi in ReflectionUtils.GetFieldsAndPropertiesForClasses(t))
{
// Work out if properties is to be included
var isColumnDefined = typeConfig.ColumnConfiguration.ContainsKey(mi.Name);
if (explicitColumns && !isColumnDefined) continue;
if (isColumnDefined && (typeConfig.ColumnConfiguration[mi.Name].IgnoreColumn.HasValue && typeConfig.ColumnConfiguration[mi.Name].IgnoreColumn.Value))
continue;
var pc = new PocoColumn();
pc.MemberInfo = mi;
// Work out the DB column name
if (isColumnDefined)
{
var colattr = typeConfig.ColumnConfiguration[mi.Name];
pc.ColumnName = colattr.DbColumnName;
if (colattr.ResultColumn.HasValue && colattr.ResultColumn.Value)
pc.ResultColumn = true;
else if (colattr.VersionColumn.HasValue && colattr.VersionColumn.Value)
pc.VersionColumn = true;
if (colattr.ForceUtc.HasValue && colattr.ForceUtc.Value)
pc.ForceToUtc = true;
if (TableInfo.PrimaryKey.Split(',').Contains(mi.Name))
TableInfo.PrimaryKey = (pc.ColumnName ?? mi.Name) + ",";
pc.ColumnType = colattr.DbColumnType;
}
if (pc.ColumnName == null)
{
pc.ColumnName = mi.Name;
if (mapper != null && !mapper.MapMemberToColumn(mi, ref pc.ColumnName, ref pc.ResultColumn))
continue;
}
// Store it
Columns.Add(pc.ColumnName, pc);
}
// Trim trailing slash if built using Property names
TableInfo.PrimaryKey = TableInfo.PrimaryKey.TrimEnd(',');
// Build column list for automatic select
QueryColumns = (from c in Columns where !c.Value.ResultColumn select c.Key).ToArray();
}
public FluentMappingsPocoData(Type t, TypeDefinition typeConfig, IMapper mapper, Cache<string, Type> aliasCache)
{
AliasToType = aliasCache;
Mapper = mapper;
type = t;
TableInfo = new TableInfo();
// Get the table name
var a = typeConfig.TableName ?? "";
TableInfo.TableName = a.Length == 0 ? t.Name : a;
// Get the primary key
a = typeConfig.PrimaryKey ?? "";
TableInfo.PrimaryKey = a.Length == 0 ? "ID" : a;
a = typeConfig.SequenceName ?? "";
TableInfo.SequenceName = a.Length == 0 ? null : a;
TableInfo.AutoIncrement = typeConfig.AutoIncrement ?? true;
// Set autoincrement false if primary key has multiple columns
TableInfo.AutoIncrement = TableInfo.AutoIncrement ? !TableInfo.PrimaryKey.Contains(',') : TableInfo.AutoIncrement;
// Call column mapper
if (mapper != null)
mapper.GetTableInfo(t, TableInfo);
var alias = CreateAlias(type.Name, type);
TableInfo.AutoAlias = alias;
var index = 0;
// Work out bound properties
bool explicitColumns = typeConfig.ExplicitColumns ?? false;
Columns = new Dictionary<string, PocoColumn>(StringComparer.OrdinalIgnoreCase);
var originalPK = TableInfo.PrimaryKey.Split(',');
foreach (var mi in ReflectionUtils.GetFieldsAndPropertiesForClasses(t))
{
// Work out if properties is to be included
var isColumnDefined = typeConfig.ColumnConfiguration.ContainsKey(mi.Name);
if (explicitColumns && !isColumnDefined) continue;
if (isColumnDefined && (typeConfig.ColumnConfiguration[mi.Name].IgnoreColumn.HasValue && typeConfig.ColumnConfiguration[mi.Name].IgnoreColumn.Value))
continue;
var pc = new PocoColumn();
pc.TableInfo = TableInfo;
pc.MemberInfo = mi;
pc.AutoAlias = alias + "_" + index++;
// Work out the DB column name
if (isColumnDefined)
{
var colattr = typeConfig.ColumnConfiguration[mi.Name];
pc.ColumnName = colattr.DbColumnName;
pc.ColumnAlias = colattr.DbColumnAlias;
if (colattr.ResultColumn.HasValue && colattr.ResultColumn.Value)
pc.ResultColumn = true;
else if (colattr.VersionColumn.HasValue && colattr.VersionColumn.Value)
{
pc.VersionColumn = true;
pc.VersionColumnType = colattr.VersionColumnType ?? VersionColumnType.Number;
}
else if (colattr.ComputedColumn.HasValue && colattr.ComputedColumn.Value)
pc.ComputedColumn = true;
if (colattr.ForceUtc.HasValue && colattr.ForceUtc.Value)
pc.ForceToUtc = true;
for (int i = 0; i < originalPK.Length; i++)
{
if (originalPK[i].Equals(mi.Name, StringComparison.OrdinalIgnoreCase))
originalPK[i] = (pc.ColumnName ?? mi.Name);
}
pc.ColumnType = colattr.DbColumnType;
}
if (pc.ColumnName == null)
{
pc.ColumnName = mi.Name;
if (mapper != null && !mapper.MapMemberToColumn(mi, ref pc.ColumnName, ref pc.ResultColumn))
continue;
}
// Store it
if (!Columns.ContainsKey(pc.ColumnName))
Columns.Add(pc.ColumnName, pc);
}
// Recombine the primary key
TableInfo.PrimaryKey = String.Join(",", originalPK);
// Build column list for automatic select
QueryColumns = Columns.Where(x => !x.Value.ResultColumn).ToArray();
}