public void LocationsRepositoryTest()
{
//Container initialization
string connectionString = "";
var container = new WindsorContainer();
container.Register(
Component.For <ILocationsRepository>()
.ImplementedBy <PostgresqLocationsRepository>()
.DependsOn(Dependency.OnValue("connectionString", connectionString))
.Named("pgrslocrepo"));
//Test
ILocationsRepository locationRepository = container.Resolve <ILocationsRepository>();
//Category Test
string newCategory = "aggghtldon";
Assert.IsFalse(locationRepository.DeleteCategory(newCategory));
Assert.IsTrue(locationRepository.InsertCategory(newCategory, null) != -1);
Assert.IsTrue(locationRepository.DeleteCategory(newCategory));
//Location Test
var enumerator = locationRepository.GetCategories().GetEnumerator();
enumerator.MoveNext(); int pCatId = locationRepository.GetCategoryByName(enumerator.Current.Key).Id;
var userId = "-a1";
var loc = new Location
{
UserId = userId,
PCatId = pCatId,
Name = "TestLocation",
Lat = "11",
Lng = "12",
Desc = "A description",
Type = "POI"
};
int id = locationRepository.Insert(loc);
Assert.AreEqual(locationRepository.GetOwnerId(id), userId);
LocationDTO locdto1 = locationRepository.GetById(id);
loc.Desc = "New description";
Assert.IsTrue(locationRepository.Update(id, loc));
Assert.IsFalse(locationRepository.Update(-1, loc));
LocationDTO locdto2 = locationRepository.GetById(id);
Assert.AreNotEqual(locdto1, locdto2);
var locs = new List <LocationDTO>(locationRepository.GetByUserId(userId));
Assert.IsTrue(locs.Count == 1);
Assert.AreEqual(locs[0], locdto2);
Assert.IsTrue(locationRepository.DeleteById(id));
var newLocs = new List <LocationDTO>(locationRepository.GetByUserId(userId));
Assert.IsTrue(newLocs.Count == 0);
Assert.IsNull(locationRepository.GetById(id));
}