public function testQueryForTotal()
{
Database::setConfig(['default' => ['dsn' => 'sqlite::memory:']]);
$dbh = Database::get();
$pager = new Pager();
$pager->queryForTotal($dbh, 'SELECT 42');
$this->assertEquals(42, $pager->getTotal());
$stmt = $dbh->prepare('SELECT 666');
$pager->queryForTotal($stmt);
$this->assertEquals(666, $pager->getTotal());
}
public static function setUpBeforeClass()
{
Database::setConfig(['default' => ['dsn' => 'sqlite::memory:']]);
$dbh = Database::get();
$dbh->exec('CREATE TABLE items (
id INTEGER PRIMARY KEY AUTOINCREMENT,
a INT,
b TEXT
)');
$dbh->exec(sprintf('INSERT INTO items (a,b) VALUES(42, %s)', $dbh->quote('The Answer')));
}
/**
* @dataProvider invalidStandardWhereClauses
* @expectedException InvalidArgumentException
*/
public function testComputeStandardWhereClauseInvalid($opt)
{
$dbh = Database::get();
$fields = ['id'];
$where = [];
$method = new ReflectionMethod('DbTools\\TableModel', 'computeStandardWhereClause');
$method->setAccessible(true);
$method->invokeArgs(null, [$dbh, $fields, $opt, &$where]);
}
