/**
* Calculated data matching ratios for all links in a relationship specified by rel_id. The computation is done in a background.
* While computing the ratios distinct values from stories involved in the relationship might be cached in MSSQL server. The caching happens only if two stories are form
* different locations (e.g. different DBMS and server).
*
* @param [type] $rel_ids colfusion relationship id for which to calculate links data matching rations.
* @return [type] [description]
*/
public function calculateDataMatchingRatios($rel_ids)
{
//var_dump($rel_ids);
if (!isset($rel_ids) || count($rel_ids) == 0) {
return;
}
$relationshipDAO = new RelationshipDAO();
foreach ($rel_ids as $key => $rel_id) {
$rel = $relationshipDAO->getRelationship($rel_id);
//this might too expensive, I don't need all infor about relationships, just sids, tablemes and links
foreach ($rel->links as $key => $link) {
$from = new DataMatcherLinkOnePart();
$from->sid = $rel->fromDataset->sid;
$from->tableName = $rel->fromTableName;
$from->transformation = $link->fromPartEncoded;
$to = new DataMatcherLinkOnePart();
$to->sid = $rel->toDataset->sid;
$to->tableName = $rel->toTableName;
$to->transformation = $link->toPartEncoded;
//var_dump($from, $to);
ExecutionManager::callChildProcessToCacheDistinctColumnValues($from, $to);
}
}
}
function testRelDAO()
{
$datasetFinder = new DatasetFinder();
//var_dump($datasetFinder->findDatasetInfoBySid(1495));
//var_dump($datasetFinder->findDatasetInfoBySid(1487));
$relDAO = new RelationshipDAO();
var_dump($relDAO->getRelationship(752));
//var_dump($relDAO->getComments(1454));
//var_dump($relDAO->getComment(1462, 20));
//var_dump($relDAO->updateComment(1462, 20, 0.7, 'Test update'));
}
/**
* Add neo4j relationship and nodes if needed by colfusion relationship id.
* @param [type] $rel_id colfusion relationships id.
*/
public function addRelationshipByRelId($rel_id)
{
$relationshipDao = new RelationshipDAO();
$relationship = $relationshipDao->getRelationship($rel_id);
//var_dump($relationship);
$confidence = $relationshipDao->getRelationshipAverageConfidenceByRelId($rel_id);
$this->addRelationship($relationship->fromDataset->sid, $relationship->toDataset->sid, $rel_id, 1 - $confidence);
}
<?php
require_once realpath(dirname(__FILE__)) . '/../config.php';
require_once realpath(dirname(__FILE__)) . '/../DAL/RelationshipDAO.php';
$relId = $_POST['relId'];
$simThreshold = $_POST['simThreshold'];
$userName = $current_user->user_login;
$relationshipDAO = new RelationshipDAO();
try {
$relationship = $relationshipDAO->getRelationship($relId, $simThreshold);
$relationship->isOwned = $relationship->creator == $userName;
$relationship->simThreshold = $simThreshold;
echo json_encode($relationship);
} catch (Exception $e) {
die($e->getMessage());
}
