Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.agent
Class msaccess

WEB-INF.cftags.component
        datafaucet.system.agent.format
            datafaucet.system.agent.engine
                datafaucet.system.agent.datadefinitionlanguage
                    datafaucet.system.agent.sqlagent
                        datafaucet.system.agent.msaccess

public class msaccess
extends sqlagent
extends sqlagent

Method Summary
`private array`	`addJoinClause(array sql, any join, numeric ins)`
`private array`	`createColumnEntity(any datasource, string entity, array column)`
`string`	`escape(string entity)`
`private string`	`escapeTableName(any table)`
`private string`	`getAutonumberSyntax(string columnSyntax)`
`string`	`getDataType_varchar(string type, numeric size)` limits the size of varchar columns to 255 characters for Access databases
`private array`	`getFromClause(any statement, array sql)`
`string`	`getFullTableName(string table)`
`string`	`getQualifiedTableName(struct entity)`

Methods inherited from class datafaucet.system.agent.sqlagent
`applyFilter, applyFilters, applyJoinFilters, delete, deleteForeignKeys, getDeleteSyntax, getFilterInclude, getFilteredColumns, getGroupByClause, getHavingClause, getInsertSyntax, getJoinClause, getOrderByClause, getOrderByColumns, getPrimaryKeyFilters, getSelectSyntax, getUpdateSyntax, select, sqlInsert, update, voidFirstFilter`

Methods inherited from class datafaucet.system.agent.datadefinitionlanguage
ParseDDL, ParseDDLNode, ParseDDL_column, ParseDDL_constraint, ParseDDL_procedure, ParseDDL_table, ParseDDL_trigger, ParseDDL_view, TransformDDL, create, createConstraintEntity, createProcedureEntity, createSequenceEntity, createTableEntity, createTriggerEntity, createViewEntity, drop, dropColumnEntity, dropConstraintEntity, dropForeignKeyEntity, dropPrimaryKeyEntity, dropSequenceEntity, getColumnDefault, getColumnProperties, getColumnReferences, getColumnSyntax, getColumnUniqueness, getDDL, getDataType, getParamDefault, getParamSyntax, getProcedureParameters, getStoredProcedureSyntax

Methods inherited from class datafaucet.system.agent.datadefinitionlanguage

ParseDDL, ParseDDLNode, ParseDDL_column, ParseDDL_constraint, ParseDDL_procedure, ParseDDL_table, ParseDDL_trigger, ParseDDL_view, TransformDDL, create, createConstraintEntity, createProcedureEntity, createSequenceEntity, createTableEntity, createTriggerEntity, createViewEntity, drop, dropColumnEntity, dropConstraintEntity, dropForeignKeyEntity, dropPrimaryKeyEntity, dropSequenceEntity, 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, fixOrderby, getDataFaucet, getDataManager, getDefaultLocalization, getEntity, 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

addJoinClause

private array addJoinClause(array sql, any join, numeric ins)

Parameters:: sql; join; ins

createColumnEntity

private array createColumnEntity(any datasource, string entity, array column)

Overrides:: createColumnEntity in class datadefinitionlanguage

Parameters:: datasource; entity; column

escape

public string escape(string entity)

Overrides:: escape in class format

Parameters:: entity

escapeTableName

private string escapeTableName(any table)

Parameters:: table

getAutonumberSyntax

private string getAutonumberSyntax(string columnSyntax)

Overrides:: getAutonumberSyntax in class datadefinitionlanguage

Parameters:: columnSyntax

getDataType_varchar

public string getDataType_varchar(string type, numeric size)

limits the size of varchar columns to 255 characters for Access databases

getFromClause

private array getFromClause(any statement, array sql)

Overrides:: getFromClause in class sqlagent

Parameters:: statement; sql

getFullTableName

public string getFullTableName(string table)

Overrides:: getFullTableName in class format

Parameters:: table

getQualifiedTableName

public string getQualifiedTableName(struct entity)

Parameters:: entity

Overview

Package