function prefix_replacement_test()
{
$db = Database_For_Test::instance();
$converted = $db->add_table_prefixes("CREATE TABLE IF NOT EXISTS {test_tables} (\n `id` int(9) NOT NULL auto_increment,\n `name` varchar(32) NOT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY(`name`))\n ENGINE=InnoDB DEFAULT CHARSET=utf8");
$expected = "CREATE TABLE IF NOT EXISTS g3test_test_tables (\n `id` int(9) NOT NULL auto_increment,\n `name` varchar(32) NOT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY(`name`))\n ENGINE=InnoDB DEFAULT CHARSET=utf8";
$this->assert_same($expected, $converted);
$sql = "UPDATE {test_tables} SET `name` = '{test string}' " . "WHERE `item_id` IN " . " (SELECT `id` FROM {items} " . " WHERE `left_ptr` >= 1 " . " AND `right_ptr` <= 6)";
$sql = $db->add_table_prefixes($sql);
$expected = "UPDATE g3test_test_tables SET `name` = '{test string}' " . "WHERE `item_id` IN " . " (SELECT `id` FROM g3test_items " . " WHERE `left_ptr` >= 1 " . " AND `right_ptr` <= 6)";
$this->assert_same($expected, $sql);
}
function prefix_no_replacement_test()
{
$update = Database_For_Test::instance()->from("test_tables")->where("1 = 1")->set(array("name" => "Test Name"))->update();
$expected = "UPDATE `g3test_test_tables` SET `name` = 'Test Name' WHERE 1 = 1";
$this->assert_same($expected, $update);
}
