@Test
public void should_WritesPAGINGClauseIntoQueryStatement() throws QueryBuildException, SQLException {

    pagingWriter.write(query, 3, 8);
    assertEquals("LIMIT(?)OFFSET(?)", body.toString());
    verify(query, times(1)).pushParameterSetter(any());
    for (SQLQueryParameterSetter setter : setters) {
        PreparedStatement statement = mock(PreparedStatement.class);
        int finalIndex = setter.setParameters(statement, 1);
        assertEquals(3, finalIndex);
        verify(statement).setInt(eq(1), eq(8));
        verify(statement).setInt(eq(2), eq(16));
    }
}