void frmMainStateTable::setupUI(bool hasRowLabels_) { ui = createUI(); ui->setupUI(tableColumns(), hasRowLabels_, static_cast<QWidget*>(this->parent())); ui->toolbarDateBeginEdit->setDate(QDate::fromJulianDay(m_portfolio.startDate())); ui->toolbarDateEndEdit->setDate(QDate::fromJulianDay(m_portfolio.endDate())); setSortDropDown(); connect(ui->toolbarDateBeginEdit, SIGNAL(dateChanged(QDate)), this, SLOT(refreshTab())); connect(ui->toolbarDateEndEdit, SIGNAL(dateChanged(QDate)), this, SLOT(refreshTab())); connect(ui->toolbarSortCmb, SIGNAL(activated(int)), this, SLOT(sortIndexChanged(int))); connect(ui->toolbarReorder, SIGNAL(triggered()), this, SLOT(modifyColumns())); connect(ui->toolbarExport, SIGNAL(triggered()), ui->table, SLOT(exportTable())); connect(ui->tableCopy, SIGNAL(activated()), ui->table, SLOT(copyTable())); connect(ui->toolbar1D, SIGNAL(triggered()), this, SLOT(dateClicked())); connect(ui->toolbar3M, SIGNAL(triggered()), this, SLOT(dateClicked())); connect(ui->toolbar6M, SIGNAL(triggered()), this, SLOT(dateClicked())); connect(ui->toolbarYTD, SIGNAL(triggered()), this, SLOT(dateClicked())); connect(ui->toolbar1Y, SIGNAL(triggered()), this, SLOT(dateClicked())); connect(ui->toolbar5Y, SIGNAL(triggered()), this, SLOT(dateClicked())); connect(ui->toolbarMax, SIGNAL(triggered()), this, SLOT(dateClicked())); refreshTab(); connect(ui->table,SIGNAL(doubleClicked(const QModelIndex &)),this,SLOT(cellSelected(const QModelIndex &))); }
void frmMainStateTable::sortIndexChanged(int index_) { int columnID = ui->toolbarSortCmb->itemData(index_).toInt(); switch(columnID) { case -1: m_settings.setViewableColumnsSorting(columnEnumValue(), QList<orderBy>()); break; case -2: { frmSort f(m_settings.viewableColumnsSorting(columnEnumValue()), tableColumns(), static_cast<QWidget*>(this->parent())); if (f.exec()) m_settings.setViewableColumnsSorting(columnEnumValue(), f.getReturnValues()); else { setSortDropDown(); return; } } break; default: m_settings.setViewableColumnsSorting(columnEnumValue(), QList<orderBy>() << orderBy(columnID, orderBy::order_ascending)); break; } setSortDropDown(); static_cast<mpiViewModelBase*>(ui->table->model())->setColumnSort(m_settings.viewableColumnsSorting(columnEnumValue())); }
bool SyncJournalDb::updateErrorBlacklistTableStructure() { QStringList columns = tableColumns("blacklist"); bool re = true; // check if the file_id column is there and create it if not if( !checkConnect() ) { return false; } if( columns.indexOf(QLatin1String("lastTryTime")) == -1 ) { SqlQuery query(_db); query.prepare("ALTER TABLE blacklist ADD COLUMN lastTryTime INTEGER(8);"); if( !query.exec() ) { sqlFail("updateBlacklistTableStructure: Add lastTryTime fileid", query); re = false; } query.prepare("ALTER TABLE blacklist ADD COLUMN ignoreDuration INTEGER(8);"); if( !query.exec() ) { sqlFail("updateBlacklistTableStructure: Add ignoreDuration fileid", query); re = false; } commitInternal("update database structure: add lastTryTime, ignoreDuration cols"); } return re; }
bool SyncJournalDb::updateDatabaseStructure() { QStringList columns = tableColumns("metadata"); bool re = true; // check if the file_id column is there and create it if not if( !checkConnect() ) { return false; } if( columns.indexOf(QLatin1String("fileid")) == -1 ) { QSqlQuery query(_db); query.prepare("ALTER TABLE metadata ADD COLUMN fileid VARCHAR(128);"); if( !query.exec() ) { sqlFail("updateDatabaseStructure: Add column fileid", query); re = false; } query.prepare("CREATE INDEX metadata_file_id ON metadata(fileid);"); if( ! query.exec() ) { sqlFail("updateDatabaseStructure: create index fileid", query); re = false; } commitInternal("update database structure: add fileid col"); } if( columns.indexOf(QLatin1String("remotePerm")) == -1 ) { QSqlQuery query(_db); query.prepare("ALTER TABLE metadata ADD COLUMN remotePerm VARCHAR(128);"); if( !query.exec()) { sqlFail("updateDatabaseStructure: add column remotePerm", query); re = false; } commitInternal("update database structure (remotePerm"); } if( 1 ) { QSqlQuery query(_db); query.prepare("CREATE INDEX IF NOT EXISTS metadata_inode ON metadata(inode);"); if( !query.exec()) { sqlFail("updateDatabaseStructure: create index inode", query); re = false; } commitInternal("update database structure: add inode index"); } if( 1 ) { QSqlQuery query(_db); query.prepare("CREATE INDEX IF NOT EXISTS metadata_pathlen ON metadata(pathlen);"); if( !query.exec()) { sqlFail("updateDatabaseStructure: create index pathlen", query); re = false; } commitInternal("update database structure: add pathlen index"); } return re; }
void frmMainStateTable::modifyColumns() { frmColumns f(m_settings.viewableColumns(columnEnumValue()), tableColumns(), static_cast<QWidget*>(this->parent())); if (!f.exec()) return; m_settings.setViewableColumns(columnEnumValue(), f.getReturnValues()); static_cast<mpiViewModelBase*>(ui->table->model())->setViewableColumns(m_settings.viewableColumns(columnEnumValue())); }
bool SyncJournalDb::updateDatabaseStructure() { QStringList columns = tableColumns("metadata"); bool re = true; // check if the file_id column is there and create it if not if( !checkConnect() ) { return false; } if( columns.indexOf(QLatin1String("fileid")) == -1 ) { QSqlQuery query(_db); query.prepare("ALTER TABLE metadata ADD COLUMN fileid VARCHAR(128);"); re = query.exec(); query.prepare("CREATE INDEX metadata_file_id ON metadata(fileid);"); re = re && query.exec(); commitInternal("update database structure"); } return re; }