From: Michael D. <mik...@us...> - 2004-11-17 01:02:35
|
Update of /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/ExpressionTest In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27191/ExpressionTest Modified Files: SimpleExpressionFixture.cs Log Message: Added test to verify DateTime properties with Gt & Lt expressions worked correctly. Index: SimpleExpressionFixture.cs =================================================================== RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/ExpressionTest/SimpleExpressionFixture.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** SimpleExpressionFixture.cs 19 Jul 2004 03:25:25 -0000 1.2 --- SimpleExpressionFixture.cs 17 Nov 2004 01:02:15 -0000 1.3 *************** *** 1,3 **** --- 1,4 ---- using System; + using System.Collections; using System.Data; using System.Text; *************** *** 52,55 **** --- 53,82 ---- } + [Test] + public void SimpleDateExpression() + { + ISession session = factory.OpenSession(); + + NExpression.Expression andExpression = NExpression.Expression.Ge( "Date", DateTime.Now ); + + SqlString sqlString = andExpression.ToSqlString( factoryImpl, typeof(Simple), "simple_alias" ); + + string expectedSql = "simple_alias.date_ >= :simple_alias.date_"; + Parameter[] expectedParams = new Parameter[1]; + + Parameter firstAndParam = new Parameter(); + firstAndParam.SqlType = new SqlTypes.DateTimeSqlType(); + firstAndParam.TableAlias = "simple_alias"; + firstAndParam.Name = "date_"; + + expectedParams[0] = firstAndParam; + + CompareSqlStrings(sqlString, expectedSql, expectedParams); + + session.Close(); + } + + + } |