org.efaps.db.query.WhereClauseAttrEqAttr Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of efaps-kernel Show documentation
Show all versions of efaps-kernel Show documentation
eFaps is a framework used to map objects with or without attached files to
a relational database and optional file systems (only for attaches files). Configurable access control can be provided down to object and attribute level depending on implementation and use case. Depending on requirements, events (like triggers) allow to implement business logic and to separate business logic from user interface.
The framework includes integrations (e.g. webdav, full text search) and a web application as 'simple' configurable user interface. Some best practises, example web application modules (e.g. team work module) support administrators and implementers using this framework.
/*
* Copyright 2003 - 2012 The eFaps Team
*
* 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.
*
* Revision: $Rev: 7483 $
* Last Changed: $Date: 2012-05-11 11:57:38 -0500 (Fri, 11 May 2012) $
* Last Changed By: $Author: [email protected] $
*/
package org.efaps.db.query;
import org.efaps.admin.datamodel.Attribute;
import org.efaps.db.AbstractQuery;
/**
* The class represents an equal where clause between two attributes.
*
* @author The eFaps Team
* @version $Id: WhereClauseAttrEqAttr.java 7483 2012-05-11 16:57:38Z [email protected] $
*/
//CHECKSTYLE:OFF
@Deprecated
public class WhereClauseAttrEqAttr
implements WhereClause
{
private final Attribute attr1;
private final Attribute attr2;
private final AbstractQuery.SelectType selectType1;
private final AbstractQuery.SelectType selectType2;
public WhereClauseAttrEqAttr(final AbstractQuery _query,
final Attribute _attr1,
final Attribute _attr2)
{
this.attr1 = _attr1;
this.attr2 = _attr2;
this.selectType1 = _query.getSelectType(this.attr1.getParent());
this.selectType2 = _query.getSelectType(this.attr2.getParent());
}
public WhereClauseAttrEqAttr(final AbstractQuery.SelectType _selectType1,
final Attribute _attr1,
final AbstractQuery.SelectType _selectType2,
final Attribute _attr2)
{
this.attr1 = _attr1;
this.attr2 = _attr2;
this.selectType1 = _selectType1;
this.selectType2 = _selectType2;
}
/**
* TODO: compare does not work if an attribute has more than one SQL
* column!!
*/
public WhereClause appendWhereClause(final CompleteStatement _completeStatement,
final int _orderIndex)
{
if ((_orderIndex < 0)
|| ((this.selectType1.getOrderIndex() < _orderIndex) && (this.selectType2.getOrderIndex() < _orderIndex))) {
final String sqlColName1 = this.attr1.getSqlColNames().get(0);
final String sqlColName2 = this.attr2.getSqlColNames().get(0);
_completeStatement.appendWhereAnd();
_completeStatement.appendWhere(this.attr1.getTable().getSqlTable());
_completeStatement.appendWhere(this.selectType1.getTypeIndex());
_completeStatement.appendWhere(".");
// _completeStatement.appendWhere(getAttr1().getSqlColName());
_completeStatement.appendWhere(sqlColName1);
_completeStatement.appendWhere("=");
_completeStatement.appendWhere(this.attr2.getTable().getSqlTable());
_completeStatement.appendWhere(this.selectType2.getTypeIndex());
_completeStatement.appendWhere(".");
// _completeStatement.appendWhere(getAttr2().getSqlColName());
_completeStatement.appendWhere(sqlColName2);
} else if ((_orderIndex >= 0) && (this.selectType1.getOrderIndex() < _orderIndex)
&& (this.selectType2.getOrderIndex() == _orderIndex)) {
final String sqlColName1 = this.attr1.getSqlColNames().get(0);
_completeStatement.appendWhereAnd();
_completeStatement.appendWhere(this.attr1.getTable().getSqlTable());
_completeStatement.appendWhere(this.selectType1.getTypeIndex());
_completeStatement.appendWhere(".");
// _completeStatement.appendWhere(getAttr1().getSqlColName());
_completeStatement.appendWhere(sqlColName1);
_completeStatement.appendWhere(" is null");
} else if ((_orderIndex >= 0) && (this.selectType1.getOrderIndex() == _orderIndex)
&& (this.selectType2.getOrderIndex() < _orderIndex)) {
final String sqlColName2 = this.attr2.getSqlColNames().get(0);
_completeStatement.appendWhereAnd();
_completeStatement.appendWhere(this.attr2.getTable().getSqlTable());
_completeStatement.appendWhere(this.selectType2.getTypeIndex());
_completeStatement.appendWhere(".");
// _completeStatement.appendWhere(getAttr2().getSqlColName());
_completeStatement.appendWhere(sqlColName2);
_completeStatement.appendWhere(" is null");
}
return this;
}
/**
* {@inheritDoc}
*/
public boolean isIgnoreCase()
{
return false;
}
/**
* {@inheritDoc}
*/
public WhereClause setIgnoreCase(final boolean _ignoreCase)
{
return this;
}
/**
* {@inheritDoc}
*/
@Override
public boolean isOr()
{
return false;
}
/**
* {@inheritDoc}
*/
@Override
public WhereClause setOr(final boolean or)
{
return this;
}
}