Changeset 51529bd
- Timestamp:
- 06/22/11 19:51:30 (12 years ago)
- Branches:
- master, qt5
- Children:
- f657e9c
- Parents:
- cfe9990
- Location:
- src
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
src/mvc/track.cpp
rcfe9990 r51529bd 21 21 22 22 QString const Track::sTableName = QString("track"); 23 int const Track::sTableColCount = 2; 23 int const Track::sTableColCount = 3; 24 const QString Track::CONFERENCEID = "xid_conference"; 24 25 const QString Track::NAME = "name"; 25 26 26 27 QSqlRecord const Track::sColumns = Track::toRecord(QList<QSqlField>() 27 28 << QSqlField("id", QVariant::Int) 29 << QSqlField(CONFERENCEID, QVariant::Int) 28 30 << QSqlField(NAME, QVariant::String)); 29 31 … … 37 39 { 38 40 QSqlQuery query; 39 query.prepare("INSERT INTO " + sTableName + " (" + NAME + ")" + " VALUES " + "(\"" + name() + "\")");41 query.prepare("INSERT INTO " + sTableName + " (" + CONFERENCEID + "," + NAME + ")" + " VALUES " + "(\"" + QString::number(conferenceid()) + "\",\"" + name() + "\")"); 40 42 if (!query.exec()) 41 43 { -
src/mvc/track.h
rcfe9990 r51529bd 29 29 static QString const sTableName; 30 30 static const int sTableColCount; 31 static const QString CONFERENCEID; 31 32 static const QString NAME; 32 33 public: 33 34 int id() const { return value("id").toInt(); } 34 35 void setId(int id) { setValue("id", id); } 36 int conferenceid() const { return value("xid_conference").toInt(); } 37 void setConference(int conferenceid) { setValue("xid_conference", conferenceid); } 35 38 QString name() const { return value("name").toString(); } 36 39 void setName(const QString & type) { setValue("name", type); } -
src/sql/sqlengine.cpp
rcfe9990 r51529bd 132 132 { 133 133 //insert event track to table and get track id 134 int conference = aEvent["conference_id"].toInt(); 134 135 QString name = aEvent["track"]; 135 136 Track track; … … 142 143 } 143 144 catch (OrmNoObjectException &e) { 145 track.setConference(conference); 144 146 track.setName(name); 145 147 trackId = track.insert(); … … 212 214 if (db.isValid() && db.isOpen()) 213 215 { 214 QString values = QString("'%1', '%2' ").arg(aPerson["id"],aPerson["name"]);215 QString query = QString("INSERT INTO PERSON ( id,name) VALUES (%1)").arg(values);216 QString values = QString("'%1', '%2', '%3'").arg(aPerson["conference_id"],aPerson["id"],aPerson["name"]); 217 QString query = QString("INSERT INTO PERSON (xid_conference,id,name) VALUES (%1)").arg(values); 216 218 QSqlQuery result (query, db); 217 219 //LOG_AUTOTEST(query); … … 243 245 else // ROOM record doesn't exist yet, need to create it 244 246 { 245 QString values = QString("'%1', '%2' ").arg(aRoom["name"],aRoom["picture"]);246 QString query = QString("INSERT INTO ROOM ( name,picture) VALUES (%1)").arg(values);247 QString values = QString("'%1', '%2', '%3'").arg(aRoom["conference_id"],aRoom["name"],aRoom["picture"]); 248 QString query = QString("INSERT INTO ROOM (xid_conference,name,picture) VALUES (%1)").arg(values); 247 249 QSqlQuery result (query, db); 248 250 roomId = result.lastInsertId().toInt(); // 'id' is assigned automatically
Note: See TracChangeset
for help on using the changeset viewer.