X-Git-Url: http://vcs.maemo.org/git/?a=blobdiff_plain;f=src%2Fcommon%2Fdb.cpp;h=d7b7dfa9ba5ad89f1a54950dedc5958b7cab6d46;hb=cf883c1283eb6b096592ef875a32696fee9dd6ff;hp=e5ce3161030424b998179740dcfcb09ebfead93a;hpb=89496ceee9788c2908c27ad4e2535f2728310d76;p=jenirok diff --git a/src/common/db.cpp b/src/common/db.cpp index e5ce316..d7b7dfa 100644 --- a/src/common/db.cpp +++ b/src/common/db.cpp @@ -24,8 +24,8 @@ namespace { - const QString SQL_DRIVER = "QSQLITE"; - const QString SQL_DATABASE = ".jenirok.db"; + const QString SQL_DRIVER = "QSQLITE"; + const QString SQL_DATABASE = ".jenirok.db"; } bool DB::initialized_ = false; @@ -33,71 +33,71 @@ QSqlDatabase DB::db_; bool DB::connect() { - if(!initialized_) - { - db_ = QSqlDatabase::addDatabase(SQL_DRIVER); - QString path = QDir::home().path() + QDir::separator() + SQL_DATABASE; - db_.setDatabaseName(QDir::toNativeSeparators(path)); - } - - bool ret = db_.open(); - - if(!ret) - { - QSqlError error = db_.lastError(); - qDebug() << error.text(); - } - - if(ret && !initialized_) - { - QSqlQuery query("SELECT value FROM settings WHERE name = 'initialized'"); - - if(!query.next()) - { - ret = createTables(); - } - } - - if(!initialized_) - { - initialized_ = true; - } - - return ret; + if(!initialized_) + { + db_ = QSqlDatabase::addDatabase(SQL_DRIVER); + QString path = QDir::home().path() + QDir::separator() + SQL_DATABASE; + db_.setDatabaseName(QDir::toNativeSeparators(path)); + } + + bool ret = db_.open(); + + if(!ret) + { + QSqlError error = db_.lastError(); + qDebug() << error.text(); + } + + if(ret && !initialized_) + { + QSqlQuery query("SELECT value FROM settings WHERE name = 'initialized'"); + + if(!query.next()) + { + ret = createTables(); + } + } + + if(!initialized_) + { + initialized_ = true; + } + + return ret; } void DB::disconnect() { - db_.close(); + db_.close(); } void DB::removeDatabase() { - db_.close(); - db_ = QSqlDatabase(); - QSqlDatabase::removeDatabase(QSqlDatabase::defaultConnection); - initialized_ = false; + db_.close(); + db_ = QSqlDatabase(); + QSqlDatabase::removeDatabase(QSqlDatabase::defaultConnection); + initialized_ = false; } bool DB::connected() { - return db_.isOpen(); + return db_.isOpen(); } QSqlDatabase& DB::instance() { - return db_; + return db_; } bool DB::createTables() { - QSqlQuery query; + QSqlQuery query; - bool ret = true; + bool ret = true; - ret = ret && query.exec("CREATE TABLE cache (id INTEGER PRIMARY KEY, number VARCHAR(32) NOT NULL UNIQUE, name VARCHAR(255) NOT NULL, street VARCHAR(255) NOT NULL, city VARCHAR(255) NOT NULL)"); - ret = ret && query.exec("CREATE TABLE settings (name VARCHAR(255) NOT NULL PRIMARY KEY, value VARCHAR(255) NOT NULL)"); - ret = ret && query.exec("INSERT INTO settings(name, value) VALUES('initialized', '1')"); + ret = ret && query.exec("CREATE TABLE cache (id INTEGER PRIMARY KEY, number VARCHAR(32) NOT NULL UNIQUE, name VARCHAR(255) NOT NULL, street VARCHAR(255) NOT NULL, city VARCHAR(255) NOT NULL)"); + ret = ret && query.exec("CREATE TABLE settings (name VARCHAR(255) NOT NULL PRIMARY KEY, value VARCHAR(255) NOT NULL)"); + ret = ret && query.exec("INSERT INTO settings(name, value) VALUES('initialized', '1')"); - return ret; + return ret; }