[Nhibernate-commit] SF.net SVN: nhibernate:[4041] trunk/nhibernate/src/NHibernate/Dialect/ Schema/OracleMetaData.cs

[<fab...@us...>]

Revision: 4041
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4041&view=rev
Author:   fabiomaulo
Date:     2009-02-04 20:10:30 +0000 (Wed, 04 Feb 2009)

Log Message:
-----------
Fixed OracleMetaData for SchemaUpdate and SchemaValidation

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/Schema/OracleMetaData.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/Schema/OracleMetaData.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/Schema/OracleMetaData.cs	2009-02-04 17:52:02 UTC (rev 4040)
+++ trunk/nhibernate/src/NHibernate/Dialect/Schema/OracleMetaData.cs	2009-02-04 20:10:30 UTC (rev 4041)
@@ -12,6 +12,46 @@
 		{
 			return new OracleTableMetadata(rs, this, extras);
 		}
+
+		public override bool StoresUpperCaseIdentifiers
+		{
+			get { return true; }
+		}
+
+		public override DataTable GetTables(string catalog, string schemaPattern, string tableNamePattern, string[] types)
+		{
+			string owner = string.IsNullOrEmpty(schemaPattern) ? null : schemaPattern;
+			var restrictions = new[] { owner, tableNamePattern };
+			return Connection.GetSchema("Tables", restrictions);
+		}
+
+		public override DataTable GetColumns(string catalog, string schemaPattern, string tableNamePattern, string columnNamePattern)
+		{
+			string owner = string.IsNullOrEmpty(schemaPattern) ? null : schemaPattern;
+			var restrictions = new[] { owner, tableNamePattern, columnNamePattern };
+			return Connection.GetSchema("Columns", restrictions);
+		}
+
+		public override DataTable GetIndexColumns(string catalog, string schemaPattern, string tableName, string indexName)
+		{
+			string owner = string.IsNullOrEmpty(schemaPattern) ? null : schemaPattern;
+			var restrictions = new[] { owner, indexName, null, tableName, null };
+			return Connection.GetSchema("IndexColumns", restrictions);
+		}
+
+		public override DataTable GetIndexInfo(string catalog, string schemaPattern, string tableName)
+		{
+			string owner = string.IsNullOrEmpty(schemaPattern) ? null : schemaPattern;
+			var restrictions = new[] { owner, null, null, tableName };
+			return Connection.GetSchema("Indexes", restrictions);
+		}
+
+		public override DataTable GetForeignKeys(string catalog, string schema, string table)
+		{
+			string owner = string.IsNullOrEmpty(schema) ? null : schema;
+			var restrictions = new[] { owner, table, null };
+			return Connection.GetSchema("ForeignKeys", restrictions);
+		}
 	}
 
 	public class OracleTableMetadata : AbstractTableMetadata
@@ -28,7 +68,7 @@
 
 		protected override string GetConstraintName(DataRow rs)
 		{
-			return Convert.ToString(rs["FOREIGN_KEY_CONSTRIANT_NAME"]);
+			return Convert.ToString(rs["FOREIGN_KEY_CONSTRAINT_NAME"]);
 		}
 
 		protected override string GetColumnName(DataRow rs)
@@ -92,7 +132,7 @@
 		public OracleForeignKeyMetadata(DataRow rs)
 			: base(rs)
 		{
-			Name = Convert.ToString(rs["FOREIGN_KEY_CONSTRIANT_NAME"]);
+			Name = Convert.ToString(rs["FOREIGN_KEY_CONSTRAINT_NAME"]);
 		}
 	}
 }


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.