public void CreateColumn(string tableName, string columnName, DbType dbType)
{
ILoggingService loggingService = engine.GetService<ILoggingService>();
if (loggingService != null)
loggingService.LogInfo(this, String.Format("Creating {0} column {1} in table {2} in NPersist mapping file.",
dbType.ToString(), columnName, tableName));
ITableMap tableMap = GetDomainMap().GetSourceMap().MustGetTableMap(tableName);
//Add the column to the npersist xml file
IColumnMap columnMap = new ColumnMap(columnName);
columnMap.TableMap = tableMap;
columnMap.DataType = dbType;
}
protected virtual void CreateColumnForProperty(IPropertyMap propertyMap, IDomainMap targetDomainMap, bool generateMappings, IClassMap ownerClassMap)
{
IClassMap classMap = propertyMap.ClassMap;
ITableMap tableMap = null;
ISourceMap sourceMap = null;
ISourceMap addToSourceMap = null;
IClassMap classMapClone = null;
IPropertyMap propertyMapClone = null;
IColumnMap columnMap = null;
string classTableName = "";
string name = "";
string tableName = "";
bool allowNulls = false;
IClassMap refClassMap = null;
string forTableName = "";
string forColumnName = "";
int cnt = 0;
bool found = false;
string primColName = "";
string ownerClassTableName = "";
string foreignKeyName = "";
sourceMap = classMap.GetSourceMap();
if (sourceMap == null)
{
sourceMap = classMap.DomainMap.GetSourceMap();
if (sourceMap == null)
{
throw new Exception("No default data source specified for domain model! Can't add table for class!");
}
}
addToSourceMap = targetDomainMap.GetSourceMap(sourceMap.Name);
if (addToSourceMap == null)
{
addToSourceMap = (ISourceMap) sourceMap.Clone();
addToSourceMap.DomainMap = targetDomainMap;
}
if (propertyMap.ClassMap.Table.Length > 0)
{
classTableName = propertyMap.ClassMap.Table;
}
else
{
classTableName = GetTableNameForClass(propertyMap.ClassMap);
}
if (propertyMap.Table.Length > 0)
{
tableName = propertyMap.Table;
}
else if (propertyMap.IsCollection)
{
tableName = GetTableNameForProperty(propertyMap);
}
else
{
if (IsOutbrokenByInheritance(propertyMap, ownerClassMap))
{
ownerClassTableName = GetTableNameForClass(ownerClassMap, true);
tableName = ownerClassTableName;
}
else
{
tableName = classTableName;
}
}
tableMap = addToSourceMap.GetTableMap(tableName);
if (tableMap == null)
{
tableMap = new TableMap();
tableMap.Name = tableName;
tableMap.SourceMap = addToSourceMap;
}
if (propertyMap.Column.Length > 0)
{
name = propertyMap.Column;
}
else
{
name = GetColumnNameForProperty(propertyMap);
}
columnMap = tableMap.GetColumnMap(name);
if (columnMap == null)
{
columnMap = new ColumnMap();
columnMap.Name = name;
columnMap.TableMap = tableMap;
}
columnMap.DataType = GetColumnTypeForProperty(propertyMap);
columnMap.Length = GetColumnLengthForProperty(propertyMap);
columnMap.Precision = GetColumnPrecisionForProperty(propertyMap);
columnMap.Scale = GetColumnScaleForProperty(propertyMap);
allowNulls = propertyMap.IsNullable;
if (propertyMap.IsIdentity)
{
allowNulls = false;
}
columnMap.AllowNulls = allowNulls;
if (propertyMap.IsIdentity)
{
columnMap.IsPrimaryKey = true;
columnMap.AllowNulls = false;
if (propertyMap.ReferenceType == ReferenceType.None)
{
if (columnMap.DataType == DbType.Int16 || columnMap.DataType == DbType.Int32 || columnMap.DataType == DbType.Int64)
{
if (propertyMap.ClassMap.GetIdentityPropertyMaps().Count == 1)
{
if (propertyMap.GetIsAssignedBySource())
{
columnMap.IsAutoIncrease = true;
columnMap.Seed = 1;
columnMap.Increment = 1;
}
}
}
}
}
if (!(propertyMap.ReferenceType == ReferenceType.None))
{
foreignKeyName = "FK_" + columnMap.TableMap.Name + "_" + columnMap.Name;
refClassMap = propertyMap.GetReferencedClassMap();
if (!(refClassMap == null))
{
foreach (IPropertyMap idProp in refClassMap.GetIdentityPropertyMaps())
{
if (cnt > 0)
{
if (idProp.Column.Length > 0)
{
name = idProp.Column;
}
else
{
name = GetColumnNameForProperty(idProp);
}
foreignKeyName += "_" + name;
}
}
}
primColName = "";
if (refClassMap.TypeColumn.Length > 0)
{
primColName = refClassMap.TypeColumn;
}
else
{
if (!(refClassMap.InheritanceType == InheritanceType.None))
{
primColName = GetTypeColumnNameForClass(refClassMap);
}
}
if (primColName.Length > 0)
{
name = propertyMap.Name + "_" + primColName;
foreignKeyName += "_" + name;
}
else
{
name = propertyMap.Name;
}
}
if (!(propertyMap.ReferenceType == ReferenceType.None))
{
columnMap.IsForeignKey = true;
columnMap.ForeignKeyName = foreignKeyName;
refClassMap = propertyMap.GetReferencedClassMap();
if (!(refClassMap == null))
{
if (refClassMap.Table.Length > 0)
{
forTableName = refClassMap.Table;
}
else
{
forTableName = GetTableNameForClass(refClassMap);
}
columnMap.PrimaryKeyTable = forTableName;
foreach (IPropertyMap idProp in refClassMap.GetIdentityPropertyMaps())
{
if (idProp.Column.Length > 0)
{
forColumnName = idProp.Column;
}
else
{
forColumnName = GetColumnNameForProperty(idProp);
}
break;
}
columnMap.PrimaryKeyColumn = forColumnName;
}
}
if (generateMappings & propertyMap.Column.Length < 1)
{
classMapClone = targetDomainMap.GetClassMap(classMap.Name);
if (classMapClone == null)
{
classMapClone = (IClassMap) classMap.Clone();
if (tableMap.Name == classTableName)
{
classMapClone.Table = tableMap.Name;
if (!(addToSourceMap.Name == targetDomainMap.Source))
{
classMapClone.Source = addToSourceMap.Name;
}
}
classMapClone.DomainMap = targetDomainMap;
}
propertyMapClone = classMapClone.GetPropertyMap(propertyMap.Name);
if (propertyMapClone == null)
{
propertyMapClone = (IPropertyMap) propertyMap.Clone();
propertyMapClone.ClassMap = classMapClone;
}
propertyMapClone.Column = columnMap.Name;
if (!(tableMap.Name == classTableName))
{
propertyMapClone.Table = tableMap.Name;
if (!(addToSourceMap.Name == classMapClone.Source))
{
if (!(addToSourceMap.Name == targetDomainMap.Source))
{
propertyMapClone.Source = addToSourceMap.Name;
}
}
}
}
if (!(propertyMap.ReferenceType == ReferenceType.None))
{
refClassMap = propertyMap.GetReferencedClassMap();
if (!(refClassMap == null))
{
foreach (IPropertyMap idProp in refClassMap.GetIdentityPropertyMaps())
{
if (cnt > 0)
{
if (idProp.Column.Length > 0)
{
name = idProp.Column;
}
else
{
name = GetColumnNameForProperty(idProp);
}
columnMap = tableMap.GetColumnMap(name);
if (columnMap == null)
{
columnMap = new ColumnMap();
columnMap.Name = name;
columnMap.TableMap = tableMap;
}
columnMap.DataType = GetColumnTypeForProperty(idProp);
columnMap.Length = GetColumnLengthForProperty(idProp);
columnMap.Precision = GetColumnPrecisionForProperty(idProp);
columnMap.Scale = GetColumnScaleForProperty(idProp);
columnMap.IsForeignKey = true;
columnMap.ForeignKeyName = foreignKeyName;
columnMap.PrimaryKeyTable = forTableName;
if (idProp.Column.Length > 0)
{
forColumnName = idProp.Column;
}
else
{
forColumnName = GetColumnNameForProperty(idProp);
}
columnMap.PrimaryKeyColumn = forColumnName;
if (generateMappings)
{
classMapClone = targetDomainMap.GetClassMap(classMap.Name);
if (classMapClone == null)
{
classMapClone = (IClassMap) classMap.Clone();
if (tableMap.Name == classTableName)
{
classMapClone.Table = tableMap.Name;
if (!(addToSourceMap.Name == targetDomainMap.Source))
{
classMapClone.Source = addToSourceMap.Name;
}
}
classMapClone.DomainMap = targetDomainMap;
}
propertyMapClone = classMapClone.GetPropertyMap(propertyMap.Name);
if (propertyMapClone == null)
{
propertyMapClone = (IPropertyMap) propertyMap.Clone();
propertyMapClone.ClassMap = classMapClone;
if (!(tableMap.Name == classTableName))
{
propertyMapClone.Table = tableMap.Name;
if (!(addToSourceMap.Name == classMapClone.Source))
{
if (!(addToSourceMap.Name == targetDomainMap.Source))
{
propertyMapClone.Source = addToSourceMap.Name;
}
}
}
}
found = false;
foreach (string iterName in propertyMapClone.AdditionalColumns)
{
if (iterName == columnMap.Name)
{
found = true;
}
}
if (!(found))
{
propertyMapClone.AdditionalColumns.Add(columnMap.Name);
}
}
}
cnt += 1;
}
if (refClassMap.InheritanceType != InheritanceType.None)
{
if (refClassMap.TypeColumn.Length > 0)
{
primColName = refClassMap.TypeColumn;
}
else
{
primColName = GetTypeColumnNameForClass(refClassMap);
}
name = propertyMap.Name + "_" + primColName;
columnMap = tableMap.GetColumnMap(name);
if (columnMap == null)
{
columnMap = new ColumnMap();
columnMap.Name = name;
columnMap.TableMap = tableMap;
}
columnMap.DataType = DbType.AnsiStringFixedLength;
columnMap.Length = 1;
columnMap.Precision = 1;
columnMap.Scale = 0;
columnMap.AllowNulls = true;
if (propertyMap.IsIdentity)
{
columnMap.AllowNulls = false;
}
columnMap.IsForeignKey = true;
columnMap.ForeignKeyName = foreignKeyName;
columnMap.PrimaryKeyTable = forTableName;
columnMap.PrimaryKeyColumn = primColName;
if (generateMappings)
{
classMapClone = targetDomainMap.GetClassMap(classMap.Name);
if (classMapClone == null)
{
classMapClone = (IClassMap) classMap.Clone();
if (tableMap.Name == classTableName)
{
classMapClone.Table = tableMap.Name;
if (!(addToSourceMap.Name == targetDomainMap.Source))
{
classMapClone.Source = addToSourceMap.Name;
}
}
classMapClone.DomainMap = targetDomainMap;
}
propertyMapClone = classMapClone.GetPropertyMap(propertyMap.Name);
if (propertyMapClone == null)
{
propertyMapClone = (IPropertyMap) propertyMap.Clone();
propertyMapClone.ClassMap = classMapClone;
if (!(tableMap.Name == classTableName))
{
propertyMapClone.Table = tableMap.Name;
if (!(addToSourceMap.Name == classMapClone.Source))
{
if (!(addToSourceMap.Name == targetDomainMap.Source))
{
propertyMapClone.Source = addToSourceMap.Name;
}
}
}
}
found = false;
foreach (string iterName in propertyMapClone.AdditionalColumns)
{
if (iterName == columnMap.Name)
{
found = true;
}
}
if (!(found))
{
propertyMapClone.AdditionalColumns.Add(columnMap.Name);
}
}
}
}
}
}
protected virtual void CreateTypeColumnForClass(IClassMap classMap, IDomainMap targetDomainMap, bool generateMappings)
{
ITableMap tableMap = null;
ISourceMap sourceMap = null;
ISourceMap addToSourceMap = null;
IClassMap classMapClone = null;
IColumnMap columnMap = null;
string tableName = "";
string name = "";
sourceMap = classMap.GetSourceMap();
if (sourceMap == null)
{
sourceMap = classMap.DomainMap.GetSourceMap();
if (sourceMap == null)
{
throw new Exception("No default data source specified for domain model! Can't add table for class!");
}
}
addToSourceMap = targetDomainMap.GetSourceMap(sourceMap.Name);
if (addToSourceMap == null)
{
addToSourceMap = (ISourceMap) sourceMap.Clone();
addToSourceMap.DomainMap = targetDomainMap;
}
if (classMap.Table.Length > 0)
{
tableName = classMap.Table;
}
else
{
tableName = GetTableNameForClass(classMap);
}
tableMap = addToSourceMap.GetTableMap(tableName);
if (tableMap == null)
{
tableMap = new TableMap();
tableMap.Name = tableName;
tableMap.SourceMap = addToSourceMap;
}
if (classMap.TypeColumn.Length > 0)
{
name = classMap.TypeColumn;
}
else
{
name = GetTypeColumnNameForClass(classMap);
}
columnMap = tableMap.GetColumnMap(name);
if (columnMap == null)
{
columnMap = new ColumnMap();
columnMap.Name = name;
columnMap.TableMap = tableMap;
}
columnMap.DataType = DbType.AnsiStringFixedLength;
columnMap.Length = 1;
columnMap.Precision = 1;
columnMap.Scale = 0;
columnMap.IsPrimaryKey = true;
columnMap.AllowNulls = false;
if (generateMappings & classMap.TypeColumn.Length < 1)
{
classMapClone = targetDomainMap.GetClassMap(classMap.Name);
if (classMapClone == null)
{
classMapClone = (IClassMap) classMap.Clone();
classMapClone.DomainMap = targetDomainMap;
}
classMapClone.TypeColumn = name;
}
}
protected virtual void CreateIDColumnForProperty(IPropertyMap propertyMap, IDomainMap targetDomainMap, bool generateMappings, IClassMap ownerClassMap)
{
IClassMap classMap = propertyMap.ClassMap;
ITableMap tableMap = null;
ISourceMap sourceMap = null;
ISourceMap addToSourceMap = null;
IClassMap classMapClone = null;
IPropertyMap propertyMapClone = null;
IColumnMap columnMap = null;
string classTableName = "";
string ownerClassTableName = "";
string name = "";
string forColName = "";
string tableName = "";
string foreignKeyName = "";
bool isClassTableOrConcrete = false;
sourceMap = classMap.GetSourceMap();
if (sourceMap == null)
{
sourceMap = classMap.DomainMap.GetSourceMap();
if (sourceMap == null)
{
throw new Exception("No default data source specified for domain model! Can't add table for class!");
}
}
addToSourceMap = targetDomainMap.GetSourceMap(sourceMap.Name);
if (addToSourceMap == null)
{
addToSourceMap = (ISourceMap) sourceMap.Clone();
addToSourceMap.DomainMap = targetDomainMap;
}
if (propertyMap.ClassMap.Table.Length > 0)
{
classTableName = propertyMap.ClassMap.Table;
}
else
{
classTableName = GetTableNameForClass(propertyMap.ClassMap);
}
if (propertyMap.Table.Length > 0)
{
tableName = propertyMap.Table;
}
else if (propertyMap.IsCollection)
{
tableName = GetTableNameForProperty(propertyMap);
}
else
{
if (IsOutbrokenByInheritance(propertyMap, ownerClassMap))
{
isClassTableOrConcrete = true;
ownerClassTableName = GetTableNameForClass(ownerClassMap, true);
tableName = ownerClassTableName;
}
else
{
tableName = classTableName;
}
}
tableMap = addToSourceMap.GetTableMap(tableName);
if (tableMap == null)
{
tableMap = new TableMap();
tableMap.Name = tableName;
tableMap.SourceMap = addToSourceMap;
}
foreignKeyName = "FK_" + tableMap.Name;
foreach (IPropertyMap idPropertyMap in propertyMap.ClassMap.GetIdentityPropertyMaps())
{
if (idPropertyMap.Column.Length > 0)
{
forColName = idPropertyMap.Column;
}
else
{
forColName = GetColumnNameForProperty(idPropertyMap);
}
foreignKeyName += "_" + forColName;
}
if (!(classMap.InheritanceType == InheritanceType.None))
{
if (classMap.TypeColumn.Length > 0)
{
foreignKeyName += "_" + classMap.TypeColumn;
}
else
{
foreignKeyName += "_" + GetTypeColumnNameForClass(classMap);
}
}
foreach (IPropertyMap idPropertyMap in propertyMap.ClassMap.GetIdentityPropertyMaps())
{
if (idPropertyMap.Column.Length > 0)
{
forColName = idPropertyMap.Column;
}
else
{
forColName = GetColumnNameForProperty(idPropertyMap);
}
if (propertyMap.IdColumn.Length > 0)
{
name = propertyMap.IdColumn;
}
else
{
name = forColName;
}
columnMap = tableMap.GetColumnMap(name);
if (columnMap == null)
{
columnMap = new ColumnMap();
columnMap.Name = name;
columnMap.TableMap = tableMap;
}
columnMap.DataType = GetColumnTypeForProperty(idPropertyMap);
columnMap.Length = GetColumnLengthForProperty(idPropertyMap);
columnMap.Precision = GetColumnPrecisionForProperty(idPropertyMap);
columnMap.Scale = GetColumnScaleForProperty(idPropertyMap);
if (!(propertyMap.IsCollection))
{
columnMap.IsPrimaryKey = true;
columnMap.AllowNulls = false;
}
if (propertyMap.IsCollection || propertyMap.Table.Length > 0 || isClassTableOrConcrete)
{
columnMap.IsForeignKey = true;
columnMap.PrimaryKeyTable = classTableName;
columnMap.PrimaryKeyColumn = forColName;
columnMap.ForeignKeyName = foreignKeyName;
}
if (generateMappings & propertyMap.IdColumn.Length < 1)
{
classMapClone = targetDomainMap.GetClassMap(classMap.Name);
if (classMapClone == null)
{
classMapClone = (IClassMap) classMap.Clone();
classMapClone.DomainMap = targetDomainMap;
}
propertyMapClone = classMapClone.GetPropertyMap(propertyMap.Name);
if (propertyMapClone == null)
{
propertyMapClone = (IPropertyMap) propertyMap.Clone();
propertyMapClone.ClassMap = classMapClone;
}
propertyMapClone.IdColumn = columnMap.Name;
if (tableMap.Name != classTableName)
{
propertyMapClone.Table = tableMap.Name;
if (!(addToSourceMap.Name == classMapClone.Source))
{
if (!(addToSourceMap.Name == targetDomainMap.Source))
{
propertyMapClone.Source = addToSourceMap.Name;
}
}
}
}
}
if (classMap.InheritanceType != InheritanceType.None)
{
if (classMap.TypeColumn.Length > 0)
{
name = classMap.TypeColumn;
}
else
{
name = GetTypeColumnNameForClass(classMap);
}
columnMap = tableMap.GetColumnMap(name);
if (columnMap == null)
{
columnMap = new ColumnMap();
columnMap.Name = name;
columnMap.TableMap = tableMap;
}
columnMap.DataType = DbType.AnsiStringFixedLength;
columnMap.Length = 1;
columnMap.Precision = 1;
columnMap.Scale = 0;
if (!(propertyMap.IsCollection))
{
columnMap.IsPrimaryKey = true;
columnMap.ForeignKeyName = foreignKeyName;
columnMap.AllowNulls = false;
}
columnMap.IsForeignKey = true;
columnMap.PrimaryKeyTable = classTableName;
columnMap.PrimaryKeyColumn = name;
if (generateMappings)
{
classMapClone = targetDomainMap.GetClassMap(classMap.Name);
if (classMapClone == null)
{
classMapClone = (IClassMap) classMap.Clone();
classMapClone.DomainMap = targetDomainMap;
}
propertyMapClone = classMapClone.GetPropertyMap(propertyMap.Name);
if (propertyMapClone == null)
{
propertyMapClone = (IPropertyMap) propertyMap.Clone();
propertyMapClone.ClassMap = classMapClone;
}
foreach (string iterName in propertyMapClone.AdditionalIdColumns)
{
if (iterName == columnMap.Name)
{
return;
}
}
propertyMapClone.AdditionalIdColumns.Add(columnMap.Name);
}
}
}
protected virtual void DeserializeColumnMap(ITableMap tableMap, XmlNode xmlCol)
{
IColumnMap columnMap = new ColumnMap();
columnMap.TableMap = tableMap;
if (!(xmlCol.Attributes["name"] == null))
{
columnMap.Name = xmlCol.Attributes["name"].Value;
}
if (!(xmlCol.Attributes["type"] == null))
{
columnMap.DataType = (DbType) Enum.Parse(typeof (DbType), xmlCol.Attributes["type"].Value);
}
if (!(xmlCol.Attributes["format"] == null))
{
columnMap.Format = xmlCol.Attributes["format"].Value;
}
if (!(xmlCol.Attributes["default"] == null))
{
columnMap.DefaultValue = xmlCol.Attributes["default"].Value;
}
if (!(xmlCol.Attributes["foreign-key"] == null))
{
columnMap.ForeignKeyName = xmlCol.Attributes["foreign-key"].Value;
}
if (!(xmlCol.Attributes["primary-table"] == null))
{
columnMap.PrimaryKeyTable = xmlCol.Attributes["primary-table"].Value;
}
if (!(xmlCol.Attributes["primary-column"] == null))
{
columnMap.PrimaryKeyColumn = xmlCol.Attributes["primary-column"].Value;
}
if (!(xmlCol.Attributes["sequence"] == null))
{
columnMap.Sequence = xmlCol.Attributes["sequence"].Value;
}
if (!(xmlCol.Attributes["specific-type"] == null))
{
columnMap.SpecificDataType = xmlCol.Attributes["specific-type"].Value;
}
if (!(xmlCol.Attributes["allow-null"] == null))
{
columnMap.AllowNulls = ParseBool(xmlCol.Attributes["allow-null"].Value);
}
if (!(xmlCol.Attributes["auto-inc"] == null))
{
columnMap.IsAutoIncrease = ParseBool(xmlCol.Attributes["auto-inc"].Value);
}
if (!(xmlCol.Attributes["primary"] == null))
{
columnMap.IsPrimaryKey = ParseBool(xmlCol.Attributes["primary"].Value);
}
if (!(xmlCol.Attributes["foreign"] == null))
{
columnMap.IsForeignKey = ParseBool(xmlCol.Attributes["foreign"].Value);
}
if (!(xmlCol.Attributes["fixed"] == null))
{
columnMap.IsFixedLength = ParseBool(xmlCol.Attributes["fixed"].Value);
}
if (!(xmlCol.Attributes["seed"] == null))
{
columnMap.Seed = System.Convert.ToInt32(xmlCol.Attributes["seed"].Value);
}
if (!(xmlCol.Attributes["inc"] == null))
{
columnMap.Increment = System.Convert.ToInt32(xmlCol.Attributes["inc"].Value);
}
if (!(xmlCol.Attributes["length"] == null))
{
columnMap.Length = System.Convert.ToInt32(xmlCol.Attributes["length"].Value);
}
if (!(xmlCol.Attributes["prec"] == null))
{
columnMap.Precision = System.Convert.ToInt32(xmlCol.Attributes["prec"].Value);
}
if (!(xmlCol.Attributes["scale"] == null))
{
columnMap.Scale = System.Convert.ToInt32(xmlCol.Attributes["scale"].Value);
}
ArrayList metaData = columnMap.MetaData;
DeserializeMetaData(xmlCol, ref metaData);
}
public override IMap DeepClone()
{
IColumnMap columnMap = new ColumnMap();
DeepCopy(columnMap);
return columnMap;
}