public function testShouldFetchAllPersistedObjects() { self::$phactory->getConnection()->exec("DELETE FROM tests"); $users = array(); for ($i = 1; $i <= 10; $i++) { $users[] = self::$phactory->create('test'); } $query = Query::getInstance(); $query->select(Projections::count("id"))->from("tests"); $database = new Database(self::$phactory->getConnection()); $result = $database->query($query)->uniqueResult(); $this->assertThat(array_pop($result), $this->equalTo(10)); }
/** * Counts rows on the table with the given clauses. * * @param Array $clauses * @return void * @author Dan Cox */ public function countRows(array $clauses = array()) { $qb = $this->database->setEntity($this->entity)->queryBuilder(); $qb->select('count(u)'); $this->total = $qb->getQuery()->getSingleScalarResult(); }