diff options
Diffstat (limited to 'moviemodel.cpp')
| -rw-r--r-- | moviemodel.cpp | 47 |
1 files changed, 33 insertions, 14 deletions
diff --git a/moviemodel.cpp b/moviemodel.cpp index 9e6e493..3d93d41 100644 --- a/moviemodel.cpp +++ b/moviemodel.cpp @@ -12,19 +12,39 @@ MovieModel::MovieModel(QObject *parent) : QAbstractItemModel(parent) { mHeaders << tr("Title") << tr("Filename") << tr("MD5Sum") << tr("Size") << tr("Genre") << tr("Quality") << tr("Archived"); - mInsertQuery = new QSqlQuery("SELECT insert_movie(:title, :filename, :md5, :filesize, :genre, :quality, :dvd"); - mDeleteQuery = new QSqlQuery("DELETE FROM movies WHERE imovid = :id"); - mDeleteActorsForMovie = new QSqlQuery("DELETE FROM movieactormap WHERE imovid = :id"); - mInsertActorsForMovie = new QSqlQuery("INSERT INTO movieactormap VALUES(:movid, :actorid"); - mDeleteCovers = new QSqlQuery("DELETE FROM covers WHERE imovid = :id"); - mInsertCovers = new QSqlQuery("INSERT INTO covers VALUES(:filename, :movid, :covertype, :md5sum"); - mColumnQueries << new QSqlQuery("UPDATE movies SET ttitle = :value WHERE imovid = :id"); - mColumnQueries << new QSqlQuery("UPDATE movies SET tfilename = :value WHERE imovid = :id"); - mColumnQueries << new QSqlQuery("UPDATE movies SET cmd5sum = :value WHERE imovid = :id"); - mColumnQueries << new QSqlQuery("UPDATE movies SET bisize = :value WHERE imovid = :id"); - mColumnQueries << new QSqlQuery("UPDATE movies SET igenreid = :value WHERE imovid = :id"); - mColumnQueries << new QSqlQuery("UPDATE movies SET iquality = :value WHERE imovid = :id"); - mColumnQueries << new QSqlQuery("UPDATE movies SET idvd = :value WHERE imovid = :id"); + mInsertQuery = new QSqlQuery; + mInsertQuery->prepare("SELECT insert_movie(:title, :filename, :md5, :filesize, :genre, :quality, :dvd)"); + mDeleteQuery = new QSqlQuery; + mDeleteQuery->prepare("DELETE FROM movies WHERE imovid = :id"); + mDeleteActorsForMovie = new QSqlQuery; + mDeleteActorsForMovie->prepare("DELETE FROM movieactormap WHERE imovid = :id"); + mInsertActorsForMovie = new QSqlQuery; + mInsertActorsForMovie->prepare("INSERT INTO movieactormap VALUES(:movid, :actorid)"); + mDeleteCovers = new QSqlQuery; + mDeleteCovers->prepare("DELETE FROM covers WHERE imovid = :id"); + mInsertCovers = new QSqlQuery; + mInsertCovers->prepare("INSERT INTO covers VALUES(:filename, :movid, :covertype, :md5sum)"); + QSqlQuery *c1 = new QSqlQuery; + c1->prepare("UPDATE movies SET ttitle = :value WHERE imovid = :id"); + mColumnQueries << c1; + QSqlQuery *c2 = new QSqlQuery; + c2->prepare("UPDATE movies SET tfilename = :value WHERE imovid = :id"); + mColumnQueries << c2; + QSqlQuery *c3 = new QSqlQuery; + c3->prepare("UPDATE movies SET cmd5sum = :value WHERE imovid = :id"); + mColumnQueries << c3; + QSqlQuery *c4 = new QSqlQuery; + c4->prepare("UPDATE movies SET bisize = :value WHERE imovid = :id"); + mColumnQueries << c4; + QSqlQuery *c5 = new QSqlQuery; + c5->prepare("UPDATE movies SET igenreid = :value WHERE imovid = :id"); + mColumnQueries << c5; + QSqlQuery *c6 = new QSqlQuery; + c6->prepare("UPDATE movies SET iquality = :value WHERE imovid = :id"); + mColumnQueries << c6; + QSqlQuery *c7 = new QSqlQuery; + c7->prepare("UPDATE movies SET idvd = :value WHERE imovid = :id"); + mColumnQueries << c7; populate(); } @@ -204,7 +224,6 @@ void MovieModel::removeMovie(const QModelIndex &idx){ void MovieModel::populate(){ QSqlQuery movieQuery("SELECT imovid FROM movies"); - movieQuery.exec(); while(movieQuery.next()){ int id = movieQuery.value(0).toInt(); MovieItem *item = new MovieItem(id); |