Update of /cvsroot/nhibernate/nhibernate/src/NHibernate.Test
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27191
Modified Files:
CriteriaTest.cs
Log Message:
Added test to verify DateTime properties with Gt & Lt expressions
worked correctly.
Index: CriteriaTest.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate.Test/CriteriaTest.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** CriteriaTest.cs 20 Sep 2004 17:45:58 -0000 1.6
--- CriteriaTest.cs 17 Nov 2004 01:02:14 -0000 1.7
***************
*** 67,70 ****
--- 67,112 ----
s2.Close();
}
+
+ [Test]
+ public void SimpleDateCriteria()
+ {
+ Simple s1 = new Simple();
+ s1.Address = "blah";
+ s1.Count = 1;
+ s1.Date = new DateTime( 2004, 01, 01 );
+
+ Simple s2 = new Simple();
+ s2.Address = "blah";
+ s2.Count = 2;
+ s2.Date = new DateTime( 2006, 01, 01 );
+
+ ISession s = sessions.OpenSession();
+ s.Save( s1, 1 );
+ s.Save( s2, 2 );
+ s.Flush();
+ s.Close();
+
+ s = sessions.OpenSession();
+ IList results = s.CreateCriteria( typeof(Simple) )
+ .Add( Expression.Expression.Gt( "Date", new DateTime( 2005, 01, 01 ) ) )
+ .AddOrder( Expression.Order.Asc( "Date" ) )
+ .List();
+
+ Assert.AreEqual( 1, results.Count, "one gt from 2005" );
+ Simple simple = (Simple)results[0];
+ Assert.IsTrue( simple.Date > new DateTime( 2005, 01, 01), "should have returned dates after 2005" );
+
+ results = s.CreateCriteria( typeof(Simple) )
+ .Add( Expression.Expression.Lt( "Date", new DateTime( 2005, 01, 01 ) ) )
+ .AddOrder( Expression.Order.Asc( "Date" ) )
+ .List();
+
+ Assert.AreEqual( 1, results.Count, "one lt than 2005" );
+ simple = (Simple)results[0];
+ Assert.IsTrue( simple.Date < new DateTime( 2005, 01, 01 ), "should be less than 2005" );
+
+ s.Delete( "from Simple" );
+ s.Close();
+ }
}
}
|
