Examples with MergedResult io.shardingjdbc.core.merger.MergedResult used on opensource projects

Example 36 with MergedResult

use of io.shardingjdbc.core.merger.MergedResult in project sharding-jdbc by shardingjdbc.

the class IteratorStreamMergedResultTest method assertNextForLastResultSetsNotEmptyOnly.

@Test
public void assertNextForLastResultSetsNotEmptyOnly() throws SQLException {
    when(queryResults.get(2).next()).thenReturn(true, false);
    mergeEngine = new DQLMergeEngine(queryResults, selectStatement);
    MergedResult actual = mergeEngine.merge();
    assertTrue(actual.next());
    assertFalse(actual.next());
}

Example 37 with MergedResult

use of io.shardingjdbc.core.merger.MergedResult in project sharding-jdbc by shardingjdbc.

the class OrderByStreamMergedResultTest method assertNextForSomeResultSetsEmpty.

@Test
public void assertNextForSomeResultSetsEmpty() throws SQLException {
    mergeEngine = new DQLMergeEngine(queryResults, selectStatement);
    when(queryResults.get(0).next()).thenReturn(true, false);
    when(queryResults.get(0).getValue(1, Object.class)).thenReturn("2");
    when(queryResults.get(2).next()).thenReturn(true, true, false);
    when(queryResults.get(2).getValue(1, Object.class)).thenReturn("1", "1", "3", "3");
    MergedResult actual = mergeEngine.merge();
    assertTrue(actual.next());
    assertThat(actual.getValue(1, Object.class).toString(), is("1"));
    assertTrue(actual.next());
    assertThat(actual.getValue(1, Object.class).toString(), is("2"));
    assertTrue(actual.next());
    assertThat(actual.getValue(1, Object.class).toString(), is("3"));
    assertFalse(actual.next());
}

Example 38 with MergedResult

use of io.shardingjdbc.core.merger.MergedResult in project sharding-jdbc by shardingjdbc.

the class LimitDecoratorMergedResultTest method assertNextWithRowCount.

@Test
public void assertNextWithRowCount() throws SQLException {
    Limit limit = new Limit(DatabaseType.MySQL);
    limit.setOffset(new LimitValue(2, -1, true));
    limit.setRowCount(new LimitValue(2, -1, false));
    selectStatement.setLimit(limit);
    mergeEngine = new DQLMergeEngine(queryResults, selectStatement);
    MergedResult actual = mergeEngine.merge();
    assertTrue(actual.next());
    assertTrue(actual.next());
    assertFalse(actual.next());
}

Example 39 with MergedResult

use of io.shardingjdbc.core.merger.MergedResult in project sharding-jdbc by shardingjdbc.

the class LimitDecoratorMergedResultTest method assertNextForSkipAll.

@Test
public void assertNextForSkipAll() throws SQLException {
    Limit limit = new Limit(DatabaseType.MySQL);
    limit.setOffset(new LimitValue(Integer.MAX_VALUE, -1, true));
    selectStatement.setLimit(limit);
    mergeEngine = new DQLMergeEngine(queryResults, selectStatement);
    MergedResult actual = mergeEngine.merge();
    assertFalse(actual.next());
}

Example 40 with MergedResult

use of io.shardingjdbc.core.merger.MergedResult in project sharding-jdbc by shardingjdbc.

the class RowNumberDecoratorMergedResultTest method assertNextForSkipAll.

@Test
public void assertNextForSkipAll() throws SQLException {
    Limit limit = new Limit(DatabaseType.Oracle);
    limit.setOffset(new LimitValue(Integer.MAX_VALUE, -1, true));
    selectStatement.setLimit(limit);
    mergeEngine = new DQLMergeEngine(queryResults, selectStatement);
    MergedResult actual = mergeEngine.merge();
    assertFalse(actual.next());
}