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