public function test_indexActionTwoProject()
{
$table_project = new USVN_Db_Table_Projects();
$project = $table_project->fetchNew();
$project->setFromArray(array('projects_name' => 'OpenBSD', 'projects_start_date' => '1984-12-03 00:00:00'));
$project->save();
$project->addUser($this->user);
$project2 = $table_project->fetchNew();
$project2->setFromArray(array('projects_name' => 'Hurd', 'projects_start_date' => '1984-12-03 00:00:00'));
$project2->save();
$project2->addUser($this->user);
$this->runAction('index');
$this->assertEquals(2, count($this->controller->view->projects));
$this->assertContains('href="/project/OpenBSD">OpenBSD</a>', $this->getBody(), $this->getBody());
$this->assertContains('href="/project/Hurd">Hurd</a>', $this->getBody());
}
public function setUp()
{
parent::setUp();
$table = new USVN_Db_Table_Projects();
$obj = $table->fetchNew();
$obj->setFromArray(array('projects_name' => 'test', 'projects_start_date' => '1984-12-03 00:00:00'));
$obj->save();
}
public function setUp()
{
parent::setUp();
$table = new USVN_Db_Table_Projects();
$project = $table->fetchNew();
$project->setFromArray(array('projects_name' => 'project1', 'projects_start_date' => '1984-12-03 00:00:00'));
$this->_projectid1 = $project->save();
$table = new USVN_Db_Table_Projects();
$project = $table->fetchNew();
$project->setFromArray(array('projects_name' => 'project2', 'projects_start_date' => '1984-12-03 00:00:00'));
$this->_projectid2 = $project->save();
$table_files = new USVN_Db_Table_FilesRights();
$id = $table_files->insert(array('projects_id' => $this->_projectid1, 'files_rights_path' => '/'));
}
public function setUp()
{
parent::setUp();
$table = new USVN_Db_Table_Projects();
$project = $table->fetchNew();
$project->setFromArray(array('projects_name' => 'project1', 'projects_start_date' => '1984-12-03 00:00:00'));
$this->_projectid1 = $project->save();
$table = new USVN_Db_Table_Projects();
$project = $table->fetchNew();
$project->setFromArray(array('projects_name' => 'project2', 'projects_start_date' => '1984-12-03 00:00:00'));
$this->_projectid2 = $project->save();
$group_table = new USVN_Db_Table_Groups();
$group = $group_table->fetchNew();
$group->setFromArray(array("groups_name" => "toto"));
$this->_groupid1 = $group->save();
$group_table = new USVN_Db_Table_Groups();
$group = $group_table->fetchNew();
$group->setFromArray(array("groups_name" => "titi"));
$this->_groupid2 = $group->save();
}
public function testfetchAllAssignedTwoUserInGroup()
{
$table_user = new USVN_Db_Table_Users();
$user = $table_user->fetchNew();
$user->setFromArray(array('users_login' => 'test', 'users_password' => 'password', 'users_firstname' => 'firstname', 'users_lastname' => 'lastname', 'users_email' => '*****@*****.**'));
$user->save();
$user2 = $table_user->fetchNew();
$user2->setFromArray(array('users_login' => 'test2', 'users_password' => 'password', 'users_firstname' => 'firstname', 'users_lastname' => 'lastname', 'users_email' => '*****@*****.**'));
$user2->save();
$table_project = new USVN_Db_Table_Projects();
$project = $table_project->fetchNew();
$project->setFromArray(array('projects_name' => 'InsertProjectOk', 'projects_start_date' => '1984-12-03 00:00:00'));
$project->save();
$project2 = $table_project->fetchNew();
$project2->setFromArray(array('projects_name' => 'Project2', 'projects_start_date' => '1984-12-03 00:00:00'));
$project2->save();
$group_table = new USVN_Db_Table_Groups();
$group_table->insert(array("groups_id" => 2, "groups_name" => "toto"));
$group = $group_table->find(2)->current();
$group_table = new USVN_Db_Table_Groups();
$group_table->insert(array("groups_id" => 3, "groups_name" => "titi"));
$group = $group_table->find(3)->current();
$project->addGroup($group);
$this->assertEquals(count($table_project->fetchAllAssignedTo($user)), 0);
$group->addUser($user);
$group->addUser($user2);
$this->assertEquals(count($table_project->fetchAllAssignedTo($user)), 1);
}
/**
* Generate and save a project
*
* @param string $name
* @return USVN_Db_Table_Row_Project
*/
protected function createProject($name)
{
$table = new USVN_Db_Table_Projects();
try {
$obj = $table->fetchNew();
$obj->setFromArray(array('projects_name' => $name));
$obj->save();
return $obj;
} catch (Exception $e) {
$this->fail($name . " : " . $e->getMessage());
}
}
