/**
* Export stats.
* @param $groupId
* @param $type
* @param $saveTo
* @return bool
* @throws \Exception
*/
public function export($groupId, $type, $saveTo)
{
if (!$this->actionParser->groupExists($groupId)) {
throw new \Exception('Group ID does not exist: ' . $groupId);
}
if ($type != 'csv') {
throw new \Exception('Unknown export type: ' . $type);
}
$actions = $this->actionParser->parseGroup($groupId);
$fullRows = $this->actionParser->getFullRows($actions);
$fullRows = $this->filterRows($fullRows);
$this->exportToCSV($fullRows, $saveTo);
$this->display->outputMessage('Export saved to: ' . $saveTo);
return true;
}
public function execute()
{
$this->prepare();
if ($this->dbManager->hasTriggers()) {
throw new \Exception('dbtrack is still running.');
} else {
if (!$this->dbManager->trackingTablesExist()) {
throw new \Exception('Tracking tables do not exist. Use <dbt start> to start.');
}
}
$actionParser = new ActionParser($this->dbms, $this->dbManager);
$this->helper = new Helper($this->dbms, $this->dbManager);
$options = $this->parseOptions($this->options);
if (!isset($options[0]) || empty($options[0])) {
throw new \Exception('No dbtrack group id specified. Use <dbt stats> to get one.');
}
if (!$actionParser->groupExists($options[0])) {
throw new \Exception('Group ID does not exist: ' . $options[0]);
}
$allGroups = $actionParser->getAllGroups($options[0]);
$revertedActions = 0;
$this->dbms->beginTransaction();
try {
foreach ($allGroups as $group) {
$actions = $actionParser->parseGroup($group->id);
$actions = array_reverse($actions);
$revertedActions += count($actions);
if ($this->helper->revert($actions)) {
$sql = "DELETE FROM dbtrack_data\n WHERE actionid IN (SELECT id FROM dbtrack_actions WHERE groupid = :groupid)";
$this->dbms->executeQuery($sql, array('groupid' => $group->id));
$sql = "DELETE FROM dbtrack_actions WHERE groupid = :groupid";
$this->dbms->executeQuery($sql, array('groupid' => $group->id));
}
}
$this->dbms->commitTransaction();
} catch (\Exception $e) {
$this->dbms->rollbackTransaction();
throw new \Exception($e->getMessage(), 0, $e);
}
$this->userInteraction->outputMessage($revertedActions . ' action(s) have been reverted.');
return true;
}