diff options
Diffstat (limited to 'tests/codeigniter/database/query_builder/escape_test.php')
-rw-r--r-- | tests/codeigniter/database/query_builder/escape_test.php | 68 |
1 files changed, 0 insertions, 68 deletions
diff --git a/tests/codeigniter/database/query_builder/escape_test.php b/tests/codeigniter/database/query_builder/escape_test.php deleted file mode 100644 index de6cd0a9d..000000000 --- a/tests/codeigniter/database/query_builder/escape_test.php +++ /dev/null @@ -1,68 +0,0 @@ -<?php - -class Escape_test extends CI_TestCase { - - /** - * @var object Database/Query Builder holder - */ - protected $db; - - public function set_up() - { - $this->db = Mock_Database_Schema_Skeleton::init(DB_DRIVER); - - Mock_Database_Schema_Skeleton::create_tables(); - Mock_Database_Schema_Skeleton::create_data(); - } - - // ------------------------------------------------------------------------ - - /** - * @see ./mocks/schema/skeleton.php - */ - public function test_escape_like_percent_sign() - { - // Escape the like string - $string = $this->db->escape_like_str('\%foo'); - - if (strpos(DB_DRIVER, 'mysql') !== FALSE) - { - $sql = "SELECT `value` FROM `misc` WHERE `key` LIKE '$string%' ESCAPE '!';"; - } - else - { - $sql = 'SELECT "value" FROM "misc" WHERE "key" LIKE \''.$string.'%\' ESCAPE \'!\';'; - } - - $res = $this->db->query($sql)->result_array(); - - // Check the result - $this->assertCount(1, $res); - } - - // ------------------------------------------------------------------------ - - /** - * @see ./mocks/schema/skeleton.php - */ - public function test_escape_like_backslash_sign() - { - // Escape the like string - $string = $this->db->escape_like_str('\\'); - - if (strpos(DB_DRIVER, 'mysql') !== FALSE) - { - $sql = "SELECT `value` FROM `misc` WHERE `key` LIKE '$string%' ESCAPE '!';"; - } - else - { - $sql = 'SELECT "value" FROM "misc" WHERE "key" LIKE \''.$string.'%\' ESCAPE \'!\';'; - } - - $res = $this->db->query($sql)->result_array(); - - // Check the result - $this->assertCount(2, $res); - } - -} |