nhibernate-commit

[Nhibernate-commit] SF.net SVN: nhibernate:[4390] trunk/nhibernate/src/NHibernate.Test/Criteria /CriteriaQueryTest.cs

[<fab...@us...>]

Revision: 4390
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4390&view=rev
Author:   fabiomaulo
Date:     2009-05-29 16:35:45 +0000 (Fri, 29 May 2009)

Log Message:
-----------
Simple pagination Test using Criteria

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs

Modified: trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2009-05-27 23:06:09 UTC (rev 4389)
+++ trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2009-05-29 16:35:45 UTC (rev 4390)
@@ -286,6 +286,44 @@
 		}
 
 		[Test]
+		public void SimplePagination()
+		{
+			using (ISession session = OpenSession())
+			using (ITransaction t = session.BeginTransaction())
+			{
+				session.Save(new Student {Name = "Mengano", StudentNumber = 232});
+				session.Save(new Student {Name = "Ayende", StudentNumber = 999});
+				session.Save(new Student {Name = "Fabio", StudentNumber = 123});
+				session.Save(new Student {Name = "Merlo", StudentNumber = 456});
+				session.Save(new Student {Name = "Fulano", StudentNumber = 0});
+
+				t.Commit();
+			}
+
+			using (ISession session = OpenSession())
+			using (ITransaction t = session.BeginTransaction())
+			{
+				var result = session.CreateCriteria<Student>()
+					.Add(Restrictions.Gt("StudentNumber", 0L))
+					.AddOrder(Order.Asc("StudentNumber"))
+					.SetFirstResult(1).SetMaxResults(2)
+					.List<Student>();
+				Assert.That(result.Count, Is.EqualTo(2));
+				Assert.That(result[0].StudentNumber, Is.EqualTo(232));
+				Assert.That(result[1].StudentNumber, Is.EqualTo(456));
+
+				t.Commit();
+			}
+
+			using (ISession session = OpenSession())
+			using (ITransaction t = session.BeginTransaction())
+			{
+				session.CreateQuery("delete from Student").ExecuteUpdate();
+				t.Commit();
+			}
+		}
+
+		[Test]
 		public void CloningDetachedCriteriaTest()
 		{
 			DetachedCriteria dc = DetachedCriteria.For(typeof(Student))


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5434] trunk/nhibernate/src/NHibernate.Test/Criteria /CriteriaQueryTest.cs

[<pa...@us...>]

Revision: 5434
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5434&view=rev
Author:   patearl
Date:     2011-03-06 06:53:56 +0000 (Sun, 06 Mar 2011)

Log Message:
-----------
Handle databases with unsupported "All" operator in criteria query tests.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs

Modified: trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2011-03-06 06:52:05 UTC (rev 5433)
+++ trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2011-03-06 06:53:56 UTC (rev 5434)
@@ -121,7 +121,7 @@
 					.SetProjection(Property.ForName("Name"));
 
 				session.CreateCriteria(typeof(Student))
-					.Add(Subqueries.PropertyEqAll("Name", dc))
+					.Add(Subqueries.PropertyEq("Name", dc))
 					.List();
 			}
 		}
@@ -183,17 +183,23 @@
 				.Add(Property.ForName("StudentNumber").Eq(232L))
 				.SetProjection(Property.ForName("Name"));
 
-			session.CreateCriteria(typeof(Student))
-				.Add(Subqueries.PropertyEqAll("Name", dc))
-				.List();
+			if (TestDialect.SupportsOperatorAll)
+			{
+				session.CreateCriteria(typeof (Student))
+					.Add(Subqueries.PropertyEqAll("Name", dc))
+					.List();
+			}
 
 			session.CreateCriteria(typeof(Student))
 				.Add(Subqueries.Exists(dc))
 				.List();
 
-			session.CreateCriteria(typeof(Student))
-				.Add(Property.ForName("Name").EqAll(dc))
-				.List();
+			if (TestDialect.SupportsOperatorAll)
+			{
+				session.CreateCriteria(typeof (Student))
+					.Add(Property.ForName("Name").EqAll(dc))
+					.List();
+			}
 
 			session.CreateCriteria(typeof(Student))
 				.Add(Subqueries.In("Gavin King", dc))
@@ -284,46 +290,52 @@
 				
 				t.Commit();
 			}
-	
-			using (ISession session = OpenSession())
-			using (ITransaction t = session.BeginTransaction())
+
+			if (TestDialect.SupportsOperatorAll)
 			{
-				try
+				using (ISession session = OpenSession())
+				using (ITransaction t = session.BeginTransaction())
 				{
-					session.CreateCriteria<Student>()
-						.Add(Subqueries.PropertyEqAll("CityState", dc))
-						.List();
-					
-					Assert.Fail("should have failed because cannot compare subquery results with multiple columns");
+					try
+					{
+						session.CreateCriteria<Student>()
+							.Add(Subqueries.PropertyEqAll("CityState", dc))
+							.List();
+
+						Assert.Fail("should have failed because cannot compare subquery results with multiple columns");
+					}
+					catch (QueryException ex)
+					{
+						// expected
+					}
+					t.Rollback();
 				}
-				catch (QueryException ex)
-				{
-					// expected
-				}
-				t.Rollback();
 			}
-			
-			using (ISession session = OpenSession())
-			using (ITransaction t = session.BeginTransaction())
+
+			if (TestDialect.SupportsOperatorAll)
 			{
-				try
+				using (ISession session = OpenSession())
+				using (ITransaction t = session.BeginTransaction())
 				{
-					session.CreateCriteria<Student>()
-						.Add(Property.ForName("CityState").EqAll(dc))
-						.List();
-	
-					Assert.Fail("should have failed because cannot compare subquery results with multiple columns");
+					try
+					{
+						session.CreateCriteria<Student>()
+							.Add(Property.ForName("CityState").EqAll(dc))
+							.List();
+
+						Assert.Fail("should have failed because cannot compare subquery results with multiple columns");
+					}
+					catch (QueryException ex)
+					{
+						// expected
+					}
+					finally
+					{
+						t.Rollback();
+					}
 				}
-				catch (QueryException ex)
-				{
-					// expected
-				}
-				finally
-				{
-					t.Rollback();
-				}
 			}
-	
+
 			using (ISession session = OpenSession())
 			using (ITransaction t = session.BeginTransaction())
 			{


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5895] trunk/nhibernate/src/NHibernate.Test/Criteria /CriteriaQueryTest.cs

[<pa...@us...>]

Revision: 5895
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5895&view=rev
Author:   patearl
Date:     2011-05-31 03:41:20 +0000 (Tue, 31 May 2011)

Log Message:
-----------
Tests: Temporarily disabled a test for SQLite (NH-2752).

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs

Modified: trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2011-05-30 22:38:01 UTC (rev 5894)
+++ trunk/nhibernate/src/NHibernate.Test/Criteria/CriteriaQueryTest.cs	2011-05-31 03:41:20 UTC (rev 5895)
@@ -112,6 +112,9 @@
 		[Test]
 		public void AllowToSetLimitOnSubqueries()
 		{
+            if (Dialect is SQLiteDialect)
+                Assert.Ignore("SQLite seems to have a bug related to named query parameters in subquery limit clauses.");
+
 			using (ISession session = OpenSession())
 			{
 				DetachedCriteria dc = DetachedCriteria.For(typeof(Student))


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.