LimitClauseFixture.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NHibernate.Hql.Ast.ANTLR;
using NUnit.Framework;

namespace NHibernate.Test.Hql.Ast
{
    [TestFixture]
    public class LimitClauseFixture : BaseFixture
    {
        protected override void OnSetUp()
        {
            ISession session = OpenSession();
            ITransaction txn = session.BeginTransaction();

            var mother = new Human { BodyWeight = 10, Description = "mother" };
            var father = new Human { BodyWeight = 15, Description = "father" };
            var child1 = new Human { BodyWeight = 5, Description = "child1" };
            var child2 = new Human { BodyWeight = 6, Description = "child2" };
            var friend = new Human { BodyWeight = 20, Description = "friend" };

            session.Save(mother);
            session.Save(father);
            session.Save(child1);
            session.Save(child2);
            session.Save(friend);

            txn.Commit();
            session.Close();
        }

        protected override void OnTearDown()
        {
            ISession session = OpenSession();
            ITransaction txn = session.BeginTransaction();
			session.Delete("from Animal");
            txn.Commit();
            session.Close();
        }

        [Test]
        public void None()
        {
            ISession s = OpenSession();
            ITransaction txn = s.BeginTransaction();

            var actual = s.CreateQuery("from Human h order by h.bodyWeight").List<Human>().Select(h => h.BodyWeight).ToArray();
            var expected = new[] { 5, 6, 10, 15, 20 };
            CollectionAssert.AreEqual(expected, actual);

            txn.Commit();
            s.Close();
        }

        [Test]
        public void Skip()
        {
            ISession s = OpenSession();
            ITransaction txn = s.BeginTransaction();

            var actual = s.CreateQuery("from Human h order by h.bodyWeight skip 2").List<Human>().Select(h => h.BodyWeight).ToArray();
            var expected = new[] { 10, 15, 20 };
            CollectionAssert.AreEqual(expected, actual);

            txn.Commit();
            s.Close();
        }

        [Test]
        public void Take()
        {
            ISession s = OpenSession();
            ITransaction txn = s.BeginTransaction();

            var actual = s.CreateQuery("from Human h order by h.bodyWeight take 2").List<Human>().Select(h => h.BodyWeight).ToArray();
            var expected = new[] { 5, 6 };
            CollectionAssert.AreEqual(expected, actual);

            txn.Commit();
            s.Close();
        }

        [Test]
        public void SkipTake()
        {
            ISession s = OpenSession();
            ITransaction txn = s.BeginTransaction();

            var actual = s.CreateQuery("from Human h order by h.bodyWeight skip 1 take 3").List<Human>().Select(h => h.BodyWeight).ToArray();
            var expected = new[] { 6, 10, 15 };
            CollectionAssert.AreEqual(expected, actual);

            txn.Commit();
            s.Close();
        }

        [Test]
        public void TakeSkip()
        {
            ISession s = OpenSession();
            ITransaction txn = s.BeginTransaction();

            Assert.Throws<QuerySyntaxException>(() => s.CreateQuery("from Human h order by h.bodyWeight take 1 skip 2").List<Human>(), "take should not be allowed before skip");

            txn.Commit();
            s.Close();
        }
    }
}