Changeset 680a4da in confclerk_git for src/sql

Timestamp:

01/16/10 16:31:15 (13 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

c790268

Parents:

8860ff4

Message:

work on favourite

• created 'favourite' column in EVENT table
• modified 'ormrecord' for setting record's elements
• favourities view not implemented

File:

• src/sql/sqlengine.cpp (modified) (3 diffs)

src/sql/sqlengine.cpp

@@ -91 +91 @@
         // VIRTUAL_EVENT is for Full-Text-Serach Support
         QDateTime startDateTime = QDateTime(QDate::fromString(aEvent["date"],DATE_FORMAT),QTime::fromString(aEvent["start"],TIME_FORMAT));
-        QString values = QString("'%1', '%2', '%3', '%4', '%5', '%6', '%7'") \
+        QString values = QString("'%1', '%2', '%3', '%4', '%5', '%6', '%7', '%8'") \
                          .arg(aEvent["conference_id"]) \
                          .arg(aEvent["id"]) \
@@ -98 +98 @@
                          .arg("123456") \
                          .arg(aEvent["type"]) \
-                         .arg(aEvent["language"]);
-
-        QString query = QString("INSERT INTO EVENT (xid_conference, id, start, duration, xid_activity, type, language) VALUES (%1)").arg(values);
+                         .arg(aEvent["language"]) \
+                         .arg("0"); // not favourite when added
+
+        QString query = QString("INSERT INTO EVENT (xid_conference, id, start, duration, xid_activity, type, language, favourite) VALUES (%1)").arg(values);
         QSqlQuery result (query, db);
         //LOG_AUTOTEST(query);
@@ -227 +228 @@
             type VARCHAR, \
             language VARCHAR, \
+            favourite INTEGER DEFAULT 0, \
             PRIMARY KEY (xid_conference,id), \
             FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id) \