fix small bug(wildcard), and change some comments

[mdictionary] / src / mdictionary / backbone / Bookmarks.cpp

diff --git a/src/mdictionary/backbone/Bookmarks.cpp b/src/mdictionary/backbone/Bookmarks.cpp
index 2df2de7..645e9ad 100644 (file)
--- a/src/mdictionary/backbone/Bookmarks.cpp
+++ b/src/mdictionary/backbone/Bookmarks.cpp
@@ -5,12 +5,11 @@
 Bookmarks::Bookmarks() {
     this->dbName = QDir::homePath() + "/.mdictionary/"
                  + "bookmarks.db";
-    checkAndCreateDb();
+    mdb = QSqlDatabase::addDatabase("QSQLITE");
+    mdb.setDatabaseName(dbName);
+    checkAndCreateDb(dbName);
     initAccents();
 
-    mdb = QSqlDatabase::addDatabase("QSQLITE",
-            QString("%2").arg((int)QThread::currentThreadId()));
-    mdb.setDatabaseName(dbName);
 }
 
 
@@ -19,50 +18,44 @@ Bookmarks::~Bookmarks() {
 }
 
 
-QSqlDatabase Bookmarks::getDbCnx(QString dbName) {
-    QSqlDatabase::removeDatabase(
-            QString("%2").arg((int)QThread::currentThreadId()));
-    QSqlDatabase db =QSqlDatabase::addDatabase("QSQLITE",
-            QString("%2").arg((int)QThread::currentThreadId()));
-    db.setDatabaseName(dbName);
-    return db;
+QSqlDatabase Bookmarks::getDbCnx(){
+    return mdb;
 }
 
 
-
-bool Bookmarks::checkAndCreateDb() {
-    QSqlDatabase db = getDbCnx(dbName);
+bool Bookmarks::checkAndCreateDb(QString dbName) {
+    QSqlDatabase db = QSqlDatabase::database();
+    if(dbName.size())
+        db.setDatabaseName(dbName);
+    else
+        db.setDatabaseName(this->dbName);
     db.open();
     QSqlQuery cur(db);
     cur.exec("create table bookmarks(key text, normalized text, translation text)");
-    db.close();
     return true;
 }
 
 
-
 void Bookmarks::clear() {
     checkAndCreateDb();
-    qDebug()<<"dename1"<<dbName;
-    QSqlDatabase db = getDbCnx(dbName);
+    QSqlDatabase db = getDbCnx();
     if(!db.isOpen() && !db.open()) {
-        qDebug() << "Database error1: " << db.lastError().text() << endl;
+        qDebug() << "Database error: " << db.lastError().text() << endl;
         return ;
     }
     QSqlQuery cur(db);
     cur.exec("drop table bookmarks");
     cur.exec("create table bookmarks(key text, normalized text,translation text)");
-    db.close();
 }
 
 
-
 void Bookmarks::add(Translation* translation) {
-    checkAndCreateDb();
-    qDebug()<<"dename2"<<dbName;
-    QSqlDatabase db = getDbCnx(dbName);
+    if (!translation)
+        return ;
+    checkAndCreateDb();   
+    QSqlDatabase db = getDbCnx();
     if(!db.isOpen() && !db.open()) {
-        qDebug() << "Database error2: " << db.lastError().text() << endl;
+        qDebug() << "Database error: " << db.lastError().text() << endl;
         return ;
     }
     translation->setBookmark(true);
@@ -70,36 +63,49 @@ void Bookmarks::add(Translation* translation) {
     cur.prepare("insert into bookmarks values (?,?,?)");
     cur.addBindValue(translation->key());
     cur.addBindValue(removeAccents(translation->key()));
-    cur.addBindValue(translation->toHtml());
+    cur.addBindValue(translation->toXml());
+    cur.exec();
+}
+
+
+void Bookmarks::add(QString key,QString removeAccentKey,QString value){
+    checkAndCreateDb();
+    QSqlDatabase db = getDbCnx();
+    if(!db.isOpen() && !db.open()) {
+        qDebug() << "Database error: " << db.lastError().text() << endl;
+        return ;
+    }
+    QSqlQuery cur(db);
+    cur.prepare("insert into bookmarks values (?,?,?)");
+    cur.addBindValue(key);
+    cur.addBindValue(removeAccentKey);
+    cur.addBindValue(value);
     cur.exec();
-    db.close();
 }
 
 
 void Bookmarks::remove(Translation* translation) {
-    qDebug()<<"dename3"<<dbName;
+    if (!translation)
+        return ;
     checkAndCreateDb();
-    QSqlDatabase db = getDbCnx(dbName);
+    QSqlDatabase db = getDbCnx();
     if(!db.isOpen() && !db.open()) {
-        qDebug() << "Database error3: " << db.lastError().text() << endl;
+        qDebug() << "Database error: " << db.lastError().text() << endl;
         return ;
     }
     QSqlQuery cur(db);
     cur.prepare("delete from bookmarks where key=?");
     cur.addBindValue(translation->key());
     cur.exec();
-    db.close();
 }
 
 
-
 QList<Translation*> Bookmarks::list() {
-    qDebug()<<"dename4"<<dbName;
     checkAndCreateDb();
     QList<Translation*> res;
-    QSqlDatabase db = getDbCnx(dbName);
+    QSqlDatabase db = getDbCnx();
     if(!db.isOpen() && !db.open()) {
-        qDebug() << "Database error4: " << db.lastError().text() << endl;
+        qDebug() << "Database error: " << db.lastError().text() << endl;
         return res;
     }
     QSqlQuery cur(db);
@@ -107,14 +113,11 @@ QList<Translation*> Bookmarks::list() {
     while(cur.next())
         res.append(new BookmarkTranslation(cur.value(0).toString(),
                 this, dbName));
-    db.close();
     return res;
 }
 
 
-
 QList<Translation*> Bookmarks::searchWordList(QString word) {
-    qDebug()<<"dename5"<<dbName;
     checkAndCreateDb();
     if(word.indexOf("*")==-1 && word.indexOf("?")== -1)
         word+="%";
@@ -122,9 +125,9 @@ QList<Translation*> Bookmarks::searchWordList(QString word) {
     word = word.replace("?", "_");
 
     QList<Translation*> tr;
-    QSqlDatabase db = getDbCnx(dbName);
+    QSqlDatabase db = getDbCnx();
     if(!db.isOpen() && !db.open()) {
-        qDebug() << "Database error5: " << db.lastError().text() << endl;
+        qDebug() << "Database error: " << db.lastError().text() << endl;
         return tr;
     }
     QSqlQuery cur(db);
@@ -137,19 +140,16 @@ QList<Translation*> Bookmarks::searchWordList(QString word) {
         res.insert(cur.value(0).toString());
     foreach(QString str, res.toList())
         tr.append(new BookmarkTranslation(str, this, dbName));
-    db.close();
     return tr;
 }
 
 
-
 QStringList Bookmarks::search(QString word, QString dbName) {
-    checkAndCreateDb();
-    qDebug()<<"dename6"<<dbName;
     QStringList result;
-    QSqlDatabase db = getDbCnx(dbName);
+    QSqlDatabase db = QSqlDatabase::database();
+    db.setDatabaseName(dbName);
     if(!db.isOpen() && !db.open()) {
-        qDebug() << "Database error6: " << db.lastError().text() << endl;
+        qDebug() << "Database error: " << db.lastError().text() << endl;
         return result;
     }
     QSqlQuery cur(db);
@@ -159,17 +159,13 @@ QStringList Bookmarks::search(QString word, QString dbName) {
     while(cur.next())
         result << cur.value(0).toString();
 
-    db.close();
     return result;
 }
 
 
-
-
 bool Bookmarks::inBookmarks(QString word) {
-    qDebug()<<"dename7"<<dbName;
     if(!mdb.isOpen() && !mdb.open()) {
-        qDebug() << "Database error7: " << mdb.lastError().text() << endl;
+        qDebug() << "Database error: " << mdb.lastError().text() << endl;
         return false;
     }
     QSqlQuery cur(mdb);