/// <summary> /// Returns copy of cached object /// </summary> public void TestReturnCopyOfCachedOject() { CacheModel cacheModel = new CacheModel("test", typeof(LruCache).FullName, 60, 1, true); Order order = new Order(); order.CardNumber = "CardNumber"; order.Date = DateTime.Now; order.LineItemsCollection = new LineItemCollection(); LineItem item = new LineItem(); item.Code = "Code1"; order.LineItemsCollection.Add(item); item = new LineItem(); item.Code = "Code2"; order.LineItemsCollection.Add(item); CacheKey key = new CacheKey(); key.Update(order); int firstId = HashCodeProvider.GetIdentityHashCode(order); cacheModel[ key ] = order; Order order2 = cacheModel[ key ] as Order; int secondId = HashCodeProvider.GetIdentityHashCode(order2); Assert.AreNotEqual(firstId, secondId, "hasCode equal"); }
/// <summary> /// Returns reference to same instance of cached object /// </summary> public void TestReturnInstanceOfCachedOject() { CacheModel cacheModel = new CacheModel("test", typeof(LruCache).FullName, 60, 1, false); //cacheModel.FlushInterval = interval; //cacheModel.IsReadOnly = true; //cacheModel.IsSerializable = false; Order order = new Order(); order.CardNumber = "CardNumber"; order.Date = DateTime.Now; order.LineItemsCollection = new LineItemCollection(); LineItem item = new LineItem(); item.Code = "Code1"; order.LineItemsCollection.Add(item); item = new LineItem(); item.Code = "Code2"; order.LineItemsCollection.Add(item); CacheKey key = new CacheKey(); key.Update(order); int firstId = HashCodeProvider.GetIdentityHashCode(order); cacheModel[ key ] = order; Order order2 = cacheModel[ key ] as Order; int secondId = HashCodeProvider.GetIdentityHashCode(order2); Assert.AreEqual(firstId, secondId, "hasCode different"); }
public void TestNullValueReplacementOnDateTime() { Account account = NewAccount6(); dataMapper.Insert("InsertAccountViaParameterMap", account); Order order = new Order(); order.Id = 99; order.CardExpiry = "09/11"; order.Account = account; order.CardNumber = "154564656"; order.CardType = "Visa"; order.City = "Lyon"; order.Date = System.DateTime.MinValue; //<-- null replacement order.PostalCode = "69004"; order.Province = "Rhone"; order.Street = "rue Durand"; dataMapper.Insert("InsertOrderViaParameterMap", order); Order orderTest = (Order)dataMapper.QueryForObject("GetOrderLiteByColumnName", 99); Assert.AreEqual(System.DateTime.MinValue, orderTest.Date); }
public void TestNullValueReplacementOnDecimal() { Account account = NewAccount6(); dataMapper.Insert("InsertAccountViaParameterMap", account); Order order = new Order(); order.Id = 99; order.CardExpiry = "09/11"; order.Account = account; order.CardNumber = "154564656"; order.CardType = "Visa"; order.City = "Lyon"; order.Date = System.DateTime.MinValue; //<-- null replacement for parameterMAp order.PostalCode = "69004"; order.Province = "Rhone"; order.Street = "rue Durand"; dataMapper.Insert("InsertOrderViaParameterMap", order); LineItem item = new LineItem(); item.Id = 99; item.Code = "test"; item.Price = -99.99m;//<-- null replacement for parameterMAp item.Quantity = 99; item.Order = order; dataMapper.Insert("InsertLineItem", item); // Retrieve LineItem & test null replacement for resultMap LineItem testItem = (LineItem)dataMapper.QueryForObject("GetSpecificLineItemWithNullReplacement", 99); Assert.IsNotNull(testItem); Assert.AreEqual(-77.77m, testItem.Price); Assert.AreEqual("test", testItem.Code); }
public void TestByteArrayMapping() { Account account = NewAccount6(); dataMapper.Insert("InsertAccountViaParameterMap", account); Order order = new Order(); order.Id = 99; order.CardExpiry = "09/11"; order.Account = account; order.CardNumber = "154564656"; order.CardType = "Visa"; order.City = "Lyon"; order.Date = System.DateTime.MinValue; order.PostalCode = "69004"; order.Province = "Rhone"; order.Street = "rue Durand"; dataMapper.Insert("InsertOrderViaParameterMap", order); LineItem item = new LineItem(); item.Id = 99; item.Code = "test"; item.Price = -99.99m; item.Quantity = 99; item.Order = order; item.PictureData = new byte[] { 1, 2, 3 }; // Check insert dataMapper.Insert("InsertLineItemWithPicture", item); // select LineItem loadItem = null; Hashtable param = new Hashtable(); param.Add("LineItem_ID", 99); param.Add("Order_ID", 99); loadItem = dataMapper.QueryForObject("GetSpecificLineItemWithPicture", param) as LineItem; Assert.IsNotNull(loadItem.Id); Assert.IsNotNull(loadItem.PictureData); Assert.AreEqual(item.PictureData, loadItem.PictureData); }
public void TestInsertOrderViaProperties() { Account account = NewAccount6(); dataMapper.Insert("InsertAccountViaParameterMap", account); Order order = new Order(); order.Id = 99; order.CardExpiry = "09/11"; order.Account = account; order.CardNumber = "154564656"; order.CardType = "Visa"; order.City = "Lyon"; order.Date = DateTime.Now; order.PostalCode = "69004"; order.Province = "Rhone"; order.Street = "rue Durand"; dataMapper.Insert("InsertOrderViaPublicFields", order); }
public void TestOrderLineItemGroupBy() { InitScript(sessionFactory.DataSource, scriptDirectory + "petstore-drop.sql"); InitScript(sessionFactory.DataSource, scriptDirectory + "account-init.sql"); InitScript(sessionFactory.DataSource, scriptDirectory + "order-init.sql"); InitScript(sessionFactory.DataSource, scriptDirectory + "line-item-init.sql"); Order order = new Order(); order.Id = 11; LineItem item = new LineItem(); item.Id = 10; item.Code = "blah"; item.Price = 44.00m; item.Quantity = 1; item.Order = order; dataMapper.Insert("InsertLineItemPostKey", item); IList list = dataMapper.QueryForList("GetOrderLineItem", null); Assert.AreEqual(11, list.Count); order = (Order)list[0]; Assert.AreEqual(3, order.LineItemsIList.Count); Assert.IsNotNull(order.Account); AssertAccount1(order.Account); order = (Order)list[10]; Assert.AreEqual(1, order.LineItemsIList.Count); Assert.IsNull(order.Account); }
/// <summary> /// Verify that the input order is equal to the order(id=1). /// </summary> /// <param name="order">An order object.</param> protected void AssertOrder1(Order order) { DateTime date = new DateTime(2003, 2, 15, 8, 15, 00); Assert.AreEqual(1, order.Id, "order.Id"); Assert.AreEqual(date.ToString(), order.Date.ToString(), "order.Date"); Assert.AreEqual("VISA", order.CardType, "order.CardType"); Assert.AreEqual("999999999999", order.CardNumber, "order.CardNumber"); Assert.AreEqual("05/03", order.CardExpiry, "order.CardExpiry"); Assert.AreEqual("11 This Street", order.Street, "order.Street"); Assert.AreEqual("Victoria", order.City, "order.City"); Assert.AreEqual("BC", order.Province, "order.Id"); Assert.AreEqual("C4B 4F4", order.PostalCode, "order.PostalCode"); }
public void TestComplexMappingViaHasTable() { Hashtable param = new Hashtable(); Account a = new Account(); a.FirstName = "Joe"; param.Add("Account",a); Order o = new Order(); o.City = "Dalton"; param.Add("Order", o); Account accountTest = (Account) dataMapper.QueryForObject("GetAccountComplexMapping", param); AssertAccount1(accountTest); }
public void TestNullValueReplacementForDateTimeWithHashtable() { Account account = NewAccount6(); dataMapper.Insert("InsertAccountViaParameterMap", account); Order order = new Order(); order.Id = 99; order.CardExpiry = "09/11"; order.Account = account; order.CardNumber = "154564656"; order.CardType = "Visa"; order.City = "Lyon"; order.Date = DateTime.MinValue; //<-- null replacement order.PostalCode = "69004"; order.Province = "Rhone"; order.Street = "rue Durand"; dataMapper.Insert("InsertOrderViaParameterMap", order); Hashtable orderTest = (Hashtable) dataMapper.QueryForObject("GetOrderByHashTable", 99); Assert.AreEqual(orderTest["Date"], DateTime.MinValue); }