[Nhibernate-commit] nhibernate/src/NHibernate.Test/SqlCommandTest SqlDeleteBuilderFixture.cs,1.1,1.2 SqlUpdateBuilderFixture.cs,1.1,1.2

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

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

Modified Files:
	SqlDeleteBuilderFixture.cs SqlUpdateBuilderFixture.cs 
Log Message:
Added a new method to support where strings on collection mappings.

Index: SqlUpdateBuilderFixture.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlUpdateBuilderFixture.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** SqlUpdateBuilderFixture.cs	20 Mar 2004 23:08:55 -0000	1.1
--- SqlUpdateBuilderFixture.cs	30 Apr 2004 04:43:08 -0000	1.2
***************
*** 38,46 ****
  			update.SetVersionColumn(new string[] {"versionColumn"}, (IVersionType)NHibernate.Int32);
  
  			SqlString sqlString = update.ToSqlString();
  			Parameter[] actualParams = new Parameter[4];
  			int numOfParameters = 0;
  
! 			string expectedSql = "UPDATE test_update_builder SET intColumn = :intColumn, longColumn = :longColumn, literalColumn = 0, stringColumn = 5 WHERE decimalColumn = :decimalColumn AND versionColumn = :versionColumn";
  
  			Assertion.AssertEquals("SQL String", expectedSql , sqlString.ToString());
--- 38,47 ----
  			update.SetVersionColumn(new string[] {"versionColumn"}, (IVersionType)NHibernate.Int32);
  
+ 			update.AddWhereFragment("a=b");
  			SqlString sqlString = update.ToSqlString();
  			Parameter[] actualParams = new Parameter[4];
  			int numOfParameters = 0;
  
! 			string expectedSql = "UPDATE test_update_builder SET intColumn = :intColumn, longColumn = :longColumn, literalColumn = 0, stringColumn = 5 WHERE decimalColumn = :decimalColumn AND versionColumn = :versionColumn AND a=b";
  
  			Assertion.AssertEquals("SQL String", expectedSql , sqlString.ToString());

Index: SqlDeleteBuilderFixture.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/SqlCommandTest/SqlDeleteBuilderFixture.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** SqlDeleteBuilderFixture.cs	20 Mar 2004 23:08:55 -0000	1.1
--- SqlDeleteBuilderFixture.cs	30 Apr 2004 04:43:08 -0000	1.2
***************
*** 33,36 ****
--- 33,37 ----
  			delete.SetVersionColumn(new string[] {"versionColumn"}, (IVersionType)NHibernate.Int32);
  
+ 			delete.AddWhereFragment("a=b");
  			SqlString sqlString = delete.ToSqlString();
  			Parameter[] actualParams = new Parameter[2];
***************
*** 38,42 ****
  			
  
! 			string expectedSql = "DELETE FROM test_delete_builder WHERE decimalColumn = :decimalColumn AND versionColumn = :versionColumn";
  			Assertion.AssertEquals("SQL String", expectedSql , sqlString.ToString());
  			
--- 39,43 ----
  			
  
! 			string expectedSql = "DELETE FROM test_delete_builder WHERE decimalColumn = :decimalColumn AND versionColumn = :versionColumn AND a=b";
  			Assertion.AssertEquals("SQL String", expectedSql , sqlString.ToString());