From a0ae79cb4616fcca8a25b1a6f54bbecd39474bd5 Mon Sep 17 00:00:00 2001
From: Arno <am@disconnect.de>
Date: Fri, 18 Apr 2014 12:50:24 +0200
Subject: Delete files from Archive

Well, the title says it all. KILL THEM!
---
 archivemodel.cpp | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'archivemodel.cpp')

diff --git a/archivemodel.cpp b/archivemodel.cpp
index 11ee6e5..1da5833 100644
--- a/archivemodel.cpp
+++ b/archivemodel.cpp
@@ -534,6 +534,26 @@ void ArchiveModel::addFiles(int partId, const QStringList files){
     }
 }
 
+void ArchiveModel::removeFiles(const QList<int> fileIds){
+    QSqlQuery removeQ(mDb);
+    removeQ.prepare("DELETE FROM files WHERE ifiles_id = :id");
+    QSqlQuery dataQ(mDb);
+    dataQ.prepare("SELECT tfilename, cmd5sum FROM files WHERE ifiles_id = :id");
+    QString md5, fileName;
+    foreach(int id, fileIds){
+        dataQ.bindValue(":id" ,id);
+        dataQ.exec();
+        while(dataQ.next()){
+            fileName = dataQ.value(0).toString();
+            md5 = dataQ.value(1).toString();
+            if(Helper::removeFromArchive(fileName, md5)){
+                removeQ.bindValue(":id", id);
+                removeQ.exec();
+            }
+        }
+    }
+}
+
 bool ArchiveModel::deleteSeriesPart(int partId){
     QSqlQuery filesQ(mDb);
     filesQ.prepare("SELECT cmd5sum,tfilename FROM files WHERE iseriespart_id = :id");
-- 
cgit v1.2.3-70-g09d2