1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| bool bdd::addMovie(const Movie &movie)
{
mmldb.setDatabaseName(pathDB);
if(mmldb.open())
{
QSqlQuery checkQuery;
checkQuery.prepare("SELECT COUNT(*) FROM Movies WHERE md5=:coucou)");
checkQuery.bindValue(":coucou",movie.md5);
if(!checkQuery.exec() || !checkQuery.first())
{
qDebug() << "étape 0.1";
qDebug() << checkQuery.lastError().text();
qDebug() << "étape 1";
}
else if(checkQuery.value(0)==0)
{
QSqlQuery query;
query.prepare("INSERT INTO Movies(title, md5, jacketPath, jacketMd5, releaseDate, genre, note, alreadySeen,\
favourite, toBeSeen, synopsis, duration, pathWallPaper, path, nationality)\
VALUES (:title, :md5, :jacketPath, :jacketMd5, :releaseDate, :genre, :note, :alreadySeen, \
:favourite, :toBeSeen, :synopsis, :duration, :pathWallPaper, :path, :nationality)");
query.bindValue(":title", movie.title);
query.bindValue(":md5",movie.md5);
query.bindValue(":jacketPath",""); //voir comment faire
query.bindValue(":jacketMd5",""); //voir comment faire
query.bindValue(":releaseDate",movie.releaseDate);
query.bindValue(":genre",movie.genre);
query.bindValue(":note",movie.note);
query.bindValue(":alreadySeen",movie.alreadySeen);
query.bindValue(":favourite",movie.favourite);
query.bindValue(":toBeSeen",movie.toBeSeen);
query.bindValue(":synopsis",movie.synopsis);
query.bindValue(":duration",movie.duration);
query.bindValue(":pathWallPaper", movie.pathWallPaper);
query.bindValue(":path", movie.path);
query.bindValue(":nationality", movie.nationality);
if (query.exec())
{
qDebug()<<"étape 2";
mmldb.close();
}
else
{
qDebug()<<query.lastError().text();
emit RequetteNonPossible(query.lastError().text());
mmldb.close();
return false;
}
}
else
{
emit RequetteNonPossible(checkQuery.lastError().text());
mmldb.close();
return false;
}
}
else
{
emit BDDAbsente(mmldb.lastError().text());
return false;
}
return true;
} |
Partager