Examples with SelectResults org.apache.geode.cache.query.SelectResults used on opensource projects

Example 86 with SelectResults

use of org.apache.geode.cache.query.SelectResults in project geode by apache.

the class MapRangeIndexMaintenanceJUnitTest method updatingWithSameKeysDifferentValuesAfterRemovingUsingRegionDestroyShouldReinsertIndexMappings.

@Test
public void updatingWithSameKeysDifferentValuesAfterRemovingUsingRegionDestroyShouldReinsertIndexMappings() throws Exception {
    AttributesFactory af = new AttributesFactory();
    af.setScope(Scope.LOCAL);
    region = CacheUtils.createRegion("portfolio", af.create(), false);
    qs = CacheUtils.getQueryService();
    Index keyIndex1 = qs.createIndex(INDEX_NAME, "positions[*]", "/portfolio");
    Portfolio p1 = new Portfolio(1, 1);
    HashMap map1 = new HashMap();
    map1.put("SUN", 1);
    map1.put("IBM", 2);
    p1.positions = map1;
    region.put(1, p1);
    SelectResults results = (SelectResults) qs.newQuery("select * from /portfolio p where p.positions['SUN'] = 1").execute();
    assertEquals(1, results.size());
    region.destroy(1);
    results = (SelectResults) qs.newQuery("select * from /portfolio p where p.positions['SUN'] = 1").execute();
    assertEquals(0, results.size());
    Portfolio p3 = new Portfolio(1, 1);
    HashMap map3 = new HashMap();
    p3.positions = map3;
    map3.put("SUN", 3);
    map3.put("IBM", 4);
    region.put(1, p3);
    results = (SelectResults) qs.newQuery("select * from /portfolio p where p.positions['SUN'] = 1").execute();
    assertEquals(0, results.size());
    results = (SelectResults) qs.newQuery("select * from /portfolio p where p.positions['SUN'] = 3").execute();
    assertEquals(1, results.size());
    results = (SelectResults) qs.newQuery("select * from /portfolio p where p.positions['GOOG'] = 1").execute();
    assertEquals(0, results.size());
}

Example 87 with SelectResults

use of org.apache.geode.cache.query.SelectResults in project geode by apache.

the class MapRangeIndexMaintenanceJUnitTest method testUpdateWithSameKeysSameValuesShouldRetainIndexMappings.

@Test
public void testUpdateWithSameKeysSameValuesShouldRetainIndexMappings() throws Exception {
    AttributesFactory af = new AttributesFactory();
    af.setScope(Scope.LOCAL);
    Portfolio p = new Portfolio(1, 1);
    HashMap map1 = new HashMap();
    map1.put("SUN", 1);
    map1.put("IBM", 2);
    p.positions = map1;
    region = CacheUtils.createRegion("portfolio", af.create(), false);
    region.put(1, p);
    qs = CacheUtils.getQueryService();
    keyIndex1 = (IndexProtocol) qs.createIndex(INDEX_NAME, "positions[*]", "/portfolio");
    region.put(1, p);
    SelectResults results = (SelectResults) qs.newQuery("select * from /portfolio p where p.positions['SUN'] = 1").execute();
    assertEquals(1, results.size());
}

Example 88 with SelectResults

use of org.apache.geode.cache.query.SelectResults in project geode by apache.

the class IndexUseJUnitTest method evaluatePKIndexUsetest.

private void evaluatePKIndexUsetest(RegionShortcut regionShortcut, String regionName) throws Exception {
    Cache cache = CacheUtils.getCache();
    Region r = cache.createRegionFactory(regionShortcut).create(regionName);
    Map map0 = new HashMap();
    Map map1 = new HashMap();
    Map map2 = new HashMap();
    r.put("A0", map0);
    r.put("A1", map1);
    r.put("A2", map2);
    qs.createIndex("pkIndex", IndexType.PRIMARY_KEY, "p.pk", "/" + regionName + " p");
    QueryObserverImpl observer = new QueryObserverImpl();
    QueryObserverHolder.setInstance(observer);
    SelectResults sr = (SelectResults) qs.newQuery("select * from /" + regionName + " p where p.pk = 'A1'").execute();
    assertEquals(1, sr.size());
    if (!observer.isIndexesUsed) {
        fail("Index not used for operator '='");
    }
}

Example 89 with SelectResults

use of org.apache.geode.cache.query.SelectResults in project geode by apache.

the class IndexTrackingQueryObserverDUnitTest method runQuery.

private void runQuery(VM vm) {
    SerializableRunnable runQuery = new SerializableRunnable("Run Query on PR") {

        public void run() {
            QueryService qs = getCache().getQueryService();
            Query query = qs.newQuery(queryStr);
            Region region = getCache().getRegion("portfolio");
            SelectResults results = null;
            try {
                results = (SelectResults) query.execute();
            } catch (Exception e) {
                Assert.fail("While running query on PR", e);
            }
            // The query should return all elements in region.
            assertEquals(region.size(), results.size());
        }
    };
    vm.invoke(runQuery);
}

Example 90 with SelectResults

use of org.apache.geode.cache.query.SelectResults in project geode by apache.

the class IndexUseJUnitTest method testIndexUsageWithOrderBy.

@Test
public void testIndexUsageWithOrderBy() throws Exception {
    QueryService qs;
    qs = CacheUtils.getQueryService();
    LocalRegion testRgn = (LocalRegion) CacheUtils.createRegion("testRgn", null);
    int numObjects = 30;
    // and so on
    for (int i = 0; i < numObjects; i++) {
        Portfolio p = new Portfolio(i);
        p.pkid = ("" + (numObjects - i));
        testRgn.put("" + i, p);
    }
    qs = CacheUtils.getQueryService();
    String[] queries = { "SELECT DISTINCT * FROM /testRgn p  WHERE p.ID <= 10 order by p.pkid asc limit 1", "SELECT DISTINCT * FROM /testRgn p  WHERE p.ID <= 10 order by p.pkid desc limit 1" };
    Object[][] r = new Object[queries.length][2];
    // Execute Queries without Indexes
    for (int i = 0; i < queries.length; i++) {
        Query q = null;
        try {
            q = CacheUtils.getQueryService().newQuery(queries[i]);
            CacheUtils.getLogger().info("Executing query: " + queries[i]);
            // verify individual result
            SelectResults sr = (SelectResults) q.execute();
            List results = sr.asList();
            for (int rows = 0; rows < results.size(); rows++) {
                Portfolio p = (Portfolio) results.get(0);
                CacheUtils.getLogger().info("p: " + p);
                if (i == 0) {
                    assertEquals(p.getID(), 10);
                    assertEquals(p.pkid, "" + (numObjects - 10));
                } else if (i == 1) {
                    assertEquals(p.getID(), 0);
                    assertEquals(p.pkid, "" + numObjects);
                }
            }
            r[i][0] = sr;
            CacheUtils.log("Executed query: " + queries[i]);
        } catch (Exception e) {
            e.printStackTrace();
            fail(q.getQueryString());
        }
    }
    Index i1 = qs.createIndex("Index1", IndexType.FUNCTIONAL, "p.ID", "/testRgn p");
    // Execute Queries with Indexes
    for (int i = 0; i < queries.length; i++) {
        Query q = null;
        try {
            q = CacheUtils.getQueryService().newQuery(queries[i]);
            CacheUtils.getLogger().info("Executing query: " + queries[i]);
            QueryObserverImpl observer = new QueryObserverImpl();
            QueryObserverHolder.setInstance(observer);
            SelectResults sr = (SelectResults) q.execute();
            List results = sr.asList();
            for (int rows = 0; rows < results.size(); rows++) {
                Portfolio p = (Portfolio) results.get(0);
                CacheUtils.getLogger().info("index p: " + p);
                if (i == 0) {
                    assertEquals(p.getID(), 10);
                    assertEquals(p.pkid, "" + (numObjects - 10));
                } else if (i == 1) {
                    assertEquals(p.getID(), 0);
                    assertEquals(p.pkid, "" + numObjects);
                }
            }
            r[i][1] = sr;
            // r[i][1] = q.execute();
            CacheUtils.log("Executing query: " + queries[i] + " with index created");
            if (!observer.isIndexesUsed) {
                fail("Index is NOT uesd");
            }
            Iterator itr = observer.indexesUsed.iterator();
            assertTrue(itr.hasNext());
            String temp = itr.next().toString();
            assertEquals(temp, "Index1");
        } catch (Exception e) {
            e.printStackTrace();
            fail(q.getQueryString());
        }
    }
    StructSetOrResultsSet ssOrrs = new StructSetOrResultsSet();
    ssOrrs.CompareQueryResultsWithoutAndWithIndexes(r, queries.length, queries);
}