Index

Classes

Interfaces

Traits

Class \Prado\Data\Common\Mssql\TMssqlCommandBuilder

TMssqlCommandBuilder provides specifics methods to create limit/offset query commands for MSSQL servers.

Class hierarchy

\Prado\Data\Common\Mssql\TMssqlCommandBuilder

Extended by

\Prado\Data\Common\TDbCommandBuilder

Extended by

\Prado\TComponent

Author: Wei Zhuo <weizho[at]gmail[dot]com>
Since: 3.1

Methods summary
`public`	`applyLimitOffset(string $sql[, int $limit = -1 ][, int $offset = -1 ]) : string` Overrides parent implementation. Alters the sql to apply $limit and $offset. The idea for limit with offset is done by modifying the sql on the fly with numerous assumptions on the structure of the sql string. The modification is done with reference to the notes from http://troels.arvin.dk/db/rdbms/#select-limit-offset `SELECT * FROM ( SELECT TOP n * FROM ( SELECT TOP z columns -- (z=n+skip) FROM tablename ORDER BY key ASC ) AS FOO ORDER BY key DESC -- ('FOO' may be anything) ) AS BAR ORDER BY key ASC -- ('BAR' may be anything)` Regular expressions are used to alter the SQL query. The resulting SQL query may be malformed for complex queries. The following restrictions apply In particular, commas should NOT be used as part of the ordering expression or identifier. Commas must only be used for separating the ordering clauses. In the ORDER BY clause, the column name should NOT be be qualified with a table name or view name. Alias the column names or use column index. No clauses should follow the ORDER BY clause, e.g. no COMPUTE or FOR clauses.
`public`	`getLastInsertID() : null\|int` Overrides parent implementation. Uses "SELECT @@Identity".
`protected`	`findOrdering(string $sql) : array<string\|int, mixed>` Base on simplified syntax http://msdn2.microsoft.com/en-us/library/aa259187(SQL.80).aspx
`protected`	`joinOrdering(array<string\|int, mixed> $orders) : string`
`protected`	`reverseDirection(array<string\|int, mixed> $orders) : array<string\|int, mixed>`
`protected`	`rewriteLimitOffsetSql(string $sql, int $limit, int $offset) : string` Rewrite sql to apply $limit > and $offset > 0 for MSSQL database. See http://troels.arvin.dk/db/rdbms/#select-limit-offset

Inherited methods
__call, __callStatic, __clone, __construct, __destruct, __get, __isset, __set, __sleep, __unset, __wakeup, addParsedObject, applyCriterias, applyLimitOffset, applyOrdering, asa, attachBehavior, attachBehaviors, attachClassBehavior, attachEventHandler, bindArrayValues, bindColumnValues, callBehaviorsMethod, canGetProperty, canSetProperty, clearBehaviors, createCommand, createCountCommand, createDeleteCommand, createdOnTemplate, createFindCommand, createInsertCommand, createUpdateCommand, detachBehavior, detachBehaviors, detachClassBehavior, detachEventHandler, disableBehavior, disableBehaviors, enableBehavior, enableBehaviors, evaluateExpression, evaluateStatements, fxAttachClassBehavior, fxDetachClassBehavior, getAutoGlobalListen, getBehaviors, getBehaviorsEnabled, getClassHierarchy, getDbConnection, getEventHandlers, getLastInsertID, getListeningToGlobalEvents, getPdoType, getSearchExpression, getSelectFieldList, getSubProperty, getTableInfo, hasEvent, hasEventHandler, hasMethod, hasProperty, isa, listen, raiseEvent, setDbConnection, setSubProperty, setTableInfo, unlisten, _getZappableSleepProps, getCallChain, getClassFxEvents, getColumnBindings, getInsertFieldBindings, getSearchCondition, hasIntegerKey, instanceBehavior, filter_prado_fx

Inherited constants
`\Prado\TComponent::GLOBAL_RAISE_EVENT_LISTENER`