C# IClassMap.GetTableMap方法代码示例

		/// <summary>
		/// Generates custom fields and methods of the class.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="classMap">The class map.</param>
		public override void GenerateCustomFieldsAndMethods(StreamWriter file, IClassMap classMap)
		{
			ArrayList		allColumns = classMap.GetTableMap().ColumnMaps;
			IColumnMap[]	allColumnsTyped = (IColumnMap[]) allColumns.ToArray(typeof (IColumnMap));
			string			columnNames = StringUtility.CombineObjects(allColumnsTyped, MapToStringConverters.Columns).ToString();

			file.WriteLine("		protected static readonly string c_rowFields = \"" + columnNames + "\";");
			
			base.GenerateCustomFieldsAndMethods(file, classMap);
		}

		/// <summary>
		/// Generates all the 'find' methods of this interface.
		/// </summary>
		/// <param name="classMap">The class map.</param>
		/// <param name="file">The file.</param>
		private static void GenerateFindMethods (IClassMap classMap, StreamWriter file)
		{				
			// method name
			file.Write("		" + EntityGenerator.GetTypeName(classMap) + " Find(");
			ArrayList primaryColumns = classMap.GetTableMap().GetPrimaryKeyColumnMaps();

			// method's params
			bool first = true;
			foreach (IColumnMap columnMap in primaryColumns)
			{
				IPropertyMap propertyMap = classMap.GetPropertyMapForColumnMap(columnMap);

				if (!first)
				{
					file.Write(", ");
				}

				// param type and name
				string paramName = ClassUtility.GetParamName(propertyMap);
				string paramType = ClassUtility.ConvertColumnTypeToCsType(columnMap.DataType);
				file.Write(paramType + " " + paramName);
				first = false;

			}
			file.Write(");");

			file.WriteLine();
		}

		/// <summary>
		/// Generates the 'find' method.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="classMap">The class map.</param>
		public override void GenerateFind(StreamWriter file, IClassMap classMap)
		{
			ArrayList primaryColumns = classMap.GetTableMap().GetPrimaryKeyColumnMaps();

			StringBuilder whereQuery = new StringBuilder();
			StringBuilder findParams = new StringBuilder();
			bool first = true;

			foreach (IColumnMap primColumn in primaryColumns)
			{
				IPropertyMap propertyMap = classMap.GetPropertyMapForColumnMap(primColumn);

				if (!first)
				{
					whereQuery.Append(", ");
					findParams.Append(", ");
				}

				whereQuery
					.Append('`')
					.Append(primColumn.Name)
					.Append("`='\" + m_state.EscapeString(")
					.Append(ClassUtility.GetParamName(propertyMap))
					.Append(".ToString()) + \"'");

				string paramName = ClassUtility.GetParamName(propertyMap);
				string paramType = ClassUtility.ConvertColumnTypeToCsType(primColumn.DataType);
					
				findParams.Append(paramType + " " + paramName);

				first = false;
			}
			
			string entityClassName = EntityGenerator.GetTypeName(classMap);
			string sqlCommand = "SELECT \" + c_rowFields + \""
				+ " FROM `" + classMap.GetTableMap().Name + "`"
				+ " WHERE " + whereQuery.ToString();

			file.WriteLine("		public virtual " + entityClassName + " Find(" + findParams.ToString() + ")");
			file.WriteLine("		{");
			file.WriteLine("			" + entityClassName + " result = new " + entityClassName + "();");
			file.WriteLine("			string command = \"" + sqlCommand + "\";");
			file.WriteLine();
			file.WriteLine("			m_state.ExecuteQuery(");
			file.WriteLine("				command,");
			file.WriteLine("				CommandBehavior.SingleRow,");
			file.WriteLine("				delegate(MySqlDataReader reader)");
			file.WriteLine("				{");
			file.WriteLine("					if (!reader.Read())");
			file.WriteLine("					{");
			file.WriteLine("						result = null;");
			file.WriteLine("					}");
			file.WriteLine("					else");
			file.WriteLine("					{");
			file.WriteLine("						FillEntityWithRow(ref result, reader);");
			file.WriteLine("					}");
			file.WriteLine("				}");
			file.WriteLine("			);");
			file.WriteLine();
			file.WriteLine("			return result;");
			file.WriteLine("		}");
			file.WriteLine();
		}

		/// <summary>
		/// Generates the 'verify schema' code.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="classMap">The class map.</param>
		public override void GenerateVerifySchema(StreamWriter file, IClassMap classMap)
		{
#warning TODO: finish VerifySchema method
			if (classMap.PropertyMaps.Count <= 0)
			{
				file.WriteLine("			return null; // no property maps");
				return; // ???
			}
			
			// no table - create it
			bool firstColumn = true;
			StringBuilder sqlCommandText = new StringBuilder("\"CREATE TABLE IF NOT EXISTS `" + classMap.Table + "` (\"", classMap.PropertyMaps.Count * 16);
			foreach (IPropertyMap propertyMap in classMap.PropertyMaps)
			{
				IColumnMap columnMap = propertyMap.GetColumnMap();

				// close prev statement's quote, start new line
				if (firstColumn)
				{
					sqlCommandText.Append("\n");
					firstColumn = false;
				}
				else
				{
					sqlCommandText.Append(",\"\n");
				}

				// opening quote
				sqlCommandText.Append("				+\"");

				
				// build one field creation statement
				sqlCommandText
					.Append("`")
					.Append(columnMap.Name)
					.Append("` ")
					.Append(MySqlUtility.GetDataType(columnMap));

				// is nulls allowed
				if (!columnMap.AllowNulls)
				{
					sqlCommandText.Append(" NOT NULL");
				}

				// default value
				if (columnMap.DefaultValue != null && columnMap.DefaultValue.Length > 0)
				{
					sqlCommandText
						.Append(" default '")
						.Append(MySqlUtility.Escape(columnMap.DefaultValue))
						.Append("'");
				}
				
				// auto_increment?
				if (columnMap.IsAutoIncrease)
				{
					sqlCommandText.Append(" auto_increment");
				}
			}

			// close last statement's quotes, start new line
			sqlCommandText.Append("\"\n");

			// primary keys
			ArrayList		primaryKeyMaps = classMap.GetTableMap().GetPrimaryKeyColumnMaps();
			if (primaryKeyMaps.Count > 0)
			{
				// opening quote
				sqlCommandText.Append("				+\"");
				
				// write primary key name and open fields list
				string pkName = StringUtility.CombineObjects((IColumnMap[])primaryKeyMaps.ToArray(typeof(IColumnMap)), MapToStringConverters.Join).ToString();
				sqlCommandText.Append(", primary key `" + pkName + "`");

				// combine primary key fields
				IColumnMap[]	primaryKeyMapsTyped = (IColumnMap[])primaryKeyMaps.ToArray(typeof(IColumnMap));
				StringBuilder	primaryKeyMapNames = StringUtility.CombineObjects(primaryKeyMapsTyped, MapToStringConverters.Columns);

				sqlCommandText.Append(" (");
				sqlCommandText.Append(primaryKeyMapNames);
				sqlCommandText.Append(")\"\n");
			}
			else
			{
				// no primary
//				sqlCommandText.Append("\n");
			}
			
			// close the field list
			sqlCommandText.Append("				+\")\"");

			
			
			// write to file
			file.WriteLine("			m_state.ExecuteNonQuery(" + sqlCommandText.ToString() + "\n			);");
//.........这里部分代码省略.........

		/// <summary>
		/// Generates the 'select all' method.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="classMap">The class map.</param>
		public override void GenerateSelectAll(StreamWriter file, IClassMap classMap)
		{
			string sqlCommand = "SELECT \" + c_rowFields + \" FROM `" + classMap.GetTableMap().Name + "`";
			string entityClassName = EntityGenerator.GetTypeName(classMap);

			// create an array and store results
			file.WriteLine("			" + entityClassName + " entity;");
			file.WriteLine("			List<" + entityClassName + "> results = null;");
			file.WriteLine();
			file.WriteLine("			m_state.ExecuteQuery(");
			file.WriteLine("				\"" + sqlCommand + "\",");
			file.WriteLine("				CommandBehavior.Default,");
			file.WriteLine("				delegate(MySqlDataReader reader)");
			file.WriteLine("				{");
			file.WriteLine("					results = new List<" + entityClassName + ">();");
			file.WriteLine("					while (reader.Read())");
			file.WriteLine("					{");
			file.WriteLine("						entity = new " + entityClassName + "();");
			file.WriteLine("						FillEntityWithRow(ref entity, reader);");
			file.WriteLine("						results.Add(entity);");
			file.WriteLine("					}");
			file.WriteLine("				}");
			file.WriteLine("			);");
			file.WriteLine();
			file.WriteLine("			return results;");
		}

		/// <summary>
		/// Generates the 'count all' method.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="classMap">The class map.</param>
		public override void GenerateCountAll(StreamWriter file, IClassMap classMap)
		{
			string sqlCommand = "SELECT COUNT(*) FROM `" + classMap.GetTableMap().Name + "`";

			file.WriteLine("			return (long) m_state.ExecuteScalar(\"" + sqlCommand + "\");");
		}

		/// <summary>
		/// Generates the 'delete' method.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="classMap">The class map.</param>
		public override void GenerateDelete(StreamWriter file, IClassMap classMap)
		{
			ArrayList primaryColumns = classMap.GetTableMap().GetPrimaryKeyColumnMaps();

			bool first = true;
			StringBuilder whereQuery = new StringBuilder(16 * primaryColumns.Count);

			foreach (IColumnMap columnMap in primaryColumns)
			{
				IPropertyMap propertyMap = classMap.GetPropertyMapForColumnMap(columnMap);
				
				if (!first)
				{
					whereQuery.Append("AND ");
				}

				whereQuery
					.Append('`')
					.Append(columnMap.Name)
					.Append("`='\" + m_state.EscapeString(")
					.Append("obj." + propertyMap.Name)
					.Append(".ToString()) + \"'");

				first = false;
			}

			string sqlCommand = "DELETE FROM `" + classMap.GetTableMap().Name + "`"
				+ " WHERE " + whereQuery.ToString();

			file.WriteLine("			m_state.ExecuteNonQuery(");
			file.WriteLine("				\"" + sqlCommand + "\");");
		}

		/// <summary>
		/// Generates the 'create' method.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="classMap">The class map.</param>
		public override void GenerateCreate(StreamWriter file, IClassMap classMap)
		{
			bool first = true;

			// create fields list
			StringBuilder valuesQuery = new StringBuilder(16 * classMap.PropertyMaps.Count);
			foreach (IPropertyMap propertyMap in classMap.PropertyMaps)
			{
				if (!first)
				{
					valuesQuery.Append(",");
				}

				valuesQuery.Append("'\" + m_state.EscapeString(obj." + propertyMap.Name + ".ToString()) + \"'");
				
				first = false;
			}

			string sqlCommand = "INSERT INTO `" + classMap.GetTableMap().Name + "`"
				+ " VALUES (" + valuesQuery + ");";
			
			// find auto_incremented values
			IPropertyMap autoIncrementProperty = null;
			foreach (IPropertyMap propertyMap in classMap.PropertyMaps)
			{
				IColumnMap columnMap = propertyMap.GetColumnMap();
				if (columnMap.IsAutoIncrease)
				{
					// just one auto_increment column
					autoIncrementProperty = propertyMap;
					break;
				}
			}

			file.WriteLine("			m_state.ExecuteNonQuery(");
			file.WriteLine("				\"" + sqlCommand + "\");");
			
			if (autoIncrementProperty != null)
			{
				file.WriteLine("			object insertedId = m_state.ExecuteScalar(\"SELECT LAST_INSERT_ID();\");");
				file.WriteLine("			obj." + autoIncrementProperty.Name + " = (" + ClassUtility.ConvertColumnTypeToCsType(autoIncrementProperty.GetColumnMap().DataType) + ") (long) insertedId;");
			}
		}

		/// <summary>
		/// Generates the 'count by' method.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="propertyMaps">The property maps.</param>
		/// <param name="returnedClassMap">The returned class map.</param>
		public override void GenerateCountBy(StreamWriter file, IList<IPropertyMap> propertyMaps, IClassMap returnedClassMap)
		{
			ArrayList allColumns = returnedClassMap.GetTableMap().ColumnMaps;

			// build the 'where' statement
			bool first = true;
			StringBuilder whereQuery = new StringBuilder(16 * propertyMaps.Count);
			foreach (IPropertyMap propertyMap in propertyMaps)
			{
				if (!first)
				{
					whereQuery.Append(" AND ");
				}

				whereQuery
					.Append('`')
					.Append(propertyMap.GetColumnMap().Name)
					.Append("`='\" + m_state.EscapeString(")
					.Append(ClassUtility.GetParamName(propertyMap))
					.Append(".ToString()) + \"'");

				first = false;
			}

			string entityClassName = EntityGenerator.GetTypeName(returnedClassMap);
			string sqlCommand = "SELECT  count(*)"
				+ " FROM `" + returnedClassMap.GetTableMap().Name + "`"
				+ " WHERE " + whereQuery.ToString();

			// create an array and store results
			file.WriteLine();
			file.WriteLine("			return (long) m_state.ExecuteScalar(");
			file.WriteLine("				\"" + sqlCommand + "\");");
			file.WriteLine();
		}

		/// <summary>
		/// Generates the 'find by' method.
		/// </summary>
		/// <param name="file">The file.</param>
		/// <param name="propertyMaps">The property maps.</param>
		/// <param name="returnedClassMap">The returned class map.</param>
		public override void GenerateFindBy(StreamWriter file, IList<IPropertyMap> propertyMaps, IClassMap returnedClassMap)
		{
			ArrayList allColumns = returnedClassMap.GetTableMap().ColumnMaps;
			
			// build the 'where' statement
			bool first = true;
			StringBuilder whereQuery = new StringBuilder(16 * propertyMaps.Count);
			foreach (IPropertyMap propertyMap in propertyMaps)
			{
				if (!first)
				{
					whereQuery.Append(" AND ");
				}

				whereQuery
					.Append('`')
					.Append(propertyMap.GetColumnMap().Name)
					.Append("`='\" + m_state.EscapeString(")
					.Append(ClassUtility.GetParamName(propertyMap))
					.Append(".ToString()) + \"'");
				
				first = false;
			}

			string entityClassName = EntityGenerator.GetTypeName(returnedClassMap);
			string sqlCommand = "SELECT  \" + c_rowFields + \""
				+ " FROM `" + returnedClassMap.GetTableMap().Name + "`"
				+ " WHERE " + whereQuery.ToString();

			// create an array and store results
			file.WriteLine("			" + entityClassName + " entity;");
			file.WriteLine("			List<" + entityClassName + "> results = null;");
			file.WriteLine();
			file.WriteLine("			m_state.ExecuteQuery(");
			file.WriteLine("				\"" + sqlCommand + "\",");
			file.WriteLine("				CommandBehavior.Default,");
			file.WriteLine("				delegate(MySqlDataReader reader)");
			file.WriteLine("				{");
			file.WriteLine("					results = new List<" + entityClassName + ">(reader.FieldCount);");
			file.WriteLine("					while (reader.Read())");
			file.WriteLine("					{");
            file.WriteLine("						entity = new " + entityClassName + "();");
			file.WriteLine("						FillEntityWithRow(ref entity, reader);");
			file.WriteLine("						results.Add(entity);");
			file.WriteLine("					}");
			file.WriteLine("				}");
			file.WriteLine("			);");
			file.WriteLine();
			file.WriteLine("			return results;");
		}

        public virtual void VerifyClassMap(IClassMap classMap)
        {
            bool failedSorting = false;
            IClassMap superClassMap = null;
            if (classMap.Name.Length < 1)
            {
                HandleVerifyException(classMap, "Class name must not be empty!", "Name"); // do not localize
            }

            if (classMap.ClassType == ClassType.Class || classMap.ClassType == ClassType.Default)
            {
                superClassMap = classMap.GetInheritedClassMap();
                if (superClassMap != null)
                {
                    if (!(classMap.IsLegalAsSuperClass(superClassMap)))
                    {
                        HandleVerifyException(classMap, "Inherited class '" + superClassMap.Name + "' is illegal as superclass for this class! Creates cyclic inheritance graph, which is a very serious error, potentially leading to infinite loops! No more verification of this class or its properties will be made until this error is corrected! (" + GetClassType(classMap) + ": '" + classMap.Name + "')", "InheritsClass"); // do not localize
                        return;
                    }
                }
                bool checkMappings = this.checkOrmMappings;
                if (classMap.IsAbstract)
                {
                    if (classMap.InheritanceType == InheritanceType.ConcreteTableInheritance)
                    {
                        checkMappings = false;
                    }
                }
                if (checkMappings)
                {
                    if (classMap.SourceClass.Length > 0)
                    {
                        if (classMap.GetSourceClassMap() == null)
                        {
                            HandleVerifyException(classMap, "Source class not found! (Class: '" + classMap.Name + "', Source class: '" + classMap.SourceClass + "')", "SourceClass"); // do not localize
                        }
                    }
                    else
                    {
                        if (classMap.Table.Length < 1)
                        {
                            HandleVerifyException(classMap, "Table name must not be empty! (" + GetClassType(classMap) + ": '" + classMap.Name + "')", "Table"); // do not localize
                        }
                        if (classMap.GetTableMap() == null)
                        {
                            HandleVerifyException(classMap, "Table not found! (" + GetClassType(classMap) + ": '" + classMap.Name + "', Table: '" + classMap.Table + "')", "Table"); // do not localize
                        }
                        if (classMap.TypeColumn.Length > 0)
                        {
                            if (classMap.GetTypeColumnMap() == null)
                            {
                                HandleVerifyException(classMap, "Type column not found! (" + GetClassType(classMap) + ": '" + classMap.Name + "', Type column: '" + classMap.TypeColumn + "')", "TypeColumn"); // do not localize
                            }
                            if (classMap.TypeValue.Length < 1)
                            {
                                HandleVerifyException(classMap, "Type column supplied but no type value! (" + GetClassType(classMap) + ": '" + classMap.Name + "', Type column: '" + classMap.TypeColumn + "')", "TypeColumn"); // do not localize
                            }
                        }
                    }
                    if (classMap.TypeValue.Length > 0)
                    {
                        if (classMap.TypeColumn.Length < 1)
                        {
                            HandleVerifyException(classMap, "Type value supplied but no type column! (" + GetClassType(classMap) + ": '" + classMap.Name + "', Type value: '" + classMap.TypeValue + "')", "TypeValue"); // do not localize
                        }
                        VerifyUniqueTypeValue(classMap);
                    }

                }
                if (classMap.InheritsClass.Length > 0)
                {
                    if (superClassMap == null)
                    {
                        HandleVerifyException(classMap, "Inherited class not found! (" + GetClassType(classMap) + ": '" + classMap.Name + "', Inherited class: '" + classMap.InheritsClass + "')", "InheritsClass"); // do not localize
                    }
                }
                if (classMap.GetSortedIdentityPropertyMaps(ref failedSorting, true).Count < 1)
                {
                    HandleVerifyException(classMap, "Class must have at least one identity property! (" + GetClassType(classMap) + ": '" + classMap.Name + "')", "PropertyMaps"); // do not localize
                }
                if (failedSorting)
                {
                    HandleVerifyException(classMap, "Failed sorting identity properties due to invalid indexes! (" + GetClassType(classMap) + ": '" + classMap.Name + "')", "PropertyMaps"); // do not localize
                }
                if (classMap.IsInHierarchy())
                {
                    if (classMap.InheritanceType == InheritanceType.None)
                    {
                        HandleVerifyException(classMap, "Inheritance type must be specified for class that is part of an inheritance hierarchy! (" + GetClassType(classMap) + ": '" + classMap.Name + "')", "InheritanceType"); // do not localize
                    }
                    else
                    {
                        if (classMap.InheritanceType == InheritanceType.ConcreteTableInheritance)
                        {
                            if (superClassMap != null)
                            {
                                if (!(classMap.IsAbstract))
                                {
                                    foreach (IPropertyMap propertyMap in classMap.GetAllPropertyMaps())
                                    {
//.........这里部分代码省略.........