Fluent
class Fluent implements IDataSource
dibi SQL builder via fluent interfaces. EXPERIMENTAL!
Constants
| REMOVE |
|
Properties
| static array | $masks | ||
| static array | $modifiers | ||
| static array | $separators | ||
| static array | $clauseSwitches |
Methods
Removes a clause.
Is a flag set?
Returns SQL command.
Returns the dibi connection.
Adds Result setup.
Like fetch(), but returns only first field.
Fetches all records from table.
Fetches all records from table and returns associative tree.
Fetches all records from table like $key => $value pairs.
Required by the IteratorAggregate interface.
Generates and prints SQL query or it's part.
No description
No description
Returns SQL query.
Generates parameters for Translator.
Format camelCase clause name to UPPER CASE.
No description
Details
at line 108
__construct(Connection $connection)
No description
at line 124
Fluent
__call($clause, $args)
Appends new argument to the clause.
at line 212
Fluent
clause($clause)
Switch to a clause.
at line 228
Fluent
removeClause($clause)
Removes a clause.
at line 241
Fluent
setFlag($flag, $value = true)
Change a SQL flag.
at line 258
final bool
getFlag($flag)
Is a flag set?
at line 268
final string
getCommand()
Returns SQL command.
at line 278
final Connection
getConnection()
Returns the dibi connection.
at line 290
Fluent
setupResult($method)
Adds Result setup.
at line 306
Result|int
execute($return = null)
Generates and executes SQL query.
at line 324
Row|false
fetch()
Generates, executes SQL query and fetches the single row.
at line 338
mixed
fetchSingle()
Like fetch(), but returns only first field.
at line 354
array
fetchAll($offset = null, $limit = null)
Fetches all records from table.
at line 365
array
fetchAssoc($assoc)
Fetches all records from table and returns associative tree.
at line 377
array
fetchPairs($key = null, $value = null)
Fetches all records from table like $key => $value pairs.
at line 389
ResultIterator
getIterator($offset = null, $limit = null)
Required by the IteratorAggregate interface.
at line 400
bool
test($clause = null)
Generates and prints SQL query or it's part.
at line 409
int
count()
No description
at line 436
DataSource
toDataSource()
No description
at line 446
final string
__toString()
Returns SQL query.
at line 462
protected array
_export($clause = null, $args = [])
Generates parameters for Translator.
at line 502
static string
_formatClause($s)
| internal |
Format camelCase clause name to UPPER CASE.
at line 512
__clone()
No description
at line 32
Fluent
select(mixed $field)
No description
at line 32
Fluent
distinct()
No description
at line 32
Fluent
from(mixed $table)
No description
at line 32
Fluent
where(mixed $cond)
No description
at line 32
Fluent
groupBy(mixed $field)
No description
at line 32
Fluent
having(mixed $cond)
No description
at line 32
Fluent
orderBy(mixed $field)
No description
at line 32
Fluent
limit(int $limit)
No description
at line 32
Fluent
offset(int $offset)
No description
at line 32
Fluent
join(mixed $table)
No description
at line 32
Fluent
leftJoin(mixed $table)
No description
at line 32
Fluent
innerJoin(mixed $table)
No description
at line 32
Fluent
rightJoin(mixed $table)
No description
at line 32
Fluent
outerJoin(mixed $table)
No description
at line 32
Fluent
as(mixed $field)
No description
at line 32
Fluent
on(mixed $cond)
No description
at line 32
Fluent
using(mixed $cond)
No description
Traits
Better OOP experience.