public function testFindBySidOrName_noDataset()
{
$finder = new DatasetFinder();
$searchTerm = '112 ';
$datasetsInfo = $finder->findDatasetInfoBySidOrName($searchTerm);
$this->assertEquals(0, count($datasetsInfo));
}
public function getRelationship($relId, $simThreshold)
{
$sql = "SELECT name, description, user_id, user_login, sid1, sid2, tableName1, tableName2, creation_time \n FROM `colfusion_relationships` CR INNER JOIN `colfusion_users` U ON CR.creator = U.user_id \n WHERE CR.rel_id = '" . mysql_real_escape_string($relId) . "'";
$relInfo = $this->ezSql->get_row($sql);
if ($relInfo == null) {
throw new Exception('Relationship Not Found');
}
$relationship = new Relationship();
$relationship->rid = $relId;
$relationship->name = $relInfo->name;
$relationship->description = $relInfo->description;
$relationship->creator = $relInfo->user_login;
$relationship->creatorId = $relInfo->user_id;
$relationship->createdTime = $relInfo->creation_time;
$datasetFinder = new DatasetFinder();
$fromDataset = $datasetFinder->findDatasetInfoBySid($relInfo->sid1, true);
$toDataset = $datasetFinder->findDatasetInfoBySid($relInfo->sid2, true);
$relationship->fromDataset = $fromDataset;
$relationship->toDataset = $toDataset;
$relationship->fromTableName = $relInfo->tableName1;
$relationship->toTableName = $relInfo->tableName2;
// $relationship->links[] = $this->GetLinksByRelId($relId);
$relationship->links = $this->GetLinksByRelId($relId, $simThreshold);
return $relationship;
}
<?php
require_once realpath(dirname(__FILE__)) . '/../config.php';
require_once realpath(dirname(__FILE__)) . '/../DAL/DatasetFinder.php';
require_once realpath(dirname(__FILE__)) . "/../DataImportWizard/ExecutionManager.php";
if (!$current_user->authenticated) {
die('Access Denied');
}
$userId = $current_user->user_id;
$datasetFinder = new DatasetFinder();
$datasetsInfo = $datasetFinder->findDatasetInfoByUserId($userId);
foreach ($datasetsInfo as $datasetInfo) {
$datasetInfo->description = $datasetInfo->description == null ? 'This dataset has no description' : $datasetInfo->description;
// $datasetInfo->status = getDatasetStatus($datasetInfo->sid);
}
echo json_encode($datasetsInfo);
function getDatasetStatus($sid)
{
return ExecutionManager::getExecutionStatus($sid);
}
<?php
require_once realpath(dirname(__FILE__)) . '/../DAL/DatasetFinder.php';
$searchTerm = $_GET['searchTerm'];
$datasetFinder = new DatasetFinder();
$datasetsInfo = $datasetFinder->findDatasetInfoBySidOrName($searchTerm);
foreach ($datasetsInfo as $datasetInfo) {
$datasetInfo->source_key = $datasetInfo->title . "#" . $datasetInfo->sid;
$datasetInfo->description = $datasetInfo->description == null ? 'This dataset has no description' : $datasetInfo->description;
}
echo json_encode($datasetsInfo);
