Changeset 990afd5 for src/sql

Timestamp:

01/20/10 15:50:12 (13 years ago)

Author:

timkoma <timkoma@…>

Branches:

master, qt5

Children:

f2ef735

Parents:

b1a201a

Message:

temp commit for search tab

Location:

src/sql

Files:

• sqlengine.cpp (modified) (1 diff)
• sqlengine.h (modified) (1 diff)

src/sql/sqlengine.cpp

@@ -290 +290 @@
 }
 
+int SqlEngine::searchEvent(int aConferenceId, const QList<QString> &aColumns, const QString &aKeyword)
+{
+    QSqlDatabase db = QSqlDatabase::database();
+
+    if ( !db.isValid() || !db.isOpen())
+        return -1;
+
+    QString query = QString(
+        "DROP TABLE IF EXISTS SEARCH_EVENT;"
+        "CREATE TEMP TABLE SEARCH_EVENT ( xid_conference INTEGER  NOT NULL, id INTEGER NOT NULL );"
+        "INSERT INTO SEARCH_EVENT ( xid_conference, id) "
+            "SELECT xid_conference, id FROM EVENT AS e INNER JOIN VIRTUAL_EVENT AS ve USING (xid_conference, id) "
+            "WHERE xid_conference = %1 AND (").arg( aConferenceId );
+
+    int i = 0;
+    foreach (QString str, aColumns){
+        query += QString("%1 LIKE '\%%2\%' OR ").arg( aColumns.at(i++), aKeyword );
+    }
+    query.chop( QString(" OR ").length() );
+    query += QString(");");
+
+    qDebug() << "\nSQL: " << query;
+
+    db.exec();
+
+    if( db.lastError().isValid() && db.lastError().number() != 0 ){
+        qDebug() << "SQL ERR: " << db.lastError().number() << ", " << db.lastError().text();
+        return 0;
+    }
+    else{
+        qDebug() << "SQL OK.\n";
+        return 1;
+    }
+
+}

src/sql/sqlengine.h

@@ -19 +19 @@
         void addLinkToDB(QHash<QString,QString> &aLink);
         void addRoomToDB(QHash<QString,QString> &aRoom);
+
+        // search Events for ....
+        int searchEvent(int conferenceId, const QList<QString> &columns, const QString &keyword);
     private:
         QString login(const QString &aDatabaseType, const QString &aDatabaseName);