PHP Vovanmix\WebOrm QueryBuilder::prepare Examples

Example #1

File: queryPartsTest.php Project: vovanmix/web_orm

 public function testPrepare()
 {
     $val = QueryBuilder::prepare(" 'MyName' is hello ");
     $expectedVal = "'`MyName` is hello'";
     $this->assertEquals($expectedVal, $val);
     $val2 = QueryBuilder::prepare(['hello']);
     $expectedVal2 = "'hello'";
     $this->assertEquals($expectedVal2, $val2);
     $val3 = QueryBuilder::prepare(1);
     $expectedVal3 = "'1'";
     $this->assertEquals($expectedVal3, $val3);
     $val = QueryBuilder::prepare(0);
     $expectedVal = "0";
     $this->assertEquals($expectedVal, $val);
     $val = QueryBuilder::prepare('0');
     $expectedVal = "0";
     $this->assertEquals($expectedVal, $val);
     $val = QueryBuilder::prepare('');
     $expectedVal = '""';
     $this->assertEquals($expectedVal, $val);
     $val = QueryBuilder::prepare(NULL);
     $expectedVal = 'NULL';
     $this->assertEquals($expectedVal, $val);
     $val = QueryBuilder::prepare(false);
     $expectedVal = 0;
     $this->assertEquals($expectedVal, $val);
     $val = QueryBuilder::prepare(true);
     $expectedVal = "'1'";
     $this->assertEquals($expectedVal, $val);
 }