/**
* Test query parsing and arguments quoting
*/
function test_query_parsing()
{
$db = new rcube_db_test_wrapper('test');
$db->set_option('identifier_start', '`');
$db->set_option('identifier_end', '`');
$db->query("SELECT ?", "test`test");
$db->query("SELECT ?", "test?test");
$db->query("SELECT ?", "test``test");
$db->query("SELECT ?", "test??test");
$db->query("SELECT `test` WHERE 'test``test'");
$db->query("SELECT `test` WHERE 'test??test'");
$db->query("SELECT `test` WHERE `test` = ?", "`te``st`");
$db->query("SELECT `test` WHERE `test` = ?", "?test?");
$db->query("SELECT `test` WHERE `test` = ?", "????");
$expected = implode("\n", array("SELECT 'test`test'", "SELECT 'test?test'", "SELECT 'test``test'", "SELECT 'test??test'", "SELECT `test` WHERE 'test`test'", "SELECT `test` WHERE 'test?test'", "SELECT `test` WHERE `test` = '`te``st`'", "SELECT `test` WHERE `test` = '?test?'", "SELECT `test` WHERE `test` = '????'"));
$this->assertSame($expected, implode("\n", $db->queries), "Query parsing [1]");
$db->set_option('identifier_start', '"');
$db->set_option('identifier_end', '"');
$db->queries = array();
$db->query("SELECT ?", "test`test");
$db->query("SELECT ?", "test?test");
$db->query("SELECT ?", "test``test");
$db->query("SELECT ?", "test??test");
$db->query("SELECT `test` WHERE 'test``test'");
$db->query("SELECT `test` WHERE 'test??test'");
$db->query("SELECT `test` WHERE `test` = ?", "`te``st`");
$db->query("SELECT `test` WHERE `test` = ?", "?test?");
$db->query("SELECT `test` WHERE `test` = ?", "????");
$expected = implode("\n", array("SELECT 'test`test'", "SELECT 'test?test'", "SELECT 'test``test'", "SELECT 'test??test'", "SELECT \"test\" WHERE 'test`test'", "SELECT \"test\" WHERE 'test?test'", "SELECT \"test\" WHERE \"test\" = '`te``st`'", "SELECT \"test\" WHERE \"test\" = '?test?'", "SELECT \"test\" WHERE \"test\" = '????'"));
$this->assertSame($expected, implode("\n", $db->queries), "Query parsing [2]");
}
