Fr3nch13/CakePHP Utilities

Expression

Table of Contents

Interfaces

FieldInterface
Describes a getter and a setter for the a field property. Useful for expressions that contain an identifier to compare against.
WindowInterface
This defines the functions used for building window expressions.

Classes

AggregateExpression
This represents an SQL aggregate function expression in an SQL statement.
BetweenExpression
An expression object that represents a SQL BETWEEN snippet
CaseExpression
This class represents a SQL Case statement
CaseStatementExpression
Represents a SQL case statement with a fluid API
CommonTableExpression
An expression that represents a common table expression definition.
ComparisonExpression
A Comparison is a type of query expression that represents an operation involving a field an operator and a value. In its most common form the string representation of a comparison is `field = value`
FunctionExpression
This class represents a function call string in a SQL statement. Calls can be constructed by passing the name of the function and a list of params.
IdentifierExpression
Represents a single identifier name in the database.
OrderByExpression
An expression object for ORDER BY clauses
OrderClauseExpression
An expression object for complex ORDER BY clauses
QueryExpression
Represents a SQL Query expression. Internally it stores a tree of expressions that can be compiled by converting this object to string and will contain a correctly parenthesized and nested expression.
StringExpression
String expression with collation.
TupleComparison
This expression represents SQL fragments that are used for comparing one tuple to another, one tuple to a set of other tuples or one tuple to an expression
UnaryExpression
An expression object that represents an expression with only a single operand.
ValuesExpression
An expression object to contain values being inserted.
WhenThenExpression
Represents a SQL when/then clause with a fluid API
WindowExpression
This represents a SQL window expression used by aggregate and window functions.

Traits

FieldTrait
Contains the field property with a getter and a setter for it

        
On this page

Search results