public function getComplexJoinRelationsTest()
{
$toJob = new JoinPart('j', Job::getPeer());
$toPerson = new JoinPart('p', Person::getPeer());
$toDepartment = new JoinPart('d', Department::getPeer());
$toChief = new JoinPart('c', Person::getPeer());
$toJob->addRelative($toPerson, 'PersonJob');
$toPerson->addRelative($toDepartment, 'Department');
$toDepartment->addRelative($toChief, 'Chief');
$this->assertEquals($this->conn->getFormatter()->dialect->makeJoinBy($toJob->getJoinRelations()), 'JOBS.job as j LEFT OUTER JOIN JOBS.Person as p on (j.job_id = p.job_id) LEFT JOIN JOBS.Department as d on (p.department_id = d.department_id) LEFT JOIN JOBS.Person as c on (d.chief_id = c.person_id) where ');
}
