Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.agent
Class mssql

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

public class mssql
extends sqlagent
extends sqlagent

Method Summary
`private array`	`createProcedureEntity(any datasource, string entity, string syntax, [array param='[runtime expression]'])` MS SQL Server doesn't allow use of the catalog name when creating a view - use the system stored procedure sp_executeSQL as a workaround
`private array`	`createTriggerEntity(any datasource, string entity, string trigger, string action, string syntax, [string exec='after'])`
`private array`	`createViewEntity(string entity, string syntax)` MS SQL Server doesn't allow use of the catalog name when creating a view - use the system stored procedure sp_executeSQL as a workaround
`private array`	`dropProcedureEntity(any datasource, string entity)`
`private array`	`dropTriggerEntity(any datasource, string entity)`
`private array`	`dropViewEntity(any datasource, string entity)`
`string`	`escape(string entity)`
`private string`	`getAutonumberSyntax(string columnSyntax)`
`string`	`getDataType_varchar(string type, numeric size)` limits the size of varchar and nvarchar columns to 4000 or 8000 characters for SQL Server databases
`private string`	`getOrderByClause(struct statement)`
`private struct`	`queryparam_longvarchar(struct st='')`
`private array`	`sp_executeSQL(string catalog, array sql)`

Methods inherited from class datafaucet.system.agent.sqlagent
`applyFilter, applyFilters, applyJoinFilters, delete, deleteForeignKeys, getDeleteSyntax, getFilterInclude, getFilteredColumns, getFromClause, getGroupByClause, getHavingClause, getInsertSyntax, getJoinClause, 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, createColumnEntity, createConstraintEntity, createSequenceEntity, createTableEntity, 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, createColumnEntity, createConstraintEntity, createSequenceEntity, createTableEntity, 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, 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

createProcedureEntity

private array createProcedureEntity(any datasource, string entity, string syntax, [array param='[runtime expression]'])

MS SQL Server doesn't allow use of the catalog name when creating a view - use the system stored procedure sp_executeSQL as a workaround

createTriggerEntity

private array createTriggerEntity(any datasource, string entity, string trigger, string action, string syntax, [string exec='after'])

Overrides:: createTriggerEntity in class datadefinitionlanguage

Parameters:: datasource; entity; trigger; action; syntax; exec

createViewEntity

private array createViewEntity(string entity, string syntax)

MS SQL Server doesn't allow use of the catalog name when creating a view - use the system stored procedure sp_executeSQL as a workaround

dropProcedureEntity

private array dropProcedureEntity(any datasource, string entity)

Parameters:: datasource; entity

dropTriggerEntity

private array dropTriggerEntity(any datasource, string entity)

Parameters:: datasource; entity

dropViewEntity

private array dropViewEntity(any datasource, string entity)

Parameters:: datasource; entity

escape

public string escape(string entity)

Overrides:: escape in class format

Parameters:: entity

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 and nvarchar columns to 4000 or 8000 characters for SQL Server databases

getOrderByClause

private string getOrderByClause(struct statement)

Overrides:: getOrderByClause in class sqlagent

Parameters:: statement

queryparam_longvarchar

private struct queryparam_longvarchar(struct st='')

Parameters:: st

sp_executeSQL

private array sp_executeSQL(string catalog, array sql)

Parameters:: catalog; sql

Overview

Package