public function testCreateView() { $query = new Doctrine_Query($this->connection); $query->from('User'); $view = new Doctrine_View($query, 'MyView'); $this->assertEqual($view->getName(), 'MyView'); $this->assertTrue($view->getQuery() === $query); $this->assertTrue($view === $query->getView()); $this->assertTrue($view->getConnection() instanceof Doctrine_Connection); $success = true; try { $view->create(); } catch (Exception $e) { $success = false; } $this->assertTrue($success); $users = $view->execute(); $count = $this->conn->count(); $this->assertTrue($users instanceof Doctrine_Collection); $this->assertEqual($users->count(), 8); $this->assertEqual($users[0]->name, 'zYne'); $this->assertEqual($users[0]->state(), Doctrine_Record::STATE_CLEAN); $this->assertEqual($count, $this->conn->count()); $success = true; try { $view->drop(); } catch (Exception $e) { $success = false; } $this->assertTrue($success); }
public function testTest() { $person = new Ticket_987_Person(); $person->gender = 'male'; $person->firstname = 'jon'; $person->lastname = 'wage'; $person->save(); // creating the query $q = Doctrine_Query::create(); $q->from('Ticket_987_Person p'); // creating the view $view = new Doctrine_View($q, 'view_person2person_type'); $view->create(); // creating the query $q = Doctrine_Query::create(); $q->from('Ticket_987_Person p'); // creating view object for querying $view = new Doctrine_View($q, 'view_person2person_type'); // executes view $coll = $view->execute(); $this->assertEqual($coll->count(), 1); }