[Nhibernate-commit] SF.net SVN: nhibernate:[5108] trunk/nhibernate/src/NHibernate.Test/HQL/Ast/ QuerySubstitutionTest.cs

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

Revision: 5108
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5108&view=rev
Author:   fabiomaulo
Date:     2010-08-04 17:30:13 +0000 (Wed, 04 Aug 2010)

Log Message:
-----------
Minor (Check NH-2089 with strings substitution)

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/HQL/Ast/QuerySubstitutionTest.cs

Modified: trunk/nhibernate/src/NHibernate.Test/HQL/Ast/QuerySubstitutionTest.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/HQL/Ast/QuerySubstitutionTest.cs	2010-08-04 17:21:44 UTC (rev 5107)
+++ trunk/nhibernate/src/NHibernate.Test/HQL/Ast/QuerySubstitutionTest.cs	2010-08-04 17:30:13 UTC (rev 5108)
@@ -10,13 +10,13 @@
 		protected override void Configure(NHibernate.Cfg.Configuration configuration)
 		{
 			base.Configure(configuration);
-			configuration.SessionFactory().Integrate.CreateCommands.WithHqlToSqlSubstitutions("pizza 1");
+			configuration.SessionFactory().Integrate.CreateCommands.WithHqlToSqlSubstitutions("pizza 1, calda 'bobrock'");
 		}
-		const string query = "from SimpleClass s where s.IntValue > pizza";
 
 		[Test]
 		public void WhenSubstitutionsConfiguredThenUseItInTranslation()
 		{
+			const string query = "from SimpleClass s where s.IntValue > pizza";
 			var sql = GetSql(query, new Dictionary<string, string>{{"pizza","1"}});
 			sql.Should().Not.Contain("pizza");
 		}
@@ -24,6 +24,7 @@
 		[Test]
 		public void WhenExecutedThroughSessionThenUseSubstitutions()
 		{
+			const string query = "from SimpleClass s where s.IntValue > pizza";
 			using (var s = OpenSession())
 			{
 				using (SqlLogSpy sqlLogSpy = new SqlLogSpy())
@@ -34,5 +35,28 @@
 				}
 			}
 		}
+
+		[Test]
+		public void WhenSubstitutionsWithStringConfiguredThenUseItInTranslation()
+		{
+			const string query = "from SimpleClass s where s.Description > calda";
+			var sql = GetSql(query, new Dictionary<string, string> { { "calda", "'bobrock'" } });
+			sql.Should().Not.Contain("pizza").And.Contain("'bobrock'");
+		}
+
+		[Test]
+		public void WhenExecutedThroughSessionThenUseSubstitutionsWithString()
+		{
+			const string query = "from SimpleClass s where s.Description > calda";
+			using (var s = OpenSession())
+			{
+				using (SqlLogSpy sqlLogSpy = new SqlLogSpy())
+				{
+					s.CreateQuery(query).List();
+					string sql = sqlLogSpy.Appender.GetEvents()[0].RenderedMessage;
+					sql.Should().Not.Contain("pizza").And.Contain("'bobrock'");
+				}
+			}
+		}
 	}
 }
\ No newline at end of file


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