public function testQuoteIdentifier() { $this->db->multiQuery("\n DROP TABLE IF EXISTS `test``_ident`;\n CREATE TABLE `test``_ident` (\n `id` int(11) unsigned NOT NULL,\n `ide``nt` varchar(100) NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n "); $table = 'test`_ident'; // test insert $insert = ['id' => 1, 'ide`nt' => 'test']; $this->db->insert($table, $insert); $ident = $this->db->getAssoc('SELECT id, `ide``nt` FROM `test``_ident` WHERE id = 1'); $this->assertEquals($insert, $ident); // test update $update = ['ide`nt' => 'pass']; $this->db->update($table, $update, ['id' => 1]); $ident = $this->db->getAssoc('SELECT `ide``nt` FROM `test``_ident` WHERE id = 1'); $this->assertEquals($update, $ident); $update = ['ide`nt' => 'order']; $where = ['ide`nt' => 'pass']; $this->db->update($table, $update, $where); $ident = $this->db->getAssoc('SELECT `ide``nt` FROM `test``_ident` WHERE id = 1'); $this->assertEquals($update, $ident); // test insertUpdate $update = ['id' => 1, 'ide`nt' => 'update']; $this->db->insertUpdate($table, $update); $ident = $this->db->getAssoc('SELECT id, `ide``nt` FROM `test``_ident` WHERE id = 1'); $this->assertEquals($update, $ident); // test multiInsert $insert = [['id' => 2, 'ide`nt' => 'first'], ['id' => 3, 'ide`nt' => 'second']]; $this->db->multiInsert($table, array_keys($insert[0]), $insert); $idents = $this->db->getAll('SELECT id, `ide``nt` FROM `test``_ident` WHERE id > 1'); $this->assertEquals($insert, $idents); // test delete $where = ['id' => 2, 'ide`nt' => 'first']; $res = $this->db->delete($table, $where); $ident = $this->db->getAssoc('SELECT id, `ide``nt` FROM `test``_ident` WHERE id = 2'); $this->assertNull($ident); $this->assertEquals(1, $res); }