Make it possible to edit the fileno

Default value is 0 (not SQL NULL, but zero) if none is given. Shouldn't
hurt.

2 files changed, 9 insertions, 3 deletions

diff --git a/editfiledialog.cpp b/editfiledialog.cpp
index c6908d5..7064789 100644
--- a/editfiledialog.cpp
+++ b/editfiledialog.cpp
@@ -33,12 +33,15 @@ void EditFileDialog::setupGui(){
     mMd5Sum = new QLineEdit;
     mMd5Sum->setReadOnly(true);
     mMd5Sum->setFont(QFont("Monospace"));
+    QIntValidator *validator = new QIntValidator;
+    mFileNo = new QLineEdit;
+    mFileNo->setValidator(validator);
     QFormLayout *lineEditL = new QFormLayout;
     lineEditL->addRow(tr("Filename"), mFileName);
     lineEditL->addRow(tr("MD5"), mMd5Sum);
+    lineEditL->addRow(tr("File No."), mFileNo);
     QGroupBox *dvdNoGB = new QGroupBox(tr("DVD No."));
     mDvdNo= new QLineEdit;
-    QIntValidator *validator = new QIntValidator;
     mDvdNo->setValidator(validator);
     QHBoxLayout *dvdNoGBL = new QHBoxLayout;
     dvdNoGBL->addWidget(mDvdNo);
@@ -87,7 +90,7 @@ void EditFileDialog::setupGui(){
 void EditFileDialog::initDlg(QString md5sum, QString fullPath){
     QSqlDatabase db = QSqlDatabase::database("treedb");
     QSqlQuery dataQ(db);
-    dataQ.prepare("SELECT idvd, sifiletype, siquality, tfilename FROM files WHERE cmd5sum = :md5");
+    dataQ.prepare("SELECT idvd, sifiletype, siquality, tfilename, sifileno FROM files WHERE cmd5sum = :md5");
     dataQ.bindValue(":md5", md5sum);
     dataQ.exec();
     while(dataQ.next()){
@@ -100,6 +103,7 @@ void EditFileDialog::initDlg(QString md5sum, QString fullPath){
         int fileType = dataQ.value(1).toInt();
         mFileType->setCurrentText(mFiletypeMap.value(fileType));
         mFileName->setText(dataQ.value(3).toString());
+        mFileNo->setText(QString::number(dataQ.value(4).toInt()));
     }
     mMd5Sum->setText(md5sum);
     QVariantMap ffmpegMap = Helper::ffmpegData(fullPath);
@@ -111,8 +115,9 @@ void EditFileDialog::initDlg(QString md5sum, QString fullPath){
 void EditFileDialog::accept(){
     QSqlDatabase db = QSqlDatabase::database("treedb");
     QSqlQuery updateQ(db);
-    updateQ.prepare("UPDATE files SET sifiletype = :ft, siquality = :fq, idvd = :dvd, iduration = :dur WHERE cmd5sum = :md5");
+    updateQ.prepare("UPDATE files SET sifiletype = :ft, siquality = :fq, idvd = :dvd, iduration = :dur, sifileno = :fno WHERE cmd5sum = :md5");
     updateQ.bindValue(":md5", mMd5Sum->text());
+    updateQ.bindValue(":fno", mFileNo->text());
     updateQ.bindValue(":fq", mQuality->text().toInt());
     updateQ.bindValue(":dvd", mDvdNo->text().toInt());
     updateQ.bindValue(":dur", mDurationSecs);
diff --git a/editfiledialog.h b/editfiledialog.h
index e4f91ae..3067a1b 100644
--- a/editfiledialog.h
+++ b/editfiledialog.h
@@ -27,6 +27,7 @@ class EditFileDialog : public QDialog {
         void setupGui();
         QLineEdit *mFileName;
         QLineEdit *mMd5Sum;
+        QLineEdit *mFileNo;
         QLineEdit *mDvdNo;
         QLineEdit *mQuality;
         QLineEdit *mDuration;