예제 #1
0
파일: MysqlTest.php 프로젝트: vtk13/lib-sql
 public function testConditionBuilder()
 {
     $this->assertEquals('`a` IS NULL', $this->db->where('a', null));
     $this->assertEquals("`a`='4'", $this->db->where('a', 4));
     $this->assertEquals("`a` IN ('1','2','3')", $this->db->where('a', [1, 2, 3]));
     $this->assertEquals('`a` IS NULL', $this->db->where(array('a' => null)));
     $this->assertEquals("`a`='4'", $this->db->where(array('a' => 4)));
     $this->assertEquals("`a` IN ('1','2','3')", $this->db->where(array('a' => [1, 2, 3])));
     $this->assertEquals("`a`='4' AND `b`='as\\'d'", $this->db->where(array('a' => 4, 'b' => 'as\'d')));
 }