Java VoltTable.getString方法代码示例

import org.voltdb.VoltTable; //导入方法依赖的package包/类
@Override
public void clientCallback(ClientResponse clientResponse) {
    LOG.info("Processing statistics callback information");
    VoltTable[] results = clientResponse.getResults();
    for (VoltTable vt : results) {
        //
        // [0] SITE_ID
        // [1] STAT_TIME
        // [2] TABLE_NAME
        // [3] TABLE_TYPE
        // [4] TABLE_ACTIVE_TUPLE_COUNT
        // [5] TABLE_ALLOCATED_TUPLE_COUNT
        // [6] TABLE_DELETED_TUPLE_COUNT
        //
        while (vt.advanceRow()) {
            String table_name = vt.getString(2);
            long count = vt.getLong(4);
            TableStatistics.addTupleCount(table_name, count);
        } // WHILE
    } // FOR
    LOG.info("Finished collecting statistic. Number of tables = " + TableStatistics.getTables().size());
    latch.countDown();
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
private final void loadConfigHistograms(VoltTable vt) {
    while (vt.advanceRow()) {
        int col = 0;
        String name = vt.getString(col++);
        ObjectHistogram<String> h = JSONUtil.fromJSONString(new ObjectHistogram<String>(), vt.getString(col++));
        boolean is_airline = (vt.getLong(col++) == 1);
        
        if (is_airline) {
            this.airport_histograms.put(name, h);
            if (trace.val) 
                LOG.trace(String.format("Loaded %d records for %s airport histogram", h.getValueCount(), name));
        } else {
            this.histograms.put(name, h);
            if (trace.val)
                LOG.trace(String.format("Loaded %d records for %s histogram", h.getValueCount(), name));
        }
    } // WHILE
    if (debug.val)
        LOG.debug(String.format("Loaded %s data", SEATSConstants.TABLENAME_CONFIG_HISTOGRAMS));
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
public VoltTable run(int contestantNumber, int max)
{
    ArrayList<Result> results = new ArrayList<Result>();
    voltQueueSQL(resultStmt);
    VoltTable summary = voltExecuteSQL()[0];
    String state = "";
    while(summary.advanceRow()) {
        if (!summary.getString(1).equals(state)) {
            state = summary.getString(1);
            if (summary.getLong(0) == contestantNumber)
                results.add(new Result(state, summary.getLong(2)));
        }
    }
    Result[] resultArray = (Result[])results.toArray();
    Arrays.sort(resultArray, new OrderByVotesDesc());
    VoltTable result = new VoltTable(
						 new VoltTable.ColumnInfo("state",VoltType.STRING),
						 new VoltTable.ColumnInfo("num_votes",VoltType.BIGINT));
    for(int i=0;i<Math.min(resultArray.length,max);i++)
        result.addRow(new Object[] {
resultArray[i].state,
resultArray[i].votes });
    return result;
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
public void testGetStats() throws Exception {
    final Catalog catalog = new Catalog();
    catalog.execute(LoadCatalogToString.THE_CATALOG);
    sourceEngine.loadCatalog(catalog.serialize());

    final int WAREHOUSE_TABLEID = catalog.getClusters().get("cluster").getDatabases().get("database").getTables().get("WAREHOUSE").getRelativeIndex();
    final int STOCK_TABLEID = catalog.getClusters().get("cluster").getDatabases().get("database").getTables().get("STOCK").getRelativeIndex();
    final int locators[] = new int[] { WAREHOUSE_TABLEID, STOCK_TABLEID };
    final VoltTable results[] = sourceEngine.getStats(SysProcSelector.TABLE, locators, false, 0L);
    assertNotNull(results);
    assertEquals(1, results.length);
    assertNotNull(results[0]);
    final VoltTable resultTable = results[0];
    assertEquals(2, resultTable.getRowCount());
    while (resultTable.advanceRow()) {
        String tn = resultTable.getString("TABLE_NAME");
        assertTrue(tn.equals("WAREHOUSE") || tn.equals("STOCK"));
    }
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
public void testTABLECOUNTS() throws IOException, ProcCallException {
    Client client = getClient();
    ClientResponse cr = null;
    CatalogContext catalogContext = this.getCatalogContext();
    
    Random rand = this.getRandom();
    int num_tuples = 11;
    for (Table catalog_tbl : catalogContext.database.getTables()) {
        RegressionSuiteUtil.loadRandomData(client, catalog_tbl, rand, num_tuples);
    } // FOR (table)
    
    // Now get the counts for the tables that we just loaded
    cr = client.callProcedure(GetTableCounts.class.getSimpleName());
    // System.err.println(cr);
    assertEquals(Status.OK, cr.getStatus());
    assertEquals(1, cr.getResults().length);
    VoltTable vt = cr.getResults()[0];
    while (vt.advanceRow()) {
        String tableName = vt.getString(0);
        int count = (int)vt.getLong(1);
        assertEquals(tableName, num_tuples, count);
    } // WHILE
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
protected void getTupleIds(String targetTableName, VoltTable tsTracking, Collection<Integer> tupleIds) {
    tsTracking.resetRowPosition();
    while (tsTracking.advanceRow()) {
        String tableName = tsTracking.getString(0);
        if (targetTableName.equalsIgnoreCase(tableName)) {
            tupleIds.add((int)tsTracking.getLong(1));
        }
    } // WHILE
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
private final void loadCodeXref(VoltTable vt, String codeCol, String idCol) {
    Map<String, Long> m = this.code_id_xref.get(idCol);
    while (vt.advanceRow()) {
        long id = vt.getLong(0);
        String code = vt.getString(1);
        m.put(code, id);
    } // WHILE
    if (debug.val) LOG.debug(String.format("Loaded %d xrefs for %s -> %s", m.size(), codeCol, idCol));
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
public VoltTable run() {
    ArrayList<Result> results = new ArrayList<Result>();
    voltQueueSQL(resultStmt);
    VoltTable summary = voltExecuteSQL()[0];
    String state = "";
		
    while(summary.advanceRow()) {
        if (!summary.getString(1).equals(state)) {
            state = summary.getString(1);
            results.add(new Result(state, (int)summary.getLong(0), summary.getLong(2), (byte)1));
        }
        else {
            results.add(new Result(state, (int)summary.getLong(0), summary.getLong(2), (byte)0));
        }
    }
		
    Object[] resultArray = results.toArray();
    VoltTable result = new VoltTable(
						 new VoltTable.ColumnInfo("state",VoltType.STRING),
						 new VoltTable.ColumnInfo("contestant_number",VoltType.INTEGER),
						 new VoltTable.ColumnInfo("num_votes",VoltType.BIGINT),
						 new VoltTable.ColumnInfo("is_winning",VoltType.TINYINT));
		
    for(int i=0;i<resultArray.length;i++) {
        result.addRow(new Object[] {
((Result)resultArray[i]).state,
((Result)resultArray[i]).contestantNumber,
((Result)resultArray[i]).votes,
((Result)resultArray[i]).isWinning });
    }
    return result;
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
/**
 * testReadSets
 */
@Test
public void testReadSets() throws Exception {
    TestSmallBankSuite.initializeSmallBankDatabase(catalogContext, this.client);
    
    BlockingSendPayment voltProc = this.startTxn();
    Long txnId = voltProc.getTransactionId();
    assertNotNull(txnId);
    LocalTransaction ts = hstore_site.getTransaction(txnId);
    assertNotNull(ts);
    
    Set<String> expectedTables = new HashSet<String>();
    for (Table tbl : catalogContext.database.getTables()) {
        if (ts.isTableRead(BASE_PARTITION, tbl)) {
            expectedTables.add(tbl.getName());
        }
    } // FOR
    
    // Let's take a peek at its ReadSet
    VoltTable result = this.ee.trackingReadSet(txnId);
    assertNotNull(result);
    this.verifySchema(result);
    Set<String> foundTables = new HashSet<String>();
    while (result.advanceRow()) {
        String tableName = result.getString(0);
        int tupleId = (int)result.getLong(1);
        foundTables.add(tableName);
        assert(tupleId >= 0);
    } // WHILE 
    this.finishTxn(voltProc);
    System.err.println("READ SET:\n" + VoltTableUtil.format(result));
    
    assertEquals(expectedTables, foundTables);
}
 

import org.voltdb.VoltTable; //导入方法依赖的package包/类
/**
 * testWriteSets
 */
@Test
public void testWriteSets() throws Exception {
    TestSmallBankSuite.initializeSmallBankDatabase(catalogContext, this.client);
    
    BlockingSendPayment voltProc = this.startTxn();
    Long txnId = voltProc.getTransactionId();
    assertNotNull(txnId);
    LocalTransaction ts = hstore_site.getTransaction(txnId);
    assertNotNull(ts);
    
    Set<String> expectedTables = new HashSet<String>();
    for (Table tbl : catalogContext.database.getTables()) {
        if (ts.isTableWritten(BASE_PARTITION, tbl)) {
            expectedTables.add(tbl.getName());
        }
    } // FOR
    
    // Let's take a peek at its WriteSet
    VoltTable result = this.ee.trackingWriteSet(txnId);
    assertNotNull(result);
    this.verifySchema(result);
    Set<String> foundTables = new HashSet<String>();
    while (result.advanceRow()) {
        String tableName = result.getString(0);
        int tupleId = (int)result.getLong(1);
        foundTables.add(tableName);
        assert(tupleId >= 0);
    } // WHILE 
    this.finishTxn(voltProc);
    System.err.println("WRITE SET:\n" + VoltTableUtil.format(result));
    
    assertEquals(expectedTables, foundTables);
}