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(); }