Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
Total | CRAP |
<?php | |
namespace Codeception\Util; | |
interface DbInterface | |
{ | |
/** | |
* Checks if a row with given column values exists. | |
* Provide table name and column values. | |
* | |
* Example: | |
* | |
* ``` php | |
* <?php | |
* $I->seeInDatabase('users', array('name' => 'Davert', 'email' => 'davert@mail.com')); | |
* | |
* ``` | |
* Will generate: | |
* | |
* ``` sql | |
* SELECT COUNT(*) FROM `users` WHERE `name` = 'Davert' AND `email` = 'davert@mail.com' | |
* ``` | |
* Fails if no such user found. | |
* | |
* @param $table | |
* @param array $criteria | |
*/ | |
public function seeInDatabase($table, $criteria = array()); | |
/** | |
* Effect is opposite to ->seeInDatabase | |
* | |
* Checks if there is no record with such column values in database. | |
* Provide table name and column values. | |
* | |
* Example: | |
* | |
* ``` php | |
* <?php | |
* $I->seeInDatabase('users', array('name' => 'Davert', 'email' => 'davert@mail.com')); | |
* | |
* ``` | |
* Will generate: | |
* | |
* ``` sql | |
* SELECT COUNT(*) FROM `users` WHERE `name` = 'Davert' AND `email` = 'davert@mail.com' | |
* ``` | |
* Fails if such user was found. | |
* | |
* @param $table | |
* @param array $criteria | |
*/ | |
public function dontSeeInDatabase($table, $criteria = array()); | |
/** | |
* Fetches a single column value from a database. | |
* Provide table name, desired column and criteria. | |
* | |
* Example: | |
* | |
* ``` php | |
* <?php | |
* $mail = $I->grabFromDatabase('users', 'email', array('name' => 'Davert')); | |
* | |
* ``` | |
* | |
* @version 1.1 | |
* @param $table | |
* @param $column | |
* @param array $criteria | |
* @return mixed | |
*/ | |
public function grabFromDatabase($table, $column, $criteria = array()); | |
} |