public function indexAction()
{
$this->view->status = 'ok';
// get the csrf token
$session = new Zend_Session_Namespace('csrf');
$csrf = $session->hash;
// get the forms to display
$options = array('defaultForm' => Null, 'polling' => Daiquiri_Config::getInstance()->query->polling->toArray(), 'forms' => array(), 'csrf' => $csrf);
foreach (Daiquiri_Config::getInstance()->query->forms as $key => $form) {
if ($form->default) {
$options['defaultForm'] = $key;
}
$options['forms'][] = array('key' => $key, 'title' => $form->title);
}
$this->view->options = $options;
// get options for the query plan
$queryModel = new Query_Model_Query();
$this->view->plan = array('enabled' => $queryModel->canShowPlan(), 'editable' => $queryModel->canAlterPlan(), 'mail' => Daiquiri_Config::getInstance()->query->processor->mail->enabled);
// get the different download options
$this->view->downloadAdapter = Daiquiri_Config::getInstance()->getQueryDownloadAdapter();
// check if imageviewer is enabled
if (Daiquiri_Config::getInstance()->query->images->enabled) {
$this->view->images = true;
} else {
$this->view->images = false;
}
// check if the table cols/rows should be selectable
if (Daiquiri_Config::getInstance()->query->results->select) {
$this->view->select = true;
} else {
$this->view->select = false;
}
// check if samp is enabled
if (Daiquiri_Config::getInstance()->query->samp->enabled && Daiquiri_Auth::getInstance()->getCurrentUsername() !== 'guest') {
$this->view->samp = true;
} else {
$this->view->samp = false;
}
// check if plot is enabled
if (Daiquiri_Config::getInstance()->query->plot->enabled) {
$this->view->plot = true;
} else {
$this->view->plot = false;
}
}
/**
* Submits a new query query plan to the database.
* @param string $mail
* @param array $formParams
* @return array $response
*/
public function plan($mail = null, array $formParams = array())
{
// get query, tablename and queue from session
$ns = new Zend_Session_Namespace('query_plan');
// get query model
$model = new Query_Model_Query();
// format plan
if (empty($ns->plan)) {
$outString = "No query plan returned...";
} else {
$outString = "";
foreach ($ns->plan as $line) {
$outString .= $line . "\n";
}
}
// get the form for the plan
$form = new Query_Form_Plan(array('query' => $outString, 'editable' => $model->canAlterPlan(), 'mail' => Daiquiri_Config::getInstance()->query->processor->mail->enabled));
// init errors array
$errors = array();
// validate form
if (!empty($formParams)) {
if ($form->isValid($formParams)) {
// get values
$values = $form->getValues();
if ($model->canAlterPlan()) {
// get new plan from form
$plan = $values['plan_query'];
// validate query plus plan
if ($model->validate($ns->sql, $plan, $ns->tablename, $errors) !== true) {
if (!empty($errors)) {
return $this->getModelHelper('CRUD')->validationErrorResponse($form, $errors);
}
}
} else {
$plan = false;
}
if (empty($mail)) {
// submit query
$response = $model->query($ns->sql, $plan, $ns->tablename, array("queue" => $ns->queue));
if ($response['status'] === 'ok') {
return $response;
} else {
return $this->getModelHelper('CRUD')->validationErrorResponse($form, $response['errors']);
}
} else {
// store plan in session
if ($plan !== false) {
$ns->planString = $plan;
} else {
$ns->planString = implode('\\n', $ns->plan);
}
// redirect to mail controller action and return
$baseurl = Daiquiri_Config::getInstance()->getSiteUrl();
return array('status' => 'redirect', 'redirect' => $baseurl . '/query/form/mail');
}
} else {
return $this->getModelHelper('CRUD')->validationErrorResponse($form, $errors);
}
}
return array('form' => $form, 'status' => 'form', 'query' => $outString);
}
public function runJob(Uws_Model_Resource_JobSummaryType &$job)
{
// obtain queue information
$resource = Query_Model_Resource_AbstractQuery::factory();
$queues = array();
if ($resource::$hasQueues === true && isset($job->parameters['queue'])) {
$queues = $resource->fetchQueues();
// find the queue
foreach ($queues as $queue) {
if ($queue['name'] === $job->parameters['queue']->value) {
$job->executionDuration = $queue['timeout'];
break;
}
}
} else {
if ($resource::$hasQueues === true) {
// no queue has been specified, but we support queues - if executionDuration is 0, use default queue
// otherwise find the desired queue
$queues = $resource->fetchQueues();
if ($job->executionDuration === 0) {
// use default queue here
$queue = Daiquiri_Config::getInstance()->query->query->qqueue->defaultQueue;
foreach ($queues as $currQueue) {
if ($currQueue['name'] === $queue) {
$job->executionDuration = $currQueue['timeout'];
$job->addParameter("queue", $currQueue['name']);
break;
}
}
} else {
// find a queue that matches the request (i.e. is nearest to the request)
$maxQueueTimeout = 0;
$maxQueue = false;
$deltaQueue = 9.999999999999999E+33;
$queue = false;
foreach ($queues as $currQueue) {
if ($currQueue['timeout'] > $maxQueue) {
$maxQueueTimeout = $currQueue['timeout'];
$maxQueue = $currQueue;
}
if ($currQueue['timeout'] >= $job->executionDuration) {
$currDelta = $currQueue['timeout'] - $job->executionDuration;
if ($currDelta < $deltaQueue) {
$queue = $currQueue;
$deltaQueue = $currDelta;
}
}
}
if ($queue === false) {
$queue = $maxQueue;
}
$job->addParameter("queue", $currQueue['name']);
$job->executionDuration = $currQueue['timeout'];
}
}
}
// now check if everything is there that we need...
$tablename = null;
$sql = null;
$queue = null;
$errors = array();
if (!isset($job->parameters['query']) || $resource::$hasQueues === true && !isset($job->parameters['queue'])) {
// throw error
$job->addError("Incomplete job");
$resource = new Uws_Model_Resource_UWSJobs();
$resource->updateRow($job->jobId, array("phase" => "ERROR", "errorSummary" => Zend_Json::encode($job->errorSummary)));
return;
}
if (isset($job->parameters['table'])) {
$tablename = $job->parameters['table']->value;
}
$sql = $job->parameters['query']->value;
if ($resource::$hasQueues === true) {
$queue = $job->parameters['queue']->value;
}
// submit job
// validate query
$job->resetErrors();
$model = new Query_Model_Query();
try {
if ($model->validate($sql, false, $tablename, $errors) !== true) {
//throw error
foreach ($errors as $error) {
$job->addError($error);
}
$resource = new Uws_Model_Resource_UWSJobs();
$resource->updateRow($job->jobId, array("phase" => "ERROR", "errorSummary" => Zend_Json::encode($job->errorSummary)));
return;
}
} catch (Exception $e) {
// throw error
$job->addError($e->getMessage());
$resource = new Uws_Model_Resource_UWSJobs();
$resource->updateRow($job->jobId, array("phase" => "ERROR", "errorSummary" => Zend_Json::encode($job->errorSummary)));
return;
}
// submit query
if ($resource::$hasQueues === true) {
$response = $model->query($sql, false, $tablename, array("queue" => $queue, "jobId" => $job->jobId));
} else {
$response = $model->query($sql, false, $tablename, array("jobId" => $job->jobId));
}
if ($response['status'] !== 'ok') {
// throw error
foreach ($response['errors'] as $error) {
$job->addError($error);
}
$resource = new Uws_Model_Resource_UWSJobs();
$resource->updateRow($job->jobId, array("phase" => "ERROR", "errorSummary" => Zend_Json::encode($job->errorSummary)));
return;
}
// clean up stuff (basically just remove the job in the temorary UWS job store - if we are here
// everything has been handeled by the queue)
$resource = new Uws_Model_Resource_UWSJobs();
$resource->deleteRow($job->jobId);
}
