public void CopyToTest() { TestDetachedQuery origin = new TestDetachedQuery(); origin.SetMaxResults(10).SetFirstResult(5).SetCacheable(true).SetReadOnly(true).SetTimeout(444).SetFlushMode (FlushMode.Auto).SetCacheRegion("A_REGION").SetResultTransformer(new AliasToBeanResultTransformer(typeof(NoFoo))); origin.SetComment(MyComment); origin.SetLockMode("LM1", LockMode.Upgrade); origin.SetProperties(new Foo("Pallino", "Pinco")); origin.SetInt64(1, 1); origin.SetBinary(2, new byte[] { }); origin.SetBoolean(3, false); origin.SetDateTime(6, DateTime.MaxValue); origin.SetCharacter("5", 'A'); origin.SetDateTime("6", DateTime.MaxValue); origin.SetDecimal("7", 10.15m); origin.SetParameterList("UntypedList", new int[] { 1, 2, 3 }); origin.SetParameterList("TypedList", new Int64[] { 1, 2, 3 }, NHibernateUtil.Int64); TestDetachedQuery tdq = new TestDetachedQuery(); tdq.SetLockMode("LM1", LockMode.Read); tdq.SetLockMode("LM2", LockMode.Write); tdq.SetProperties(new Foo("Fulano", "De Tal")); tdq.SetAnsiString(1, ""); //will be override tdq.SetByte(4, 255); tdq.SetCharacter(5, 'A'); tdq.SetDateTime(6, DateTime.MinValue); // will be override tdq.SetDateTime("6", DateTime.MinValue); // will be override tdq.SetDouble("8", 8.1f); tdq.SetEntity("9", new Foo("Fulano", "De Tal")); tdq.SetParameterList("UntypedList", new int[] { 5, 6, 7, 8 }); // will be override tdq.SetParameterList("TypedList", new Int64[] { 5, 6, 7, 8 }, NHibernateUtil.Int64); // will be override tdq.SetComment("other comment"); // will be override origin.CopyTo(tdq); Assert.AreEqual(5, tdq.Selection.FirstRow); Assert.AreEqual(444, tdq.Selection.Timeout); Assert.IsTrue(tdq.Cacheable); Assert.IsTrue(tdq.ReadOnly); Assert.AreEqual(FlushMode.Auto, tdq.FlushMode); Assert.AreEqual("A_REGION", tdq.CacheRegion); Assert.IsNotNull(tdq.ResultTransformer); Assert.That(tdq.Comment, Is.EqualTo(MyComment)); // merge/override of LockModes Assert.AreEqual(2, tdq.LockModes.Count); Assert.IsTrue(tdq.LockModes.ContainsKey("LM1")); Assert.AreEqual(LockMode.Upgrade, tdq.LockModes["LM1"]); Assert.IsTrue(tdq.LockModes.ContainsKey("LM2")); Assert.AreEqual(LockMode.Write, tdq.LockModes["LM2"]); // merge of OptionalUntypeParams (eventually override by IQuery) Assert.AreEqual(2, tdq.OptionalUntypeParams.Count); Assert.IsTrue(tdq.OptionalUntypeParams[0].Equals(new Foo("Fulano", "De Tal"))); Assert.IsTrue(tdq.OptionalUntypeParams[1].Equals(new Foo("Pallino", "Pinco"))); // merge/override positional parameters Assert.IsTrue(tdq.PosParams[1].Type.Equals(NHibernateUtil.Int64)); Assert.IsTrue(tdq.PosParams[2].Type.Equals(NHibernateUtil.Binary)); Assert.IsTrue(tdq.PosParams[3].Type.Equals(NHibernateUtil.Boolean)); Assert.IsTrue(tdq.PosParams[4].Type.Equals(NHibernateUtil.Byte)); Assert.IsTrue(tdq.PosParams[5].Type.Equals(NHibernateUtil.Character)); Assert.IsTrue(tdq.PosParams[6].Type.Equals(NHibernateUtil.DateTime)); Assert.IsTrue(tdq.PosParams[6].Value.Equals(DateTime.MaxValue)); // merge/override named parameters Assert.IsTrue(tdq.NamedParams["5"].Type.Equals(NHibernateUtil.Character)); Assert.IsTrue(tdq.NamedParams["6"].Type.Equals(NHibernateUtil.DateTime)); Assert.IsTrue(tdq.NamedParams["6"].Value.Equals(DateTime.MaxValue)); Assert.IsTrue(tdq.NamedParams["7"].Type.Equals(NHibernateUtil.Decimal)); Assert.IsTrue(tdq.NamedParams["8"].Type.Equals(NHibernateUtil.Double)); Assert.IsTrue(tdq.NamedParams["9"].Type.Equals(NHibernateUtil.Entity(typeof(Foo)))); // merge/override named parameters list int expected = 1; foreach (int i in tdq.NamedUntypeListParams["UntypedList"]) { Assert.AreEqual(expected, i); expected++; } // merge/override named params lists long lexpected = 1; foreach (long i in (tdq.NamedListParams["TypedList"].Value as IEnumerable)) { Assert.AreEqual(lexpected, i); lexpected++; } }
public void CopyToTest() { TestDetachedQuery origin = new TestDetachedQuery(); origin.SetMaxResults(10).SetFirstResult(5).SetCacheable(true).SetReadOnly(true).SetTimeout(444).SetFlushMode (FlushMode.Auto).SetCacheRegion("A_REGION").SetResultTransformer(new AliasToBeanResultTransformer(typeof(NoFoo))); origin.SetComment(MyComment); origin.SetLockMode("LM1", LockMode.Upgrade); origin.SetProperties(new Foo("Pallino", "Pinco")); origin.SetInt64(1, 1); origin.SetBinary(2, new byte[] { }); origin.SetBoolean(3, false); origin.SetDateTime(6, DateTime.MaxValue); origin.SetCharacter("5", 'A'); origin.SetDateTime("6", DateTime.MaxValue); origin.SetDecimal("7", 10.15m); origin.SetParameterList("UntypedList", new int[] { 1, 2, 3 }); origin.SetParameterList("TypedList", new Int64[] { 1, 2, 3 }, NHibernateUtil.Int64); TestDetachedQuery tdq = new TestDetachedQuery(); tdq.SetLockMode("LM1", LockMode.Read); tdq.SetLockMode("LM2", LockMode.Write); tdq.SetProperties(new Foo("Fulano", "De Tal")); tdq.SetAnsiString(1, ""); //will be override tdq.SetByte(4, 255); tdq.SetCharacter(5, 'A'); tdq.SetDateTime(6, DateTime.MinValue); // will be override tdq.SetDateTime("6", DateTime.MinValue); // will be override tdq.SetDouble("8", 8.1f); tdq.SetEntity("9", new Foo("Fulano", "De Tal")); tdq.SetParameterList("UntypedList", new int[] { 5, 6, 7, 8 }); // will be override tdq.SetParameterList("TypedList", new Int64[] { 5, 6, 7, 8 }, NHibernateUtil.Int64); // will be override tdq.SetComment("other comment"); // will be override origin.CopyTo(tdq); Assert.AreEqual(5, tdq.Selection.FirstRow); Assert.AreEqual(444, tdq.Selection.Timeout); Assert.IsTrue(tdq.Cacheable); Assert.IsTrue(tdq.ReadOnly); Assert.AreEqual(FlushMode.Auto, tdq.FlushMode); Assert.AreEqual("A_REGION", tdq.CacheRegion); Assert.IsNotNull(tdq.ResultTransformer); Assert.That(tdq.Comment, Is.EqualTo(MyComment)); // merge/override of LockModes Assert.AreEqual(2, tdq.LockModes.Count); Assert.IsTrue(tdq.LockModes.ContainsKey("LM1")); Assert.AreEqual(LockMode.Upgrade, tdq.LockModes["LM1"]); Assert.IsTrue(tdq.LockModes.ContainsKey("LM2")); Assert.AreEqual(LockMode.Write, tdq.LockModes["LM2"]); // merge of OptionalUntypeParams (eventually override by IQuery) Assert.AreEqual(2, tdq.OptionalUntypeParams.Count); Assert.IsTrue(tdq.OptionalUntypeParams[0].Equals(new Foo("Fulano", "De Tal"))); Assert.IsTrue(tdq.OptionalUntypeParams[1].Equals(new Foo("Pallino", "Pinco"))); // merge/override positional parameters Assert.IsTrue(tdq.PosParams[1].Type.Equals(NHibernateUtil.Int64)); Assert.IsTrue(tdq.PosParams[2].Type.Equals(NHibernateUtil.Binary)); Assert.IsTrue(tdq.PosParams[3].Type.Equals(NHibernateUtil.Boolean)); Assert.IsTrue(tdq.PosParams[4].Type.Equals(NHibernateUtil.Byte)); Assert.IsTrue(tdq.PosParams[5].Type.Equals(NHibernateUtil.Character)); Assert.IsTrue(tdq.PosParams[6].Type.Equals(NHibernateUtil.DateTime)); Assert.IsTrue(tdq.PosParams[6].Value.Equals(DateTime.MaxValue)); // merge/override named parameters Assert.IsTrue(tdq.NamedParams["5"].Type.Equals(NHibernateUtil.Character)); Assert.IsTrue(tdq.NamedParams["6"].Type.Equals(NHibernateUtil.DateTime)); Assert.IsTrue(tdq.NamedParams["6"].Value.Equals(DateTime.MaxValue)); Assert.IsTrue(tdq.NamedParams["7"].Type.Equals(NHibernateUtil.Decimal)); Assert.IsTrue(tdq.NamedParams["8"].Type.Equals(NHibernateUtil.Double)); Assert.IsTrue(tdq.NamedParams["9"].Type.Equals(NHibernateUtil.Entity(typeof(Foo)))); // merge/override named parameters list int expected = 1; foreach (int i in tdq.NamedUntypeListParams["UntypedList"]) { Assert.AreEqual(expected, i); expected++; } // merge/override named params lists long lexpected = 1; foreach (long i in (tdq.NamedListParams["TypedList"].Value as IEnumerable)) { Assert.AreEqual(lexpected, i); lexpected++; } }