public function testSetConfig()
{
$dsn = 'sqlite::memory:';
Database::setConfig(['default' => ['dsn' => $dsn, 'attributes' => [PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC]]]);
$c = Database::getConfig();
$this->assertEquals('PDO', $c['default']['class'], 'setConfig preserves default values');
$this->assertEquals($dsn, $c['default']['dsn'], 'setConfig merges values');
$this->assertEquals(PDO::ERRMODE_EXCEPTION, $c['default']['attributes'][PDO::ATTR_ERRMODE], 'setConfig preserves default attributes');
$this->assertEquals(PDO::FETCH_ASSOC, $c['default']['attributes'][PDO::ATTR_DEFAULT_FETCH_MODE], 'setConfig preserves default attributes');
}
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')));
}
