@Test public void testCountQuery() { CqlQuery<String,String,Long> cqlQuery = new CqlQuery<String,String,Long>(keyspace, se, se, le); cqlQuery.setQuery("SELECT COUNT(*) FROM StandardLong1 WHERE KEY in ('cqlQueryTest_key1', 'cqlQueryTest_key2')"); QueryResult<CqlRows<String,String,Long>> result = cqlQuery.execute(); assertEquals(2, result.get().getAsCount()); }
/** * Constructed for {@link CqlResultType#ROWS} * @param thriftRet * @param nameSerializer * @param valueSerializer * @param resultType */ public CqlRows(LinkedHashMap<K, List<Column>> thriftRet, Serializer<N> nameSerializer, Serializer<V> valueSerializer) { super(thriftRet, nameSerializer, valueSerializer); this.resultType = CqlResultType.ROWS; // test for a count object. eeewww. if ( getCount() == 1 ) { Row row = iterator().next(); if ( row.getColumnSlice().getColumnByName("count") != null ) { count = LongSerializer.get().fromByteBuffer(row.getColumnSlice().getColumnByName("count").getValueBytes()).intValue(); } } }
@Test public void testSelectAllSuppressesKeyColumn() { CqlQuery<String,String,Long> cqlQuery = new CqlQuery<String,String,Long>(keyspace, se, se, le); cqlQuery.setQuery("select * from StandardLong1"); cqlQuery.setSuppressKeyInColumns(true); QueryResult<CqlRows<String,String,Long>> result = cqlQuery.execute(); CqlRows<String, String, Long> rows = result.get(); // check that we contain a 'key' column assertNull(rows.getList().get(0).getColumnSlice().getColumnByName("KEY")); // arbitrary row check assertNull(rows.getList().get(3).getColumnSlice().getColumnByName("KEY")); assertEquals(6,rows.getCount()); }
T entity = null; if (metadata == null) { entity = (T) Long.valueOf(cqlRows.getAsCount()); result.add(entity); } else { for (Row<String, String, Object> orderedRow : cqlRows.getList()) { ColumnSlice<String, Object> slice = orderedRow.getColumnSlice(); List<HColumn<String, Object>> columns = slice.getColumns();
@Test public void testSimpleSelect20() { CqlQuery<String,String,Long> cqlQuery = new CqlQuery<String,String,Long>(keyspace, se, se, le); cqlQuery.setQuery("select birth .. birthzz from StandardLong1"); cqlQuery.setCqlVersion("2.0.0"); QueryResult<CqlRows<String,String,Long>> result = cqlQuery.execute(); CqlRows<String, String, Long> rows = result.get(); assertEquals(6 + customColumns,rows.getCount()); }
@Test public void testSimpleSelect() { CqlQuery<String,String,Long> cqlQuery = new CqlQuery<String,String,Long>(keyspace, se, se, le); cqlQuery.setQuery("select * from StandardLong1"); QueryResult<CqlRows<String,String,Long>> result = cqlQuery.execute(); CqlRows<String, String, Long> rows = result.get(); // check that we contain a 'key' column assertNotNull(rows.getList().get(0).getColumnSlice().getColumnByName("KEY")); assertEquals(6 + customColumns,rows.getCount()); }
/** * Constructed for {@link CqlResultType#ROWS} * @param thriftRet * @param nameSerializer * @param valueSerializer * @param resultType */ public CqlRows(LinkedHashMap<K, List<Column>> thriftRet, Serializer<N> nameSerializer, Serializer<V> valueSerializer) { super(thriftRet, nameSerializer, valueSerializer); this.resultType = CqlResultType.ROWS; // test for a count object. eeewww. if ( getCount() == 1 ) { Row row = iterator().next(); if ( row.getColumnSlice().getColumnByName("count") != null ) { count = LongSerializer.get().fromByteBuffer(row.getColumnSlice().getColumnByName("count").getValueBytes()).intValue(); } } }
private static int countNumberOfRowsByFamilyColumn(Keyspace keyspace, String columnFamilyName) { CqlQuery<String, String, Long> cqlQuery = new CqlQuery<String, String, Long>(keyspace, StringSerializer.get(), StringSerializer.get(), new LongSerializer()); cqlQuery.setQuery("SELECT COUNT(*) FROM " + columnFamilyName); QueryResult<CqlRows<String, String, Long>> result = cqlQuery.execute(); return result.get().getAsCount(); }
/** * Constructed for {@link CqlResultType#ROWS} * @param thriftRet * @param nameSerializer * @param valueSerializer * @param resultType */ public CqlRows(LinkedHashMap<K, List<Column>> thriftRet, Serializer<N> nameSerializer, Serializer<V> valueSerializer) { super(thriftRet, nameSerializer, valueSerializer); this.resultType = CqlResultType.ROWS; // test for a count object. eeewww. if ( getCount() == 1 ) { Row row = iterator().next(); if ( row.getColumnSlice().getColumnByName("count") != null ) { count = LongSerializer.get().fromByteBuffer(row.getColumnSlice().getColumnByName("count").getValueBytes()).intValue(); } } }
private static int countNumberOfRowsByFamilyColumn(Keyspace keyspace, String columnFamilyName) { CqlQuery<String, String, Long> cqlQuery = new CqlQuery<String, String, Long>(keyspace, StringSerializer.get(), StringSerializer.get(), new LongSerializer()); cqlQuery.setQuery("SELECT COUNT(*) FROM " + columnFamilyName); QueryResult<CqlRows<String, String, Long>> result = cqlQuery.execute(); return result.get().getAsCount(); }