How to use

completeSql

method

in

com.avaje.ebean.config.dbplatform.DatabasePlatform

 @Override
 public SqlLimitResponse limit(SqlLimitRequest request) {

  StringBuilder sb = new StringBuilder(512);
  sb.append("select ");
  if (request.isDistinct()) {
   sb.append("distinct ");
  }
  sb.append(request.getDbSql());

  int maxRows = request.getMaxRows();
  if (maxRows > 0) {
   sb.append(" ").append(NEW_LINE).append("FETCH FIRST ").append(maxRows).append(" ROWS ONLY");
  }

  String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());
  return new SqlLimitResponse(sql, false);
 }
}

public SqlLimitResponse limit(SqlLimitRequest request) {
  
  StringBuilder sb = new StringBuilder(512);
  sb.append("select ");
  if (request.isDistinct()){
    sb.append("distinct ");
  }
  
  sb.append(request.getDbSql());
  
  int firstRow = request.getFirstRow();
  int maxRows = request.getMaxRows();
  if (maxRows > 0) {
    maxRows = maxRows + 1;
  }
  sb.append(" ").append(NEW_LINE).append(LIMIT).append(" ");
  if (maxRows > 0) {
    sb.append(maxRows);
  }
  if (firstRow > 0) {
    sb.append(" ").append(OFFSET).append(" ");
    sb.append(firstRow);
  }
String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());
  
  return new SqlLimitResponse(sql, false);
}

public SqlLimitResponse limit(SqlLimitRequest request) {
 String dbSql = request.getDbSql();
 StringBuilder sb = new StringBuilder(50 + dbSql.length());
 sb.append("select ");
 if (request.isDistinct()) {
  sb.append("distinct ");
 }
 sb.append(dbSql);
 int firstRow = request.getFirstRow();
 int maxRows = request.getMaxRows();
 if (maxRows > 0 || firstRow > 0) {
  sb.append(" ").append(LIMIT).append(" ").append(maxRows);
  if (firstRow > 0) {
   sb.append(" ").append(OFFSET).append(" ");
   sb.append(firstRow);
  }
 }
 String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());
 return new SqlLimitResponse(sql, false);
}

public SqlLimitResponse limit(SqlLimitRequest request) {
 StringBuilder sb = new StringBuilder(512);
 sb.append("select ");
 if (request.isDistinct()) {
  sb.append("distinct ");
 }
 sb.append(request.getDbSql());
 int firstRow = request.getFirstRow();
 int maxRows = request.getMaxRows();
 if (maxRows > 0) {
  maxRows = maxRows + 1;
 }
 sb.append(" ").append(NEW_LINE).append(LIMIT).append(" ");
 if (maxRows > 0) {
  sb.append(maxRows);
 }
 if (firstRow > 0) {
  sb.append(" ").append(OFFSET).append(" ");
  sb.append(firstRow);
 }
 String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());
 return new SqlLimitResponse(sql, false);
}

public SqlLimitResponse limit(SqlLimitRequest request) {
 String dbSql = request.getDbSql();
 StringBuilder sb = new StringBuilder(60 + dbSql.length());
 int firstRow = request.getFirstRow();
 int maxRows = request.getMaxRows();
 /*
  * SELECT TOP xx START AT xx ... FROM ...
  */
 sb.append("select ");
 if (request.isDistinct()) {
  sb.append("distinct ");
 }
 if (maxRows > 0) {
  sb.append("top ").append(maxRows).append(" ");
 }
 if (firstRow > 0) {
  sb.append("start at ").append(firstRow + 1).append(" ");
 }
 sb.append(dbSql);
 String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());
 return new SqlLimitResponse(sql, false);
}

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

public SqlLimitResponse limit(SqlLimitRequest request) {
 StringBuilder sb = new StringBuilder(500);
 int firstRow = request.getFirstRow();
 int maxRows = request.getMaxRows();
 if (maxRows > 0) {
  // fetch 1 more than we return so that
  // we know if more rows are available
  maxRows = maxRows + 1;
 }
 /*
  * SELECT TOP xx START AT xx ... FROM ...
  */
 sb.append("select ");
 if (request.isDistinct()) {
  sb.append("distinct ");
 }
 if (maxRows > 0) {
  sb.append("top ").append(maxRows).append(" ");
 }
 if (firstRow > 0) {
  sb.append("start at ").append(firstRow + 1).append(" ");
 }
 sb.append(request.getDbSql());
 String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());
 return new SqlLimitResponse(sql, false);
}

public SqlLimitResponse limit(SqlLimitRequest request) {
  StringBuilder sb = new StringBuilder(500);
  int firstRow = request.getFirstRow();
  int maxRows = request.getMaxRows();
  if (maxRows > 0) {
    // fetch 1 more than we return so that
    // we know if more rows are available
    maxRows = maxRows + 1;
  }
  /*
   * SELECT TOP xx START AT xx ... FROM ...
   */
  sb.append("select ");
  if (request.isDistinct()) {
    sb.append("distinct ");
  }
  if (maxRows > 0) {
    sb.append("top ").append(maxRows).append(" ");
  }
  if (firstRow > 0) {
    sb.append("start at ").append(firstRow + 1).append(" ");
  }
  sb.append(request.getDbSql());
  String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());
  return new SqlLimitResponse(sql, false);
}

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

String sql = request.getDbPlatform().completeSql(sb.toString(), request.getOrmQuery());

return new SqlLimitResponse(dbPlatform.completeSql(sb.toString(), query), false);

return new SqlLimitResponse(dbPlatform.completeSql(sb.toString(), query), false);

return new SqlLimitResponse(dbPlatform.completeSql(sb.toString(), query), false);