void KInstitutionsView::slotLoadAccounts(void)
{
if(isVisible()) {
loadAccounts();
} else {
m_needReload = true;
}
}
int AccountManager::start()
{
const char *errmsg;
const char *sql;
QString db_path = QDir(seafApplet->configurator()->seafileDir()).filePath("accounts.db");
if (sqlite3_open (toCStr(db_path), &db)) {
errmsg = sqlite3_errmsg (db);
qCritical("failed to open account database %s: %s",
toCStr(db_path), errmsg ? errmsg : "no error given");
seafApplet->errorAndExit(tr("failed to open account database"));
return -1;
}
// enabling foreign keys, it must be done manually from each connection
// and this feature is only supported from sqlite 3.6.19
sql = "PRAGMA foreign_keys=ON;";
if (sqlite_query_exec (db, sql) < 0) {
qCritical("sqlite version is too low to support foreign key feature\n");
sqlite3_close(db);
db = NULL;
return -1;
}
sql = "CREATE TABLE IF NOT EXISTS Accounts (url VARCHAR(24), "
"username VARCHAR(15), token VARCHAR(40), lastVisited INTEGER, "
"PRIMARY KEY(url, username))";
if (sqlite_query_exec (db, sql) < 0) {
qCritical("failed to create accounts table\n");
sqlite3_close(db);
db = NULL;
return -1;
}
updateAccountDatabaseForColumnShibbolethUrl(db);
// create ServerInfo table
sql = "CREATE TABLE IF NOT EXISTS ServerInfo ("
"key TEXT NOT NULL, value TEXT, "
"url VARCHAR(24), username VARCHAR(15), "
"PRIMARY KEY(url, username, key), "
"FOREIGN KEY(url, username) REFERENCES Accounts(url, username) "
"ON DELETE CASCADE ON UPDATE CASCADE )";
if (sqlite_query_exec (db, sql) < 0) {
qCritical("failed to create server_info table\n");
sqlite3_close(db);
db = NULL;
return -1;
}
loadAccounts();
connect(this, SIGNAL(accountsChanged()), this, SLOT(onAccountsChanged()));
return 0;
}
void ClientWidget::chooseLoadData()
{
int i = socket->getIndexOfLastQuery( qList );
QString str = socket->getData();
socket->closeConnection();
info->showProgressBar( false );
if( i < 0 )
return;
//if( str.isEmpty() || str.isNull() )
// return;
switch(i)
{
case 0:
{
int a = lastRow;
loadClients(str);
clientTable->SetFocus(a);
break;
}
case 1:
{
//loadStats(str);
break;
}
case 2:
{
loadAccounts(str);
break;
}
case 3:
{
removeClient(str);
break;
}
case 4:
{
removeClientAnswer(str);
break;
}
case 5:
{
removeClientAccountAnswer(str);
break;
}
}
}
LoginDialog::LoginDialog(HostList * h)
{
ui.setupUi(this);
connectionName = ui.serverComboBox->currentText();
connection = 0;
serverlistdialog_open = false;
hostlist = h; // Should just read it from settings here
loadAccounts();
connect(ui.serverComboBox, SIGNAL(currentIndexChanged ( int )), SLOT(slot_cbconnectChanged(int )));
connect(ui.connectPB, SIGNAL(clicked()), this, SLOT(slot_connect()));
connect(ui.cancelPB, SIGNAL(clicked()), this, SLOT(slot_cancel()));
connect(ui.loginEdit, SIGNAL(editTextChanged(const QString &)), this, SLOT(slot_editTextChanged(const QString &)));
}
void KInstitutionsView::show(void)
{
if(m_needReload) {
loadAccounts();
m_needReload = false;
}
// don't forget base class implementation
KInstitutionsViewDecl::show();
// if we have a selected account, let the application know about it
KMyMoneyAccountTreeBaseItem *item = m_accountTree->selectedItem();
if(item) {
emit selectObject(item->itemObject());
}
}
void Prefs::loadSettings()
{
// Load CallRecords although not settings per se!
loadCallRecords();
loadAccounts();
// load device settings
loadDeviceSettings();
// load filter settings
loadFilterSettings();
// load miscellaneous settings
loadMiscSettings();
// load session settings
loadSessionSettings();
}
int AccountManager::start()
{
const char *errmsg;
const char *sql;
QString db_path = QDir(seafApplet->configurator()->seafileDir()).filePath("accounts.db");
if (sqlite3_open (toCStr(db_path), &db)) {
errmsg = sqlite3_errmsg (db);
qDebug("failed to open account database %s: %s",
toCStr(db_path), errmsg ? errmsg : "no error given");
seafApplet->errorAndExit(tr("failed to open account database"));
return -1;
}
sql = "CREATE TABLE IF NOT EXISTS Accounts (url VARCHAR(24), "
"username VARCHAR(15), token VARCHAR(40), lastVisited INTEGER, "
"PRIMARY KEY(url, username))";
sqlite_query_exec (db, sql);
loadAccounts();
return 0;
}
WProtocol::WProtocol()
{
loadAccounts();
}
void LoginDialog::slot_cbconnectChanged(int)
{
connectionName = ui.serverComboBox->currentText();
loadAccounts();
}
KNAccountManager::KNAccountManager( KNGroupManager *gm, QObject * parent )
: QObject( parent ), gManager( gm ), c_urrentAccount( 0 ),
mAsyncOpening( false )
{
loadAccounts();
}
//Constructor
AccountsFunctions::AccountsFunctions() {
account_ID = 0;
loadAccounts();
}
