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]); }