com.opengamma.elsql.OffsetFetchSqlFragment Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of elsql Show documentation

Simple tool to externalize SQL from Java

There is a newer version: 1.3

/**
 * Copyright (C) 2009 - present by OpenGamma Inc. and the OpenGamma group of companies
 *
 * Please see distribution for license.
 */
package com.opengamma.elsql;

/**
 * Representation of OFFSETFETCH.
 * 
 * This outputs an OFFSET-FETCH type clauses.
 */
final class OffsetFetchSqlFragment extends ContainerSqlFragment {

  /**
   * The offset variable name (starting with a colon) or numeric literal.
   */
  private final String _offsetVariable;
  /**
   * The fetch limit variable name (starting with a colon) or numeric literal.
   */
  private final String _fetchVariable;

  /**
   * Creates an instance.
   *
   * @param fetchVariable  the fetch limit variable name (starting with a colon) or numeric literal, not null
   */
  OffsetFetchSqlFragment(String fetchVariable) {
    _offsetVariable = null;
    _fetchVariable = fetchVariable;
  }

  /**
   * Creates an instance.
   *
   * @param offsetVariable  the offset variable name (starting with a colon) or numeric literal, not null
   * @param fetchVariable  the fetch limit variable name (starting with a colon) or numeric literal, not null
   */
  OffsetFetchSqlFragment(String offsetVariable, String fetchVariable) {
    _offsetVariable = offsetVariable;
    _fetchVariable = fetchVariable;
  }

  //-------------------------------------------------------------------------
  @Override
  void toSQL(StringBuilder buf, SqlFragments fragments, SqlParams params, int[] loopIndex) {
    int offset = extractVariableOrLiteral(params, _offsetVariable);
    int fetchLimit = extractVariableOrLiteral(params, _fetchVariable);
    buf.append(fragments.getConfig().getPaging(offset, fetchLimit == Integer.MAX_VALUE ? 0 : fetchLimit));
  }

  //-------------------------------------------------------------------------
  @Override
  public String toString() {
    return getClass().getSimpleName() + " " + getFragments();
  }

}