Example usage for org.apache.commons.lang.text StrBuilder delete

Introduction

In this page you can find the example usage for org.apache.commons.lang.text StrBuilder delete.

Prototype

public StrBuilder delete(int startIndex, int endIndex) 

Source Link

Document

Deletes the characters between the two specified indices.

Usage

From source file:com.google.visualization.datasource.util.SqlDataSourceHelperTest.java

/**
 * Tests the building of the SQL query LIMIT and OFFSET clauses from the Gviz
 * query./*from w w  w . j  av a2  s.  c  o  m*/
 *
 * @throws InvalidQueryException When there is an error in the query.
 */
public void testBuildLimitAndOffsetClauses() throws InvalidQueryException {
    Query query = new Query();
    int limit = 2;
    int offset = 3;

    // Only offset, default limit.
    query.setRowOffset(offset);
    StrBuilder queryStringBuilder = new StrBuilder();
    SqlDataSourceHelper.appendLimitAndOffsetClause(query, queryStringBuilder);
    assertEquals(" OFFSET " + offset, queryStringBuilder.toString());

    // Both limit and offset.
    query.setRowLimit(limit);
    queryStringBuilder.delete(0, queryStringBuilder.length());
    SqlDataSourceHelper.appendLimitAndOffsetClause(query, queryStringBuilder);
    assertEquals("LIMIT " + limit + " OFFSET " + offset, queryStringBuilder.toString());

    // Only limit.
    query = new Query();
    queryStringBuilder.delete(0, queryStringBuilder.length());
    query.setRowLimit(limit);
    SqlDataSourceHelper.appendLimitAndOffsetClause(query, queryStringBuilder);
    assertEquals("LIMIT " + limit, queryStringBuilder.toString());

    // No limit and no offset.
    query = new Query();
    queryStringBuilder.delete(0, queryStringBuilder.length());
    SqlDataSourceHelper.appendLimitAndOffsetClause(query, queryStringBuilder);
    assertEquals("", queryStringBuilder.toString());
}

---