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);
}
