PHP October\Rain\Database Dongle::parseBooleanExpression Examples

Example #1

File: DongleTest.php Project: richlove1/avc-october

 public function testSqliteParseBooleanExpression()
 {
     $dongle = new Dongle('sqlite');
     $result = $dongle->parseBooleanExpression("select * from table where is_true = true");
     $this->assertEquals("select * from table where is_true = 1", $result);
     $result = $dongle->parseBooleanExpression("is_true = true and is_false <> true");
     $this->assertEquals("is_true = 1 and is_false <> 1", $result);
     $result = $dongle->parseBooleanExpression("is_true = true and is_false = false or is_whatever = 2");
     $this->assertEquals("is_true = 1 and is_false = 0 or is_whatever = 2", $result);
     $result = $dongle->parseBooleanExpression("select * from table where is_true = true");
     $this->assertEquals("select * from table where is_true = 1", $result);
 }