public function setup() { try { $this->db = ezcDbInstance::get(); } catch (Exception $e) { $this->markTestSkipped('There was no database configured'); } MultiRelationTestPerson::setupTables(); MultiRelationTestPerson::insertData(); $this->session = new ezcPersistentSession(ezcDbInstance::get(), new ezcPersistentCodeManager(dirname(__FILE__) . "/data/")); }
public function testSubSelectSameClass() { MultiRelationTestPerson::setupTables($this->session->database); MultiRelationTestPerson::insertData($this->session->database); $q = $this->session->createFindQuery('MultiRelationTestPerson'); $subQ = $this->session->createSubQuery($q, 'MultiRelationTestPerson'); $subQ->select('mother'); $q->where($q->expr->in('id', $subQ)); $stmt = $q->prepare(); $this->assertTrue($stmt->execute()); $this->assertEquals(1, count($stmt->fetchAll())); MultiRelationTestPerson::cleanup($this->session->database); }