public function testQueryTwoScanners()
{
$this->testDb->getDbManager()->queryOnce('CREATE TABLE monk_ars AS SELECT * FROM nomos_ars WHERE 0=1');
$this->testDb->insertData(array('monk_ars'));
$uploadId = 2;
$agentNames = array('nomos', 'monk');
$latestScannerProxy = new LatestScannerProxy($uploadId, $agentNames, 'latest_scanner', "AND agent_enabled='true'");
$sql = $latestScannerProxy->getDbViewQuery();
$scanners = $this->getAllColumns($sql);
assertThat($scanners, arrayContainingInAnyOrder(array(array('agent_pk' => 6, 'agent_name' => 'nomos'), array('agent_pk' => 5, 'agent_name' => 'monk'))));
}
public function testAddGroupMembership()
{
$this->testDb->createPlainTables(array('users', 'groups', 'group_user_member'));
$this->testDb->insertData(array('users', 'groups', 'group_user_member'));
$this->userDao->addGroupMembership($groupId = 2, $userId = 1);
$map = $this->userDao->getUserGroupMap($userId);
assertThat($map, hasKey($groupId));
}
