[Nhibernate-commit] SF.net SVN: nhibernate:[5560] trunk/nhibernate/src/NHibernate.Test/ SqlCommandTest

[<pa...@us...>]

Revision: 5560
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5560&view=rev
Author:   patearl
Date:     2011-03-28 03:47:26 +0000 (Mon, 28 Mar 2011)

Log Message:
-----------
Tests: Use dialect-specific false literals in SqlCommandTests.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlInsertBuilderFixture.cs
    trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlUpdateBuilderFixture.cs

Modified: trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlInsertBuilderFixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlInsertBuilderFixture.cs	2011-03-28 03:45:18 UTC (rev 5559)
+++ trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlInsertBuilderFixture.cs	2011-03-28 03:47:26 UTC (rev 5560)
@@ -32,8 +32,9 @@
 			SqlCommandInfo sqlCommand = insert.ToSqlCommandInfo();
 			SqlType[] actualParameterTypes = sqlCommand.ParameterTypes;
 
+		    string falseString = factoryImpl.Dialect.ToBooleanValueString(false);
 			string expectedSql =
-				"INSERT INTO test_insert_builder (intColumn, longColumn, literalColumn, stringColumn) VALUES (?, ?, 0, 5)";
+                "INSERT INTO test_insert_builder (intColumn, longColumn, literalColumn, stringColumn) VALUES (?, ?, " + falseString + ", 5)";
 			Assert.AreEqual(expectedSql, sqlCommand.Text.ToString(), "SQL String");
 
 			Assert.AreEqual(2, actualParameterTypes.Length);
@@ -78,8 +79,9 @@
 			SqlCommandInfo sqlCommand = insert.ToSqlCommandInfo();
 			SqlType[] actualParameterTypes = sqlCommand.ParameterTypes;
 
-			string expectedSql =
-				"INSERT INTO test_insert_builder (literalColumn, intColumn, stringColumn, longColumn) VALUES (0, ?, 5, ?)";
+            string falseString = factoryImpl.Dialect.ToBooleanValueString(false);
+            string expectedSql =
+                "INSERT INTO test_insert_builder (literalColumn, intColumn, stringColumn, longColumn) VALUES (" + falseString + ", ?, 5, ?)";
 			Assert.AreEqual(expectedSql, sqlCommand.Text.ToString(), "SQL String");
 
 			Assert.AreEqual(2, actualParameterTypes.Length);

Modified: trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlUpdateBuilderFixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlUpdateBuilderFixture.cs	2011-03-28 03:45:18 UTC (rev 5559)
+++ trunk/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlUpdateBuilderFixture.cs	2011-03-28 03:47:26 UTC (rev 5560)
@@ -38,8 +38,9 @@
 			SqlCommandInfo sqlCommand = update.ToSqlCommandInfo();
 
 			Assert.AreEqual(CommandType.Text, sqlCommand.CommandType);
-			string expectedSql =
-				"UPDATE test_update_builder SET intColumn = ?, longColumn = ?, literalColumn = 0, stringColumn = 5 WHERE decimalColumn = ? AND versionColumn = ? AND a=b";
+            string falseString = factoryImpl.Dialect.ToBooleanValueString(false);
+            string expectedSql =
+                "UPDATE test_update_builder SET intColumn = ?, longColumn = ?, literalColumn = " + falseString + ", stringColumn = 5 WHERE decimalColumn = ? AND versionColumn = ? AND a=b";
 			Assert.AreEqual(expectedSql, sqlCommand.Text.ToString(), "SQL String");
 
 			SqlType[] actualParameterTypes = sqlCommand.ParameterTypes;


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