org.pentaho.di.core.sql

Class SQLFields

java.lang.Object

org.pentaho.di.core.sql.SQLFields

public class SQLFields
extends Object

Constructor Summary

Constructors

Constructor and Description
SQLFields(String tableAlias, RowMetaInterface serviceFields, String fieldsClause)
SQLFields(String tableAlias, RowMetaInterface serviceFields, String fieldsClause, boolean orderClause)
SQLFields(String tableAlias, RowMetaInterface serviceFields, String fieldsClause, boolean orderClause, SQLFields selectFields)

Method Summary

Methods

Modifier and Type	Method and Description
SQLField	findByName(String fieldName) Find a field by it's field name (not alias)
List<SQLField>	getAggregateFields()
List<SQLField>	getConstantFields()
List<SQLField>	getFields()
String	getFieldsClause()
List<SQLField>	getIifFunctionFields()
List<SQLField>	getNonAggregateFields()
List<SQLField>	getRegularFields()
SQLFields	getSelectFields()
RowMetaInterface	getServiceFields()
String	getTableAlias()
boolean	hasAggregates()
boolean	isDistinct()
boolean	isEmpty()
void	setFields(List<SQLField> fields)
void	setFieldsClause(String fieldsClause)
void	setSelectFields(SQLFields selectFields)
void	setServiceFields(RowMetaInterface serviceFields)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLFields

public SQLFields(String tableAlias,
         RowMetaInterface serviceFields,
         String fieldsClause)
          throws KettleSQLException

Throws:

KettleSQLException

SQLFields

public SQLFields(String tableAlias,
         RowMetaInterface serviceFields,
         String fieldsClause,
         boolean orderClause)
          throws KettleSQLException

Throws:

KettleSQLException

SQLFields

public SQLFields(String tableAlias,
         RowMetaInterface serviceFields,
         String fieldsClause,
         boolean orderClause,
         SQLFields selectFields)
          throws KettleSQLException

Throws:

KettleSQLException

Method Detail

getFields

public List<SQLField> getFields()

getNonAggregateFields

public List<SQLField> getNonAggregateFields()

getAggregateFields

public List<SQLField> getAggregateFields()

isEmpty

public boolean isEmpty()

findByName

public SQLField findByName(String fieldName)

Find a field by it's field name (not alias)

Parameters:

fieldName - the name of the field

Returns:

the field or null if nothing was found.

getServiceFields

public RowMetaInterface getServiceFields()

Returns:

the serviceFields

setServiceFields

public void setServiceFields(RowMetaInterface serviceFields)

Parameters:

serviceFields - the serviceFields to set

getFieldsClause

public String getFieldsClause()

Returns:

the fieldsClause

setFieldsClause

public void setFieldsClause(String fieldsClause)

Parameters:

fieldsClause - the fieldsClause to set

getSelectFields

public SQLFields getSelectFields()

Returns:

the selectFields

setSelectFields

public void setSelectFields(SQLFields selectFields)

Parameters:

selectFields - the selectFields to set

setFields

public void setFields(List<SQLField> fields)

Parameters:

fields - the fields to set

hasAggregates

public boolean hasAggregates()

Returns:

true if one or more fields is an aggregation.

getIifFunctionFields

public List<SQLField> getIifFunctionFields()

getRegularFields

public List<SQLField> getRegularFields()

getConstantFields

public List<SQLField> getConstantFields()

isDistinct

public boolean isDistinct()

Returns:

the distinct

getTableAlias

public String getTableAlias()

Returns:

the tableAlias