diff options
| -rw-r--r-- | moviewidget.cpp | 14 |
1 files changed, 6 insertions, 8 deletions
diff --git a/moviewidget.cpp b/moviewidget.cpp index 1438f32..98368f4 100644 --- a/moviewidget.cpp +++ b/moviewidget.cpp @@ -177,18 +177,16 @@ void MovieWidget::deleteSeries(){ } int partId = cur.first().data(SeriesPartIdRole).toInt(); QStringList fullPaths; - QSqlDatabase db = QSqlDatabase::database("treedb"); - QSqlQuery filesQ(db); - filesQ.prepare("SELECT tfilename, cmd5sum FROM files WHERE iseriespart_id = :id"); - filesQ.bindValue(":id", partId); - filesQ.exec(); - while(filesQ.next()){ - QString fp = Helper::createArchivePath(filesQ.value(0).toString(), filesQ.value(1).toString()); - fullPaths << fp; + for(int i = 0; i < mBottomModel->rowCount(); ++i){ + QStandardItem *item = mBottomModel->item(i); + if(item){ + fullPaths << item->data(FullPathRole).toString(); + } } QString msg = QString(tr("Really delete %1 file(s) (SeriesId %2)?")).arg(fullPaths.count()).arg(partId); int retval = QMessageBox::question(this, tr("Delete files..."), msg); if(retval == QMessageBox::Yes){ + QSqlDatabase db = QSqlDatabase::database("treedb"); db.transaction(); QSqlQuery deleteId(db); deleteId.prepare("DELETE FROM seriesparts WHERE iseriesparts_id = :id"); |