function getColumnChart($sid, $tableName, $columnName) { $datasetDAO = new DatasetDAO(); $cid = $datasetDAO->getCidBySidTableNameColumName($sid, $tableName, $columnName); $columnChartInput = new stdClass(); $inputObj = new stdClass(); $inputObj->sid = $sid; $inputObj->oneSid = true; $inputObj->tableName = $tableName; $inputObj->title = 'columnChart'; $columnChartInput->inputObj = $inputObj; $columnChartInput->table = $tableName; $columnObj = new stdClass(); $columnObj->cid = $cid; $columnChartInput->columnCat = $columnObj; $columnChartInput->columnAgg = $columnObj; $columnChartInput->columnAggType = "Count"; $columnChartInput->where = ""; $columnChart = new ColumnChart(null, null, null, null, null, null, null, null, null, null, null); $columnData = $columnChart->query($columnChartInput); $chartId = str_replace(".", "dot", "{$sid}{$tableName}{$columnName}"); $columnData["chartId"] = $chartId; $columnData["columnName"] = $columnName; return $columnData; }
<?php require_once realpath(dirname(__FILE__)) . '/../DAL/DatasetDAO.php'; $test = file_get_contents("/opt/local/apache2/htdocs/Colfusion/temp/1048/1048.xml"); $datasetDAO = new DatasetDAO(); $datasetDAO->saveProvenanceXML(1085, $test); var_dump($test); //SAVE TO DB! ?>