Examples of org.voltdb.VoltTableRow

org.voltdb.VoltTableRow

Summary

Represents the interface to a row in a VoltTable result set.

Accessing Row Fields

Row fields are acessed via methods of the form get<Type>(col_index|col_name). Note: it is more performant to access rows by column index than by column name.

Advancing and Iterating through a Table

VoltTableRow represents both a row in a table and an iterator for all the rows in the table. For a given table, each VoltTableRow instance has a position value which represents the index represented in the table. To increment the position, call {@link #advanceRow()}. To reset the position, call {@link #resetRowPosition()}, which moves the position before the first row. Note that before you can access fields after a call to resetRowPosition, advanceRow must be called to move to the first row.

Example
VoltTableRow row = table.fetchRow(5); System.out.println(row.getString("foo"); row.resetRowPosition(); while (row.advanceRow()) { System.out.println(row.getLong(7)); }

                    + " + 11) from NO_NULLS where " + m_columnNames[3] + " = "
                    + m_midValues[3];
            System.out.println("testsimpleexpression: " + sql);
            final VoltTable[] result = client.callProcedure("@AdHoc", sql)
                    .getResults();
            final VoltTableRow row = result[0].fetchRow(0);
            final Object obj = row.get(0, m_types[i]);


            final double expect = ((Number) m_midValues[i]).doubleValue() + 11;
            final double got = ((Number) obj).doubleValue();
            System.out.println("Expect: " + expect + " got: " + got);
            assertEquals(expect, got);

View Full Code Here


        // select that same row again by primary key
        result = client.callProcedure("Select", "ALLOW_NULLS", 0).getResults();


        // and verify the row
        final VoltTableRow row = result[0].fetchRow(0);
        final BigDecimal bd = (row.getDecimalAsBigDecimal(13));
        assertTrue(comparisonHelper(m_minValues[12], bd, m_types[12]));
    }

View Full Code Here


        // Start off easy, with COUNT(*)s
        // Actually, these exercise a different (counted index) code path which has experienced its own regressions.
        // Test 1 -- count EQ first component of compound key
        int tableI = 0;
        final VoltTableRow countEQ = results[tableI].fetchRow(0);
        assertEquals( 2, countEQ.getLong(0));


        // Test 2 -- count GTE first component of compound key
        tableI++;
        final VoltTableRow countGT = results[tableI].fetchRow(0);
        assertEquals( 3, countGT.getLong(0));


        // Test 3 -- count GT first component of compound key
        tableI++;
        final VoltTableRow countGTE = results[tableI].fetchRow(0);
        assertEquals( 1, countGTE.getLong(0));


        // Test 4 -- count LTE first component of compound key
        tableI++;
        final VoltTableRow countLTE = results[tableI].fetchRow(0);
        assertEquals( 3, countLTE.getLong(0));


        // Test 5 -- count LT first component of compound key
        tableI++;
        final VoltTableRow countLT = results[tableI].fetchRow(0);
        assertEquals( 1, countLT.getLong(0));


        // Test 6 -- EQ first component of compound key
        tableI++;
        int rowI = 0;
        assertEquals( 2, results[tableI].getRowCount());
        final VoltTableRow rowEQ0 = results[tableI].fetchRow(rowI++);
        assertEquals( 0, rowEQ0.getLong(0));
        assertEquals( 0, rowEQ0.getLong(1));


        final VoltTableRow rowEQ1 = results[tableI].fetchRow(rowI++);
        assertEquals( 0, rowEQ1.getLong(0));
        assertEquals( 1, rowEQ1.getLong(1));


        // Test 7 -- GTE first component of compound key
        tableI++;
        rowI = 0;
        assertEquals( 3, results[tableI].getRowCount());
        final VoltTableRow rowGTE0 = results[tableI].fetchRow(rowI++);
        assertEquals( 0, rowGTE0.getLong(0));
        assertEquals( 0, rowGTE0.getLong(1));


        final VoltTableRow rowGTE1 = results[tableI].fetchRow(rowI++);
        assertEquals( 0, rowGTE1.getLong(0));
        assertEquals( 1, rowGTE1.getLong(1));


        final VoltTableRow rowGTE2 = results[tableI].fetchRow(rowI++);
        assertEquals( 1, rowGTE2.getLong(0));
        assertEquals( 1, rowGTE2.getLong(1));


        // Test 8 -- GT first component of compound key
        tableI++;
        rowI = 0;
        assertEquals( 1, results[tableI].getRowCount());
        final VoltTableRow rowGT0 = results[tableI].fetchRow(rowI++);
        assertEquals( 1, rowGT0.getLong(0));
        assertEquals( 1, rowGT0.getLong(1));


        // Test 9 -- LTE first component of compound key
        tableI++;
        rowI = 0;
        assertEquals( 3, results[tableI].getRowCount());
        // after adding reserve scan, JNI and HSQL will report
        // tuples in different order
        // so, add them to a set and ignore the order instead
        final VoltTableRow rowLTE0 = results[tableI].fetchRow(rowI++);
        final VoltTableRow rowLTE1 = results[tableI].fetchRow(rowI++);
        final VoltTableRow rowLTE2 = results[tableI].fetchRow(rowI++);
        HashSet<Long> TID = new HashSet<Long>();


        HashSet<Long> BID = new HashSet<Long>();
        HashSet<Long> expectedTID = new HashSet<Long>();
        HashSet<Long> expectedBID = new HashSet<Long>();


        expectedTID.add(-1L);
        expectedTID.add(0L);
        expectedTID.add(0L);


        expectedBID.add(0L);
        expectedBID.add(0L);
        expectedBID.add(1L);


        TID.add(rowLTE0.getLong(0));
        TID.add(rowLTE1.getLong(0));
        TID.add(rowLTE2.getLong(0));
        BID.add(rowLTE0.getLong(1));
        BID.add(rowLTE1.getLong(1));
        BID.add(rowLTE2.getLong(1));


        assertTrue(TID.equals(expectedTID));
        assertTrue(BID.equals(expectedBID));


        // Test 10 -- LT first component of compound key
        tableI++;
        rowI = 0;
        assertEquals( 1, results[tableI].getRowCount());
        final VoltTableRow rowLT0 = results[tableI].fetchRow(rowI++);
        assertEquals( -1, rowLT0.getLong(0));
        assertEquals( 0, rowLT0.getLong(1));
}

View Full Code Here

        results = client.callProcedure("AggAges", 1).getResults();
        assert(results != null);
        assertEquals(1, results.length);
        assertEquals(2, results[0].getRowCount());
        System.out.println(results[0].toString());
        VoltTableRow r1 = results[0].fetchRow(0);
        VoltTableRow r2 = results[0].fetchRow(1);
        assertEquals(31L, r1.getLong(0));
        assertEquals(2L, r1.getLong(2));
        assertTrue(Math.abs(r1.getDouble(3) - 30000.0) < .01);
        assertEquals(8L, r1.getLong(4));


        assertEquals(33L, r2.getLong(0));
        assertEquals(1L, r2.getLong(2));
        assertTrue(Math.abs(r2.getDouble(3) - 28920.99) < .01);
        assertEquals(3L, r2.getLong(4));
    }

View Full Code Here


        // get the order line table
        VoltTable table = results[2];
        assertEquals(table.getColumnName(0), "OL_O_ID");
        assertTrue(table.getRowCount() == 1);
        VoltTableRow row = table.fetchRow(0);
        assertEquals(row.getLong("OL_O_ID"), 1);
        assertEquals(row.getLong("OL_D_ID"), 6);
        assertEquals(row.getLong("OL_W_ID"), 1);
        assertEquals(row.getLong("OL_QUANTITY"), 1);
        assertEquals(row.getLong("OL_SUPPLY_W_ID"), 5);


        assertTrue(true);
    }

View Full Code Here

        assertEquals(results.length, 1);


        // get the new order table
        VoltTable table = results[0];
        assertTrue(table.getRowCount() == 1);
        VoltTableRow row = table.fetchRow(0);
        assertEquals(row.getLong("NO_D_ID"), 3);
    }

View Full Code Here


            // get the order line table
            VoltTable table = results[2];
            assertEquals(table.getColumnName(0), "OL_O_ID");
            assertTrue(table.getRowCount() == 1);
            VoltTableRow row = table.fetchRow(0);
            String resultString = row.getString("OL_DIST_INFO");
            assertEquals(testString, resultString);


            // reset
            client.callProcedure("@AdHoc", "delete from ORDER_LINE;");


            // Intentionally using a one byte string to make sure length preceded strings are handled correctly in the EE.
            client.callProcedure("ORDER_LINE.insert", 2L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 1.5, "a");
            client.callProcedure("ORDER_LINE.insert", 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1.5, testString);
            client.callProcedure("ORDER_LINE.insert", 3L, 1L, 1L, 3L, 3L, 3L, 3L, 3L, 1.5, "def");
            results = client.callProcedure("SelectOrderLineByDistInfo", testString).getResults();
            assertEquals(1, results.length);
            table = results[0];
            assertTrue(table.getRowCount() == 1);
            row = table.fetchRow(0);
            resultString = row.getString("OL_DIST_INFO");
            assertEquals(testString, resultString);


        }
        catch (ProcCallException e) {
            e.printStackTrace();

View Full Code Here

        } catch (ProcCallException e) {
            e.printStackTrace();
            fail();
        }
        assertEquals(1, results.length);
        VoltTableRow row = results[0].fetchRow(0);


        assertEquals(1, row.getLong(0));
        assertEquals(0, row.getString(2).compareTo(longString));
    }

View Full Code Here

        assertEquals(STRLEN, longString.length());




        VoltTable[] results = client.callProcedure("PassByteArrayArg", (byte)1, 2, longString.getBytes("UTF-8")).getResults();
        assertEquals(1, results.length);
        VoltTableRow row = results[0].fetchRow(0);


        assertEquals(1, row.getLong(0));
        assertEquals(0, row.getString(2).compareTo(longString));
    }

View Full Code Here

            assert(cr.getStatus() == ClientResponse.SUCCESS);
            VoltTable[] result = cr.getResults();
            assert(result.length == 4);
            VoltTable vt = result[0];
            assert(vt.getRowCount() == 1);
            VoltTableRow row = vt.fetchRow(0);
            assertEquals(row.getLong("b"), b);
            byte[] gotArray = row.getVarbinary("bArray");
            assertEquals(gotArray.length, bArray.length);
            for (int j = 0; j < gotArray.length; j++) {
                assertEquals(gotArray[j], bArray[j]);
            }
            assertEquals(gotArray.length, bArray.length);
            assertEquals(row.getLong("s"), s);
            assertEquals(row.getLong("i"), i);
            assertEquals(row.getLong("l"), l);
            assertEquals(row.getString("str"), str);
            byte[] gotString = row.getVarbinary("bString");
            assertEquals(gotString.length, bString.length);
            for (int j = 0; j < gotString.length; j++) {
                assertEquals(gotString[j], bString[j]);
            }


            String tsColName;
            int tsColIndex;
            tsColName = "tst";
            assertEquals(row.getTimestampAsLong(tsColName), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColName), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), utild.getTime());
            tsColIndex = vt.getColumnIndex(tsColName);
            assertEquals(row.getTimestampAsLong(tsColIndex), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColIndex), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), utild.getTime());


            tsColName = "sqld";
            assertEquals(row.getTimestampAsLong(tsColName), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColName), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), utild.getTime());
            tsColIndex = vt.getColumnIndex(tsColName);
            assertEquals(row.getTimestampAsLong(tsColIndex), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColIndex), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), utild.getTime());


            tsColName = "utild";
            assertEquals(row.getTimestampAsLong(tsColName), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColName), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), utild.getTime());
            tsColIndex = vt.getColumnIndex(tsColName);
            assertEquals(row.getTimestampAsLong(tsColIndex), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColIndex), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), utild.getTime());


            tsColName = "ts";
            assertEquals(row.getTimestampAsLong(tsColName), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColName), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColName).getTime(), utild.getTime());
            tsColIndex = vt.getColumnIndex(tsColName);
            assertEquals(row.getTimestampAsLong(tsColIndex), tst.getTime());
            assertEquals(row.getTimestampAsTimestamp(tsColIndex), tst);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex), ts);
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), sqld.getTime());
            assertEquals(row.getTimestampAsSqlTimestamp(tsColIndex).getTime(), utild.getTime());


            vt = result[1];
            assert(vt.getRowCount() == sArray.length);
            for (int j = 0; j < sArray.length; j++) {
                assertEquals(vt.fetchRow(j).getLong("sArray"), sArray[j]);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.voltdb.VoltTableRow

com.auctionexample.AuctionStatus

com.auctionexample.Client

com.ClientMover

com.procedures.delivery

com.procedures.neworder

com.procedures.paymentByCustomerId

com.procedures.paymentByCustomerIdC

com.procedures.paymentByCustomerName

com.procedures.paymentByCustomerNameC

com.procedures.paymentByCustomerNameW

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of org.voltdb.VoltTableRow

Summary

Accessing Row Fields

Advancing and Iterating through a Table

Example

Related Classes of org.voltdb.VoltTableRow