Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class statement

WEB-INF.cftags.component
        datafaucet.system.sql.duck
            datafaucet.system.sql.simplefiltergroup
                datafaucet.system.sql.filtergroup
                    datafaucet.system.sql.statement

Direct Known Subclasses:: delete , insertablestatement , select

public class statement
extends filtergroup
extends filtergroup

provides an additional interface for declaring and executing abstracted SQL-queries

Constructor Summary
`init()`

Method Summary
`any`	`addListener(any listener, [string method='filterSQLStatement'])`
`boolean`	`bindFilters()`
`private any`	`broadcast([any result=''])`
`any`	`clearJoinTables()`
`any`	`clearListeners()`
`any`	`clearUnions()`
`any`	`execute()`
`string`	`getColumnList([boolean alias='false'])`
`query`	`getColumns()`
`any`	`getDatasource()`
`any`	`getGroupSource()`
`any`	`getListeners()`
`private any`	`getNewListener()`
`private any`	`getSQLAgent()`
`any`	`getSource([string table=''])` searches the source tables for a join or filtergroup to match a specified alias - returns 0 if not found
`private string`	`getSourceName()`
`any`	`getSyntax()`
`any`	`getTable()` overrides the getTable method of the simplefiltergroup which returns a statement object - this will return the string from the current statement instead
`private string`	`get_alias()`
`boolean`	`hasFilters()`
`private any`	`hasGroupSource()`
`boolean`	`hasJoinTables()`
`boolean`	`hasListeners()`
`private any`	`initStatement(struct properties)`
`private any`	`notifyListener(any listener, [any result=''])`
`any`	`reset()`
`any`	`setDatasource([any datasource=''])`
`private any`	`set_datasource(string propertyname, [any propertyvalue])`
`private void`	`set_table(string propertyname, string propertyvalue)`

Methods inherited from class datafaucet.system.sql.filtergroup
`addLiquidFilterGroup, addLiquidFilters, andOrCollectionFilter, andOrFilter, caseSensitiveFilter, collectionFilter, dateFilter, filter, filterGroup, filterLanguage, filterLocale, getDefaultLocale, getLiquidNameArray, getLocaleArray, getNewFilter, listFilter, nullFilter, numericFilter, onMissingMethod, reverseFilter, setFirstFilter, sqlFilter, timeSpanFilter`

Methods inherited from class datafaucet.system.sql.simplefiltergroup
`appendFilter, clearFilters, columnNotFoundException, filtersExist, getAvailableColumnList, getFilters, getFirstFilter, getTableArray, getTableForColumn, get_column, hasJoinSource, isGroup, makeFilters, raiseFilterExceptions, setTable, typeMismatchException`

Methods inherited from class datafaucet.system.sql.duck
`arg, getDefaultLocalization, getLocalization, getNext, getObject, getProperties, getProperty, getPropertylist, getTail, getValue, hasNext, identifyAccessorOrMutator, insertAfter, parseDate, parseNumber, raiseAbstractClassException, raiseMissingMethodException, removeAfter, setLocalization, setNext, setProperties, setProperty, setValue, simplify`

Methods inherited from class WEB-INF.cftags.component

Constructor Detail

init

public init()

Method Detail

addListener

public any addListener(any listener, [string method='filterSQLStatement'])

Parameters:: listener; method

bindFilters

public boolean bindFilters()

Overrides:: bindFilters in class simplefiltergroup

broadcast

private any broadcast([any result=''])

Parameters:: result

clearJoinTables

public any clearJoinTables()

clearListeners

public any clearListeners()

clearUnions

public any clearUnions()

execute

public any execute()

Overrides:: execute in class simplefiltergroup

getColumnList

public string getColumnList([boolean alias='false'])

Parameters:: alias

getColumns

public query getColumns()

getDatasource

public any getDatasource()

Overrides:: getDatasource in class simplefiltergroup

getGroupSource

public any getGroupSource()

Overrides:: getGroupSource in class simplefiltergroup

getListeners

public any getListeners()

getNewListener

private any getNewListener()

getSQLAgent

private any getSQLAgent()

getSource

public any getSource([string table=''])

searches the source tables for a join or filtergroup to match a specified alias - returns 0 if not found

getSourceName

private string getSourceName()

getSyntax

public any getSyntax()

Overrides:: getSyntax in class simplefiltergroup

getTable

public any getTable()

overrides the getTable method of the simplefiltergroup which returns a statement object - this will return the string from the current statement instead

get_alias

private string get_alias()

hasFilters

public boolean hasFilters()

Overrides:: hasFilters in class simplefiltergroup

hasGroupSource

private any hasGroupSource()

Overrides:: hasGroupSource in class simplefiltergroup

hasJoinTables

public boolean hasJoinTables()

Overrides:: hasJoinTables in class simplefiltergroup

hasListeners

public boolean hasListeners()

initStatement

private any initStatement(struct properties)

Parameters:: properties

notifyListener

private any notifyListener(any listener, [any result=''])

Parameters:: listener; result

reset

public any reset()

setDatasource

public any setDatasource([any datasource=''])

Parameters:: datasource

set_datasource

private any set_datasource(string propertyname, [any propertyvalue])

Parameters:: propertyname; propertyvalue

set_table

private void set_table(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

Overview

Package