[Nhibernate-commit] SF.net SVN: nhibernate:[4253] trunk/nhibernate/src/NHibernate.Test/HQL/Ast/ BulkManipulation.cs

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

Revision: 4253
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4253&view=rev
Author:   fabiomaulo
Date:     2009-05-06 14:54:55 +0000 (Wed, 06 May 2009)

Log Message:
-----------
Continue port of AST tests for Updates (base entity)

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.Test/HQL/Ast/BulkManipulation.cs

Modified: trunk/nhibernate/src/NHibernate.Test/HQL/Ast/BulkManipulation.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/HQL/Ast/BulkManipulation.cs	2009-05-06 14:38:06 UTC (rev 4252)
+++ trunk/nhibernate/src/NHibernate.Test/HQL/Ast/BulkManipulation.cs	2009-05-06 14:54:55 UTC (rev 4253)
@@ -262,9 +262,9 @@
 			t.Rollback();
 			t = s.BeginTransaction();
 
-			count = s.CreateQuery("update PettingZoo pz set pz.name = pz.name where pz.id = :id")
-					.SetInt64("id", data.PettingZoo.Id)
-					.ExecuteUpdate();
+			count =
+				s.CreateQuery("update PettingZoo pz set pz.name = pz.name where pz.id = :id").SetInt64("id", data.PettingZoo.Id).
+					ExecuteUpdate();
 			Assert.That(count, Is.EqualTo(1), "Incorrect discrim subclass update count");
 
 			t.Rollback();
@@ -278,9 +278,7 @@
 
 			// TODO : not so sure this should be allowed.  Seems to me that if they specify an alias,
 			// property-refs should be required to be qualified.
-			count = s.CreateQuery("update Zoo as z set name = name where id = :id")
-					.SetInt64("id", data.Zoo.Id)
-					.ExecuteUpdate();
+			count = s.CreateQuery("update Zoo as z set name = name where id = :id").SetInt64("id", data.Zoo.Id).ExecuteUpdate();
 			Assert.That(count, Is.EqualTo(1), "Incorrect discrim subclass update count");
 
 			t.Commit();
@@ -289,6 +287,78 @@
 			data.Cleanup();
 		}
 
+		[Test]
+		public void UpdateOnAnimal()
+		{
+			var data = new TestData(this);
+			data.Prepare();
+
+			ISession s = OpenSession();
+			ITransaction t = s.BeginTransaction();
+			int count =
+				s.CreateQuery("update Animal set description = description where description = :desc")
+				.SetString("desc", data.Frog.Description)
+				.ExecuteUpdate();
+			Assert.That(count, Is.EqualTo(1), "Incorrect entity-updated count");
+
+			count =
+				s.CreateQuery("update Animal set description = :newDesc where description = :desc")
+				.SetString("desc",data.Polliwog.Description)
+				.SetString("newDesc", "Tadpole")
+				.ExecuteUpdate();
+			Assert.That(count, Is.EqualTo(1), "Incorrect entity-updated count");
+
+			var tadpole = s.Load<Animal>(data.Polliwog.Id);
+
+			Assert.That(tadpole.Description, Is.EqualTo("Tadpole"), "Update did not take effect");
+
+			count =
+				s.CreateQuery("update Animal set bodyWeight = bodyWeight + :w1 + :w2")
+				.SetDouble("w1", 1)
+				.SetDouble("w2", 2)
+				.ExecuteUpdate();
+			Assert.That(count, Is.EqualTo(6), "incorrect count on 'complex' update assignment");
+
+			if (! (Dialect is MySQLDialect))
+			{
+				// MySQL does not support (even un-correlated) subqueries against the update-mutating table
+				s.CreateQuery("update Animal set bodyWeight = ( select max(bodyWeight) from Animal )").ExecuteUpdate();
+			}
+
+			t.Commit();
+			s.Close();
+
+			data.Cleanup();
+		}
+
+		[Test]
+		public void UpdateOnMammal()
+		{
+			var data = new TestData(this);
+			data.Prepare();
+
+			ISession s = OpenSession();
+			ITransaction t = s.BeginTransaction();
+
+			int count = s.CreateQuery("update Mammal set description = description").ExecuteUpdate();
+			Assert.That(count, Is.EqualTo(2), "incorrect update count against 'middle' of joined-subclass hierarchy");
+
+			count = s.CreateQuery("update Mammal set bodyWeight = 25").ExecuteUpdate();
+			Assert.That(count, Is.EqualTo(2), "incorrect update count against 'middle' of joined-subclass hierarchy");
+
+			if (! (Dialect is MySQLDialect))
+			{
+				// MySQL does not support (even un-correlated) subqueries against the update-mutating table
+				count = s.CreateQuery("update Mammal set bodyWeight = ( select max(bodyWeight) from Animal )").ExecuteUpdate();
+				Assert.That(count, Is.EqualTo(2), "incorrect update count against 'middle' of joined-subclass hierarchy");
+			}
+
+			t.Commit();
+			s.Close();
+
+			data.Cleanup();
+		}
+
 		#endregion
 
 		#region DELETES


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