org.efaps.db.Update 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: 8286 $
* Last Changed: $Date: 2012-12-03 14:40:40 -0500 (Mon, 03 Dec 2012) $
* Last Changed By: $Author: [email protected] $
*/
package org.efaps.db;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Hashtable;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
import org.apache.commons.lang.builder.ToStringBuilder;
import org.efaps.admin.access.AccessTypeEnums;
import org.efaps.admin.datamodel.Attribute;
import org.efaps.admin.datamodel.AttributeType;
import org.efaps.admin.datamodel.SQLTable;
import org.efaps.admin.datamodel.Type;
import org.efaps.admin.event.EventDefinition;
import org.efaps.admin.event.EventType;
import org.efaps.admin.event.Parameter;
import org.efaps.admin.event.Parameter.ParameterValues;
import org.efaps.admin.event.Return;
import org.efaps.admin.event.Return.ReturnValues;
import org.efaps.ci.CIAttribute;
import org.efaps.db.transaction.ConnectionResource;
import org.efaps.db.wrapper.SQLUpdate;
import org.efaps.util.EFapsException;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
* @author The eFaps Team
* @version $Id: Update.java 8286 2012-12-03 19:40:40Z [email protected] $
*/
public class Update
{
/**
* Variable to get the Status of this update.
*/
private static final Status STATUSOK = new Status();
/**
* Logging instance used in this class.
*/
private static final Logger LOG = LoggerFactory.getLogger(Update.class);
/**
* The instance variable stores the instance for which this update is made.
*
* @see #getInstance
* @see #setInstance
*/
private Instance instance = null;
/**
* Mapping of table to AttributeType.
*
* @see #getExpr4Tables
*/
private final Map> expr4Tables = new Hashtable>();
/**
* Mapping of attribute to values.
*/
private final Map attr2values = new HashMap();
/**
* Mapping of attribute to values.
*/
private final Map trigRelevantAttr2values = new HashMap();
/**
* @param _type Type to be updated
* @param _id id to be updated
* @throws EFapsException on error
*/
public Update(final Type _type,
final String _id)
throws EFapsException
{
this(Instance.get(_type, _id));
}
/**
* @param _type Type to be updated
* @param _id id to be updated
* @throws EFapsException on error
*/
public Update(final Type _type,
final long _id)
throws EFapsException
{
this(Instance.get(_type, _id));
}
/**
* @param _type Type to be updated
* @param _id id to be updated
* @throws EFapsException on error
*/
public Update(final String _type,
final String _id)
throws EFapsException
{
this(Type.get(_type), _id);
}
/**
* @param _oid OID of the instance to be updated.
* @throws EFapsException on error
*/
public Update(final String _oid)
throws EFapsException
{
this(Instance.get(_oid));
}
/**
* @param _instance instance to be updated.
* @throws EFapsException on error
*/
public Update(final Instance _instance)
throws EFapsException
{
setInstance(_instance);
addAlwaysUpdateAttributes();
if (!Update.STATUSOK.getStati().isEmpty()) {
Update.STATUSOK.getStati().clear();
}
}
/**
* Add all attributes of the type which must be always updated.
* @throws EFapsException on error
*/
protected void addAlwaysUpdateAttributes()
throws EFapsException
{
final Iterator iter = getInstance().getType().getAttributes().entrySet().iterator();
while (iter.hasNext()) {
final Map.Entry entry = (Map.Entry) iter.next();
final Attribute attr = (Attribute) entry.getValue();
final AttributeType attrType = attr.getAttributeType();
if (attrType.isAlwaysUpdate()) {
addInternal(attr, false, (Object[]) null);
}
}
}
/**
* The method closes the SQL statement.
*
* @see #statement
* @throws EFapsException on error
*/
public void close()
throws EFapsException
{
}
/**
* The method gets all events for the given EventType and executes them in
* the given order. If no events are defined, nothing is done. The method
* return TRUE if a event was found, otherwise FALSE.
*
* @param _eventtype trigger events to execute
* @return true if a trigger was found and executed, otherwise false
* @throws EFapsException on error
*/
protected boolean executeEvents(final EventType _eventtype)
throws EFapsException
{
boolean ret = false;
final List triggers = getInstance().getType().getEvents(_eventtype);
if (triggers != null) {
// convert the map in a more simple map (following exsiting api)
final Map values = new HashMap();
for (final Entry entry : this.trigRelevantAttr2values.entrySet()) {
values.put(entry.getKey(), entry.getValue().getValues());
}
final Parameter parameter = new Parameter();
parameter.put(ParameterValues.NEW_VALUES, values);
parameter.put(ParameterValues.INSTANCE, getInstance());
for (final EventDefinition evenDef : triggers) {
evenDef.execute(parameter);
}
ret = true;
}
return ret;
}
/**
* @param _attr name of attribute to update
* @param _values attribute values
* @throws EFapsException on error
* @return Status
*/
public Status add(final String _attr,
final Object... _values)
throws EFapsException
{
final Attribute attr = getInstance().getType().getAttribute(_attr);
if (attr == null) {
throw new EFapsException(getClass(), "add.UnknownAttributeName", _attr);
}
return add(attr, _values);
}
/**
* @param _attr attribute to update
* @param _values attribute value
* @throws EFapsException on error
* @return Status
*/
public Status add(final Attribute _attr,
final Object... _values)
throws EFapsException
{
return addInternal(_attr, true, _values);
}
/**
* @param _attr attribute to update
* @param _values attribute value
* @throws EFapsException on error
* @return Status
*/
public Status add(final CIAttribute _attr,
final Object... _values)
throws EFapsException
{
final Attribute attr = getInstance().getType().getAttribute(_attr.name);
if (attr == null) {
throw new EFapsException(getClass(), "add.UnknownAttributeName", _attr);
}
return add(attr, _values);
}
/**
* @param _attr Attribute to add
* @param _value value to add
* @param _triggerRelevant is the attribute triggerrelevant
* @return Status
* @throws EFapsException on error
*/
protected Status addInternal(final Attribute _attr,
final boolean _triggerRelevant,
final Object... _value)
throws EFapsException
{
Status ret = Update.STATUSOK;
if (_attr.hasEvents(EventType.VALIDATE)) {
final List returns = _attr.executeEvents(EventType.VALIDATE, ParameterValues.NEW_VALUES, _value);
for (final Return retu : returns) {
if (retu.get(ReturnValues.TRUE) == null) {
ret = new Status(retu.get(ReturnValues.VALUES), _attr, _value);
break;
}
}
}
final Value value = new Value(_attr, _value);
Map expressions = this.expr4Tables.get(_attr.getTable());
if (expressions == null) {
expressions = new HashMap();
this.expr4Tables.put(_attr.getTable(), expressions);
}
expressions.put(_attr, value);
this.attr2values.put(_attr, value);
if (_triggerRelevant) {
this.trigRelevantAttr2values.put(_attr, value);
}
return ret;
}
/**
* Test for uniqueness.
* @return is it unique
* @throws EFapsException on error
*/
protected boolean test4Unique()
throws EFapsException
{
return test4Unique(getType());
}
/**
* Test for uniqueness.
* @param _type type to test
* @return is the type unique
* @throws EFapsException on error
*/
private boolean test4Unique(final Type _type)
throws EFapsException
{
boolean ret = false;
if (_type.getUniqueKeys() != null) {
for (final org.efaps.admin.datamodel.UniqueKey uk : _type.getUniqueKeys()) {
final QueryBuilder queryBldr = new QueryBuilder(_type);
boolean testNeeded = false;
for (final Attribute attr : uk.getAttributes()) {
final Value value = this.attr2values.get(attr.getName());
if (value != null) {
queryBldr.addWhereAttrEqValue(attr, value.values[0]);
testNeeded = true;
}
}
if (testNeeded) {
final InstanceQuery query = queryBldr.getQuery();
query.executeWithoutAccessCheck();
while (query.next()) {
if (!query.getCurrentValue().equals(getInstance())) {
ret = true;
break;
}
}
}
}
}
if (_type.getParentType() != null && !ret) {
ret = test4Unique(_type.getParentType());
}
return ret;
}
/**
* @throws EFapsException thrown from {@link #executeWithoutAccessCheck}
* @see #executeWithoutAccessCheck
*/
public void execute()
throws EFapsException
{
final Set attributes = new HashSet();
for (final Attribute attr : this.attr2values.keySet()) {
final AttributeType attrType = attr.getAttributeType();
if (!attrType.isAlwaysUpdate()) {
attributes.add(attr);
}
}
final boolean hasAccess = getType().hasAccess(getInstance(), AccessTypeEnums.MODIFY.getAccessType(),
attributes);
if (!hasAccess) {
throw new EFapsException(getClass(), "execute.NoAccess");
}
executeWithoutAccessCheck();
}
/**
* Executes the update without checking the access rights (but with
* triggers).
*
* - executes the pre update trigger (if exists)
* - executes the override trigger (if exists)
* - executes if no override trigger exists or the override trigger is not
* executed the update ({@see #executeWithoutTrigger})
* - executes the post update trigger (if exists)
*
*
* @throws EFapsException thrown from {@link #executeWithoutTrigger} or when
* the Status is invalid
* @see #executeWithoutTrigger
*/
public void executeWithoutAccessCheck()
throws EFapsException
{
if (Update.STATUSOK.getStati().isEmpty()) {
executeEvents(EventType.UPDATE_PRE);
if (!executeEvents(EventType.UPDATE_OVERRIDE)) {
executeWithoutTrigger();
}
executeEvents(EventType.UPDATE_POST);
} else {
throw new EFapsException(getClass(), "executeWithout.StatusInvalid", Update.STATUSOK.getStati());
}
}
/**
* The update is done without calling triggers and check of access rights.
*
* @throws EFapsException if update not possible (unique key, object does
* not exists, etc...)
*/
public void executeWithoutTrigger()
throws EFapsException
{
if (Update.STATUSOK.getStati().isEmpty()) {
final Context context = Context.getThreadContext();
ConnectionResource con = null;
try {
con = context.getConnectionResource();
if (test4Unique()) {
throw new EFapsException(getClass(), "executeWithoutTrigger.UniqueKeyError");
}
for (final Entry> entry : this.expr4Tables.entrySet()) {
final SQLUpdate update = Context.getDbType().newUpdate(entry.getKey().getSqlTable(),
entry.getKey().getSqlColId(),
this.instance.getId());
for (final Value value : entry.getValue().values()) {
value.attribute.prepareDBUpdate(update, value.values);
}
update.execute(con.getConnection());
}
con.commit();
} catch (final SQLException e) {
Update.LOG.error("Update of '" + this.instance + "' not possible", e);
throw new EFapsException(getClass(), "executeWithoutTrigger.SQLException", e, this.instance);
} finally {
if ((con != null) && con.isOpened()) {
con.abort();
}
}
} else {
throw new EFapsException(getClass(), "executeWithout.StatusInvalid", Update.STATUSOK.getStati());
}
}
/**
* The instance method returns the Type instance of {@link #instance}.
*
* @return type of {@link #instance}
* @see #instance
*/
protected Type getType()
{
return getInstance().getType();
}
/**
* @return the expr4Tables
*/
public Map> getExpr4Tables()
{
return this.expr4Tables;
}
/**
* The instance method returns the id of {@link #instance}.
*
* @return id of {@link #instance}
* @see #instance
*/
public long getId()
{
return getInstance().getId();
}
/**
* This is the getter method for instance variable {@link #instance}.
*
* @return value of instance variable {@link #instance}
* @see #instance
* @see #setInstance
*/
public Instance getInstance()
{
return this.instance;
}
/**
* This is the setter method for instance variable {@link #instance}.
*
* @param _instance new value for instance variable {@link #instance}
* @see #instance
* @see #getInstance
*/
protected void setInstance(final Instance _instance)
{
this.instance = _instance;
}
/**
* Class is used to set a satus of the update.
*/
public static class Status
{
/**
* this instance variable is only used in static Status STATUSOK.
* It stores all Instances of Status which are not ok.
*
* @see #getStati()
*/
private final List stati = new ArrayList();
/**
* This instance variable stores the ReturnValue of the esjp.
*
* @see #getReturnValue()
*/
private final Object returnValue;
/**
* this instance variable stores the Value wich was thought for the
* Attribute.
*
* @see #getAttribute()
*/
private final Object value;
/**
* this instance variable stores the Attribute wich led to the creation
* of this Status.
*/
private final Attribute attribute;
/**
* Constructor setting the instance variables and stores this Status in
* STATUSOK.
*
* @param _returnvalue value to be returned
* @param _attribute attribute
* @param _value value
*/
public Status(final Object _returnvalue,
final Attribute _attribute,
final Object _value)
{
this.returnValue = _returnvalue;
this.value = _value;
this.attribute = _attribute;
Update.STATUSOK.getStati().add(this);
}
/**
* defualt constructor.
*/
public Status()
{
this.returnValue = null;
this.value = null;
this.attribute = null;
}
/**
* This method can be called to see if the Status is Ok.
*
* @return true if ok, else false
*/
public boolean isOk()
{
boolean ret = false;
if (equals(Update.STATUSOK)) {
ret = true;
}
return ret;
}
/**
* This is the getter method for the instance variable
* {@link #returnValue}.
*
* @return value of instance variable {@link #returnValue}
*/
public Object getReturnValue()
{
return this.returnValue;
}
/**
* This is the getter method for the instance variable {@link #value}.
*
* @return value of instance variable {@link #value}
*/
public Object getValue()
{
return this.value;
}
/**
* This is the getter method for the instance variable
* {@link #attribute}.
*
* @return value of instance variable {@link #attribute}
*/
public Attribute getAttribute()
{
return this.attribute;
}
/**
* This is the getter method for the instance variable {@link #stati}.
*
* @return value of instance variable {@link #stati}
*/
public List getStati()
{
return this.stati;
}
/**
* @see java.lang.Object#toString()
* @return String representation of this class
*/
@Override
public String toString()
{
return new ToStringBuilder(this).append("AttributeName", getAttribute().getName())
.append(" Value", getValue()).append(" ReturnValue:", getReturnValue()).toString();
}
}
/**
* Represents one value for an attribte that will be updated.
*/
protected static final class Value
{
/**
* Attribute the value belongs to.
*/
private final Attribute attribute;
/**
* Values for the Attribute.
*/
private final Object[] values;
/**
* @param _attribute Attribute the value belongs to
* @param _values Valuers for the Attribute
*/
private Value(final Attribute _attribute,
final Object... _values)
{
this.attribute = _attribute;
this.values = _values;
}
/**
* @return the attribute
*/
public Attribute getAttribute()
{
return this.attribute;
}
/**
* @return the values
*/
public Object[] getValues()
{
return this.values;
}
}
}