public void CanSortByStringField() { IFeatureWorkspace featureWs = WorkspaceUtils.OpenFileGdbFeatureWorkspace(TestData.GetArealeFileGdbPath()); ITable table = DatasetUtils.OpenTable(featureWs, "TLM_NUTZUNGSAREAL"); const string operatorFieldName = "OPERATEUR"; ICursor cursor = TableSortUtils.GetSortedTableCursor(table, operatorFieldName); int fieldIndex = cursor.FindField(operatorFieldName); Assert.True(fieldIndex >= 0, "Field not found"); string lastValue = null; IRow row; while ((row = cursor.NextRow()) != null) { object value = row.get_Value(fieldIndex); Assert.False(value == DBNull.Value, "Empty field"); var currentValue = (string)value; Console.WriteLine(currentValue); if (lastValue != null) { Assert.False(currentValue.CompareTo(lastValue) < 0, "Not sorted"); } lastValue = currentValue; } }
public void CanCreateSpatialFilterWithNonZSimpleGeometry() { IFeatureWorkspace ws = OpenTestWorkspace(); IFeatureClass fc = ws.OpenFeatureClass("TOPGIS_TLM.TLM_STRASSE"); IEnvelope nonZSimpleEnvelope = GeometryFactory.CreateEnvelope(2600000, 1200000, 2700000, 1300000); GeometryUtils.MakeZAware(nonZSimpleEnvelope); Assert.False(((IZAware)nonZSimpleEnvelope).ZSimple, "Must be non-Z-simple"); ISpatialReference spatialReference = Assert.NotNull(DatasetUtils.GetSpatialReference(fc)); IGeometry validGeometry; string message; Assert.False(GdbQueryUtils.IsValidFilterGeometry( nonZSimpleEnvelope, SpatialReferenceUtils.GetXyResolution(spatialReference), out validGeometry, out message), "Search geometry should not be valid"); Assert.NotNull(validGeometry); IQueryFilter filter = GdbQueryUtils.CreateSpatialFilter(fc, nonZSimpleEnvelope); Assert.True(GdbQueryUtils.GetFeatures(fc, filter, true).Any(), "No features found"); }
public void Learning_CanFindFeaturesWithNonZSimpleSearchGeometry() { // 10.2.1: Test fails (correct) with COM Exception on OpenCursor // 10.4.1: Test fails (correct) with COM Exception on OpenCursor // 10.6.1: Test passes (incorrectly!), no features found IFeatureWorkspace ws = OpenTestWorkspace(); IFeatureClass fc = ws.OpenFeatureClass("TOPGIS_TLM.TLM_STRASSE"); IEnvelope nonZSimpleEnvelope = GeometryFactory.CreateEnvelope(2600000, 1200000, 2700000, 1300000); GeometryUtils.MakeZAware(nonZSimpleEnvelope); Assert.False(((IZAware)nonZSimpleEnvelope).ZSimple, "Must be non-Z-simple"); ISpatialReference spatialReference = DatasetUtils.GetSpatialReference(fc); nonZSimpleEnvelope.SpatialReference = spatialReference; ISpatialFilter spatialFilter = new SpatialFilterClass(); spatialFilter.GeometryField = fc.ShapeFieldName; spatialFilter.set_GeometryEx(nonZSimpleEnvelope, true); spatialFilter.SpatialRel = esriSpatialRelEnum.esriSpatialRelIntersects; Assert.AreEqual(0, GdbQueryUtils.GetFeatures(fc, spatialFilter, true).Count(), "Behaviour changed: Now features are found even with non-Z-simple search geometry."); }
public void TableSortGuidFileGdb() { IFeatureWorkspace featureWs = WorkspaceUtils.OpenFileGdbFeatureWorkspace(TestData.GetArealeFileGdbPath()); //IFeatureWorkspace featureWs = OpenTestWorkspace(); ITable table = DatasetUtils.OpenTable(featureWs, "TLM_NUTZUNGSAREAL"); ITableSort tableSort = new TableSortClass(); tableSort.Table = table; tableSort.Fields = "UUID"; tableSort.Sort(null); ICursor cursor = tableSort.Rows; IRow row; Guid lastValue = Guid.Empty; while ((row = cursor.NextRow()) != null) { object value = row.get_Value(1); Assert.False(value == DBNull.Value, "Empty UUID field"); var currentGuid = new Guid((string)value); IComparable currentValue = currentGuid; Console.WriteLine(currentValue); if (lastValue != Guid.Empty) { // ITableSort on a GUID field in a file GDB does not sort the byte array or at least not in an obvious way byte[] currentGuidAsByteArray = currentGuid.ToByteArray(); byte[] lastGuidAsByteArray = lastValue.ToByteArray(); int byteArrayCompare = ByteArrayCompare(currentGuidAsByteArray, lastGuidAsByteArray); //Assert.True(byteArrayCompare > 0, "Different compare algorithm from byte array"); // ITableSort on a GUID field in a file GDB does not sort the same way as SqlGuid in .NET (i.e. SQL Server sorting) var sqlGuid = new SqlGuid(currentGuid); int sqlGuidCompare = sqlGuid.CompareTo(new SqlGuid(lastValue)); //Assert.True(sqlGuidCompare < 0, "Different compare algorithm from sql server"); // ITableSort on a GUID field in a file GDB does not sort the same way as Guid in .NET IComparable comparableGuid = lastValue; int guidCompare = comparableGuid.CompareTo(currentValue); //Assert.True(guidCompare < 0, "Different compare algorithm from .Net."); } lastValue = currentGuid; } }
public void CanCreateSpatialFilterWithSubResolutionEnvelope() { IFeatureWorkspace ws = OpenTestWorkspace(); IFeatureClass fc = ws.OpenFeatureClass("TOPGIS_TLM.TLM_STRASSE"); IEnvelope subResolutionEnv = GeometryFactory.CreateEnvelope(2600000, 1200000, 2600000.0001, 1200000.0001); ISpatialReference spatialReference = DatasetUtils.GetSpatialReference(fc); subResolutionEnv.SpatialReference = spatialReference; double xyResolution = SpatialReferenceUtils.GetXyResolution(Assert.NotNull(spatialReference)); IGeometry validGeometry; string message; Assert.False(GdbQueryUtils.IsValidFilterGeometry( subResolutionEnv, xyResolution, out validGeometry, out message), "Sub-resolution polygon should not be valid"); Assert.NotNull(validGeometry); Assert.False(subResolutionEnv == validGeometry, "Corrected geometry must be different to input"); Assert.True(GdbQueryUtils.IsValidFilterGeometry( validGeometry, xyResolution, out validGeometry, out message), "Corrected geometry should be valid"); IQueryFilter filter = GdbQueryUtils.CreateSpatialFilter( fc, subResolutionEnv, esriSpatialRelEnum.esriSpatialRelIntersects, false, spatialReference); IFeatureCursor cursor = fc.Search(filter, true); Marshal.ReleaseComObject(cursor); IEnvelope linearEnv = GeometryFactory.CreateEnvelope(2600000, 1200000, 2600000.0001, 1201010); linearEnv.SpatialReference = ((IGeoDataset)fc).SpatialReference; filter = GdbQueryUtils.CreateSpatialFilter( fc, linearEnv, esriSpatialRelEnum.esriSpatialRelIntersects, true, null); cursor = fc.Search(filter, true); Marshal.ReleaseComObject(cursor); }
public void CanCreateSpatialFilterWithEmptyPolygon() { IFeatureWorkspace ws = OpenTestWorkspace(); IFeatureClass fc = ws.OpenFeatureClass("TOPGIS_TLM.TLM_STRASSE"); IPolygon emptyPoly = new PolygonClass(); emptyPoly.SpatialReference = ((IGeoDataset)fc).SpatialReference; IGeometry validGeometry; string message; Assert.False(GdbQueryUtils.IsValidFilterGeometry( emptyPoly, 0.001, out validGeometry, out message), "Empty polygon should not be valid"); Assert.Null(validGeometry); if (RuntimeUtils.Is10_4orHigher) { NUnit.Framework.Assert.Catch <Exception>( () => GdbQueryUtils.CreateSpatialFilter(fc, emptyPoly)); } ISpatialFilter spatialFilter = new SpatialFilterClass(); spatialFilter.GeometryField = fc.ShapeFieldName; spatialFilter.set_GeometryEx(emptyPoly, true); spatialFilter.SpatialRel = esriSpatialRelEnum.esriSpatialRelIntersects; IFeatureCursor cursor = null; if (RuntimeUtils.Is10_1 || RuntimeUtils.Is10_2 || RuntimeUtils.Is10_3 || RuntimeUtils.Is10_4orHigher) { NUnit.Framework.Assert.Throws <NullReferenceException>( () => cursor = fc.Search(spatialFilter, true)); } else { cursor = fc.Search(spatialFilter, true); } if (cursor != null) { Marshal.ReleaseComObject(cursor); } }
private static void LoopAndWrite(ICursor cursor, string uuidFieldName) { int fieldIndex = cursor.FindField(uuidFieldName); Assert.True(fieldIndex >= 0, "Field not found"); IRow row; while ((row = cursor.NextRow()) != null) { object value = row.get_Value(fieldIndex); Assert.False(value == DBNull.Value, "Empty UUID field"); var currentGuid = new Guid((string)value); IComparable currentValue = currentGuid; // value as IComparable; // currentGuid; Console.WriteLine(currentValue); } }
public void OrderByGuidFileGdb() { IFeatureWorkspace featureWs = WorkspaceUtils.OpenFileGdbFeatureWorkspace(TestData.GetArealeFileGdbPath()); ITable table = DatasetUtils.OpenTable(featureWs, "TLM_NUTZUNGSAREAL"); IQueryFilter queryFilter = new QueryFilterClass(); var queryFilterDef = (IQueryFilterDefinition)queryFilter; queryFilterDef.PostfixClause = "ORDER BY UUID"; foreach (IRow row in GdbQueryUtils.GetRows(table, queryFilter, true)) { object value = row.get_Value(1); Assert.False(value == DBNull.Value, "Empty UUID field"); var currentGuid = new Guid((string)value); Console.WriteLine(currentGuid); } }
public void CanSortOnFgdbGuids() { IFeatureWorkspace featureWs = WorkspaceUtils.OpenFileGdbFeatureWorkspace(TestData.GetArealeFileGdbPath()); //IFeatureWorkspace featureWs = OpenTestWorkspace(); ITable table = DatasetUtils.OpenTable(featureWs, "TLM_NUTZUNGSAREAL"); //ITable table = DatasetUtils.OpenTable(featureWs, "TOPGIS_TLM.TLM_NUTZUNGSAREAL"); const string uuidFieldName = "UUID"; ICursor cursor = TableSortUtils.GetGuidFieldSortedCursor(table, uuidFieldName); int fieldIndex = cursor.FindField(uuidFieldName); Assert.True(fieldIndex >= 0, "Field not found"); Guid lastGuid = Guid.Empty; IRow row; while ((row = cursor.NextRow()) != null) { object value = row.get_Value(fieldIndex); Assert.False(value == DBNull.Value, "Empty UUID field"); var currentGuid = new Guid((string)value); Console.WriteLine(currentGuid); if (lastGuid != Guid.Empty) { Assert.False(currentGuid.CompareTo(lastGuid) < 0, "Not sorted"); } lastGuid = currentGuid; } }