public void VerifySchemaDetection(string schemaTable, string tableSchema, string table) { SharpMap.Data.Providers.SqlServer2008 sq = new SharpMap.Data.Providers.SqlServer2008("", schemaTable, "oidcolumn"); Assert.AreEqual(tableSchema, sq.TableSchema); Assert.AreEqual(table, sq.Table); Assert.AreEqual("oidcolumn", sq.ObjectIdColumn); }
public void VerifySchemaDetection() { SharpMap.Data.Providers.SqlServer2008 sq = new SharpMap.Data.Providers.SqlServer2008("", "schema.TableName", "oidcolumn"); Assert.AreEqual("schema", sq.TableSchema); Assert.AreEqual("TableName", sq.Table); Assert.AreEqual("oidcolumn", sq.ObjectIdColumn); }
public void TestGetFeatureInvalidGeometry(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType, bool validateGeometries) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); sq.ValidateGeometries = validateGeometries; var feature = sq.GetFeature(_idInvalidGeom); NUnit.Framework.Assert.IsNotNull(feature); if (providerMode == SqlServerProviderMode.NativeSqlBytes) { // client side conversion always attempts validation NUnit.Framework.Assert.IsTrue(!feature.Geometry.IsEmpty && feature.Geometry.IsValid); } else { if (validateGeometries) { NUnit.Framework.Assert.IsTrue(!feature.Geometry.IsEmpty && feature.Geometry.IsValid); } else { NUnit.Framework.Assert.IsTrue(feature.Geometry.IsEmpty); } } }
public void TestGetFeatureNonExisting(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); var feature = sq.GetFeature(99999999); NUnit.Framework.Assert.IsNull(feature); }
public void TestGetFeatureCount() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); int count = sq.GetFeatureCount(); Assert.AreEqual(100, count); }
public void TestGetFeature() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); var feature = sq.GetFeature(1); Assert.IsNotNull(feature); }
public void TestGetFeatureNonExisting() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); var feature = sq.GetFeature(99999999); Assert.IsNull(feature); }
public void TestGetExtentsSpatialIndex() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.ExtentsMode = SharpMap.Data.Providers.SqlServer2008ExtentsMode.SpatialIndex; GeoAPI.Geometries.Envelope extents = sq.GetExtents(); Assert.IsNotNull(extents); }
public void TestGetFeatureEmptyGeometry(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); var feature = sq.GetFeature(_idEmptyGeom); NUnit.Framework.Assert.IsNotNull(feature); NUnit.Framework.Assert.IsTrue(feature.Geometry.IsEmpty); }
public void TestGetFeatureCount(SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(spatialType); int count = sq.GetFeatureCount(); // includes NULL, EMPTY, and INVALID geoms NUnit.Framework.Assert.AreEqual(_numFeatures, count); }
public void TestGetGeometriesInView() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); var geometries = sq.GetGeometriesInView(GetTestEnvelope()); Assert.IsNotNull(geometries); Assert.AreEqual(100, geometries.Count); }
public void TestGetObjectIDsInView(SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType, bool validateGeometries) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(spatialType); sq.ValidateGeometries = validateGeometries; var objectIds = sq.GetObjectIDsInView(GetTestEnvelope(spatialType)); NUnit.Framework.Assert.AreEqual(sq.ValidateGeometries ? _numValidatedGeoms : _numValidGeoms, objectIds.Count); }
public void TestGetObjectIDsInView() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); var objectIds = sq.GetObjectIDsInView(GetTestEnvelope()); Assert.IsNotNull(objectIds); Assert.AreEqual(100, objectIds.Count); }
public void TestGetExtentsQueryIndividualFeatures(SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(spatialType); sq.ExtentsMode = SharpMap.Data.Providers.SqlServer2008ExtentsMode.QueryIndividualFeatures; GeoAPI.Geometries.Envelope extents = sq.GetExtents(); NUnit.Framework.Assert.IsNotNull(extents); }
public void TestGetExtentsQueryIndividualFeatures() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.ExtentsMode = SharpMap.Data.Providers.SqlServer2008ExtentsMode.QueryIndividualFeatures; GeoAPI.Geometries.Envelope extents = sq.GetExtents(); Assert.IsNotNull(extents); }
public void TestGetFeatureCountWithDefinitionQuery(SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(SqlServerProviderMode.WellKnownBinary, spatialType); sq.DefinitionQuery = "NAME LIKE 'A%'"; int count = sq.GetFeatureCount(); NUnit.Framework.Assert.LessOrEqual(count, _numValidGeoms); }
public void TestGetGeometriesInViewFORCESEEK() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.ForceSeekHint = true; var geometries = sq.GetGeometriesInView(GetTestEnvelope()); Assert.IsNotNull(geometries); Assert.AreEqual(100, geometries.Count()); }
public void TestExecuteIntersectionQuery() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); SharpMap.Data.FeatureDataSet ds = new SharpMap.Data.FeatureDataSet(); sq.ExecuteIntersectionQuery(GetTestEnvelope(), ds); Assert.AreEqual(100, ds.Tables[0].Rows.Count); }
public void TestGetFeatureCountWithDefinitionQuery() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.DefinitionQuery = "NAME LIKE 'A%'"; int count = sq.GetFeatureCount(); Assert.LessOrEqual(count, 100); }
public void TestGetGeometriesInViewFORCEINDEX() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.ForceIndex = "IX_roads_ugl_GEOM"; var geometries = sq.GetGeometriesInView(GetTestEnvelope()); Assert.IsNotNull(geometries); Assert.AreEqual(100, geometries.Count); }
public void TestGetGeometriesInViewDefinitionQuery(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); sq.DefinitionQuery = "NAME LIKE 'A%'"; var geometries = sq.GetGeometriesInView(GetTestEnvelope(spatialType)); NUnit.Framework.Assert.IsNotNull(geometries); NUnit.Framework.Assert.LessOrEqual(geometries.Count, _numValidGeoms); }
public void TestGetGeometriesInViewNOLOCK(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType, bool validateGeometries) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); sq.NoLockHint = true; sq.ValidateGeometries = validateGeometries; var geometries = sq.GetGeometriesInView(GetTestEnvelope(spatialType)); NUnit.Framework.Assert.AreEqual(sq.ValidateGeometries ? _numValidatedGeoms : _numValidGeoms, geometries.Count); }
public void TestGetGeometriesInViewDefinitionQuery() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.DefinitionQuery = "NAME LIKE 'A%'"; var geometries = sq.GetGeometriesInView(GetTestEnvelope()); Assert.IsNotNull(geometries); Assert.LessOrEqual(geometries.Count, 100); }
public void TestExecuteIntersectionQuery(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType, bool validateGeometries) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); sq.ValidateGeometries = validateGeometries; SharpMap.Data.FeatureDataSet ds = new SharpMap.Data.FeatureDataSet(); sq.ExecuteIntersectionQuery(GetTestEnvelope(spatialType), ds); NUnit.Framework.Assert.AreEqual(sq.ValidateGeometries ? _numValidatedGeoms : _numValidGeoms, ds.Tables[0].Rows.Count); }
public void TestGetGeometriesInViewAllHints() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.NoLockHint = true; sq.ForceSeekHint = true; sq.ForceIndex = "IX_roads_ugl_GEOM"; var geometries = sq.GetGeometriesInView(GetTestEnvelope()); Assert.IsNotNull(geometries); Assert.AreEqual(100, geometries.Count()); }
public void VerifySchemaDetection(string schemaTable, string tableSchema, string table) { SharpMap.Data.Providers.SqlServer2008 sq = new SharpMap.Data.Providers.SqlServer2008("", schemaTable, "oidcolumn"); NUnit.Framework.Assert.AreEqual(tableSchema, sq.TableSchema); NUnit.Framework.Assert.AreEqual(table, sq.Table); NUnit.Framework.Assert.AreEqual("oidcolumn", sq.ObjectIdColumn); System.Reflection.PropertyInfo pi = sq.GetType().GetProperty("QualifiedTable", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.GetProperty); string qualifiedTable = (string)pi.GetValue(sq, null); NUnit.Framework.Assert.IsTrue(qualifiedTable.Contains(tableSchema)); NUnit.Framework.Assert.IsTrue(qualifiedTable.Contains(table)); }
public void TestGetGeometriesInViewFORCEINDEX(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType, bool validateGeometries) { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); sq.ForceIndex = spatialType == SharpMap.Data.Providers.SqlServerSpatialObjectType.Geometry ? GeometrySpatialIndex : GeographySpatialIndex; sq.ValidateGeometries = validateGeometries; var geometries = sq.GetGeometriesInView(GetTestEnvelope(spatialType)); NUnit.Framework.Assert.IsNotNull(geometries); // NOTE ValidateGeometries is ignored when using ForceIndex NUnit.Framework.Assert.AreEqual(_numValidGeoms, geometries.Count); }
public void TestExecuteIntersectionQueryAllHints() { SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(); sq.NoLockHint = true; sq.ForceSeekHint = true; sq.ForceIndex = "IX_roads_ugl_GEOM"; SharpMap.Data.FeatureDataSet ds = new SharpMap.Data.FeatureDataSet(); sq.ExecuteIntersectionQuery(GetTestEnvelope(), ds); Assert.AreEqual(100, ds.Tables[0].Rows.Count); }
public void TestExecuteIntersectionQueryExceedGeogMaxExtents(SqlServerProviderMode providerMode, SharpMap.Data.Providers.SqlServerSpatialObjectType spatialType, double x1, double x2, double y1, double y2) { // occurs when user zooms out beyond map extents. For Geog, when latitude approaches 90 N or S can result in // error 24206: "The specified input cannot be accepted because it contains an edge with antipodal points." // Longitudes exceeding -179.99999999 or 180.0 are "wrapped" resulting in unexpected polygon (also contributes to err 24206) SharpMap.Data.Providers.SqlServer2008 sq = GetTestProvider(providerMode, spatialType); SharpMap.Data.FeatureDataSet ds = new SharpMap.Data.FeatureDataSet(); sq.ExecuteIntersectionQuery(new GeoAPI.Geometries.Envelope(x1, x2, y1, y2), ds); NUnit.Framework.Assert.AreEqual(sq.ValidateGeometries ? _numValidatedGeoms : _numValidGeoms, ds.Tables[0].Rows.Count); }
public void TestGetGeometriesInViewEx() { // Note: // This test may fail with an InvalidCastException. This is caused by multiple versions of the // Microsoft.SqlServer.Types assembly being available (e.g. SQL 2008 and 2012). // This can be solved with a <bindingRedirect> in the .config file. // http://connect.microsoft.com/SQLServer/feedback/details/685654/invalidcastexception-retrieving-sqlgeography-column-in-ado-net-data-reader SharpMap.Data.Providers.SqlServer2008 sq = GetTestProviderEx(); var geometries = sq.GetGeometriesInView(GetTestEnvelope()); Assert.IsNotNull(geometries); Assert.AreEqual(100, geometries.Count); }