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
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 53
__construct($sql, Connection $connection)
No description
at line 70
DataSource
select($col, $as = null)
Selects columns to query.
at line 87
DataSource
where($cond)
Adds conditions to query.
at line 106
DataSource
orderBy($row, $sorting = 'ASC')
Selects columns to order by.
at line 124
DataSource
applyLimit($limit, $offset = null)
Limits number of rows.
at line 136
final Connection
getConnection()
No description
at line 149
Result
getResult()
Returns (and queries) Result.
at line 161
ResultIterator
getIterator()
No description
at line 171
Row|false
fetch()
Generates, executes SQL query and fetches the single row.
at line 181
mixed
fetchSingle()
Like fetch(), but returns only first field.
at line 191
array
fetchAll()
Fetches all records from table.
at line 202
array
fetchAssoc($assoc)
Fetches all records from table and returns associative tree.
at line 214
array
fetchPairs($key = null, $value = null)
Fetches all records from table like $key => $value pairs.
at line 224
void
release()
Discards the internal cache.
at line 237
Fluent
toFluent()
Returns this data source wrapped in Fluent object.
at line 247
DataSource
toDataSource()
Returns this data source wrapped in DataSource object.
at line 257
string
__toString()
Returns SQL query.
at line 281
int
count()
Returns the number of rows in a given data source.
at line 298
int
getTotalCount()
Returns the number of rows in a given data source.
Traits
Better OOP experience.