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;
}
public function testFindBySid()
{
$finder = new DatasetFinder();
$sid = 752;
$dataset = $finder->findDatasetInfoBySid($sid);
$this->assertEquals($sid, $dataset->sid);
$this->assertEquals('dataverse', $dataset->userName);
$this->assertEquals('State list', $dataset->title);
}
