+ if (!query.exec(strQuery)){
+ qDebug() << "Error creating profiles table";
+ result = false;
+ }
+
+ strQuery = "CREATE TABLE IF NOT EXISTS settings(setting TEXT UNIQUE, value TEXT)";
+ if (!query.exec(strQuery)){
+ qDebug() << "Error creating settings table";
+ result = false;
+ }
+ }
+ return result;
+}
+
+QString DatabaseUtility::getSetting(QString setting){
+ QString value = "Unknown";
+ if (vicarDB.isOpen()){
+ QString strQuery = QString("'SELECT value FROM settings WHERE setting='%1'").arg(setting);
+ qDebug() << "SQL>"<<strQuery;
+ QSqlQuery query(strQuery);
+ if (query.next()){
+ value = query.value(0).toString();
+ }
+ }
+ return value;
+}
+
+bool DatabaseUtility::setSetting(QString setting, QString value){
+ bool result = false;
+ if (vicarDB.isOpen()){
+ QSqlQuery query;
+ QString strQuery = QString("INSERT OR REPLACE INTO settings VALUES ('%1','%2')")
+ .arg(setting).arg(value);
+ qDebug() << "SQL>"<<strQuery;