PHP Vovanmix\WebOrm QueryBuilder::buildJoins Examples

Example #1

File: queryPartsTest.php Project: vovanmix/web_orm

 public function testBuildJoins()
 {
     $sql = QueryBuilder::buildJoins([['users', [['users.city', '=', 1], ['parent', '.=', 'parent.id']]]]);
     $expectedSql = '  LEFT JOIN `users` ON users.city = 1  AND parent = parent.id ';
     $this->assertEquals($expectedSql, $sql);
     $sql = QueryBuilder::buildJoins([]);
     $expectedSql = '';
     $this->assertEquals($expectedSql, $sql);
 }