public void GetConfigurationTest() { ConfigurationDAO target = new ConfigurationDAO(connnetion); int indicatorId = 1; string geoLevel = "NUTS1"; Configuration expected = new Configuration { ID = 1, GeoLevel = "NUTS1", Shapefile = new Shapefile { ID = 4, FileName = "nuts1.shp", Name = "NUTS1", Path = "D:\\Dropbox\\My Dropbox\\Tese\\shapefiles\\sapo\\GIS\\NUTS1", Level = 1 } }; Configuration actual; actual = target.GetConfiguration(indicatorId, geoLevel); Assert.AreEqual(expected, actual); }
public void GetConfigurationsTest() { ConfigurationDAO target = new ConfigurationDAO(connnetion); int indicatorId = 1; IEnumerable<Configuration> actual; actual = target.GetConfigurations(indicatorId); Assert.AreEqual(actual.Count(), 5); Assert.AreEqual(actual.ElementAt(0).GeoLevel, "NUTS1"); Assert.AreEqual(actual.ElementAt(1).GeoLevel, "NUTS2"); Assert.AreEqual(actual.ElementAt(2).GeoLevel, "NUTS3"); Assert.AreEqual(actual.ElementAt(3).GeoLevel, "Municipalities"); Assert.AreEqual(actual.ElementAt(4).GeoLevel, "Parishes"); }
public static void addConfiguration(DbConnection conn, Indicator indicator, string lowestGeoLevel) { var configurationDAO = new ConfigurationDAO(conn); for (int geoLevel = int.Parse(lowestGeoLevel); geoLevel >= 2; --geoLevel) { GEOLevels level = (GEOLevels)geoLevel; Console.WriteLine("... Adding configuration: {0} ....", level.ToString()); DataStore.Common.Model.Configuration config = new DataStore.Common.Model.Configuration { GeoLevel = level.ToString(), Shapefile = new Shapefile { ID = SHAPEFILE_IDS[level] } }; configurationDAO.AddConfiguration(indicator.ID, config); } }
public void ConfigurationDAOConstructorTest() { ConfigurationDAO target = new ConfigurationDAO(); Assert.AreNotEqual(target, null); }
public void GetShapefileConfigurationURLTest() { ConfigurationDAO target = new ConfigurationDAO(connnetion); int indicatorId = 1; string geoLevel = "NUTS1"; string expected = "D:\\Dropbox\\My Dropbox\\Tese\\shapefiles\\sapo\\GIS\\NUTS1\\nuts1.shp"; string actual; actual = target.GetShapefileConfigurationURL(indicatorId, geoLevel); Assert.AreEqual(expected, actual); }