public void read(int empId) { logger.debug("read()"); try { OperationResult<CqlResult<Integer, String>> result = keyspace.prepareQuery(EMP_CF) .withCql(String.format("SELECT * FROM %s WHERE %s=%d;", EMP_CF_NAME, COL_NAME_EMPID, empId)) .execute(); for (Row<Integer, String> row : result.getResult().getRows()) { logger.debug("row: "+row.getKey()+","+row); // why is rowKey null? ColumnList<String> cols = row.getColumns(); logger.debug("emp"); logger.debug("- emp id: "+cols.getIntegerValue(COL_NAME_EMPID, null)); logger.debug("- dept: "+cols.getIntegerValue(COL_NAME_DEPTID, null)); logger.debug("- firstName: "+cols.getStringValue(COL_NAME_FIRST_NAME, null)); logger.debug("- lastName: "+cols.getStringValue(COL_NAME_LAST_NAME, null)); } } catch (ConnectionException e) { logger.error("failed to read from C*", e); throw new RuntimeException("failed to read from C*", e); } }
logger.debug("- emp id: "+cols.getIntegerValue(COL_NAME_EMPID, null)); logger.debug("- dept: "+cols.getIntegerValue(COL_NAME_DEPTID, null)); logger.debug("- firstName: "+cols.getStringValue(COL_NAME_FIRST_NAME, null)); logger.debug("- lastName: "+cols.getStringValue(COL_NAME_LAST_NAME, null));
@Override public ObjectMetadata readMetadata(String objectName) throws Exception, NotFoundException { ColumnList<String> columns = keyspace.prepareQuery(cf).getKey(objectName).execute().getResult(); if (columns.isEmpty()) { throw new NotFoundException(objectName); } return new ObjectMetadata().setObjectSize(columns.getLongValue(getColumnName(Columns.OBJECTSIZE), null)) .setChunkSize(columns.getIntegerValue(getColumnName(Columns.CHUNKSIZE), null)) .setChunkCount(columns.getIntegerValue(getColumnName(Columns.CHUNKCOUNT), null)) .setAttributes(columns.getStringValue(getColumnName(Columns.ATTRIBUTES), null)); }
@Override public ObjectMetadata readMetadata(String objectName) throws Exception, NotFoundException { ColumnList<String> columns = keyspace.prepareQuery(cf).getKey(objectName).execute().getResult(); if (columns.isEmpty()) { throw new NotFoundException(objectName); } return new ObjectMetadata().setObjectSize(columns.getLongValue(getColumnName(Columns.OBJECTSIZE), null)) .setChunkSize(columns.getIntegerValue(getColumnName(Columns.CHUNKSIZE), null)) .setChunkCount(columns.getIntegerValue(getColumnName(Columns.CHUNKCOUNT), null)) .setAttributes(columns.getStringValue(getColumnName(Columns.ATTRIBUTES), null)); }
Assert.assertEquals(3, row.getColumns().size()); Integer key = row.getColumns().getIntegerValue("key", null); Assert.assertTrue(Integer.valueOf(""+i) == key);