[Nhibernate-commit] SF.net SVN: nhibernate:[3837] branches/static-proxies/src/NHibernate.Test/ DialectTest/SQLiteDialectFixture.cs

[<aye...@us...>]

Revision: 3837
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=3837&view=rev
Author:   ayenderahien
Date:     2008-10-10 22:41:30 +0000 (Fri, 10 Oct 2008)

Log Message:
-----------
NH-1520  SQLite Dialect does not properly escape names surrounded by backticks

Modified Paths:
--------------
    branches/static-proxies/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs

Modified: branches/static-proxies/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs
===================================================================
--- branches/static-proxies/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs	2008-10-10 21:36:28 UTC (rev 3836)
+++ branches/static-proxies/src/NHibernate.Test/DialectTest/SQLiteDialectFixture.cs	2008-10-10 22:41:30 UTC (rev 3837)
@@ -43,6 +43,48 @@
         }
 
         [Test]
+        public void QuotedTableNameWithoutSchemaWithSqlLite()
+        {
+            Table tbl = new Table();
+            tbl.Name = "`name`";
+
+            Assert.AreEqual("\"name\"", tbl.GetQualifiedName(dialect));
+        }
+
+        [Test]
+        public void QuotedSchemaNameWithUnqoutedTableInSqlLite()
+        {
+            Table tbl = new Table();
+            tbl.Schema = "`schema`";
+            tbl.Name = "name";
+
+            Assert.AreEqual("\"schema_name\"", tbl.GetQualifiedName(dialect));
+            Assert.AreEqual("\"schema_table\"", dialect.Qualify("", "\"schema\"", "table"));
+        }
+
+        [Test]
+        public void QuotedCatalogSchemaNameWithSqlLite()
+        {
+            Table tbl = new Table();
+            tbl.Catalog = "dbo";
+            tbl.Schema = "`schema`";
+            tbl.Name = "`name`";
+
+            Assert.AreEqual("\"dbo_schema_name\"", tbl.GetQualifiedName(dialect));
+            Assert.AreEqual("\"dbo_schema_table\"", dialect.Qualify("dbo", "\"schema\"", "\"table\""));
+        }
+
+        [Test]
+        public void QuotedTableNameWithSqlLite()
+        {
+            Table tbl = new Table();
+            tbl.Name = "`Group`";
+
+            Assert.AreEqual("\"Group\"", tbl.GetQualifiedName(dialect));
+        }
+
+
+        [Test]
         public void SchemaNameWithSqlLite()
         {
             Table tbl = new Table();


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