public function testGetLicenseIdPerPfileForAgentId()
{
$this->testDb->createPlainTables(array('license_ref', 'license_file', 'uploadtree', 'agent'));
$this->testDb->insertData(array('agent'));
$this->testDb->createViews(array('license_file_ref'));
$this->testDb->insertData_license_ref($limit = 3);
$licAll = $this->dbManager->createMap('license_ref', 'rf_pk', 'rf_shortname');
$rf_pk_all = array_keys($licAll);
$rf_pk = $rf_pk_all[0];
$uploadtreetable_name = 'uploadtree';
$this->dbManager->insertInto('license_file', 'fl_pk, rf_fk, agent_fk, rf_match_pct, rf_timestamp, pfile_fk, server_fk', array(1, $rf_pk, $agentId = 5, $matchPercent = 50, $mydate = "'2014-06-04 14:01:30.551093+02'", $pfileId = 42, 1));
$uploadtreeId = 512;
$uploadId = 123;
$left = 2009;
$containerMode = 1 << 29;
$nonArtifactChildId = $uploadtreeId + 2;
$this->dbManager->insertTableRow('uploadtree', array('uploadtree_pk' => $uploadtreeId, 'upload_fk' => $uploadId, 'pfile_fk' => 0, 'lft' => $left, 'rgt' => $left + 5, 'parent' => NULL, 'ufile_mode' => $containerMode));
$this->dbManager->insertTableRow('uploadtree', array('uploadtree_pk' => $uploadtreeId + 1, 'upload_fk' => $uploadId, 'pfile_fk' => 0, 'lft' => $left + 1, 'rgt' => $left + 4, 'parent' => $uploadtreeId, 'ufile_mode' => $containerMode));
$this->dbManager->insertTableRow('uploadtree', array('uploadtree_pk' => $uploadtreeId + 2, 'upload_fk' => $uploadId, 'pfile_fk' => $pfileId, 'lft' => $left + 2, 'rgt' => $left + 3, 'parent' => $uploadtreeId + 1, 'ufile_mode' => 0));
$licDao = new LicenseDao($this->dbManager);
$itemTreeBounds = new ItemTreeBounds($uploadtreeId, $uploadtreetable_name, $uploadId, $left, $left + 5);
$row = array('pfile_id' => $pfileId, 'license_id' => $rf_pk, 'match_percentage' => $matchPercent, 'agent_id' => $agentId, 'uploadtree_pk' => $nonArtifactChildId);
$expected = array($pfileId => array($rf_pk => $row));
$itemRestriction = array($nonArtifactChildId, $nonArtifactChildId + 7);
$licensesForGoodAgent = $licDao->getLicenseIdPerPfileForAgentId($itemTreeBounds, $selectedAgentId = $agentId, $itemRestriction);
assertThat($licensesForGoodAgent, is(equalTo($expected)));
$licensesForBadAgent = $licDao->getLicenseIdPerPfileForAgentId($itemTreeBounds, $selectedAgentId = 1 + $agentId, $itemRestriction);
assertThat($licensesForBadAgent, is(equalTo(array())));
$licensesOutside = $licDao->getLicenseIdPerPfileForAgentId($itemTreeBounds, $selectedAgentId = $agentId, array());
assertThat($licensesOutside, is(equalTo(array())));
$this->addToAssertionCount(\Hamcrest\MatcherAssert::getCount() - $this->assertCountBefore);
}
public function testInsertData()
{
$testDb = new TestLiteDb();
$testDb->createPlainTables(array('perm_upload'));
$testDb->insertData(array('perm_upload'));
$tag1 = $testDb->getDbManager()->getSingleRow('select perm from perm_upload where perm_upload_pk=1');
assertThat($tag1, hasKey('perm'));
assertThat($tag1['perm'], is(10));
}
public function testGetLicensesPerFileNameForAgentId()
{
$this->testDb->createPlainTables(array('license_ref', 'license_file', 'uploadtree', 'agent'));
$this->testDb->insertData(array('agent'));
$this->testDb->createViews(array('license_file_ref'));
$this->testDb->insertData_license_ref($limit = 3);
$licAll = $this->dbManager->createMap('license_ref', 'rf_pk', 'rf_shortname');
$rf_pk_all = array_keys($licAll);
$uploadtreetable_name = 'uploadtree';
// uploadtree_pk | parent | realparent | upload_fk | pfile_fk | ufile_mode | lft | rgt | ufile_name
// ---------------+--------+------------+-----------+----------+------------+-----+-----+------------------
// 80895 | | | 16 | 70585 | 536904704 | 1 | 36 | project.tar.gz
// 80896 | 80895 | 80895 | 16 | 0 | 805323776 | 2 | 35 | artifact.dir
// 80897 | 80896 | 80895 | 16 | 70586 | 536903680 | 3 | 34 | project.tar
// 80898 | 80897 | 80897 | 16 | 0 | 805323776 | 4 | 33 | artifact.dir
// 80899 | 80898 | 80897 | 16 | 0 | 536888320 | 5 | 32 | project
// 80900 | 80899 | 80899 | 16 | 0 | 536888320 | 6 | 7 | folderA
// 80905 | 80899 | 80899 | 16 | 0 | 536888320 | 8 | 23 | folderB
// 80907 | 80905 | 80905 | 16 | 0 | 536888320 | 9 | 10 | subBfolderA
// 80908 | 80905 | 80905 | 16 | 0 | 536888320 | 11 | 20 | subBfolderB
// 80909 | 80908 | 80908 | 16 | 0 | 536888320 | 12 | 19 | subBBsubBfolderA
// 80912 | 80909 | 80909 | 16 | 70592 | 33152 | 13 | 14 | BBBfileA
// 80911 | 80909 | 80909 | 16 | 70591 | 33152 | 15 | 16 | BBBfileB
// 80910 | 80909 | 80909 | 16 | 70590 | 33152 | 17 | 18 | BBBfileC
// 80906 | 80905 | 80905 | 16 | 0 | 536888320 | 21 | 22 | subBfolderC
// 80901 | 80899 | 80899 | 16 | 0 | 536888320 | 24 | 31 | folderC
// 80903 | 80901 | 80901 | 16 | 70588 | 33152 | 25 | 26 | CfileA
// 80904 | 80901 | 80901 | 16 | 70589 | 33152 | 27 | 28 | CfileB
// 80902 | 80901 | 80901 | 16 | 70587 | 33152 | 29 | 30 | CfileC
$mainUploadtreeId = 80895;
$uploadtreeId = $mainUploadtreeId;
$uploadId = 16;
/* 80895 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'pfile_fk' => 70585, 'lft' => 1, 'rgt' => 36, 'ufile_mode' => 536904704, 'ufile_name' => 'project.tar.gz'));
/* 80896 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80895, 'realparent' => 80895, 'pfile_fk' => 0, 'lft' => 2, 'rgt' => 35, 'ufile_mode' => 805323776, 'ufile_name' => 'artifact.dir'));
/* 80897 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80896, 'realparent' => 80895, 'pfile_fk' => 70586, 'lft' => 3, 'rgt' => 34, 'ufile_mode' => 536903680, 'ufile_name' => 'project.tar'));
/* 80898 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80897, 'realparent' => 80897, 'pfile_fk' => 0, 'lft' => 4, 'rgt' => 33, 'ufile_mode' => 805323776, 'ufile_name' => 'artifact.dir'));
/* 80899 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80898, 'realparent' => 80897, 'pfile_fk' => 0, 'lft' => 5, 'rgt' => 32, 'ufile_mode' => 536888320, 'ufile_name' => 'project'));
/* 80900 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80899, 'realparent' => 80899, 'pfile_fk' => 0, 'lft' => 6, 'rgt' => 7, 'ufile_mode' => 536888320, 'ufile_name' => 'folderA'));
/* 80901 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80899, 'realparent' => 80899, 'pfile_fk' => 0, 'lft' => 24, 'rgt' => 31, 'ufile_mode' => 536888320, 'ufile_name' => 'folderC'));
/* 80902 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80901, 'realparent' => 80901, 'pfile_fk' => 70587, 'lft' => 29, 'rgt' => 30, 'ufile_mode' => 33152, 'ufile_name' => 'CfileC'));
/* 80903 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80901, 'realparent' => 80901, 'pfile_fk' => 70588, 'lft' => 25, 'rgt' => 26, 'ufile_mode' => 33152, 'ufile_name' => 'CfileA'));
/* 80904 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80901, 'realparent' => 80901, 'pfile_fk' => 70589, 'lft' => 27, 'rgt' => 28, 'ufile_mode' => 33152, 'ufile_name' => 'CfileB'));
/* 80905 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80899, 'realparent' => 80899, 'pfile_fk' => 0, 'lft' => 8, 'rgt' => 23, 'ufile_mode' => 536888320, 'ufile_name' => 'folderB'));
/* 80906 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80905, 'realparent' => 80905, 'pfile_fk' => 0, 'lft' => 21, 'rgt' => 22, 'ufile_mode' => 536888320, 'ufile_name' => 'subBfolderC'));
/* 80907 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80905, 'realparent' => 80905, 'pfile_fk' => 0, 'lft' => 9, 'rgt' => 10, 'ufile_mode' => 536888320, 'ufile_name' => 'subBfolderA'));
/* 80908 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80905, 'realparent' => 80905, 'pfile_fk' => 0, 'lft' => 11, 'rgt' => 20, 'ufile_mode' => 536888320, 'ufile_name' => 'subBfolderB'));
/* 80909 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80908, 'realparent' => 80908, 'pfile_fk' => 0, 'lft' => 12, 'rgt' => 19, 'ufile_mode' => 536888320, 'ufile_name' => 'subBBsubBfolderA'));
/* 80910 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80909, 'realparent' => 80909, 'pfile_fk' => 70590, 'lft' => 17, 'rgt' => 18, 'ufile_mode' => 33152, 'ufile_name' => 'BBBfileC'));
/* 80911 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80909, 'realparent' => 80909, 'pfile_fk' => 70591, 'lft' => 15, 'rgt' => 16, 'ufile_mode' => 33152, 'ufile_name' => 'BBBfileB'));
/* 80912 */
$this->dbManager->insertTableRow($uploadtreetable_name, array('uploadtree_pk' => $uploadtreeId++, 'upload_fk' => $uploadId, 'parent' => 80909, 'realparent' => 80909, 'pfile_fk' => 70592, 'lft' => 13, 'rgt' => 14, 'ufile_mode' => 33152, 'ufile_name' => 'BBBfileA'));
$agentId = 5;
// fl_pk | rf_fk | agent_fk | rf_match_pct | rf_timestamp | pfile_fk | server_fk | fl_ref_start_byte | fl_ref_end_byte | fl_start_byte | fl_end_byte
// --------+---------------+--------------+--------------+-------------------------------+----------+-----------+-------------------+-----------------+---------------+-------------
// 1 | $rf_pk_all[0] | $agentId | | 2016-02-08 16:08:59.333096+00 | 70592 | 1 | | | |
// 2 | $rf_pk_all[1] | $agentId + 1 | | 2016-02-08 16:08:59.333096+00 | 70591 | 1 | | | |
// 3 | $rf_pk_all[0] | $agentId | | 2016-02-08 16:08:59.333096+00 | 70590 | 1 | | | |
// 4 | $rf_pk_all[1] | $agentId | | 2016-02-08 16:08:59.333096+00 | 70590 | 1 | | | |
$someDate = "'2016-02-08 16:08:59.333096+00'";
/* 1 */
$this->dbManager->insertInto('license_file', 'fl_pk, rf_fk, agent_fk, rf_timestamp, pfile_fk, server_fk', array(1, $rf_pk_all[0], $agentId, $someDate, 70592, 1));
/* 2 */
$this->dbManager->insertInto('license_file', 'fl_pk, rf_fk, agent_fk, rf_timestamp, pfile_fk, server_fk', array(2, $rf_pk_all[1], $agentId + 1, $someDate, 70591, 1));
/* 3 */
$this->dbManager->insertInto('license_file', 'fl_pk, rf_fk, agent_fk, rf_timestamp, pfile_fk, server_fk', array(3, $rf_pk_all[0], $agentId, $someDate, 70590, 1));
/* 4 */
$this->dbManager->insertInto('license_file', 'fl_pk, rf_fk, agent_fk, rf_timestamp, pfile_fk, server_fk', array(4, $rf_pk_all[1], $agentId, $someDate, 70590, 1));
$licDao = new LicenseDao($this->dbManager);
$itemTreeBounds = new ItemTreeBounds($mainUploadtreeId, $uploadtreetable_name, $uploadId, 1, 36);
//**************************************************************************
// Test with minimal input
$result = $licDao->getLicensesPerFileNameForAgentId($itemTreeBounds);
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileA";
$this->assertArrayHasKey($key, $result);
$expected = array($licAll[$rf_pk_all[0]]);
assertThat($result[$key], is(equalTo($expected)));
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileB";
$this->assertArrayHasKey($key, $result);
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileC";
$this->assertArrayHasKey($key, $result);
$this->assertContains($licAll[$rf_pk_all[0]], $result[$key]);
$this->assertContains($licAll[$rf_pk_all[1]], $result[$key]);
$key = "project.tar.gz";
$this->assertArrayHasKey($key, $result);
//**************************************************************************
// Test with empty agent list
$result = $licDao->getLicensesPerFileNameForAgentId($itemTreeBounds, array(), true, '', true);
$expected = array();
assertThat($result, is(equalTo($expected)));
//**************************************************************************
// Test with only one agent
$result = $licDao->getLicensesPerFileNameForAgentId($itemTreeBounds, array($agentId));
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileA";
$this->assertArrayHasKey($key, $result);
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileB";
$this->assertArrayNotHasKey($key, $result);
//**************************************************************************
// Test with excluding
$result = $licDao->getLicensesPerFileNameForAgentId($itemTreeBounds, array($agentId), true, "fileC");
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileA";
$this->assertArrayHasKey($key, $result);
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileB";
$this->assertArrayNotHasKey($key, $result);
$key = "project.tar.gz/project.tar/project/folderB/subBfolderB/subBBsubBfolderA/BBBfileC";
$this->assertArrayNotHasKey($key, $result);
//**************************************************************************
// Test with container
$result = $licDao->getLicensesPerFileNameForAgentId($itemTreeBounds, array($agentId));
$key = "project.tar.gz";
$this->assertArrayHasKey($key, $result);
$key = "project.tar.gz/project.tar";
$this->assertArrayHasKey($key, $result);
$this->addToAssertionCount(\Hamcrest\MatcherAssert::getCount() - $this->assertCountBefore);
}
