if ($func == 'dump-schema') {
$table = $argv[2];
echo yaml::schema_to_yaml($table);
}
if ($func == 'load-schema') {
$table = $argv[2];
echo yaml::load_schema_from_yaml($table);
}
if ($func == 'drop-table') {
$table = $argv[2];
echo yaml::drop_table($table);
}
if ($func == 'convert-table') {
$source = $argv[2];
$target = $argv[3];
echo yaml::convert_table($source, $target);
}
if ($func == 'dump-to-screen') {
$table = $argv[2];
$renderer = new ArrayToTextTable((array) yaml::dump_to_screen($table));
$renderer->showHeaders(true);
$renderer->render();
echo "\r\n";
}
if ($func == '' or $func == 'help') {
echo "dump-schema <tablename> \r\n";
echo "load-schema <tablename> \r\n";
echo "drop-table <tablename> \r\n";
echo "convert-table <source> <target> \r\n";
echo "dump-to-screen <table>\r\n";
}
/**
* Starts the main interactive terminal
*
* @return void
*/
public function run()
{
$this->_shell->readHistory($this->_historyFile);
$prompt = '=# ';
$sql = '';
ob_start();
echo "Welcome to matrixsqlclient";
if (!empty($GLOBALS['rev'])) {
echo " (" . $GLOBALS['rev'] . ")";
}
echo ", the interactive database terminal in PHP.";
echo "\n\nYou are now connected.";
echo "\nDatabase type: " . $this->_db->getDbType() . $this->_db->getDbVersion() . ".\n\n";
ob_end_flush();
while (1) {
// Prompt for input
$line = $this->_shell->readline($this->_db->getDbName() . $prompt);
if ($line === "") {
echo "\n";
continue;
}
// Exits
if (mb_substr(trim($line), 0, 4) == 'exit' || mb_substr(trim($line), 0, 4) == 'quit' || mb_substr(trim($line), 0, 2) == '\\q') {
echo "\n";
exit;
}
if (mb_substr($line, mb_strlen($line) - 1, mb_strlen($line)) === chr(4)) {
echo "\\q\n";
exit;
}
// CTRL-C cancels any current query
if (ord(mb_substr($line, mb_strlen($line) - 1, mb_strlen($line))) === 3) {
$sql = '';
$line = '';
$prompt = '=# ';
echo "\n";
continue;
}
if (mb_strlen($line) > 0) {
// Add this command to the history
$this->_shell->addHistory(strtr($line, "\n", " "));
}
if (mb_substr(trim($line), 0, 7) == "\\timing") {
$this->setOption("timing", !$this->_getOptionValue("timing"));
if ($this->_getOptionValue("timing")) {
echo "\nTiming is on.";
} else {
echo "\nTiming is off.";
}
echo "\n";
continue;
}
// "\set" command
if (strlen(trim($sql)) === 0 && mb_substr(trim($line), 0, 4) == "\\set") {
$params = explode(" ", $line, 3);
// "\set" with no options - show existing options/values
if (count($params) === 1) {
$options = $this->_getOptions();
if (count($options) > 0) {
foreach ($this->_getOptions() as $option => $value) {
$value = $value === true ? "on" : $value;
$value = $value === false ? "off" : $value;
echo "\n" . $option . " = '" . $value . "'";
}
}
// "set" a particular value
} else {
$params = array_pad($params, 3, "");
$this->setOption($params[1], $params[2]);
$this->_parseOptions();
}
echo "\n";
continue;
}
$sql .= "\n" . $line;
// If the SQL string is terminated with a semicolon, or the DB module wants
// to accept it (eg. for a macro), then execute it
if ($this->_db->matchesMacro($sql) || mb_strpos($sql, ';')) {
echo "\n";
$sql = trim($sql);
try {
// Run the SQL
$this->restoreTerminal();
$source_data = @$this->_db->execute($sql);
} catch (Exception $e) {
echo "\n" . $e->getMessage() . "\n";
$this->resetTerminal(true);
// Reset the prompt cause its a new query
$prompt = '=# ';
$sql = '';
echo "\n";
continue;
}
$this->resetTerminal(true);
// If cancel request was triggered then just discard anything that might
// come back
if ($this->_cancel) {
$source_data = null;
$this->_cancel = false;
echo "Cancelled\n";
$prompt = '=# ';
$sql = '';
continue;
}
// If we get an array back, it's rows
if (is_array($source_data)) {
$rowlimit = (int) $this->_getOptionValue("rowlimit");
if (count($source_data) > $rowlimit) {
$this->_addToLinesBuffer(explode("\n", "\n\nWARNING: Number of rows returned exceeded rowlimit.\nOnly the first {$rowlimit} rows are being shown. Use \\set rowlimit <num> to adjust.\n\n"));
$source_data = array_slice($source_data, 0, $rowlimit);
}
// Only render the table if rows were returned
if (!empty($source_data)) {
// Render the table
$table = new ArrayToTextTable($source_data);
$table->showHeaders(true);
$data = explode("\n", $table->render(true));
array_pop($data);
$this->_addToLinesBuffer($data);
}
// Build count summary (at end of table) and add to line buffer
$count_str = "(" . count($source_data) . " row";
if (count($source_data) !== 1) {
$count_str .= "s";
}
$count_str .= ")";
$this->_addToLinesBuffer(array($count_str, ""));
// Assuming it's a string...
} else {
$this->_addToLinesBuffer(array($source_data));
}
if ($this->_getOptionValue("timing")) {
// Output amount of time this query took
$this->_addToLinesBuffer(array("Time: " . $this->_db->getQueryExecutionTime() . " ms"));
}
// Output the data
$this->_printLines();
// Reset the prompt cause its a new query
$prompt = '=# ';
$sql = '';
} elseif (mb_strlen(trim($sql)) > 0) {
// We're in the middle of some SQL, so modify the prompt slightly to show that
// (like psql does)
if (substr_count($sql, "(") > substr_count($sql, ")")) {
$prompt = '(# ';
} else {
$prompt = '-# ';
}
echo "\n";
}
}
}
function handleStatusAction()
{
$backupJobGetter = new backupJobGetter();
$backupJobGetter->setLogStream($this->log);
$scheduledBackupGetter = new scheduledBackupGetter();
$scheduledBackupGetter->setLogStream($this->log);
$hostGetter = new hostGetter();
$hostGetter->setLogStream($this->log);
$runningJobs = $backupJobGetter->getRunning();
$backupRows = array();
foreach ($runningJobs as $job) {
$info = $job->getInfo();
$scheduledBackup = $job->getScheduledBackup();
$host = $scheduledBackup->getHost();
$hostInfo = $host->getInfo();
$sbInfo = $scheduledBackup->getInfo();
$backupRows[] = array('Job ID' => $info['backup_job_id'], 'Host' => $hostInfo['hostname'], 'Backup Name' => $sbInfo['name'], 'Start Time' => $info['start_time'], 'Status' => $info['status'], 'PID' => $info['pid']);
}
if (sizeOf($backupRows) > 0) {
$textTable = new ArrayToTextTable($backupRows);
$textTable->showHeaders(true);
$tableOutput = $textTable->render(true);
print "Currently Running Backups:\n\n" . $tableOutput . "\n\n";
} else {
print "There are no backups currently running.\n\n";
}
}