void WicdApplet::popupEvent(bool show)
{
if (!show)
return;
if (m_autoScan) {
scan();
} else {
loadNetworks();
}
}
SavedNetworksList::SavedNetworksList(QObject *parent)
: QAbstractListModel(parent)
{
savedInterface = new QDBusInterface("org.freedesktop.NetworkManager", "/org/freedesktop/NetworkManager/Settings", "org.freedesktop.NetworkManager.Settings", QDBusConnection::systemBus());
QDBusConnection::systemBus().connect(savedInterface->service(), savedInterface->path(), savedInterface->interface(), "NewConnection", this, SLOT(loadNetworks()));
QDBusConnection::systemBus().connect(savedInterface->service(), savedInterface->path(), savedInterface->interface(), "ConnectionRemoved", this, SLOT(loadNetworks()));
loadNetworks();
}
void WicdApplet::setBusy(bool busy)
{
if (busy) {
m_scrollWidget->widget()->hide();
m_busyWidget->resize(m_scrollWidget->viewportGeometry().size());
m_busyWidget->show();
} else {
loadNetworks();
m_busyWidget->hide();
m_scrollWidget->widget()->show();
}
Plasma::PopupApplet::setBusy(busy);
}
DB::DB(const std::string & filename)
{
int res;
SQLOK(open(filename.c_str(), &dbh), "opening database");
SQLOK(exec(dbh,
"PRAGMA synchronous=0;\n"
"BEGIN;\n"
"CREATE TABLE IF NOT EXISTS \"sender\" (\n"
" \"id\" INTEGER NOT NULL,\n"
" \"nick\" VARCHAR,\n"
" \"user\" VARCHAR,\n"
" \"host\" VARCHAR,\n"
" PRIMARY KEY (\"id\")\n"
");\n"
"CREATE TABLE IF NOT EXISTS \"network\" (\n"
" \"id\" INTEGER NOT NULL,\n"
" \"name\" VARCHAR,\n"
" PRIMARY KEY (\"id\")\n"
");\n"
"CREATE TABLE IF NOT EXISTS \"buffer\" (\n"
" \"id\" INTEGER NOT NULL,\n"
" \"networkid\" INTEGER NOT NULL,\n"
" \"name\" VARCHAR,\n"
" PRIMARY KEY (\"id\"),\n"
" FOREIGN KEY (\"networkid\") REFERENCES \"network\" (\"id\")\n"
");\n"
"CREATE TABLE IF NOT EXISTS \"log\" (\n"
" \"id\" INTEGER NOT NULL,\n"
" \"type\" INTEGER NOT NULL,\n"
" \"timestamp\" INTEGER NOT NULL,\n"
" \"bufferid\" INTEGER NOT NULL,\n"
" \"senderid\" INTEGER NOT NULL,\n"
" \"message\" VARCHAR,\n"
" PRIMARY KEY (\"id\"),\n"
" FOREIGN KEY (\"bufferid\") REFERENCES \"buffer\" (\"id\"),\n"
" FOREIGN KEY (\"senderid\") REFERENCES \"sender\" (\"id\")\n"
");\n"
"CREATE INDEX IF NOT EXISTS \"logBufferTimestamp\" ON \"log\" (\"bufferid\", \"timestamp\");\n"
"CREATE INDEX IF NOT EXISTS \"logTimestamp\" ON \"log\" (\"timestamp\");\n"
"COMMIT;\n",
NULL, NULL, NULL), "initializing database");
PREPARE_STMT(stmt_add_message, "message insertion",
"INSERT INTO \"log\""
" (\"timestamp\", \"type\", \"bufferid\", \"senderid\", \"message\")"
" VALUES (?, ?, ?, ?, ?)");
PREPARE_STMT(stmt_add_buffer, "buffer insertion",
"INSERT INTO \"buffer\" (\"networkid\", \"name\") "
"VALUES (?, ?)");
PREPARE_STMT(stmt_add_network, "network insertion",
"INSERT INTO \"network\" (\"name\") "
"VALUES (?)");
PREPARE_STMT(stmt_add_sender, "sender insertion",
"INSERT INTO \"sender\" (\"nick\", \"user\", \"host\") "
"VALUES (?, ?, ?)");
PREPARE_STMT(stmt_begin, "begin", "BEGIN");
PREPARE_STMT(stmt_commit, "commit", "COMMIT");
loadNetworks();
loadBuffers();
loadSenders();
}
