Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class delete

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

public class delete
extends statement
extends statement

creates a sql delete statement which can be filtered - delete statements can not be unioned or joined

Constructor Summary
`init(string table, [boolean nullforeignkeys='[runtime expression]'], [boolean deleteforeignkeys='[runtime expression]'], [string include='[runtime expression]'], [any datasource=''])`

Method Summary
`any`	`execute()`
`string`	`getSyntax()`

Methods inherited from class datafaucet.system.sql.statement
`addListener, bindFilters, broadcast, clearJoinTables, clearListeners, clearUnions, getColumnList, getColumns, getDatasource, getGroupSource, getListeners, getNewListener, getSQLAgent, getSource, getSourceName, getTable, get_alias, hasFilters, hasGroupSource, hasJoinTables, hasListeners, initStatement, notifyListener, reset, setDatasource, set_datasource, set_table`

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(string table, [boolean nullforeignkeys='[runtime expression]'], [boolean deleteforeignkeys='[runtime expression]'], [string include='[runtime expression]'], [any datasource=''])

Parameters:: table - the database table to delete records from; nullforeignkeys - if true the tag will set nulls on any foreign keys which reference the primary key on the deleted records when applicable; deleteforeignkeys - if true the tag will delete any records in tables with foreign keys referencing the primary key on the deleted records - this is done after nulls are set, allowing foreign records to be saved when possible; include - and / or -- determines whether the filters are cumulative or exclusive; datasource

Method Detail

execute

public any execute()

Overrides:: execute in class statement

getSyntax

public string getSyntax()

Overrides:: getSyntax in class statement

Overview

Package