[Nhibernate-commit] nhibernate/src/NHibernate.Test/SqlCommandTest SqlStringFixture.cs,1.3,1.4

[Michael D. <mik...@us...>]

Update of /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/SqlCommandTest
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14918/NHibernate.Test/SqlCommandTest

Modified Files:
	SqlStringFixture.cs 
Log Message:
Added test for SQLExpression and new method in SqlString

Index: SqlStringFixture.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlStringFixture.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** SqlStringFixture.cs	20 Aug 2004 15:26:23 -0000	1.3
--- SqlStringFixture.cs	26 Aug 2004 14:28:44 -0000	1.4
***************
*** 173,176 ****
--- 173,195 ----
  
  		[Test]
+ 		public void Replace() 
+ 		{
+ 			SqlString sql = new SqlString( new object[] {"select ", "from table ", "where a = ", new Parameter(), " and c = ", new Parameter() } );
+ 			
+ 			SqlString replacedSql = sql.Replace( "table", "replacedTable" );
+ 			Assert.AreEqual( "select from replacedTable where a = ", replacedSql.SqlParts[0], "replaced single instance" );
+ 
+ 			replacedSql = sql.Replace( "not found", "not in here" );
+ 			Assert.AreEqual( sql.ToString(), replacedSql.ToString(), "replace no found string" );
+ 
+ 			replacedSql = sql.Replace( "le", "LE" );
+ 			Assert.AreEqual( "seLEct from tabLE where a = ", replacedSql.SqlParts[0], "multi-match replace" );
+ 			Assert.IsTrue( replacedSql.SqlParts[1] is Parameter, "multi-match replace - Param 1" );
+ 			Assert.AreEqual(" and c = ", replacedSql.SqlParts[2], "multi-match replace" );
+ 			Assert.IsTrue( replacedSql.SqlParts[3] is Parameter, "multi-match replace - Param 2" );
+ 			
+ 		}
+ 		
+ 		[Test]
  		public void StartsWith() 
  		{