com.archibus.datasource

Class FieldOperation

java.lang.Object

com.archibus.datasource.FieldUpdate

com.archibus.datasource.FieldOperation

public class FieldOperation
extends com.archibus.datasource.FieldUpdate

Port of the Nick's FieldFormula class, which was ported from Windows FieldFormula object.

Generates and runs an SQL UPDATE query that updates all records matching specified restriction, calculating a field value based on another field value and a formula.

 fo.Owner = "dp";
 fo.Assigned = "rm";
 fo.Standard = "rmcat";
 fo.InpFilter = "rmcat.occupiable = 1";
 fo.Calculate("dp.area_ocup", "SUM", "rm.area");
 fo.Clear();
 
 UPDATE dp SET dp.area_ocup=(
 SELECT IsNull(SUM(rm.area),0) 
   FROM dp o_inner,rm,rmcat 
  WHERE dp.dv_id=o_inner.dv_id AND dp.dp_id=o_inner.dp_id 
    AND o_inner.dv_id=rm.dv_id AND o_inner.dp_id=rm.dp_id 
    AND rm.rm_cat=rmcat.rm_cat AND (rmcat.occupiable = 1));
 

Field Summary

Fields inherited from class com.archibus.datasource.FieldUpdate

assignedRestriction, assignedTableName, dataSource, log, ownerRestriction, ownerTableName, standardTableName

Constructor Summary

Constructors

Constructor and Description
FieldOperation() Constructor.
FieldOperation(java.lang.String assignedTableName) Constructor for field operation with assigned table.
FieldOperation(java.lang.String ownerTableName, java.lang.String assignedTableName) Constructor for field operation with owner table and assigned table.
FieldOperation(java.lang.String ownerTableName, java.lang.String assignedTableName, java.lang.String standardTableName) Constructor for field operation with owner, assigned, and standard tables.

Method Summary

Modifier and Type	Method and Description
FieldOperation	addOperation(java.lang.String ownerFieldName, java.lang.String operation, java.lang.String assignedFieldName) Adds an operation to the list of operations.
void	calculate(java.lang.String ownerFieldName, java.lang.String operation, java.lang.String assignedFieldName) Calculates one operation.
protected void	doCalculate() Calculates all operations and formulas.
FieldOperation	setAssigned(java.lang.String tableName) Sets the assigned table name.
FieldOperation	setAssignedRestriction(java.lang.String restriction) Sets the assigned table restriction (or the input filter).
FieldOperation	setOwner(java.lang.String tableName) Sets the owner table name.
FieldOperation	setOwnerRestriction(java.lang.String restriction) Sets the owner table restriction (or the output filter).
FieldOperation	setStandard(java.lang.String tableName) Sets the standard table name.

Methods inherited from class com.archibus.datasource.FieldUpdate

buildJoinClause, calculate, getValueExpression

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

FieldOperation

public FieldOperation()

Constructor.

FieldOperation

public FieldOperation(java.lang.String assignedTableName)

Constructor for field operation with assigned table.

Parameters:

assignedTableName -

FieldOperation

public FieldOperation(java.lang.String ownerTableName,
                      java.lang.String assignedTableName)

Constructor for field operation with owner table and assigned table.

Parameters:

ownerTableName -

assignedTableName -

FieldOperation

public FieldOperation(java.lang.String ownerTableName,
                      java.lang.String assignedTableName,
                      java.lang.String standardTableName)

Constructor for field operation with owner, assigned, and standard tables.

Parameters:

ownerTableName -

assignedTableName -

standardTableName -

Method Detail

setOwner

public FieldOperation setOwner(java.lang.String tableName)

Sets the owner table name.

Parameters:

tableName -

Returns:

setAssigned

public FieldOperation setAssigned(java.lang.String tableName)

Sets the assigned table name.

Parameters:

tableName -

Returns:

setStandard

public FieldOperation setStandard(java.lang.String tableName)

Sets the standard table name.

Parameters:

tableName -

Returns:

setOwnerRestriction

public FieldOperation setOwnerRestriction(java.lang.String restriction)

Sets the owner table restriction (or the output filter).

Parameters:

restriction -

Returns:

setAssignedRestriction

public FieldOperation setAssignedRestriction(java.lang.String restriction)

Sets the assigned table restriction (or the input filter).

Parameters:

restriction -

Returns:

addOperation

public FieldOperation addOperation(java.lang.String ownerFieldName,
                                   java.lang.String operation,
                                   java.lang.String assignedFieldName)

Adds an operation to the list of operations.

Parameters:

ownerFieldName -

operation -

assignedFieldName -

Returns:

doCalculate

protected void doCalculate()

Calculates all operations and formulas.

Specified by:

doCalculate in class com.archibus.datasource.FieldUpdate

calculate

public void calculate(java.lang.String ownerFieldName,
                      java.lang.String operation,
                      java.lang.String assignedFieldName)

Calculates one operation.

Parameters:

ownerFieldName -

operation -

assignedFieldName -