Changeset c790268 for src/mvc/event.cpp

Timestamp:

01/17/10 17:22:03 (12 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

6f39595

Parents:

680a4da

Message:

implemented JOINing two tables

• modified 'ormrecord' to support JOINing two tables
• modified 'event' accordingly, since its items/columns are splitted into two separate tables

File:

• src/mvc/event.cpp (modified) (3 diffs)

src/mvc/event.cpp

@@ -1 +1 @@
 #include "event.h"
 
+// 'event' record is splitted into two separate tables 'event' and 'virtual_event'
+// for the FTS (Full-Text-Search) support and so, it is necessary to provide/use
+// two table names + corresponding parameters/methods, see bellow
+QString const Event::sTable1Name = QString("event");
+QString const Event::sTable2Name = QString("virtual_event");
+int const Event::sTable1ColCount = 8; // see 'toRecord()' for more details
+int const Event::sTable2ColCount = 5; // see 'toRecord()' for more details
+
 QSqlRecord const Event::sColumns = Event::toRecord(QList<QSqlField>()
+    /* 'columns from Table 1 */
     << QSqlField("id", QVariant::Int)
     << QSqlField("xid_conference", QVariant::Int)
@@ -9 +18 @@
     << QSqlField("type", QVariant::String)
     << QSqlField("language", QVariant::String)
-    << QSqlField("favourite", QVariant::Bool));
+    << QSqlField("favourite", QVariant::Bool)
+    /* 'columns' from Table2 */
+    << QSqlField("tag", QVariant::String)
+    << QSqlField("title", QVariant::String)
+    << QSqlField("subtitle", QVariant::String)
+    << QSqlField("abstract", QVariant::String)
+    << QSqlField("description", QVariant::String));
 
-QString const Event::sTableName = QString("event");
 
 Event Event::getById(int id, int conferenceId)
 {
     QSqlQuery query;
-    query.prepare(selectQuery() + "WHERE id = :id AND xid_conference = :conf");
+    query.prepare(selectQueryJoin2T("id") + "WHERE event.id = :id AND event.xid_conference = :conf");
     query.bindValue(":id", id);
     query.bindValue(":conf", conferenceId);
+
     return loadOne(query);
 }
@@ -25 +40 @@
 {
     QSqlQuery query;
-    query.prepare(selectQuery() + "WHERE xid_conference = :conf AND start >= :start AND start < :end ORDER BY start");
+    query.prepare(selectQueryJoin2T("id") + "WHERE event.xid_conference = :conf AND event.start >= :start AND event.start < :end ORDER BY event.start");
     query.bindValue(":conf", conferenceId);
     query.bindValue(":start", convertToDb(date, QVariant::DateTime));