DataSource
class DataSource implements IDataSource
Default implementation of IDataSource.
Methods
Selects columns to query.
Adds conditions to query.
Selects columns to order by.
Limits number of rows.
No description
No description
Generates, executes SQL query and fetches the single row.
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.
Discards the internal cache.
Returns this data source wrapped in DataSource object.
Returns SQL query.
Returns the number of rows in a given data source.
Returns the number of rows in a given data source.
Details
at line 44
__construct(string $sql, Connection $connection)
No description
at line 58
DataSource
select(string|array $col, string|null $as = null)
Selects columns to query.
at line 74
DataSource
where($cond)
Adds conditions to query.
at line 88
DataSource
orderBy(string|array $row, string $direction = 'ASC')
Selects columns to order by.
at line 104
DataSource
applyLimit(int $limit, int|null $offset = null)
Limits number of rows.
at line 113
final Connection
getConnection()
No description
at line 125
Result
getResult()
Returns (and queries) Result.
at line 135
ResultIterator
getIterator()
No description
at line 144
Row|null
fetch()
Generates, executes SQL query and fetches the single row.
at line 154
mixed
fetchSingle()
Like fetch(), but returns only first field.
at line 163
array
fetchAll()
Fetches all records from table.
at line 172
array
fetchAssoc(string $assoc)
Fetches all records from table and returns associative tree.
at line 181
array
fetchPairs(string|null $key = null, string|null $value = null)
Fetches all records from table like $key => $value pairs.
at line 190
void
release()
Discards the internal cache.
at line 202
Fluent
toFluent()
Returns this data source wrapped in Fluent object.
at line 211
DataSource
toDataSource()
Returns this data source wrapped in DataSource object.
at line 220
string
__toString()
Returns SQL query.
at line 244
int
count()
Returns the number of rows in a given data source.
at line 261
int
getTotalCount()
Returns the number of rows in a given data source.
Traits
Better OOP experience.