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()
{
|
