Changeset 151983f for src/sql/sqlengine.cpp
- Timestamp:
- 01/18/10 14:45:05 (13 years ago)
- Branches:
- master, qt5
- Children:
- ffd878f
- Parents:
- 068656d
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/sql/sqlengine.cpp
r068656d r151983f 106 106 107 107 // add some(text related) Event's items to VIRTUAL_EVENT table 108 QString values2 = QString("'%1', '%2', '%3', '%4', '%5', '%6', '%7'") \108 QString values2 = QString("'%1', '%2', '%3', ? , ? , ? , ? ") \ 109 109 .arg(aEvent["conference_id"]) \ 110 110 .arg(aEvent["id"]) \ 111 .arg(aEvent["tag"]) \ 112 .arg(aEvent["title"]) \ 113 .arg(aEvent["subtitle"]) \ 114 .arg(aEvent["abstract"]) \ 115 .arg(aEvent["description"]); 111 .arg(aEvent["tag"]); 116 112 117 113 QString query2 = QString("INSERT INTO VIRTUAL_EVENT (xid_conference, id, tag, title, subtitle, abstract, description) VALUES (%1)").arg(values2); 118 QSqlQuery result2 (query2, db); 119 //LOG_AUTOTEST(query2); 114 115 QSqlQuery result2; 116 result2.prepare(query2); 117 result2.bindValue(0,aEvent["title"]); 118 result2.bindValue(1,aEvent["subtitle"]); 119 result2.bindValue(2,aEvent["abstract"]); 120 result2.bindValue(3,aEvent["description"]); 121 result2.exec(); 122 123 //LOG_AUTOTEST(query2); 124 qDebug() << query2; 120 125 } 121 126 } … … 234 239 FOREIGN KEY(xid_activity) REFERENCES ACTIVITY(id))"); 235 240 236 #ifdef MAEMO 237 // TBD: MAEMO Virtual tables compatibility (waiting for Marek). 238 // MAEMO sqlite Qt driver doesn't provide FTS support by default - use the following HACK 239 qDebug() << "MAEMO: Creating 'general', not 'virtual' table 'VIRTUAL_EVENT'"; 241 // TBD Virtual tables compatibility (waiting for Marek). Temporary non virtual VIRTUAL_TABLE below: To be deleted 242 /* query.exec("CREATE VIRTUAL TABLE VIRTUAL_EVENT using fts3 ( \ 243 xid_conference INTEGER NOT NULL, \ 244 id INTEGER NOT NULL , \ 245 tag VARCHAR,title VARCHAR NOT NULL , \ 246 subtitle VARCHAR, \ 247 abstract VARCHAR, \ 248 description VARCHAR, \ 249 PRIMARY KEY (xid_conference,id))"); 250 */ 240 251 query.exec("CREATE TABLE VIRTUAL_EVENT ( \ 241 252 xid_conference INTEGER NOT NULL, \ … … 246 257 description VARCHAR, \ 247 258 PRIMARY KEY (xid_conference,id))"); 248 #else249 query.exec("CREATE VIRTUAL TABLE VIRTUAL_EVENT using fts3 ( \250 xid_conference INTEGER NOT NULL, \251 id INTEGER NOT NULL , \252 tag VARCHAR,title VARCHAR NOT NULL , \253 subtitle VARCHAR, \254 abstract VARCHAR, \255 description VARCHAR, \256 PRIMARY KEY (xid_conference,id))");257 #endif258 259 259 260 query.exec("CREATE TABLE EVENT_PERSON ( \
Note: See TracChangeset
for help on using the changeset viewer.