From d4708602ac2ec4f23161ae154eb86e3f6a2740fb Mon Sep 17 00:00:00 2001
From: Arno <am@disconnect.de>
Date: Sat, 14 Feb 2015 17:58:29 +0100
Subject: Implement gotoArchive

New context menu item for Filesystemwidget: select the seriespart when
goto archive is triggered... Selecting the partId from ArchiveModel was
deceptibly simple. Doom impending?
---
 archivemodel.cpp | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'archivemodel.cpp')

diff --git a/archivemodel.cpp b/archivemodel.cpp
index 1d6c8d0..695dd09 100644
--- a/archivemodel.cpp
+++ b/archivemodel.cpp
@@ -580,6 +580,18 @@ bool ArchiveModel::addSeriesPart(int partno, QString subtitle, const QModelIndex
     return false;
 }
 
+int ArchiveModel::seriesPartIdFromMd5(const QString &md5){
+    QSqlQuery partsIdQ(mDb);
+    partsIdQ.prepare("SELECT iseriespart_id FROM files WHERE cmd5sum = :md5");
+    partsIdQ.bindValue(":md5", md5);
+    int retval = -1;
+    partsIdQ.exec();
+    while(partsIdQ.next()){
+        retval = partsIdQ.value(0).toInt();
+    }
+    return retval;
+}
+
 void ArchiveModel::setOrder(int order) {
     mOrder = order;
     SmTreeItem *rootItem = readCache(mOrder);
-- 
cgit v1.2.3-70-g09d2