void CUserAdminItem::printAccessError()
{
#ifdef DEBUG
qDebug("CUserAdminItem::printAccessError()");
#endif
messagePanel()->critical(tr("You don't have enough privileges to access this section"));
}
void CAdministrationWindow::refresh()
{
if (isBlocked())
return;
setBlocked(true);
processList->refresh();
status->refresh();
if (has_innodb)
innoDBStatus->refresh();
messagePanel()->information(tr("Refresh successful"));
setBlocked(false);
}
CUserAdminItem::CUserAdminItem(CDatabaseListView * parent, CMySQLServer *m, const QString &connection_name, bool connected)
: CDatabaseListViewItem(parent, m, USER_ADMINISTRATION, "CUserAdminItem")
{
#ifdef DEBUG
qDebug("CUserAdminItem::CUserAdminItem(CDatabaseListView *, CMySQLServer *, const QString &, bool)");
#endif
is_connected = false;
if (m == 0)
{
m_mysql = new CMySQLServer(connection_name, messagePanel());
mysql()->connect();
deletemysql = true;
}
init(connected, true);
}
CDatabaseItem::CDatabaseItem(CDatabaseListView * parent, const QString &dbname, bool isconnected, const QString &connection_name, CMySQLServer *m)
: CDatabaseListViewItem(parent, m, DATABASE, "CDatabaseItem")
{
#ifdef DEBUG
qDebug("CDatabaseItem::CDatabaseItem(CDatabaseListView *, '%s', bool, const QString &, CMySQLServer *)", debug_string(dbname));
#endif
if (m == 0)
{
m_mysql = new CMySQLServer(connection_name, messagePanel());
mysql()->connect();
deletemysql = true;
}
is_connected = isconnected;
init(dbname);
widget_id = int_type();
}
void HelloWorldPlugin::init()
{
if (pluginWindow())
{
messagePanel();
pluginWindow()->statusBar();
pluginWindow()->menuBar();
CAction * fileCloseAction = new CAction(tr("Close"), icon(), tr("&Close"),
Qt::CTRL + Qt::Key_C, pluginWindow(), "fileCloseAction");
fileCloseAction->setParentMenuText(tr("File"));
connect(fileCloseAction, SIGNAL(activated()), pluginWindow(), SLOT(close()));
QPopupMenu * fileMenu = new QPopupMenu(pluginWindow(), "fileMenu");
pluginWindow()->menuBar()->insertItem(tr("&File"), fileMenu);
fileCloseAction->addTo(fileMenu);
enableHotKeyEditor();
message(icon(), "Creating Hello World Plugin");
}
}
void CAdministrationWindow::killProcesses()
{
if (isBlocked())
return;
setBlocked(true);
bool found = false;
for (int i = 0; i < processList->numRows(); i++)
{
if (processList->item(i,0) != 0 && ((QCheckTableItem *) processList->item(i,0))->isChecked())
if (mysql()->mysql()->mysqlKill(processList->text(i,0).toLong()))
{
messagePanel()->information(tr("Process killed successfully") + " :" + processList->text(i,0));
if (!found)
found = true;
}
}
if (found)
processList->refresh();
setBlocked(false);
}
CAdministrationWindow::CAdministrationWindow(QWidget* parent, CMySQLServer *m)
: CMyWindow(parent, "CAdministrationWindow")
{
(void)statusBar();
blocked = false;
myApp()->incCritical();
setCaption("[" + m->connectionName() + "] " + trUtf8("Administration Panel"));
setIcon(getPixmapIcon("applicationIcon"));
enableMessageWindow(true);
if (!m->oneConnection())
{
m_mysql = new CMySQLServer(m->connectionName(), messagePanel());
m_mysql->connect();
delete_mysql = true;
}
else
{
m_mysql = m; //POSIBLE BUG ... need to make m_mysql redirect messages & errors to this->messagePanel() also. Currently they are in consoleWindow()
//probably need to disable the timer !
delete_mysql = false;
}
setCentralWidget( new QWidget( this, "qt_central_widget"));
CAdministrationWindowLayout = new QGridLayout( centralWidget(), 1, 1, 4, 2, "CAdministrationWindowLayout");
tabWidget = new QTabWidget( centralWidget(), "tabWidget");
processList = new CProcessListTable(tabWidget, m_mysql);
tabWidget->insertTab(processList, getPixmapIcon("showProcessListIcon"), tr("Process List"), SHOW_PROCESSLIST);
status = new CServerStatusTable(tabWidget, m_mysql);
tabWidget->insertTab(status, getPixmapIcon("showStatusIcon"), tr("Status"), SHOW_STATUS);
variables = new CShowServerVariables(tabWidget, m_mysql);
tabWidget->insertTab(variables, getPixmapIcon("showVariablesIcon"), tr("Variables"), SHOW_VARIABLES);
save_menu = new QPopupMenu(this);
connect(save_menu, SIGNAL(activated(int)), this, SLOT(save(int)));
save_menu->insertItem(getPixmapIcon("showProcessListIcon"), tr("&Process List"), MENU_SAVE_PROCESSLIST);
save_menu->insertItem(getPixmapIcon("showStatusIcon"), tr("&Status"), MENU_SAVE_STATUS);
save_menu->insertItem(getPixmapIcon("showVariablesIcon"), tr("&Variables"), MENU_SAVE_VARIABLES);
save_menu->insertItem(tr("&InnoDB Status"), MENU_SAVE_INNODB_STATUS);
has_innodb = CInnoDBStatus::hasInnoDB(m_mysql);
if (has_innodb)
{
innoDBStatus = new CInnoDBStatus(tabWidget, m_mysql);
tabWidget->insertTab(innoDBStatus, tr("InnoDB Status"), SHOW_INNODB_STATUS);
}
else
save_menu->setItemEnabled(MENU_SAVE_INNODB_STATUS, false);
CAdministrationWindowLayout->addWidget( tabWidget, 0, 0 );
viewShowMessagesAction = new CAction (tr("Show Messages"), tr("Show &Messages"), Qt::CTRL + Qt::Key_M,
this, "fileShowMessagesAction", true);
viewShowMessagesAction->setParentMenuText(tr("View"));
connect(viewShowMessagesAction, SIGNAL(toggled(bool)), this, SLOT(showMessages(bool)));
CAction * fileCloseAction = new CAction (tr("Close"), getPixmapIcon("closeIcon"),
tr("&Close"), 0, this, "fileCloseAction");
fileCloseAction->setParentMenuText(tr("File"));
connect(fileCloseAction, SIGNAL(activated()), this, SLOT(close()));
fileRefreshAction = new CAction (tr("Refresh"), getPixmapIcon("refreshIcon"),
tr("&Refresh"), Qt::Key_F5, this, "fileRefreshAction");
fileRefreshAction->setParentMenuText(tr("File"));
connect(fileRefreshAction, SIGNAL(activated()), this, SLOT(refresh()));
actionKillProcessAction = new CAction (tr("Kill Process"), getPixmapIcon("killProcessIcon"),
tr("&Kill Process"), Qt::CTRL + Qt::Key_K, this, "actionKillProcessAction");
actionKillProcessAction->setParentMenuText(tr("Action"));
connect(actionKillProcessAction, SIGNAL(activated()), this, SLOT(killProcesses()));
CAction * actionPingAction = new CAction (tr("Ping"), getPixmapIcon("pingIcon"),
tr("&Ping"), Qt::CTRL + Qt::Key_P, this, "actionPingAction");
actionPingAction->setParentMenuText(tr("Action"));
connect(actionPingAction, SIGNAL(activated()), this, SLOT(ping()));
CAction * actionShutdownAction = new CAction (tr("Shutdown"), getPixmapIcon("serverShutdownIcon"),
tr("&Shutdown"), 0, this, "actionShutdownAction");
actionShutdownAction->setParentMenuText(tr("Action"));
connect(actionShutdownAction, SIGNAL(activated()), this, SLOT(shutdown()));
fileTimerAction = new CAction (tr("Start Refresh Timer"), getPixmapIcon("timerIcon"),
tr("Start Refresh &Timer"), Qt::CTRL + Qt::Key_T, this, "fileTimerAction", true);
fileTimerAction->setParentMenuText(tr("File"));
connect(fileTimerAction, SIGNAL(toggled(bool)), this, SLOT(fileTimerActionToggled(bool)));
QPopupMenu *fileMenu = new QPopupMenu(this);
QPopupMenu *actionMenu = new QPopupMenu(this);
QPopupMenu *viewMenu = new QPopupMenu(this);
connect(viewMenu, SIGNAL(aboutToShow()), this, SLOT(viewMenuAboutToShow()));
fileMenu->insertItem(getPixmapIcon("saveIcon"), tr("Save"), save_menu);
fileMenu->insertSeparator();
fileRefreshAction->addTo(fileMenu);
fileMenu->insertSeparator();
fileTimerAction->addTo(fileMenu);
fileMenu->insertSeparator();
fileCloseAction->addTo(fileMenu);
menuBar()->insertItem(tr("&File"), fileMenu);
viewShowMessagesAction->addTo(viewMenu);
menuBar()->insertItem(tr("&View"), viewMenu);
actionKillProcessAction->addTo(actionMenu);
flush_menu = flushMenu(m_mysql->mysql());
connect(flush_menu, SIGNAL(activated(int)), this, SLOT(flush(int)));
actionMenu->insertItem(getPixmapIcon("flushIcon"),tr("Flush"), flush_menu);
actionPingAction->addTo(actionMenu);
actionMenu->insertSeparator();
actionShutdownAction->addTo(actionMenu);
menuBar()->insertItem(tr("&Action"), actionMenu);
new CHotKeyEditorMenu(this, menuBar(), "HotKeyEditor");
QToolBar * actionToolBar = new QToolBar(tr("Action Bar"), this, Top);
QToolButton * saveTypeButton = new QToolButton(actionToolBar);
saveTypeButton->setPopup(save_menu);
saveTypeButton->setPixmap(getPixmapIcon("saveIcon"));
saveTypeButton->setTextLabel(tr("Save"), true);
saveTypeButton->setPopupDelay(0);
actionToolBar->addSeparator();
actionKillProcessAction->addTo(actionToolBar);
QToolButton * flushTypeButton = new QToolButton(actionToolBar);
flushTypeButton->setPopup(flush_menu);
flushTypeButton->setPixmap(getPixmapIcon("flushIcon"));
flushTypeButton->setTextLabel(tr("Flush"), true);
flushTypeButton->setPopupDelay(0);
actionPingAction->addTo(actionToolBar);
actionToolBar->addSeparator();
actionShutdownAction->addTo(actionToolBar);
QToolBar * refreshToolBar = new QToolBar(tr("Refresh Bar"), this, Top );
fileRefreshAction->addTo(refreshToolBar);
refreshToolBar->addSeparator();
QLabel * delayLabel = new QLabel(refreshToolBar, "delayLabel" );
delayLabel->setMinimumSize(QSize(65, 0));
delayLabel->setText(tr("Refresh Rate (sec)"));
delay = new QSpinBox(refreshToolBar, "delayBox");
delay->setMinimumSize(QSize( 50, 0));
delay->setMaxValue(7200);
delay->setMinValue(1);
CConfig *cfg = new CConfig();
delay->setValue(cfg->readNumberEntry("Refresh Rate", 30));
status->setTraditionalMode(strtobool(cfg->readStringEntry("Status Traditional Mode", "true")));
delete cfg;
status->refresh();
fileTimerAction->addTo(refreshToolBar);
refreshTimer = new QTimer(this);
connect(refreshTimer, SIGNAL(timeout()), this, SLOT(refresh()));
connect(tabWidget, SIGNAL(currentChanged (QWidget *)), this, SLOT(tabChanged(QWidget *)));
myResize(600, 400);
}