| class Escape_test extends CI_TestCase { |
| * @var object Database/Query Builder holder |
| $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() |
| $string = $this->db->escape_like_str('\%foo'); |
| $sql = "SELECT `value` FROM `misc` WHERE `key` LIKE '$string%';"; |
| $res = $this->db->query($sql)->result_array(); |
| $this->assertEquals(1, count($res)); |
| // ------------------------------------------------------------------------ |
| * @see ./mocks/schema/skeleton.php |
| public function test_escape_like_backslash_sign() |
| $string = $this->db->escape_like_str('\\'); |
| $sql = "SELECT `value` FROM `misc` WHERE `key` LIKE '$string%';"; |
| $res = $this->db->query($sql)->result_array(); |
| $this->assertEquals(2, count($res)); |