PHP Titon\Db Query::leftJoin Examples

Example #1

File: QueryTest.php Project: titon/db

 public function testFieldsAutoPopulateViaJoinsNoSchema()
 {
     $query = new Query(Query::SELECT, new Repository(['table' => 'foo']));
     // Repo has no schema
     $query->leftJoin('bar', [], ['bar.user_id' => 'foo.id']);
     $this->assertEquals([], $query->getFields());
 }

Example #2

File: DialectTest.php Project: titon/db

 /**
  * @expectedException \Titon\Db\Exception\InvalidQueryException
  */
 public function testFormatFieldsThrowsErrorsNoJoinFields()
 {
     $query = new Query(Query::SELECT, new User());
     $query->fields(['id', 'country_id', 'username']);
     $query->leftJoin(['countries', 'Country'], [], ['users.country_id' => 'Country.id']);
     $this->object->formatFields($query);
 }