Overview  Package   Class 
DataFaucet 1.0 Beta
FRAMES  

datafaucet.system.agent
Class sqlagent

WEB-INF.cftags.component
        extended by datafaucet.system.agent.format
            extended by datafaucet.system.agent.engine
                extended by datafaucet.system.agent.datadefinitionlanguage
                    extended by datafaucet.system.agent.sqlagent
Direct Known Subclasses:
msaccess , mssql , mysql , oracle 
public class sqlagent

extends datadefinitionlanguage

all vendor-specific SQL Syntax Agents should extend this component

Method Summary
private array applyFilter(any statement, any filter, array sql)
private array applyFilters(any statement, array sql, [string include=''], [boolean required='true'])
private array applyJoinFilters(any statement, array sql, [boolean required='true'])
 any delete(any statement, [boolean execute='true'])
private array deleteForeignKeys(any statement, [boolean execute='true'], [array sql='[runtime expression]'])
private array getDeleteSyntax(any statement, [boolean execute='true'], [array sql='[runtime expression]'])
private string getFilterInclude(any filter, [any statement])
private string getFilteredColumns(any statement)
private array getFromClause(any statement, array sql)
private string getGroupByClause(any statement)
private string getHavingClause(any statement)
private array getInsertSyntax(any statement)
private array getJoinClause(any statement, array sql)
private string getOrderByClause(struct statement)
private string getOrderByColumns(array columnArray, struct statement, [string strColumns=''], [string desc='ASC'], [boolean allowarbitrary='false'])
          qualifies table names and removes duplicates from the order-by clause of a select statement
 string getPrimaryKeyFilters(any statement, struct scope)
private any getSelectSyntax(any statement, [array sql='[runtime expression]'])
private array getUpdateSyntax(any statement)
 any select(any statement, [boolean execute='true'])
private any sqlInsert(any statement, [boolean execute='true'])
 any update(any statement, [boolean execute='true'])
private any voidFirstFilter(any statement)
 
Methods inherited from class datafaucet.system.agent.datadefinitionlanguage
ParseDDL, ParseDDLNode, ParseDDL_column, ParseDDL_constraint, ParseDDL_procedure, ParseDDL_table, ParseDDL_trigger, ParseDDL_view, TransformDDL, create, createColumnEntity, createConstraintEntity, createProcedureEntity, createSequenceEntity, createTableEntity, createTriggerEntity, createViewEntity, drop, dropColumnEntity, dropConstraintEntity, dropForeignKeyEntity, dropPrimaryKeyEntity, dropSequenceEntity, getAutonumberSyntax, getColumnDefault, getColumnProperties, getColumnReferences, getColumnSyntax, getColumnUniqueness, getDDL, getDataType, getParamDefault, getParamSyntax, getProcedureParameters, getStoredProcedureSyntax
 
Methods inherited from class datafaucet.system.agent.engine
arg, cfsqltype, executeSQL, executeStoredProcedure, getColumnType, getSQL, getSyntaxOrExecute, getTimeCreated, getTraceEnabled, getWriteableColumns, isModified, procedure
 
Methods inherited from class datafaucet.system.agent.format
concatenate, escape, fixOrderby, getDataFaucet, getDataManager, getDefaultLocalization, getEntity, getFullTableName, getNextFromSequence, getNumericScale, getValidator, init, newID, newLine, qp, queryparam, queryparam_bit, queryparam_integer, queryparam_numeric, queryparam_timestamp, raiseUnspecifiedEntityException, replaceConcatenator
 
Methods inherited from class WEB-INF.cftags.component
 

Constructor Detail

init

public init([string version=''])

Parameters:
version
Method Detail

applyFilter

private array applyFilter(any statement, any filter, array sql)

Parameters:
statement
filter
sql

applyFilters

private array applyFilters(any statement, array sql, [string include=''], [boolean required='true'])

Parameters:
statement
sql
include
required

applyJoinFilters

private array applyJoinFilters(any statement, array sql, [boolean required='true'])

Parameters:
statement
sql
required

delete

public any delete(any statement, [boolean execute='true'])

Parameters:
statement
execute

deleteForeignKeys

private array deleteForeignKeys(any statement, [boolean execute='true'], [array sql='[runtime expression]'])

Parameters:
statement
execute
sql

getDeleteSyntax

private array getDeleteSyntax(any statement, [boolean execute='true'], [array sql='[runtime expression]'])

Parameters:
statement
execute
sql

getFilterInclude

private string getFilterInclude(any filter, [any statement])

Parameters:
filter
statement

getFilteredColumns

private string getFilteredColumns(any statement)

Parameters:
statement

getFromClause

private array getFromClause(any statement, array sql)

Parameters:
statement
sql

getGroupByClause

private string getGroupByClause(any statement)

Parameters:
statement

getHavingClause

private string getHavingClause(any statement)

Parameters:
statement

getInsertSyntax

private array getInsertSyntax(any statement)

Parameters:
statement

getJoinClause

private array getJoinClause(any statement, array sql)

Parameters:
statement
sql

getOrderByClause

private string getOrderByClause(struct statement)

Parameters:
statement

getOrderByColumns

private string getOrderByColumns(array columnArray, struct statement, [string strColumns=''], [string desc='ASC'], [boolean allowarbitrary='false'])
qualifies table names and removes duplicates from the order-by clause of a select statement

Parameters:
columnArray
statement
strColumns
desc
allowarbitrary - arbitrary sql strings in the order-by clause should only be allowed when they are not provided by a user

getPrimaryKeyFilters

public string getPrimaryKeyFilters(any statement, struct scope)

Parameters:
statement
scope

getSelectSyntax

private any getSelectSyntax(any statement, [array sql='[runtime expression]'])

Parameters:
statement
sql

getUpdateSyntax

private array getUpdateSyntax(any statement)

Parameters:
statement

select

public any select(any statement, [boolean execute='true'])

Parameters:
statement
execute

sqlInsert

private any sqlInsert(any statement, [boolean execute='true'])

Parameters:
statement
execute

update

public any update(any statement, [boolean execute='true'])

Parameters:
statement
execute

voidFirstFilter

private any voidFirstFilter(any statement)

Parameters:
statement
Overview  Package   Class 
DataFaucet 1.0 Beta
FRAMES