/** * @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'); } }