| 635 | } |
| 636 | |
| 637 | void DBHelper::deleteComicsFromReadingList(const QList<ComicDB> &comicsList, qulonglong readingListId, QSqlDatabase &db) |
| 638 | { |
| 639 | db.transaction(); |
| 640 | |
| 641 | QLOG_DEBUG() << "deleteComicsFromReadingList----------------------------------"; |
| 642 | |
| 643 | QSqlQuery query(db); |
| 644 | query.prepare("DELETE FROM comic_reading_list WHERE comic_id = :comic_id AND reading_list_id = :reading_list_id"); |
| 645 | for (const auto &comic : comicsList) { |
| 646 | query.bindValue(":comic_id", comic.id); |
| 647 | query.bindValue(":reading_list_id", readingListId); |
| 648 | query.exec(); |
| 649 | } |
| 650 | |
| 651 | db.commit(); |
| 652 | } |
| 653 | |
| 654 | // updates |
| 655 | void DBHelper::update(ComicDB *comic, QSqlDatabase &db) |
no test coverage detected