Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.xdev.jadoth.sqlengine.SELECT Maven / Gradle / Ivy
/*
* XDEV Application Framework - XDEV Application Framework
* Copyright © 2003 XDEV Software (https://xdev.software)
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this program. If not, see
{
///////////////////////////////////////////////////////////////////////////
// constants //
/////////////////////
private static final long serialVersionUID = 3276555717823103305L;
///////////////////////////////////////////////////////////////////////////
// instance fields //
////////////////////
/** The distinct. */
private boolean distinct;
/** The limit row skip. */
private Integer limitRowSkip;
/** The limit row range. */
private Integer limitRowRange;
/** The select items. */
private final GrowList selectItems;
/** The group by clause. */
private GROUP_BY groupByClause;
/** The having clause. */
private HAVING havingClause;
/** The order by clause. */
private ORDER_BY orderByClause;
/** The union select. */
private SELECT unionSelect;
/** The union all select. */
private SELECT unionAllSelect;
/** The intersect select. */
private SELECT intersectSelect;
/** The except select. */
private SELECT exceptSelect;
/** The alias. */
private String alias; //Needed in case of use as a table expression
private final SuperConditionalQuery superConditionalQuery;
///////////////////////////////////////////////////////////////////////////
// constructors //
/////////////////
/**
* Instantiates a new sELECT.
*/
public SELECT()
{
super();
this.superConditionalQuery = new SuperConditionalQuery();
this.limitRowSkip = null;
this.limitRowRange = null;
this.distinct = false;
this.selectItems = new GrowList();
this.groupByClause = null;
this.havingClause = null;
this.orderByClause = null;
this.unionSelect = null;
this.unionAllSelect = null;
this.intersectSelect = null;
this.exceptSelect = null;
this.alias = null;
}
public SELECT(final SELECT copySource)
{
super(copySource);
this.superConditionalQuery = copySource.superConditionalQuery.copy();
this.limitRowSkip = copySource.limitRowSkip;
this.limitRowRange = copySource.limitRowRange;
this.distinct = copySource.distinct;
this.selectItems = copySource.selectItems != null ?
new GrowList(copySource.selectItems) :
new GrowList();
if(copySource.groupByClause != null)
this.groupByClause = copySource.groupByClause.copy();
if(copySource.havingClause != null)
this.havingClause = copySource.havingClause.copy();
if(copySource.orderByClause != null)
this.orderByClause = copySource.orderByClause.copy();
this.unionSelect = copySource.unionSelect; //do not copy other query objects
this.unionAllSelect = copySource.unionAllSelect; //do not copy other query objects
this.intersectSelect = copySource.intersectSelect; //do not copy other query objects
this.exceptSelect = copySource.exceptSelect; //do not copy other query objects
this.alias = copySource.alias; //Strings are immutable
}
///////////////////////////////////////////////////////////////////////////
// getters //
/////////////////////
/**
* Checks if is distinct.
*
* @return the distinct
*/
public boolean isDistinct()
{
return this.distinct;
}
/**
* Gets the union select.
*
* @return the unionSelect
*/
public SELECT getUnionSelect()
{
return this.unionSelect;
}
/**
* Gets the union all select.
*
* @return the unionAllSelect
*/
public SELECT getUnionAllSelect()
{
return this.unionAllSelect;
}
/**
* Gets the intersect select.
*
* @return the intersectSelect
*/
public SELECT getIntersectSelect()
{
return this.intersectSelect;
}
/**
* Gets the except select.
*
* @return the exceptSelect
*/
public SELECT getExceptSelect()
{
return this.exceptSelect;
}
/**
* Gets the select items.
*
* @return the selectItems
*/
public List getSelectItems()
{
return this.selectItems;
}
/**
* Gets the group by clause.
*
* @return the groupByClause
*/
public GROUP_BY getGroupByClause()
{
return this.groupByClause;
}
/**
* Gets the having clause.
*
* @return the havingClause
*/
public HAVING getHavingClause()
{
return this.havingClause;
}
/**
* Gets the order by clause.
*
* @return the orderByClause
*/
public ORDER_BY getOrderByClause()
{
return this.orderByClause;
}
/**
* Gets the offset skip count.
*
* @return the offset skip count
*/
public Integer getOffsetSkipCount()
{
return this.limitRowSkip;
}
/**
* Gets the fetch first row count.
*
* @return the fetch first row count
*/
public Integer getFetchFirstRowCount()
{
return this.limitRowRange;
}
///////////////////////////////////////////////////////////////////////////
// setters //
/////////////////////
/**
* Sets the distinct.
*
* @param distinct the distinct to set
* @return the sELECT
*/
public SELECT setDistinct(final boolean distinct)
{
this.distinct = distinct;
return this;
}
/**
* Sets the from clause.
*
* @param fromClause the from clause
* @return the sELECT
*/
@Override
public SELECT setFromClause(final FROM fromClause)
{
this.superConditionalQuery.setFromClause(fromClause);
return this;
}
/**
* @param databaseGateway
* @return
*/
@Override
public SELECT setDatabaseGateway(final DatabaseGateway databaseGateway)
{
super.setDatabaseGateway(databaseGateway);
return this;
}
/**
* @param whereClause
* @return
*/
@Override
public SELECT setWhereClause(final WHERE whereClause)
{
this.superConditionalQuery.setWhereClause(whereClause);
return this;
}
/**
* Sets the group by clause.
*
* @param groupByClause the groupByClause to set
* @return the sELECT
*/
public SELECT setGroupByClause(final GROUP_BY groupByClause)
{
this.groupByClause = groupByClause;
return this;
}
/**
* Sets the having clause.
*
* @param havingClause the havingClause to set
* @return the sELECT
*/
public SELECT setHavingClause(final HAVING havingClause)
{
this.havingClause = havingClause;
final SuperConditionalQuery superConditionalQuery = this.superConditionalQuery;
final ConditionClause lastConditionClause = superConditionalQuery.getLastConditionClause();
if(lastConditionClause == null || lastConditionClause instanceof HAVING){
superConditionalQuery.setLastConditionClause(lastConditionClause);
}
return this;
}
/**
* Sets the order by clause.
*
* @param orderByClause the orderByClause to set
* @return the sELECT
*/
public SELECT setOrderByClause(final ORDER_BY orderByClause)
{
this.orderByClause = orderByClause;
return this;
}
/**
* Sets the selects.
*
* @param union the union
* @param unionAll the union all
* @param intersect the intersect
* @param except the except
*/
private void setSelects(final SELECT union, final SELECT unionAll, final SELECT intersect, final SELECT except)
{
this.unionSelect = union;
this.unionAllSelect = unionAll;
this.intersectSelect = intersect;
this.exceptSelect = except;
}
/**
* Sets the union select.
*
* @param unionSelect the unionSelect to set
* @return the sELECT
*/
public SELECT setUnionSelect(final SELECT unionSelect)
{
this.setSelects(unionSelect, null, null, null);
return this;
}
/**
* Sets the union all select.
*
* @param unionAllSelect the unionAllSelect to set
* @return the sELECT
*/
public SELECT setUnionAllSelect(final SELECT unionAllSelect)
{
this.setSelects(null, unionAllSelect, null, null);
return this;
}
/**
* Sets the intersect select.
*
* @param intersectSelect the intersectSelect to set
* @return the sELECT
*/
public SELECT setIntersectSelect(final SELECT intersectSelect)
{
this.setSelects(null, null, intersectSelect, null);
return this;
}
/**
* Sets the except select.
*
* @param exceptSelect the exceptSelect to set
* @return the sELECT
*/
public SELECT setExceptSelect(final SELECT exceptSelect)
{
this.setSelects(null, null, null, exceptSelect);
return this;
}
/**
* Sets the alias.
*
* @param alias the alias to set
* @return the sELECT
*/
public SELECT setAlias(final String alias) {
this.alias = alias;
return this;
}
@Override
public SELECT setName(final String name)
{
super.setName(name);
return this;
}
@Override
public SELECT setComment(final String comment)
{
super.setComment(comment);
return this;
}
///////////////////////////////////////////////////////////////////////////
// SQL Syntax Methods //
///////////////////////
/**
* DISTINCT.
*
* @return the sELECT
*/
public SELECT DISTINCT()
{
this.distinct = true;
return this;
}
/**
* Columns.
*
* @param columns the columns
* @return the sELECT
*/
public SELECT columns(final Object... columns)
{
return this.items(columns);
}
/**
* Items.
*
* @param items the items
* @return the sELECT
*/
public SELECT items(final Object... items)
{
for(final Object o : items){
if(o instanceof SelectItem){
this.selectItems.add((SelectItem)o);
}
else {
this.selectItems.add(new SqlExpression(o));
}
}
return this;
}
/**
* Clear select items.
*/
public void clearSelectItems()
{
this.selectItems.clear();
}
/**
* Creates a new GROUP BY clause for this SELECT object using the field list
* provided by orderByFields.orderByFields. getClauseTables()
{
return this.superConditionalQuery.getClauseTables();
}
@Override
public FROM getFromClause()
{
return this.superConditionalQuery.getFromClause();
}
@Override
public int getJoinCount()
{
return this.superConditionalQuery.getJoinCount();
}
@Override
public List getJoins()
{
return this.superConditionalQuery.getJoins();
}
@Override
public ConditionClause getLastConditionClause()
{
return this.superConditionalQuery.getLastConditionClause();
}
@Override
public SqlClause[] getSqlClauses()
{
return new SqlClause[]{
this.getFromClause(),
this.getWhereClause(),
this.getGroupByClause(),
this.getHavingClause(),
this.getOrderByClause()
};
}
@Override
public WHERE getWhereClause()
{
return this.superConditionalQuery.getWhereClause();
}
@Override
public C registerJoinClause(final C join) throws SQLEngineMissingFromClauseException
{
return this.superConditionalQuery.registerJoinClause(join);
}
@Override
public SELECT copy()
{
return new SELECT(this);
}
/**
* @return
* @throws CloneNotSupportedException is never thrown at the moment
*/
@Override
public SELECT clone() throws CloneNotSupportedException
{
return this.copy();
}
///////////////////////////////////////////////////////////////////////////
// declared methods //
/////////////////////
/**
* Gets the alias.
*
* @return the alias
*/
public String getAlias()
{
if(this.alias != null) {
return this.alias;
}
return this.superConditionalQuery.getFromClause().getAlias();
}
/**
* Execute single.
*
* @param parameters the parameters
* @return the object
* @throws SQLEngineException the sQL engine exception
*/
public Object executeSingle(final Object... parameters) throws SQLEngineException
{
return super.execute(SqlExecutor.singleResultQuery, parameters);
}
/**
* To sql expression.
*
* @return the sql expression
*/
public SqlExpression toSqlExpression()
{
/*
* Or is this done in dmlAssembler.assembleExpression() ?
* Also see TO DO note in class SelectItem
*/
return new SqlExpression(this);
}
protected class SuperConditionalQuery extends ConditionalTableQuery.Implementation
{
protected SuperConditionalQuery()
{
super();
}
protected SuperConditionalQuery(final SuperConditionalQuery copySource)
{
super(copySource);
}
@Override
public SuperConditionalQuery copy(){
return new SuperConditionalQuery(this);
}
@Override
public Implementation setFromClause(final FROM fromClause)
{
super.setFromClause(fromClause);
return this;
}
@Override
public Implementation setWhereClause(final WHERE whereClause)
{
final ConditionClause lastConditionClause = this.getLastConditionClause();
if(lastConditionClause == null || lastConditionClause instanceof WHERE){
super.setWhereClause(whereClause);
}
else {
this.setWhereClauseIntern(whereClause);
}
return this;
}
@Override
public String assemble(final Object... parameters){
return null;
}
@Override
public Object execute(final Object... parameters) throws SQLEngineException{
return null;
}
@Override public String getComment(){
return null;
}
@Override public String[] getCommentLines(){
return null;
}
@Override public DatabaseGateway getDatabaseGatewayForExecution(){
return null;
}
@Override
public String keyword(){
return null;
}
@Override public String getName(){
return null;
}
@Override public TableExpression getTable(){
return null;
}
@Override public boolean isPacked(){
return false;
}
@Override public boolean isSingleLineMode(){
return false;
}
@Override public TableQuery pack(){
return null;
}
@Override public int prepare(){
return 0;
}
@Override public TableQuery setPacked(final boolean packed){
return null;
}
@Override public TableQuery setSingleLineMode(final boolean singleLineMode){
return null;
}
@Override public TableQuery singleLineMode(){
return null;
}
@Override public TableQuery setComment(final String comment){
return null;
}
@Override public TableQuery setName(final String name){
return null;
}
@Override
protected ConditionalTableQuery setLastConditionClause(final ConditionClause lastConditionClause)
{
return super.setLastConditionClause(lastConditionClause);
}
@Override public SuperConditionalQuery setDatabaseGateway(final DatabaseGateway databaseGateway){
return null;
}
@Override public boolean isDatabaseGatewaySet(){
return false;
}
@Override public SqlClause[] getSqlClauses(){
return null;
}
@Override public QueryListeners getListeners(){
return null;
}
@Override public QueryListeners listeners(){
return null;
}
@Override public Query setListeners(final QueryListeners queryListeners){
return null;
}
}
/**
* Sets this SELECT's new selectItems list to the elements of selectItems
*
* @param selectItems the selectItems to set
*/
public void setSelectItems(final List selectItems)
{
if(selectItems == null){
throw new NullPointerException("selectItems may not be null");
}
this.selectItems.clear();
this.selectItems.addAll(selectItems);
}
/**
* Adds selectItems via the internal selectitems' implementation of
* java.util.List.addAll(Collection)
*
* @param selectItems the selectItems to set
*/
public void addSelectItems(final List selectItems)
{
this.selectItems.addAll(selectItems);
}
/**
* @param selectItems the selectItems to set
*/
public void addSelectItem(final SelectItem selectItem)
{
this.selectItems.add(selectItem);
}
}
