[Nhibernate-commit] SF.net SVN: nhibernate:[3945] trunk/nhibernate/src/NHibernate.Test

[<te...@us...>]

Revision: 3945
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=3945&view=rev
Author:   tehlike
Date:     2008-12-12 14:40:38 +0000 (Fri, 12 Dec 2008)

Log Message:
-----------
Added tests for NH1349 to support it is not an issue.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj

Added Paths:
-----------
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Fixture.cs
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Mappings.hbm.xml
    trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Services.cs


Property changes on: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349
___________________________________________________________________
Added: svn:mergeinfo
   + 

Added: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Fixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Fixture.cs	                        (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Fixture.cs	2008-12-12 14:40:38 UTC (rev 3945)
@@ -0,0 +1,56 @@
+using System;
+using System.Collections;
+using System.Collections.Generic;
+using System.Text;
+using NUnit.Framework;
+using NUnit.Framework.SyntaxHelpers;
+
+namespace NHibernate.Test.NHSpecificTest.NH1349
+{
+	[TestFixture]
+	public class Fixture : BugTestCase
+	{
+		protected override void OnSetUp()
+		{
+			using(var session=this.OpenSession())
+			{
+				using(var tran=session.BeginTransaction())
+				{
+					string name = "fabio";
+					string accNum = DateTime.Now.Ticks.ToString(); ;
+					Services newServ = new Services();
+					newServ.AccountNumber = accNum;
+					newServ.Name = name + " person";
+					newServ.Type = (new Random()).Next(0, 9).ToString();
+
+					session.Save(newServ);
+					tran.Commit();
+				}
+			}
+		}
+		protected override void OnTearDown()
+		{
+			using (var session = this.OpenSession())
+			{
+				using (var tran = session.BeginTransaction())
+				{
+					session.Delete("from Services");
+					tran.Commit();
+				}
+			}
+		}
+
+		[Test]
+		public void Can_page_with_formula_property()
+		{
+			using (var session = this.OpenSession())
+			{
+				using(var tran=session.BeginTransaction())
+				{
+					IList ret = session.CreateCriteria(typeof(Services)).SetMaxResults(5).List(); //this breaks
+					Assert.That(ret.Count,Is.EqualTo(1));
+				}
+			}
+		}
+	}
+}

Added: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Mappings.hbm.xml
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Mappings.hbm.xml	                        (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Mappings.hbm.xml	2008-12-12 14:40:38 UTC (rev 3945)
@@ -0,0 +1,19 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
+									 namespace="NHibernate.Test.NHSpecificTest.NH1349"
+								   assembly="NHibernate.Test">
+	<class name="Services" table="services">
+		<id name="Id" column="id" type="int">
+			<generator class="increment" />
+		</id>
+		<property name="AccountNumber" column="accountNumber" type="String" length="30"/>
+		<property name="Name" type="String" length="30"/>
+		<property name="Type" type="String" length="30"/>
+		<property name ="CompanyCount"
+							formula="(SELECT COUNT(*) FROM services as c WHERE c.accountNumber LIKE '63%' )"
+							update="false" insert="false"  access="nosetter.camelcase"/>
+		<!-- Using a formula seems to trigger it. I guess the query isn't being generated
+      correctly when some formulas are used.
+  -->
+	</class>
+</hibernate-mapping>
\ No newline at end of file

Added: trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Services.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Services.cs	                        (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1349/Services.cs	2008-12-12 14:40:38 UTC (rev 3945)
@@ -0,0 +1,51 @@
+using System;
+using System.Collections.Generic;
+using System.Text;
+
+namespace NHibernate.Test.NHSpecificTest.NH1349
+{
+	public class Services
+	{
+		private int id;
+		private int companyCount;
+		private string accountNumber;
+		private string name;
+		private string type;
+
+		public Services()
+		{ }
+
+		public virtual int Id
+		{
+			get { return id; }
+			set { id = value; }
+		}
+
+		public virtual string AccountNumber
+		{
+			get { return accountNumber; }
+			set { accountNumber = value; }
+		}
+		public virtual string Name
+		{
+			get { return name; }
+			set { name = value; }
+		}
+		public virtual string Type
+		{
+			get { return type; }
+			set { type = value; }
+		}
+		public virtual int CompanyCount
+		{
+			get { return companyCount; }
+			set { companyCount = value; }
+		}
+		public virtual string ToString()
+		{
+			return (this.id + "] [" + this.accountNumber + "]  [" + this.name + "] [" + this.type + "]  [" + this.CompanyCount + "]");
+
+		}
+	}
+
+}

Modified: trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj	2008-12-08 10:53:17 UTC (rev 3944)
+++ trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj	2008-12-12 14:40:38 UTC (rev 3945)
@@ -469,6 +469,8 @@
     <Compile Include="NHSpecificTest\NH1332\Fixture.cs" />
     <Compile Include="NHSpecificTest\NH1347\A.cs" />
     <Compile Include="NHSpecificTest\NH1347\Fixture.cs" />
+    <Compile Include="NHSpecificTest\NH1349\Fixture.cs" />
+    <Compile Include="NHSpecificTest\NH1349\Services.cs" />
     <Compile Include="NHSpecificTest\NH1355\Category.cs" />
     <Compile Include="NHSpecificTest\NH1355\CustomVersionType.cs" />
     <Compile Include="NHSpecificTest\NH1355\UserTypeTimestamp.cs" />
@@ -1556,6 +1558,7 @@
     <EmbeddedResource Include="Cascade\JobBatch.hbm.xml" />
     <EmbeddedResource Include="Deletetransient\Person.hbm.xml" />
     <Content Include="DynamicEntity\package.html" />
+    <EmbeddedResource Include="NHSpecificTest\NH1349\Mappings.hbm.xml" />
     <EmbeddedResource Include="NHSpecificTest\NH1593\TestIndex.hbm.xml" />
     <EmbeddedResource Include="NHSpecificTest\NH1594\Mappings.hbm.xml" />
     <EmbeddedResource Include="NHSpecificTest\NH1579\Mappings.hbm.xml" />


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