/**
* @dataProvider provideAddQuotes()
* @covers DatabaseSqlite::addQuotes
*/
public function testAddQuotes($value, $expected)
{
// check quoting
$db = new DatabaseSqliteStandalone(':memory:');
$this->assertEquals($expected, $db->addQuotes($value), 'string not quoted as expected');
// ok, quoting works as expected, now try a round trip.
$re = $db->query('select ' . $db->addQuotes($value));
$this->assertTrue($re !== false, 'query failed');
if ($row = $re->fetchRow()) {
if ($value instanceof Blob) {
$value = $value->fetch();
}
$this->assertEquals($value, $row[0], 'string mangled by the database');
} else {
$this->fail('query returned no result');
}
}
