public void TestCrud() { Country country = new Country(); country.Name = GetNewString(); City city = new City(); city.Name = GetNewString(); city.Country = country; Account acct = new Account(); acct.Created = acct.LastLogin = acct.Modified = DateTime.UtcNow; acct.Name = "Test User"; acct.Password = "******"; acct.Birthday = new DateTime(1976, 9, 7); PlaceType placetype = new PlaceType(); placetype.Name = GetNewString(); Place place = new Place(); place.Account = acct; place.Name = GetNewString(); place.Created = place.Modified = DateTime.UtcNow; place.City = city; place.Type = placetype; AccountPlaceFavorite fav = new AccountPlaceFavorite(); fav.Account = acct; fav.Place = place; fav.Created = DateTime.UtcNow; Session.Save(placetype); Session.Save(country); Session.Save(city); Session.Save(acct); Session.Save(place); Session.Save(fav); Session.Flush(); Assert.IsTrue(acct.Id > 0); Assert.IsTrue(place.Id > 0); Assert.IsTrue(fav.Id > 0); Session.Delete(acct); Session.Delete(placetype); Session.Delete(city); Session.Delete(country); Session.Flush(); }
public void TestCrudMultipleSelect() { Country country = new Country(); country.Name = GetNewString(); City city = new City(); city.Name = GetNewString(); city.Country = country; Account acct = new Account(); acct.Created = acct.LastLogin = acct.Modified = DateTime.UtcNow; acct.Name = "Test User"; acct.Password = "******"; acct.Birthday = new DateTime(1976, 9, 7); PlaceType placetype = new PlaceType(); placetype.Name = GetNewString(); Place place = new Place(); place.Account = acct; place.Name = GetNewString(); place.Created = place.Modified = DateTime.UtcNow; place.City = city; place.Type = placetype; Place place2 = new Place(); place2.Account = acct; place2.Name = GetNewString(); place2.Created = place2.Modified = DateTime.UtcNow; place2.City = city; place2.Type = placetype; AccountPlaceFavorite fav = new AccountPlaceFavorite(); fav.Account = acct; fav.Place = place; fav.Created = DateTime.UtcNow; AccountPlaceFavorite fav2 = new AccountPlaceFavorite(); fav2.Account = acct; fav2.Place = place2; fav2.Created = DateTime.UtcNow; Session.Save(placetype); Session.Save(country); Session.Save(city); Session.Save(acct); Session.Save(place); Session.Save(place2); Session.Save(fav); Session.Save(fav2); Session.Flush(); Assert.IsTrue(acct.Id > 0); Assert.IsTrue(place.Id > 0); Assert.IsTrue(place2.Id > 0); Assert.IsTrue(fav.Id > 0); Assert.IsTrue(fav2.Id > 0); IQuery q = Session.CreateQuery("SELECT COUNT(DISTINCT apf.Place) FROM AccountPlaceFavorite apf"); Assert.AreEqual(1, q.List().Count, "Expected an integer as a result of a COUNT(DISTINCT)."); int result = q.UniqueResult<int>(); Assert.IsTrue(result >= 2, "Expected at least two results."); Session.Delete(acct); Session.Delete(placetype); Session.Delete(city); Session.Delete(country); Session.Flush(); }
public void TestCrudMultipleSelect() { Country country = new Country(); country.Name = GetNewString(); City city = new City(); city.Name = GetNewString(); city.Country = country; Account acct = new Account(); acct.Created = acct.LastLogin = acct.Modified = DateTime.UtcNow; acct.Name = "Test User"; acct.Password = "******"; acct.Birthday = new DateTime(1976, 9, 7); PlaceType placetype = new PlaceType(); placetype.Name = GetNewString(); Place place = new Place(); place.Account = acct; place.Name = GetNewString(); place.Created = place.Modified = DateTime.UtcNow; place.City = city; place.Type = placetype; Place place2 = new Place(); place2.Account = acct; place2.Name = GetNewString(); place2.Created = place2.Modified = DateTime.UtcNow; place2.City = city; place2.Type = placetype; AccountPlaceFavorite fav = new AccountPlaceFavorite(); fav.Account = acct; fav.Place = place; fav.Created = DateTime.UtcNow; AccountPlaceFavorite fav2 = new AccountPlaceFavorite(); fav2.Account = acct; fav2.Place = place2; fav2.Created = DateTime.UtcNow; Session.Save(placetype); Session.Save(country); Session.Save(city); Session.Save(acct); Session.Save(place); Session.Save(place2); Session.Save(fav); Session.Save(fav2); Session.Flush(); Assert.IsTrue(acct.Id > 0); Assert.IsTrue(place.Id > 0); Assert.IsTrue(place2.Id > 0); Assert.IsTrue(fav.Id > 0); Assert.IsTrue(fav2.Id > 0); IQuery q = Session.CreateQuery("SELECT COUNT(DISTINCT apf.Place) FROM AccountPlaceFavorite apf"); Assert.AreEqual(1, q.List().Count, "Expected an integer as a result of a COUNT(DISTINCT)."); int result = q.UniqueResult <int>(); Assert.IsTrue(result >= 2, "Expected at least two results."); Session.Delete(acct); Session.Delete(placetype); Session.Delete(city); Session.Delete(country); Session.Flush(); }