From 141a5c2780c5d959cfbddefb2058f5bb5fb82392 Mon Sep 17 00:00:00 2001 From: Philipp Spitzer Date: Thu, 23 Jun 2011 06:57:20 +0000 Subject: [PATCH] Tracks are inserted now when importing new conferences. --- src/mvc/track.cpp | 5 +++-- src/mvc/track.h | 2 +- src/sql/sqlengine.cpp | 2 +- 3 files changed, 5 insertions(+), 4 deletions(-) diff --git a/src/mvc/track.cpp b/src/mvc/track.cpp index 9cadb47..5451378 100644 --- a/src/mvc/track.cpp +++ b/src/mvc/track.cpp @@ -50,12 +50,13 @@ int Track::insert() throw TrackInsertException("Last Insert Id Error"); } -Track Track::retrieveByName(QString name) +Track Track::retrieveByName(int conferenceid, QString name) { QSqlQuery query; query.prepare( selectQuery() - + QString("WHERE %1.name = :name").arg(sTableName)); + + QString("WHERE %1.xid_conference = :xid_conference and %1.name = :name").arg(sTableName)); + query.bindValue(":xid_conference", conferenceid); query.bindValue(":name", name); return loadOne(query); } diff --git a/src/mvc/track.h b/src/mvc/track.h index 3173b87..16a6b98 100644 --- a/src/mvc/track.h +++ b/src/mvc/track.h @@ -42,7 +42,7 @@ public: static QList getAll(); static Track retrieve(int id); static QString retrieveTrackName(int id); - static Track retrieveByName(QString name); + static Track retrieveByName(int conferenceid, QString name); }; #endif /* TRACK_H_ */ diff --git a/src/sql/sqlengine.cpp b/src/sql/sqlengine.cpp index 56f4477..a846c07 100644 --- a/src/sql/sqlengine.cpp +++ b/src/sql/sqlengine.cpp @@ -140,7 +140,7 @@ void SqlEngine::addEventToDB(QHash &aEvent) int trackId; try { - track = Track::retrieveByName(name); + track = Track::retrieveByName(conference, name); trackId = track.id(); /*qDebug() << QString("DEBUG: Track %1 in DB").arg(name);*/ } -- 2.39.5