Package com.esri.sde.sdk.client

Examples of com.esri.sde.sdk.client.SeQueryInfo

93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
            }
            orderAndOrGroupByClause += " " + ob;
        }

        // build SeQueryInfo
        SeQueryInfo qinfo = new SeQueryInfo();
        qinfo.setColumns(columns);

        SeSqlConstruct sqlConstruct = new SeSqlConstruct();
        sqlConstruct.setTables(tables);
        if (where != null) {
            sqlConstruct.setWhere(where);
        }

        qinfo.setConstruct(sqlConstruct);

        if (orderAndOrGroupByClause != null) {
            qinfo.setByClause(orderAndOrGroupByClause);
        }

        return qinfo;
    }
View Full Code Here
361
362
363
364
365
366
367
368
369
370
371
        if (queryFilter == Filter.EXCLUDE || queryFilter.equals(Filter.EXCLUDE)) {
            return new EmptyFeatureReader<SimpleFeatureType, SimpleFeature>(targetSchema);
        }

        if (typeInfo.isInProcessView()) {
            SeQueryInfo definitionQuery = typeInfo.getSdeDefinitionQuery();
            PlainSelect viewSelectStatement = typeInfo.getDefinitionQuery();
            sdeQuery = ArcSDEQuery.createInprocessViewQuery(session, completeSchema, query,
                    definitionQuery, viewSelectStatement);
        } else {
            final FIDReader fidStrategy = typeInfo.getFidStrategy();
View Full Code Here
730
731
732
733
734
735
736
737
738
739
740
        try {
            final PlainSelect qualifiedSelect = SelectQualifier.qualify(session, select);
            // System.out.println(qualifiedSelect);

            final SeQueryInfo queryInfo;
            try {
                LOGGER.fine("creating definition query info");
                queryInfo = QueryInfoParser.parse(session, qualifiedSelect);
            } catch (SeException e) {
                throw new ArcSdeException("Error Parsing select: " + qualifiedSelect, e);
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
486
487
488
                InProcessViewSupportTestData.CHILD + ".DESCRIPTION",
                InProcessViewSupportTestData.MASTER + ".SHAPE" };
        final int shapeIndex = 5;
        final int expectedCount = 7;

        final SeQueryInfo queryInfo = new SeQueryInfo();
        queryInfo.setConstruct(sqlConstruct);
        queryInfo.setColumns(propertyNames);
        queryInfo.setByClause(" ORDER BY " + InProcessViewSupportTestData.CHILD + ".ID DESC");

        final Integer[] expectedChildIds = { new Integer(7), new Integer(6), new Integer(5),
                new Integer(4), new Integer(3), new Integer(2), new Integer(1) };

        // final int[] expectedShapeIndicators = { SeRow.SE_IS_NOT_NULL_VALUE, // child7
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
    public void testGetBoundsWhileFetchingRows() throws Exception {
        final String typeName = testData.getTempTableName();
        final String[] columns = { TestData.TEST_TABLE_COLS[0] };
        final SeSqlConstruct sql = new SeSqlConstruct(typeName);

        final SeQueryInfo qInfo = new SeQueryInfo();
        qInfo.setConstruct(sql);

        // add a bounding box filter and verify both spatial and non spatial
        // constraints affects the COUNT statistics
        SeExtent extent = new SeExtent(-180, -90, -170, -80);
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
264
                if (state != null) {
                    SeObjectId differencesId = new SeObjectId(SeState.SE_NULL_STATE_ID);
                    query.setState(state.getId(), differencesId, SeState.SE_STATE_DIFF_NOCHECK);
                }
                SeQueryInfo qInfo = new SeQueryInfo();
                qInfo.setConstruct(sql);

                if (spatFilters != null) {
                    query.setSpatialConstraints(SeQuery.SE_OPTIMIZE, true, spatFilters);
                }
View Full Code Here
345
346
347
348
349
350
351
352
353
354
355
356
357
        String[] cols = { "SHAPE" };

        SeSqlConstruct sqlCons = new SeSqlConstruct(typeName);
        sqlCons.setWhere(where);

        final SeQueryInfo seQueryInfo = new SeQueryInfo();
        seQueryInfo.setColumns(cols);
        seQueryInfo.setConstruct(sqlCons);

        SeExtent extent = session.issue(new Command<SeExtent>() {
            @Override
            public SeExtent execute(ISession session, SeConnection connection) throws SeException,
                    IOException {
View Full Code Here
393
394
395
396
397
398
399
400
401
402
403
404
405
            throw new ArcSdeException(eek);
        }
        SeSqlConstruct sqlCons = new SeSqlConstruct(typeName);
        // sqlCons.setWhere(where);

        final SeQueryInfo seQueryInfo = new SeQueryInfo();
        seQueryInfo.setColumns(cols);
        seQueryInfo.setConstruct(sqlCons);

        SeExtent extent = session.issue(new Command<SeExtent>() {

            @Override
            public SeExtent execute(ISession session, SeConnection connection) throws SeException,
View Full Code Here
445
446
447
448
449
450
451
452
453
454
455
456
457
            throw new ArcSdeException(eek);
        }
        SeSqlConstruct sqlCons = new SeSqlConstruct(typeName);
        sqlCons.setWhere(where);

        final SeQueryInfo seQueryInfo = new SeQueryInfo();
        seQueryInfo.setColumns(cols);
        seQueryInfo.setConstruct(sqlCons);

        SeExtent extent = session.issue(new Command<SeExtent>() {
            @Override
            public SeExtent execute(ISession session, SeConnection connection) throws SeException,
                    IOException {
View Full Code Here
TOP

Related Classes of com.esri.sde.sdk.client.SeQueryInfo

  • org.geotools.arcsde.data.ArcSDEDataStore
  • org.geotools.arcsde.data.ArcSDEJavaApiTest
  • org.geotools.arcsde.data.ArcSDEQuery
  • org.geotools.arcsde.data.ArcSDEQuery$FilterSet
  • org.geotools.arcsde.data.LargePolygonsPerfTest
  • org.geotools.arcsde.data.SDEJavaApiJoinTest
  • org.geotools.arcsde.data.view.QueryInfoParser
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.