{$term}", $string); } /** * Default method to render the controller according to the action parameter. */ public function render() { if ('tree' == $this->action) { return $this->doTree(); } if ('refresh_locks' == $this->action) { return $this->currentLocks(true); } if ('refresh_processes' == $this->action) { return $this->currentProcesses(true); } $scripts = ''; // normal flow if ('locks' == $this->action || 'processes' == $this->action) { $scripts .= ''; $refreshTime = $this->conf['ajax_refresh'] * 1500; $scripts .= ''.PHP_EOL; } $header_template = 'header.twig'; $footer_template = 'footer.twig'; // @todo convert all these methods to return text instead of print text ob_start(); switch ($this->action) { case 'find': if (isset($_REQUEST['term'])) { $this->printFindForm(false); } else { $this->printFindForm(true); } break; case 'sql': $this->doSQL(); $header_template = 'header_sqledit.twig'; $footer_template = 'footer_sqledit.twig'; break; case 'variables': $this->doVariables(); break; case 'processes': $this->doProcesses(); break; case 'locks': $this->doLocks(); break; case 'export': $this->doExport(); break; case 'signal': $this->doSignal(); break; default: if (false === $this->adminActions($this->action, 'database')) { $header_template = 'header_sqledit.twig'; $footer_template = 'footer_sqledit.twig'; $this->doSQL(); } break; } $output = ob_get_clean(); $this->printHeader($this->headerTitle(), $scripts, true, $header_template); $this->printBody(); echo $output; $this->printFooter(true, $footer_template); } public function doTree($print = true) { $reqvars = $this->misc->getRequestVars('database'); $tabs = $this->misc->getNavTabs('database'); $items = $this->adjustTabsForTree($tabs); $attrs = [ 'text' => Decorator::field('title'), 'icon' => Decorator::field('icon'), 'action' => Decorator::actionurl( Decorator::field('url'), $reqvars, Decorator::field('urlvars'), [ 'database' => $this->misc->getDatabase(), ] ), 'branch' => Decorator::branchurl( Decorator::field('url'), $reqvars, Decorator::field('urlvars'), [ 'action' => 'tree', 'database' => $this->misc->getDatabase(), ] ), ]; return $this->printTree($items, $attrs, 'database', $print); } /** * Sends a signal to a process. */ public function doSignal() { $data = $this->misc->getDatabaseAccessor(); $status = $data->sendSignal($_REQUEST['pid'], $_REQUEST['signal']); if (0 == $status) { $this->doProcesses($this->lang['strsignalsent']); } else { $this->doProcesses($this->lang['strsignalsentbad']); } } /** * Searches for a named database object. * * @param mixed $confirm * @param mixed $msg */ public function printFindForm($confirm = true, $msg = '') { $data = $this->misc->getDatabaseAccessor(); $this->coalesceArr($_REQUEST, 'term', ''); $this->coalesceArr($_REQUEST, 'filter', ''); $this->printTrail('database'); $this->printTabs('database', 'find'); $this->printMsg($msg); echo '

'.PHP_EOL; echo '

_maxNameLen}\" />".PHP_EOL; // Output list of filters. This is complex due to all the 'has' and 'conf' feature possibilities echo ''.PHP_EOL; echo "lang['strfind']}\" />".PHP_EOL; echo $this->misc->form; echo '

'.PHP_EOL; echo '

'.PHP_EOL; // Default focus $this->setFocus('forms[0].term'); // If a search term has been specified, then perform the search // and display the results, grouped by object type if (!$confirm && '' != $_REQUEST['term']) { return $this->doFind(); } } private function _printTypeOption($curr) { $filter = $_REQUEST['filter']; $optionhtml = sprintf('%s'.PHP_EOL; return $optionhtml; } private function _translatedType($curr) { $types = [ 'COLUMN' => $this->lang['strcolumns'], 'CONSTRAINT' => $this->lang['strconstraints'], 'COLUMNTABLE' => $this->lang['strcolumns'], 'COLUMNVIEW' => $this->lang['strcolumns'], 'CONSTRAINTDOMAIN' => $this->lang['strconstraints'], 'CONSTRAINTTABLE' => $this->lang['strconstraints'], 'DOMAIN' => $this->lang['strdomains'], 'FUNCTION' => $this->lang['strfunctions'], 'INDEX' => $this->lang['strindexes'], 'RULE' => $this->lang['strrules'], 'RULETABLE' => $this->lang['strrules'], 'RULEVIEW' => $this->lang['strrules'], 'SCHEMA' => $this->lang['strschemas'], 'SEQUENCE' => $this->lang['strsequences'], 'TABLE' => $this->lang['strtables'], 'TRIGGER' => $this->lang['strtriggers'], 'VIEW' => $this->lang['strviews'], 'AGGREGATE' => $this->lang['straggregates'], 'CONVERSION' => $this->lang['strconversions'], 'LANGUAGE' => $this->lang['strlanguages'], 'OPCLASS' => $this->lang['stropclasses'], 'OPERATOR' => $this->lang['stroperators'], 'TYPE' => $this->lang['strtypes'], ]; if (array_key_exists($curr, $types)) { return $types[$curr]; } return $this->lang['strallobjects']; } private function _printHtmlForType($curr, $rs) { $destination = null; switch ($curr) { case 'SCHEMA': $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo '

misc->printVal($rs->fields['name']), '">'; echo $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']); echo '

'.PHP_EOL; break; case 'TABLE': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; $destination = $this->container->utils->getDestinationWithLastTab('table'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '&table=', urlencode($rs->fields['name']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'VIEW': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; $destination = $this->container->utils->getDestinationWithLastTab('view'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '&view=', urlencode($rs->fields['name']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'SEQUENCE': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&sequence=', urlencode($rs->fields['name']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'COLUMNTABLE': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&table=", urlencode($rs->fields['relname']), '&schema=', urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['relname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&table=', urlencode($rs->fields['relname']), '&column=', urlencode($rs->fields['name']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'COLUMNVIEW': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&view=", urlencode($rs->fields['relname']), '&schema=', urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['relname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&view=', urlencode($rs->fields['relname']), '&column=', urlencode($rs->fields['name']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'INDEX': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; $destination = $this->container->utils->getDestinationWithLastTab('table'); echo 'misc->href}&table=", urlencode($rs->fields['relname']), '&schema=', urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['relname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&table=', urlencode($rs->fields['relname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'CONSTRAINTTABLE': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; $destination = $this->container->utils->getDestinationWithLastTab('table'); echo 'misc->href}&table=", urlencode($rs->fields['relname']), '&schema=', urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['relname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&table=', urlencode($rs->fields['relname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'CONSTRAINTDOMAIN': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&domain=', urlencode($rs->fields['relname']), '">', $this->misc->printVal($rs->fields['relname']), '.', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'TRIGGER': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; $destination = $this->container->utils->getDestinationWithLastTab('table'); echo 'misc->href}&table=", urlencode($rs->fields['relname']), '&schema=', urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['relname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&table=', urlencode($rs->fields['relname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'RULETABLE': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; $destination = $this->container->utils->getDestinationWithLastTab('table'); echo 'misc->href}&table=", urlencode($rs->fields['relname']), '&schema=', urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['relname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&reltype=table&table=', urlencode($rs->fields['relname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'RULEVIEW': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; $destination = $this->container->utils->getDestinationWithLastTab('view'); echo 'misc->href}&view=", urlencode($rs->fields['relname']), '&schema=', urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['relname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&reltype=view&view=', urlencode($rs->fields['relname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'FUNCTION': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&function=', urlencode($rs->fields['name']), '&function_oid=', urlencode($rs->fields['oid']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'TYPE': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&type=', urlencode($rs->fields['name']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'DOMAIN': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&domain=', urlencode($rs->fields['name']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'OPERATOR': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '&operator=', urlencode($rs->fields['name']), '&operator_oid=', urlencode($rs->fields['oid']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'CONVERSION': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'LANGUAGE': echo "

misc->href}\">", $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'AGGREGATE': echo '

'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; case 'OPCLASS': echo '

'; $destination = $this->container->utils->getDestinationWithLastTab('schema'); echo 'misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->misc->printVal($rs->fields['schemaname']), '.'; echo "misc->href}&schema=", urlencode($rs->fields['schemaname']), '">', $this->_highlight($this->misc->printVal($rs->fields['name']), $_REQUEST['term']), '

'.PHP_EOL; break; } //$this->dump(['curr' => $curr, 'destination' => $destination]); } public function doFind() { $data = $this->misc->getDatabaseAccessor(); $rs = $data->findObject($_REQUEST['term'], $_REQUEST['filter']); if ($rs->recordCount() > 0) { $curr = ''; while (!$rs->EOF) { // Output a new header if the current type has changed, but not if it's just changed the rule type if ($rs->fields['type'] != $curr) { // Short-circuit in the case of changing from table rules to view rules; table cols to view cols; // table constraints to domain constraints if ('RULEVIEW' == $rs->fields['type'] && 'RULETABLE' == $curr) { $curr = $rs->fields['type']; } elseif ('COLUMNVIEW' == $rs->fields['type'] && 'COLUMNTABLE' == $curr) { $curr = $rs->fields['type']; } elseif ('CONSTRAINTTABLE' == $rs->fields['type'] && 'CONSTRAINTDOMAIN' == $curr) { $curr = $rs->fields['type']; } else { if ('' != $curr) { echo ''.PHP_EOL; } $curr = $rs->fields['type']; echo '

'; echo $this->_translatedType($curr); echo '

'; echo '

'.PHP_EOL; } } $this->_printHtmlForType($curr, $rs); $rs->moveNext(); } echo ''.PHP_EOL; echo '

', $rs->recordCount(), ' ', $this->lang['strobjects'], '

'.PHP_EOL; } else { echo "

{$this->lang['strnoobjects']}

".PHP_EOL; } } /** * Displays options for database download. * * @param mixed $msg */ public function doExport($msg = '') { $this->printTrail('database'); $this->printTabs('database', 'export'); $this->printMsg($msg); $subject = 'database'; $object = $_REQUEST['database']; echo $this->formHeader('dbexport'); echo $this->dataOnly(true, true); echo $this->structureOnly(); echo $this->structureAndData(true); // $server_info = $this->misc->getServerInfo(); // echo $this->offerNoRoleExport(isset($server_info['pgVersion']) && floatval(substr($server_info['pgVersion'], 0, 3)) >= 10); echo $this->displayOrDownload(!(strstr($_SERVER['HTTP_USER_AGENT'], 'MSIE') && isset($_SERVER['HTTPS']))); echo $this->formFooter($subject, $object); } /** * Show the current status of all database variables. */ public function doVariables() { $data = $this->misc->getDatabaseAccessor(); // Fetch the variables from the database $variables = $data->getVariables(); $this->printTrail('database'); $this->printTabs('database', 'variables'); $columns = [ 'variable' => [ 'title' => $this->lang['strname'], 'field' => Decorator::field('name'), ], 'value' => [ 'title' => $this->lang['strsetting'], 'field' => Decorator::field('setting'), ], ]; $actions = []; echo $this->printTable($variables, $columns, $actions, $this->table_place, $this->lang['strnodata']); } /** * Show all current database connections and any queries they * are running. * * @param mixed $msg */ public function doProcesses($msg = '') { $this->printTrail('database'); $this->printTabs('database', 'processes'); $this->printMsg($msg); if (0 === strlen($msg)) { echo '
$\"{$this-$ lang['strrefresh']}\" title=\"{$this->lang['strrefresh']}\"/> {$this->lang['strrefresh']}"; } echo '

'; $this->currentProcesses(); echo '

'; } public function currentProcesses($isAjax = false) { $data = $this->misc->getDatabaseAccessor(); // Display prepared transactions if ($data->hasPreparedXacts()) { echo "

{$this->lang['strpreparedxacts']}

".PHP_EOL; $prep_xacts = $data->getPreparedXacts($_REQUEST['database']); $columns = [ 'transaction' => [ 'title' => $this->lang['strxactid'], 'field' => Decorator::field('transaction'), ], 'gid' => [ 'title' => $this->lang['strgid'], 'field' => Decorator::field('gid'), ], 'prepared' => [ 'title' => $this->lang['strstarttime'], 'field' => Decorator::field('prepared'), ], 'owner' => [ 'title' => $this->lang['strowner'], 'field' => Decorator::field('owner'), ], ]; $actions = []; echo $this->printTable($prep_xacts, $columns, $actions, 'database-processes-preparedxacts', $this->lang['strnodata']); } // Fetch the processes from the database echo "

{$this->lang['strprocesses']}

".PHP_EOL; $processes = $data->getProcesses($_REQUEST['database']); $columns = [ 'user' => [ 'title' => $this->lang['strusername'], 'field' => Decorator::field('usename'), ], 'process' => [ 'title' => $this->lang['strprocess'], 'field' => Decorator::field('pid'), ], 'application_name' => [ 'title' => 'application', 'field' => Decorator::field('application_name'), ], 'client_addr' => [ 'title' => 'address', 'field' => Decorator::field('client_addr'), ], 'blocked' => [ 'title' => $this->lang['strblocked'], 'field' => Decorator::field('waiting'), ], 'query' => [ 'title' => $this->lang['strsql'], 'field' => Decorator::field('query'), ], 'start_time' => [ 'title' => $this->lang['strstarttime'], 'field' => Decorator::field('query_start'), ], ]; // Build possible actions for our process list $columns['actions'] = ['title' => $this->lang['stractions']]; $actions = []; if ($data->hasUserSignals() || $data->isSuperUser()) { $actions = [ 'cancel' => [ 'content' => $this->lang['strcancel'], 'attr' => [ 'href' => [ 'url' => 'database', 'urlvars' => [ 'action' => 'signal', 'signal' => 'CANCEL', 'pid' => Decorator::field('pid'), ], ], ], ], 'kill' => [ 'content' => $this->lang['strkill'], 'attr' => [ 'href' => [ 'url' => 'database', 'urlvars' => [ 'action' => 'signal', 'signal' => 'KILL', 'pid' => Decorator::field('pid'), ], ], ], ], ]; // Remove actions where not supported if (!$data->hasQueryKill()) { unset($actions['kill']); } if (!$data->hasQueryCancel()) { unset($actions['cancel']); } } if (0 == count($actions)) { unset($columns['actions']); } echo $this->printTable($processes, $columns, $actions, 'database-processes', $this->lang['strnodata']); } public function currentLocks($isAjax = false) { $data = $this->misc->getDatabaseAccessor(); // Get the info from the pg_locks view $variables = $data->getLocks(); $columns = [ 'namespace' => [ 'title' => $this->lang['strschema'], 'field' => Decorator::field('nspname'), ], 'tablename' => [ 'title' => $this->lang['strtablename'], 'field' => Decorator::field('tablename'), ], 'vxid' => [ 'title' => $this->lang['strvirtualtransaction'], 'field' => Decorator::field('virtualtransaction'), ], 'transactionid' => [ 'title' => $this->lang['strtransaction'], 'field' => Decorator::field('transaction'), ], 'processid' => [ 'title' => $this->lang['strprocessid'], 'field' => Decorator::field('pid'), ], 'mode' => [ 'title' => $this->lang['strmode'], 'field' => Decorator::field('mode'), ], 'granted' => [ 'title' => $this->lang['strislockheld'], 'field' => Decorator::field('granted'), 'type' => 'yesno', ], ]; if (!$data->hasVirtualTransactionId()) { unset($columns['vxid']); } $actions = []; echo $this->printTable($variables, $columns, $actions, 'database-locks', $this->lang['strnodata']); } /** * Show the existing table locks in the current database. */ public function doLocks() { $this->printTrail('database'); $this->printTabs('database', 'locks'); echo '
$\"{$this-$ lang['strrefresh']}\" title=\"{$this->lang['strrefresh']}\"/> {$this->lang['strrefresh']}"; echo '

'; $this->currentLocks(); echo '

'; } /** * Allow execution of arbitrary SQL statements on a database. */ public function doSQL() { if ((!isset($_SESSION['sqlquery'])) || isset($_REQUEST['new'])) { $_SESSION['sqlquery'] = ''; $_REQUEST['paginate'] = 'on'; } $this->printTrail('database'); $this->printTabs('database', 'sql'); echo "

{$this->lang['strentersql']}

".PHP_EOL; echo ''.PHP_EOL; // Default focus $this->setFocus('forms[0].query'); } /** * This functions does pretty much nothing. It's meant to implement * an abstract method of AdminTrait. * * @param string $msg The message * * @return string The message */ public function doDefault($msg = '') { return $msg; } }