protected function proceedSeeInDatabase($table, $criteria) { $query = "select count(*) from `%s` where %s"; $params = array(); foreach ($criteria as $k => $v) { $params[] = "`{$k}` = ? "; } $params = implode('AND ', $params); $query = sprintf($query, $table, $params); $this->debugSection('Query', $query, $params); $sth = $this->driver->getDbh()->prepare($query); if (!$sth) { \PHPUnit_Framework_Assert::fail("Query '{$query}' can't be executed."); } $sth->execute(array_values($criteria)); return $sth->fetchColumn(); }
protected function proceedSeeInDatabase($table, $column, $criteria) { $query = $this->driver->select($column, $table, $criteria); $this->debugSection('Query', $query, json_encode($criteria)); $sth = $this->driver->getDbh()->prepare($query); if (!$sth) { \PHPUnit_Framework_Assert::fail("Query '{$query}' can't be executed."); } $sth->execute(array_values($criteria)); return $sth->fetchColumn(); }