public function totalRecords(Query $query) { $model = $query->getModel(); $tablename = $model->getTablename(); try { return (int) $this->app['db']->select('count(*)')->from($tablename)->where($query->getWhere())->scalar(); } catch (PDOException $original) { $e = new AdapterException('An error occurred in the database adapter while getting the number of ' . $model::modelName() . ' objects'); $e->setException($original); throw $e; } }