@Override public Object call() throws Exception { cachePers.query(new SqlQuery(Person.class, "SELECT firstName from PERSON")); return null; } }, CacheException.class, null);
@Override public Void call() throws Exception { for (int i = 0; i < 100; i++) { QueryCursor<Cache.Entry<Integer, Person>> qry = cache.query(new SqlQuery<Integer, Person>("Person", "age >= 0")); int cnt = 0; for (Cache.Entry<Integer, Person> e : qry) cnt++; assertEquals(2000, cnt); } return null; } }, 16, "test");
@Override public Void call() throws Exception { QueryCursor<Cache.Entry<Integer, Type1>> qry1 = cache.query(new SqlQuery<Integer, Type1>(Type1.class, "FROM Type1")); qry1.getAll().size(); return null; } }, CacheException.class, null);
/** * Test metrics for Scan queries. */ @Test public void testSqlQueryHistory() { SqlQuery<Integer, String> qry = new SqlQuery<>("String", "from String"); checkQueryMetrics(qry); }
@SuppressWarnings("unchecked") @Override public void applyx() throws IgniteCheckedException { c.query(new SqlQuery(Integer.class, "_val >= 0")).getAll(); U.await(latch); } }, THREAD_COUNT);
/** * @param ignite Ignite. * @param orgId Organization id. * @return Count of found Person object with specified orgId */ private static int getPersonsCountBySqlLocalQuery(final IgniteEx ignite, int orgId) { List res = ignite.cache(Person.class.getSimpleName()) .query(new SqlQuery<Person.Key, Person>(Person.class, "orgId = ?").setArgs(orgId).setLocal(true)) .getAll(); return res.size(); }
@Override public boolean apply() { return cache.query(new SqlQuery<Integer, Integer>(Integer.class, "1=1")).getAll().size() == 5 && cache.query(new SqlFieldsQuery("select _key, _val from Integer")).getAll().size() == 5; } }, 5000);
/** * Test from client node to get cache elements through cache API. */ @Test public void testClientSqlQuery() { SqlQuery<Integer, Person> qry = new SqlQuery<>(PERSON_CACHE, "FROM " + PERSON_CACHE); Assert.assertEquals(CACHE_ELEMENT_COUNT, clientNode.getOrCreateCache(PERSON_CACHE).query(qry).getAll().size()); }
/** {@inheritDoc} */ @Override public void doRead() { int idx = random.nextInt(entriesCount()); cache().query( new SqlQuery<>(TestingEntity.class, "val >= ? and val < ?") .setArgs(idx, idx + 500) ).getAll(); } };
/** * @throws Exception If failed. */ @Test public void testQuery() throws Exception { Collection<Cache.Entry<Object, Object>> res = grid().cache(DEFAULT_CACHE_NAME) .query(new SqlQuery("Integer", "from Integer")).getAll(); assert res != null; assert res.isEmpty(); } }
/** * @param name Cache name. */ @SuppressWarnings("unchecked") private void fillRowCache(String name) { for (int i = 0; i < ENTRIES; ++i) grid().cache(name).query(new SqlQuery(Value.class, "_key = " + i)).getAll(); }
private void checkSqlQuery(IgniteCache<Long,TestData> cache, Boolean dataPageScanEnabled) { DirectPageScanIndexing.expectedDataPageScanEnabled = dataPageScanEnabled; assertTrue(cache.query(new SqlQuery<>(TestData.class, "from TestData use index() where check_scan_flag(?,false)") // Force full scan with USE INDEX() .setArgs(DirectPageScanIndexing.expectedDataPageScanEnabled) .setDataPageScanEnabled(DirectPageScanIndexing.expectedDataPageScanEnabled)) .getAll().isEmpty()); checkSqlLastFindDataPageScan(dataPageScanEnabled); }
protected void checkCacheOperations(IgniteCache<Integer, Value> cache) throws Exception { super.checkCacheOperations(cache); // Check SQL API. String sql = "fieldVal >= ? and fieldVal <= ?"; List<Cache.Entry<Integer, Value>> res = cache.query( new SqlQuery<Integer, Value>(Value.class, sql).setArgs(1, 100)).getAll(); assertNotNull(res); assertEquals(100, res.size()); } }
/** * @throws Exception If failed. */ @Test public void testIllegalBounds() throws Exception { IgniteCache<Integer, Integer> cache = jcache(Integer.class, Integer.class); cache.put(1, 1); cache.put(2, 2); QueryCursor<Cache.Entry<Integer,Integer>> qry = cache.query(new SqlQuery<Integer, Integer>(Integer.class, "_key between 2 and 1")); assertTrue(qry.getAll().isEmpty()); }
/** {@inheritDoc} */ @Override public List<Cache.Entry<Integer, GridCacheQueryTestValue>> call() throws Exception { IgniteCache<Integer, GridCacheQueryTestValue> c = ignite.cache(CACHE_NAME); String sqlStr = "FROM GridCacheQueryTestValue WHERE fieldname = ?"; SqlQuery<Integer, GridCacheQueryTestValue> sql = new SqlQuery<>(GridCacheQueryTestValue.class, sqlStr); sql.setArgs("C"); return c.query(sql.setSql(sqlStr)).getAll(); } }
/** * Tests correct query execution with disabled re-balancing. */ @Test public void testQueryNoRebalance() { IgniteCache<Object, Object> cache = grid().cache(DEFAULT_CACHE_NAME); cache.put(1, 1); QueryCursor<Cache.Entry<Integer, Integer>> qry = cache.query(new SqlQuery<Integer, Integer>(Integer.class, "_key >= 0")); assertEquals("Bad results count", 1, qry.getAll().size()); } }
/** * Test metrics for Scan queries. * * @throws Exception In case of error. */ @Test public void testSqlQueryMetrics() throws Exception { IgniteCache<Integer, String> cache = grid(0).context().cache().jcache("A"); SqlQuery<Integer, String> qry = new SqlQuery<>("String", "from String"); checkQueryMetrics(cache, qry); }
/** * Test metrics for Sql queries. * * @throws Exception In case of error. */ @Test public void testSqlQueryMetrics() throws Exception { IgniteCache<Integer, String> cache = grid(0).context().cache().jcache("A"); SqlQuery qry = new SqlQuery<>("String", "from String"); checkQueryMetrics(cache, qry); }
/** * Test metrics for Sql queries. * * @throws Exception In case of error. */ @Test public void testSqlQueryNotFullyFetchedMetrics() throws Exception { IgniteCache<Integer, String> cache = grid(0).context().cache().jcache("A"); SqlQuery qry = new SqlQuery<>("String", "from String"); qry.setPageSize(10); checkQueryNotFullyFetchedMetrics(cache, qry, true); }
/** * Test metrics for Scan queries. * * @throws Exception In case of error. */ @Test public void testSqlQueryNotFullyFetchedMetrics() throws Exception { IgniteCache<Integer, String> cache = grid(0).context().cache().jcache("A"); SqlQuery<Integer, String> qry = new SqlQuery<>("String", "from String"); qry.setPageSize(10); checkQueryNotFullyFetchedMetrics(cache, qry, true); }