org.pentaho.di.core.sql

Class SQLField

java.lang.Object

org.pentaho.di.core.sql.SQLField

public class SQLField
extends Object

Constructor Summary

Constructors

Constructor and Description
SQLField(String tableAlias, String fieldClause, RowMetaInterface serviceFields)
SQLField(String tableAlias, String fieldClause, RowMetaInterface serviceFields, boolean orderField)
SQLField(String tableAlias, String fieldClause, RowMetaInterface serviceFields, boolean orderField, SQLFields selectFields)
SQLField(String tableAlias, String field, String alias, SQLAggregation aggregation, ValueMetaInterface valueMeta)

Method Summary

Methods

Modifier and Type	Method and Description
SQLAggregation	getAggregation()
String	getAlias()
String	getExpression()
String	getField()
int	getFieldIndex()
IifFunction	getIif()
String	getName()
SQLFields	getSelectFields()
String	getTableAlias()
Object	getValueData()
ValueMetaInterface	getValueMeta()
boolean	isAscending()
boolean	isCountDistinct()
boolean	isCountStar()
boolean	isOrderField()
static SQLField	searchSQLFieldByFieldOrAlias(List<SQLField> fields, String name)
void	setAggregation(SQLAggregation aggregation)
void	setAlias(String alias)
void	setAscending(boolean ascending)
void	setCountDistinct(boolean countDistinct)
void	setCountStar(boolean countStar)
void	setExpression(String expression)
void	setField(String field)
void	setFieldIndex(int fieldIndex)
void	setIif(IifFunction iif)
void	setName(String name)
void	setOrderField(boolean orderField)
void	setSelectFields(SQLFields selectFields)
void	setTableAlias(String tableAlias)
void	setValueData(Object valueData)
void	setValueMeta(ValueMetaInterface valueMeta)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLField

public SQLField(String tableAlias,
        String field,
        String alias,
        SQLAggregation aggregation,
        ValueMetaInterface valueMeta)

Parameters:

field -

alias -

aggregation -

valueMeta -

SQLField

public SQLField(String tableAlias,
        String fieldClause,
        RowMetaInterface serviceFields)
         throws KettleSQLException

Throws:

KettleSQLException

SQLField

public SQLField(String tableAlias,
        String fieldClause,
        RowMetaInterface serviceFields,
        boolean orderField)
         throws KettleSQLException

Throws:

KettleSQLException

SQLField

public SQLField(String tableAlias,
        String fieldClause,
        RowMetaInterface serviceFields,
        boolean orderField,
        SQLFields selectFields)
         throws KettleSQLException

Throws:

KettleSQLException

Method Detail

getName

public String getName()

Returns:

the name

setName

public void setName(String name)

Parameters:

name - the name to set

getAlias

public String getAlias()

Returns:

the alias

setAlias

public void setAlias(String alias)

Parameters:

alias - the alias to set

getAggregation

public SQLAggregation getAggregation()

Returns:

the aggregation

setAggregation

public void setAggregation(SQLAggregation aggregation)

Parameters:

aggregation - the aggregation to set

getValueMeta

public ValueMetaInterface getValueMeta()

Returns:

the valueMeta

setValueMeta

public void setValueMeta(ValueMetaInterface valueMeta)

Parameters:

valueMeta - the valueMeta to set

getField

public String getField()

Returns:

the field

setField

public void setField(String field)

Parameters:

field - the field to set

isCountStar

public boolean isCountStar()

Returns:

the countStar

setCountStar

public void setCountStar(boolean countStar)

Parameters:

countStar - the countStar to set

isCountDistinct

public boolean isCountDistinct()

Returns:

the countDistinct

setCountDistinct

public void setCountDistinct(boolean countDistinct)

Parameters:

countDistinct - the countDistinct to set

isOrderField

public boolean isOrderField()

Returns:

the orderField

setOrderField

public void setOrderField(boolean orderField)

Parameters:

orderField - the orderField to set

isAscending

public boolean isAscending()

Returns:

the ascending

setAscending

public void setAscending(boolean ascending)

Parameters:

ascending - the ascending to set

getExpression

public String getExpression()

Returns:

the expression

setExpression

public void setExpression(String expression)

Parameters:

expression - the expression to set

getSelectFields

public SQLFields getSelectFields()

Returns:

the selectFields

setSelectFields

public void setSelectFields(SQLFields selectFields)

Parameters:

selectFields - the selectFields to set

getIif

public IifFunction getIif()

Returns:

the iif

getValueData

public Object getValueData()

Returns:

the valueData

setValueData

public void setValueData(Object valueData)

Parameters:

valueData - the valueData to set

setIif

public void setIif(IifFunction iif)

Parameters:

iif - the iif to set

getTableAlias

public String getTableAlias()

Returns:

the tableAlias

setTableAlias

public void setTableAlias(String tableAlias)

Parameters:

tableAlias - the tableAlias to set

getFieldIndex

public int getFieldIndex()

Returns:

the fieldIndex

setFieldIndex

public void setFieldIndex(int fieldIndex)

Parameters:

fieldIndex - the fieldIndex to set

searchSQLFieldByFieldOrAlias

public static SQLField searchSQLFieldByFieldOrAlias(List<SQLField> fields,
                                    String name)