br.com.objectos.way.sql.SelectSql Maven / Gradle / Ivy

Go to download
/*
 * Copyright 2014 Objectos, Fábrica de Software LTDA.
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */
package br.com.objectos.way.sql;

import java.util.List;

import com.google.common.base.Optional;

/**
 * @author [email protected] (Marcio Endo)
 */
public abstract class SelectSql extends Sql {

  abstract List selectableList();
  abstract TableReference tableReference();
  abstract Optional whereCondition();
  abstract Optional groupByInfo();
  abstract Optional havingCondition();
  abstract Optional orderByInfo();

  SelectSql() {
  }

  @Override
  public String toString(Dialect dialect) {
    return dialect.newSqlBuilder()
        .append("select")
        .space()
        .on(",").join(selectableList())
        .space()
        .append("from")
        .space()
        .append(tableReference())
        .when(whereCondition().isPresent())
        /**/.space()
        /**/.append("where")
        /**/.space()
        /**/.append(whereCondition().orNull())
        .endWhen()
        .when(groupByInfo().isPresent())
        /**/.space()
        /**/.append("group by")
        /**/.space()
        /**/.append(groupByInfo().orNull())
        .endWhen()
        .when(havingCondition().isPresent())
        /**/.space()
        /**/.append("having")
        /**/.space()
        /**/.append(havingCondition().orNull())
        .endWhen()
        .when(orderByInfo().isPresent())
        /**/.space()
        /**/.append("order by")
        /**/.space()
        /**/.append(orderByInfo().orNull())
        .endWhen()
        .toString();
  }

}