class Fluent implements IDataSource

SQL builder via fluent interfaces.

Constants

REMOVE

Properties

static array $masks
static array $modifiers
static array $separators
static array $clauseSwitches

Methods

__construct(Connection $connection)

No description

__call(string $clause, array $args)

Appends new argument to the clause.

clause(string $clause)

Switch to a clause.

removeClause(string $clause)

Removes a clause.

setFlag(string $flag, bool $value = true)

Change a SQL flag.

bool
getFlag(string $flag)

Is a flag set?

string|null
getCommand()

Returns SQL command.

getConnection()

No description

setupResult(string $method)

Adds Result setup.

Result|int|null
execute(string $return = null)

Generates and executes SQL query.

Row|array|null
fetch()

Generates, executes SQL query and fetches the single row.

mixed
fetchSingle()

Like fetch(), but returns only first field.

array
fetchAll(int $offset = null, int $limit = null)

Fetches all records from table.

array
fetchAssoc(string $assoc)

Fetches all records from table and returns associative tree.

array
fetchPairs(string $key = null, string $value = null)

Fetches all records from table like $key => $value pairs.

getIterator(int $offset = null, int $limit = null)

Required by the IteratorAggregate interface.

bool
test(string $clause = null)

Generates and prints SQL query or it's part.

int
count()

No description

toDataSource()

No description

string
__toString()

Returns SQL query.

array
_export(string $clause = null, array $args = [])

Generates parameters for Translator.

static string
_formatClause(string $s)

Format camelCase clause name to UPPER CASE.

__clone()

No description

select(mixed $field)

No description

distinct()

No description

from(mixed $table, mixed $args)

No description

where(mixed $cond)

No description

groupBy(mixed $field)

No description

having(mixed $cond)

No description

orderBy(mixed $field)

No description

limit(int $limit)

No description

offset(int $offset)

No description

join(mixed $table)

No description

leftJoin(mixed $table)

No description

innerJoin(mixed $table)

No description

rightJoin(mixed $table)

No description

outerJoin(mixed $table)

No description

as(mixed $field)

No description

on(mixed $cond)

No description

and(mixed $cond)

No description

or(mixed $cond)

No description

using(mixed $cond)

No description

update(mixed $cond)

No description

insert(mixed $cond)

No description

delete(mixed $cond)

No description

into(mixed $cond)

No description

values(mixed $cond)

No description

set(mixed $args)

No description

asc()

No description

desc()

No description

Details

at line 117
__construct(Connection $connection)

No description

Parameters

Connection $connection

at line 130
Fluent __call(string $clause, array $args)

Appends new argument to the clause.

Parameters

string $clause
array $args

Return Value

Fluent

at line 216
Fluent clause(string $clause)

Switch to a clause.

Parameters

string $clause

Return Value

Fluent

at line 230
Fluent removeClause(string $clause)

Removes a clause.

Parameters

string $clause

Return Value

Fluent

at line 240
Fluent setFlag(string $flag, bool $value = true)

Change a SQL flag.

Parameters

string $flag
bool $value

Return Value

Fluent

at line 255
final bool getFlag(string $flag)

Is a flag set?

Parameters

string $flag

Return Value

bool

at line 264
final string|null getCommand()

Returns SQL command.

Return Value

string|null

at line 270
final Connection getConnection()

No description

Return Value

Connection

at line 279
Fluent setupResult(string $method)

Adds Result setup.

Parameters

string $method

Return Value

Fluent

at line 294
Result|int|null execute(string $return = null)

Generates and executes SQL query.

Parameters

string $return

Return Value

Result|int|null

result set or number of affected rows

Exceptions

Exception

at line 312
Row|array|null fetch()

Generates, executes SQL query and fetches the single row.

Return Value

Row|array|null

at line 324
mixed fetchSingle()

Like fetch(), but returns only first field.

Return Value

mixed

value on success, null if no next record

at line 335
array fetchAll(int $offset = null, int $limit = null)

Fetches all records from table.

Parameters

int $offset
int $limit

Return Value

array

at line 345
array fetchAssoc(string $assoc)

Fetches all records from table and returns associative tree.

Parameters

string $assoc

associative descriptor

Return Value

array

at line 354
array fetchPairs(string $key = null, string $value = null)

Fetches all records from table like $key => $value pairs.

Parameters

string $key
string $value

Return Value

array

at line 363
ResultIterator getIterator(int $offset = null, int $limit = null)

Required by the IteratorAggregate interface.

Parameters

int $offset
int $limit

Return Value

ResultIterator

at line 372
bool test(string $clause = null)

Generates and prints SQL query or it's part.

Parameters

string $clause

Return Value

bool

at line 378
int count()

No description

Return Value

int

at line 400
DataSource toDataSource()

No description

Return Value

DataSource

at line 409
final string __toString()

Returns SQL query.

Return Value

string

at line 423
protected array _export(string $clause = null, array $args = [])

Generates parameters for Translator.

Parameters

string $clause
array $args

Return Value

array

at line 461
static string _formatClause(string $s)

internal  
 

Format camelCase clause name to UPPER CASE.

Parameters

string $s

Return Value

string

at line 471
__clone()

No description

at line 44
Fluent select(mixed $field)

No description

Parameters

mixed $field

Return Value

Fluent

at line 44
Fluent distinct()

No description

Return Value

Fluent

at line 44
Fluent from(mixed $table, mixed $args)

No description

Parameters

mixed $table
mixed $args

Return Value

Fluent

at line 44
Fluent where(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent groupBy(mixed $field)

No description

Parameters

mixed $field

Return Value

Fluent

at line 44
Fluent having(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent orderBy(mixed $field)

No description

Parameters

mixed $field

Return Value

Fluent

at line 44
Fluent limit(int $limit)

No description

Parameters

int $limit

Return Value

Fluent

at line 44
Fluent offset(int $offset)

No description

Parameters

int $offset

Return Value

Fluent

at line 44
Fluent join(mixed $table)

No description

Parameters

mixed $table

Return Value

Fluent

at line 44
Fluent leftJoin(mixed $table)

No description

Parameters

mixed $table

Return Value

Fluent

at line 44
Fluent innerJoin(mixed $table)

No description

Parameters

mixed $table

Return Value

Fluent

at line 44
Fluent rightJoin(mixed $table)

No description

Parameters

mixed $table

Return Value

Fluent

at line 44
Fluent outerJoin(mixed $table)

No description

Parameters

mixed $table

Return Value

Fluent

at line 44
Fluent as(mixed $field)

No description

Parameters

mixed $field

Return Value

Fluent

at line 44
Fluent on(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent and(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent or(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent using(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent update(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent insert(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent delete(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent into(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent values(mixed $cond)

No description

Parameters

mixed $cond

Return Value

Fluent

at line 44
Fluent set(mixed $args)

No description

Parameters

mixed $args

Return Value

Fluent

at line 44
Fluent asc()

No description

Return Value

Fluent

at line 44
Fluent desc()

No description

Return Value

Fluent

Traits

Better OOP experience.