PHP Vovanmix\WebOrm QueryBuilder::buildFields Examples

Example #1

File: queryPartsTest.php Project: vovanmix/web_orm

 public function testBuildFields()
 {
     $sql = QueryBuilder::buildFields(['name', 'last' => 'LastName', 'CONCAT(street, zip)' => 'address']);
     $expectedSql = 'name,last as LastName,CONCAT(street, zip) as address';
     $this->assertEquals($expectedSql, $sql);
     $sql2 = QueryBuilder::buildFields(NULL);
     $expectedSql = '*';
     $this->assertEquals($expectedSql, $sql2);
     $sql = QueryBuilder::buildFields([]);
     $expectedSql = '*';
     $this->assertEquals($expectedSql, $sql);
 }