public function read(Query $query)
{
$metaclass = $query->getMetaclass();
$table = $this->getTable($metaclass->getStorageName());
$select = new Select(array($table));
$conditions = array();
foreach ($query->getConditions() as $condition) {
$column = $this->getColumnFromProperty($table, $condition->subject);
$newCondition = $column->op($condition->operator, $condition->value);
if ($condition->negated) {
$newCondition->negate();
}
$conditions[] = $newCondition;
}
if (count($conditions) !== 0) {
call_user_func_array(array($select, 'where'), $conditions);
}
$sorts = array();
foreach ($query->getSorts() as $sort) {
$column = $this->getColumnFromProperty($table, $sort->subject);
$newSort = $sort->ascending ? $column->asc() : $column->desc();
$sorts[] = $newSort;
}
if (count($sorts) !== 0) {
call_user_func_array(array($select, 'orderBy'), $sorts);
}
$limit = $query->getLimit();
if ($limit) {
$select->limit($limit);
}
$offset = $query->getOffset();
if ($offset) {
$select->offset($offset);
}
return $this->connection->execute($select);
}
public function read(Query $query)
{
return $query->getMetaclass()->load($this->getAdapter()->read($query));
}