public function testReportsExport()
{
$pid = Helper::getSomeProject();
Helper::initProjectModel($pid);
// Create few MB csv
$csvFile = Helper::getTemp()->createTmpFile();
$fp = fopen($csvFile, 'w');
fwrite($fp, "id,name" . PHP_EOL);
for ($i = 1; $i < 200000; $i++) {
fwrite($fp, "{$i}," . uniqid() . PHP_EOL);
}
shell_exec("mv {$csvFile} " . Helper::getTemp()->getTmpFolder() . "/categories.csv");
fclose($fp);
$dirName = uniqid();
$webDav = new WebDav(KBGDC_USERNAME, KBGDC_PASSWORD);
$webDav->createFolder($dirName);
$webDav->upload(__DIR__ . '/../../data/products.csv', $dirName);
$webDav->upload(Helper::getTemp()->getTmpFolder() . "/categories.csv", $dirName);
$webDav->upload(__DIR__ . '/../../data/upload_info.json', $dirName);
Helper::getClient()->getDatasets()->loadData($pid, $dirName);
$uri = Helper::createReport($pid);
$report = Helper::getClient()->get($uri);
$reports = new Reports($this->client);
$resultUri = $reports->export($pid, $report['report']['content']['definitions'][0]);
$csvFile = Helper::getTemp()->getTmpFolder() . '/' . uniqid() . '.csv';
$this->client->getToFile($resultUri, $csvFile);
$this->assertTrue(file_exists($csvFile));
$this->assertGreaterThan(4800000, filesize($csvFile));
}
public function testProjectsClone()
{
// Get and clean first project
$pid1 = Helper::getSomeProject();
Helper::cleanUpProject($pid1);
$result = $this->client->get("/gdc/md/{$pid1}/data/sets");
$this->assertArrayHasKey('dataSetsInfo', $result);
$this->assertArrayHasKey('sets', $result['dataSetsInfo']);
$this->assertCount(0, $result['dataSetsInfo']['sets']);
// Build model in first project
Helper::initProjectModel($pid1);
$result = $this->client->get("/gdc/md/{$pid1}/data/sets");
$this->assertArrayHasKey('dataSetsInfo', $result);
$this->assertArrayHasKey('sets', $result['dataSetsInfo']);
$this->assertCount(4, $result['dataSetsInfo']['sets']);
// Create second project
$pid2 = Helper::createProject();
$result = $this->client->get("/gdc/md/{$pid2}/data/sets");
$this->assertArrayHasKey('dataSetsInfo', $result);
$this->assertArrayHasKey('sets', $result['dataSetsInfo']);
$this->assertCount(0, $result['dataSetsInfo']['sets']);
// Execute cloning
$projects = new Projects($this->client);
$projects->cloneProject($pid1, $pid2);
$result = $this->client->get("/gdc/md/{$pid2}/data/sets");
$this->assertArrayHasKey('dataSetsInfo', $result);
$this->assertArrayHasKey('sets', $result['dataSetsInfo']);
$this->assertCount(4, $result['dataSetsInfo']['sets']);
}
public function testDatasetsLoadData()
{
$pid = Helper::getSomeProject();
Helper::initProjectModel($pid);
Helper::loadData($pid);
$timestamp = time();
$dirName = uniqid();
$webDav = new WebDav(KBGDC_USERNAME, KBGDC_PASSWORD);
$webDav->createFolder($dirName);
$webDav->upload(__DIR__ . '/../../data/categories.csv', $dirName);
$webDav->upload(__DIR__ . '/../../data/products.csv', $dirName);
$webDav->upload(__DIR__ . '/../../data/upload_info.json', $dirName);
$this->client->getDatasets()->loadData($pid, $dirName);
$result = $this->client->get("/gdc/md/{$pid}/data/sets");
$categoriesFound = false;
$productsFound = false;
foreach ($result['dataSetsInfo']['sets'] as $d) {
if ($d['meta']['title'] == 'Categories') {
$categoriesFound = true;
$this->assertGreaterThan($timestamp, strtotime($d['lastUpload']['dataUploadShort']['date']));
}
if ($d['meta']['title'] == 'Products') {
$productsFound = true;
$this->assertGreaterThan($timestamp, strtotime($d['lastUpload']['dataUploadShort']['date']));
}
}
$this->assertTrue($categoriesFound);
$this->assertTrue($productsFound);
}
public function testFiltersGetForUser()
{
$pid = Helper::getSomeProject();
Helper::initProjectModel($pid);
Helper::loadData($pid);
$user = Helper::getSomeUser();
$filter1 = uniqid();
$filter2 = uniqid();
$attrIdentifier = Identifiers::getAttributeId("categories", "id");
$attrUri = $this->client->getDatasets()->getUriForIdentifier($pid, $attrIdentifier);
$attrValueUri = $this->client->getDatasets()->getAttributeValueUri($pid, $attrIdentifier, 'c1');
$uri1 = $this->client->getFilters()->create($pid, $filter1, $attrUri, '=', $attrValueUri);
$uri2 = $this->client->getFilters()->create($pid, $filter2, $attrUri, '=', $attrValueUri);
$this->client->getFilters()->assignToUser($pid, $user['uid'], [$uri1, $uri2]);
$filters = new Filters($this->client);
$this->assertEquals([$uri1, $uri2], $filters->getForUser($pid, $user['uid']), '', 0, 10, true);
}
