private function setUpTables()
{
$this->testDb->createPlainTables(array(), true);
$this->testDb->createInheritedTables();
$this->dbManager->queryOnce("CREATE TABLE copyright_ars () INHERITS (ars_master)");
$this->testDb->createSequences(array('agent_agent_pk_seq', 'pfile_pfile_pk_seq', 'upload_upload_pk_seq', 'nomos_ars_ars_pk_seq', 'license_file_fl_pk_seq', 'license_ref_rf_pk_seq', 'license_ref_bulk_lrb_pk_seq', 'clearing_decision_clearing_decision_pk_seq', 'clearing_event_clearing_event_pk_seq'));
$this->testDb->createConstraints(array('agent_pkey', 'pfile_pkey', 'upload_pkey_idx', 'FileLicense_pkey', 'clearing_event_pkey'));
$this->testDb->alterTables(array('agent', 'pfile', 'upload', 'ars_master', 'license_ref_bulk', 'license_set_bulk', 'clearing_event', 'clearing_decision', 'license_file', 'highlight'));
$this->testDb->insertData(array('mimetype_ars', 'pkgagent_ars', 'ununpack_ars', 'decider_ars'), true, __DIR__ . '/fo_report.sql');
$this->testDb->resetSequenceAsMaxOf('agent_agent_pk_seq', 'agent', 'agent_pk');
}
protected function setUp()
{
$this->testDb = new TestPgDb("fossclitest");
$tables = array('users', 'upload', 'uploadtree_a', 'uploadtree', 'copyright', 'groups', 'group_user_member', 'agent', 'copyright_decision', 'copyright_ars', 'ars_master');
$this->testDb->createPlainTables($tables);
$this->testDb->createInheritedTables(array('uploadtree_a'));
$this->testDb->createInheritedArsTables(array('copyright'));
$this->testDb->insertData($tables);
$sysConf = $this->testDb->getFossSysConf();
$this->fo_copyright_list_path = dirname(__DIR__) . '/fo_copyright_list -c ' . $sysConf;
$this->testInstaller = new TestInstaller($sysConf);
$this->testInstaller->init();
}
private function setUpClearingTables()
{
$this->testDb->createPlainTables(array('copyright', 'copyright_audit', 'uploadtree', 'copyright_decision'));
$this->testDb->createInheritedTables(array('uploadtree_a'));
$this->testDb->insertData(array('copyright', 'uploadtree_a'));
$this->testDb->createSequences(array('copyright_ct_pk_seq', 'copyright_decision_pk_seq'));
$this->testDb->alterTables(array('copyright', 'copyright_decision'));
}
public function testGetUploadHashes()
{
$this->testDb->createPlainTables(array('pfile'));
$this->dbManager->queryOnce('TRUNCATE upload');
$this->testDb->insertData(array('upload', 'pfile'));
// (pfile_pk, pfile_md5, pfile_sha1, pfile_size) := (9, 'F703E0197FB6C5BD0C8DFDCC115A0231', '5DAFC9C82988A81413B995210B668CF5CF5975FF', 16845)
$hashes = $this->uploadDao->getUploadHashes(2);
assertThat($hashes, equalTo(array('md5' => 'F703E0197FB6C5BD0C8DFDCC115A0231', 'sha1' => '5DAFC9C82988A81413B995210B668CF5CF5975FF')));
}
private function setUpTables()
{
$this->testDb->createPlainTables(array('agent', 'uploadtree', 'upload', 'pfile', 'users', 'bucketpool', 'mimetype', 'ars_master'));
$this->testDb->createSequences(array('agent_agent_pk_seq', 'upload_upload_pk_seq', 'pfile_pfile_pk_seq', 'users_user_pk_seq', 'nomos_ars_ars_pk_seq'));
$this->testDb->createConstraints(array('agent_pkey', 'upload_pkey_idx', 'pfile_pkey', 'user_pkey'));
$this->testDb->alterTables(array('agent', 'pfile', 'upload', 'ars_master', 'users'));
$this->testDb->createInheritedTables(array('uploadtree_a'));
$this->testDb->insertData(array('upload', 'pfile', 'uploadtree_a', 'bucketpool', 'mimetype', 'users'), false);
}
public function testGetUploadHashes()
{
$this->testDb->createPlainTables(array('pfile'));
$this->dbManager->queryOnce('ALTER TABLE uploadtree RENAME TO uploadtree_a');
$this->testDb->insertData(array('uploadtree_a', 'pfile'));
// (pfile_pk, pfile_md5, pfile_sha1, pfile_size) := (4, '59CACDFCE5051CD8A1D8A1F2DCCE40A5', '04621571BCBABCE75C4DD1C6445B87DEC0995734', 12320);
$hashes = $this->treeDao->getItemHashes(7, 'uploadtree_a');
assertThat($hashes, equalTo(array('md5' => '59CACDFCE5051CD8A1D8A1F2DCCE40A5', 'sha1' => '04621571BCBABCE75C4DD1C6445B87DEC0995734')));
}
private function setUpTables()
{
$this->testDb->createPlainTables(array('upload', 'uploadtree', 'uploadtree_a', 'license_ref', 'license_ref_bulk', 'license_set_bulk', 'clearing_event', 'clearing_decision', 'clearing_decision_event', 'license_file', 'highlight', 'highlight_bulk', 'agent', 'pfile', 'ars_master', 'users'), false);
$this->testDb->createSequences(array('agent_agent_pk_seq', 'pfile_pfile_pk_seq', 'upload_upload_pk_seq', 'nomos_ars_ars_pk_seq', 'license_file_fl_pk_seq', 'license_ref_rf_pk_seq', 'license_ref_bulk_lrb_pk_seq', 'clearing_event_clearing_event_pk_seq', 'clearing_decision_clearing_decision_pk_seq'), false);
$this->testDb->createViews(array('license_file_ref'), false);
$this->testDb->createConstraints(array('agent_pkey', 'pfile_pkey', 'upload_pkey_idx', 'FileLicense_pkey', 'clearing_event_pkey', 'clearing_decision_pkey'), false);
$this->testDb->alterTables(array('agent', 'pfile', 'upload', 'ars_master', 'license_ref_bulk', 'license_set_bulk', 'clearing_event', 'license_file', 'highlight', 'clearing_decision'), false);
$this->testDb->createInheritedTables();
$this->testDb->insertData(array('pfile', 'upload', 'uploadtree_a', 'users'), false);
$this->testDb->insertData_license_ref();
}
public function testAccessibilityViaPublicForQualifiedUser()
{
$this->testDb->createPlainTables(array('perm_upload', 'groups'));
$this->testDb->insertData(array('groups'));
$_SESSION[Auth::USER_LEVEL] = Auth::PERM_READ;
$accessibilityByNone = $this->uploadPermissionDao->isAccessible($uploadId = 2, $groupId = 2);
assertThat($accessibilityByNone, equalTo(false));
$this->uploadPermissionDao->setPublicPermission($uploadId, Auth::PERM_READ);
$accessibilityByPublic = $this->uploadPermissionDao->isAccessible($uploadId, $groupId);
assertThat($accessibilityByPublic, equalTo(true));
}
private function setUpTables()
{
$this->testDb->createPlainTables(array('upload', 'uploadtree', 'license_ref', 'license_file', 'highlight', 'agent', 'pfile', 'ars_master'), false);
$this->testDb->createSequences(array('agent_agent_pk_seq', 'pfile_pfile_pk_seq', 'upload_upload_pk_seq', 'nomos_ars_ars_pk_seq', 'license_file_fl_pk_seq', 'license_ref_rf_pk_seq'), false);
$this->testDb->createViews(array('license_file_ref'), false);
$this->testDb->createConstraints(array('agent_pkey', 'pfile_pkey', 'upload_pkey_idx', 'FileLicense_pkey', 'rf_pkpk'), false);
$this->testDb->alterTables(array('agent', 'pfile', 'upload', 'ars_master', 'license_file', 'highlight', 'license_ref'), false);
$this->testDb->createInheritedTables();
$this->testDb->insertData(array('pfile', 'upload', 'uploadtree_a'), false);
$this->testDb->insertData_license_ref();
$this->testDb->resetSequenceAsMaxOf('license_ref_rf_pk_seq', 'license_ref', 'rf_pk');
}
private function setUpTables()
{
$this->testDb->createPlainTables(array('upload', 'upload_reuse', 'uploadtree', 'uploadtree_a', 'license_ref', 'license_ref_bulk', 'license_set_bulk', 'clearing_decision', 'clearing_decision_event', 'clearing_event', 'license_file', 'highlight', 'highlight_keyword', 'agent', 'pfile', 'ars_master', 'users', 'group_user_member', 'license_map', 'jobqueue', 'job'), false);
$this->testDb->createSequences(array('agent_agent_pk_seq', 'pfile_pfile_pk_seq', 'upload_upload_pk_seq', 'nomos_ars_ars_pk_seq', 'license_file_fl_pk_seq', 'license_ref_rf_pk_seq', 'license_ref_bulk_lrb_pk_seq', 'clearing_decision_clearing_decision_pk_seq', 'clearing_event_clearing_event_pk_seq', 'FileLicense_pkey', 'jobqueue_jq_pk_seq'), false);
$this->testDb->createViews(array('license_file_ref'), false);
$this->testDb->createConstraints(array('agent_pkey', 'pfile_pkey', 'upload_pkey_idx', 'clearing_event_pkey', 'jobqueue_pkey'), false);
$this->testDb->alterTables(array('agent', 'pfile', 'upload', 'ars_master', 'license_ref_bulk', 'license_set_bulk', 'clearing_event', 'clearing_decision', 'license_file', 'highlight', 'jobqueue'), false);
$this->testDb->createInheritedTables();
$this->testDb->createInheritedArsTables(array('nomos', 'monk', 'copyright'));
$this->testDb->insertData(array('pfile', 'upload', 'uploadtree_a', 'users', 'group_user_member', 'agent', 'license_file', 'nomos_ars', 'monk_ars', 'copyright_ars'), false);
$this->testDb->insertData_license_ref(80);
$this->testDb->resetSequenceAsMaxOf('agent_agent_pk_seq', 'agent', 'agent_pk');
}
public function testHasTopLevelFolder_yes()
{
$this->testDb->insertData(array('folder'));
$htlf = $this->folderDao->hasTopLevelFolder();
assertThat($htlf, is(TRUE));
}
