diff options
Diffstat (limited to 'archivemodel.cpp')
-rw-r--r-- | archivemodel.cpp | 23 |
1 files changed, 0 insertions, 23 deletions
diff --git a/archivemodel.cpp b/archivemodel.cpp index ff37e73..1d6c8d0 100644 --- a/archivemodel.cpp +++ b/archivemodel.cpp @@ -394,29 +394,6 @@ void ArchiveModel::setGenres(int partId, const QStringList &genres){ mDb.commit(); } - -QString ArchiveModel::metadata(int partId) const{ - QString retval; - retval.append("<html><table>"); - QSqlQuery metadataQuery(mDb); - metadataQuery.prepare("SELECT sireleaseyear, tsourcemedium, tsubject, treleasegroup, tencoderopts, tcomment, sipasses, dadded FROM metadata WHERE iseriespart_id = :id"); - metadataQuery.bindValue(":id", partId); - metadataQuery.exec(); - while(metadataQuery.next()){ - retval.append(QString("<tr><td style=\"padding-right:10\"><i>Release year</i></td><td>%1</td></tr>").arg(QString::number(metadataQuery.value(0).toInt()))); - retval.append(QString("<tr><td><i>Source</i></td><td>%1</td></tr>").arg(metadataQuery.value(1).toString())); - retval.append(QString("<tr><td><i>Subject</i></td><td>%1</td></tr>").arg(metadataQuery.value(2).toString())); - retval.append(QString("<tr><td><i>Rel. Group</i></td><td>%1</td></tr>").arg(metadataQuery.value(3).toString())); - retval.append(QString("<tr><td><i>Enc. Opts</i></td><td>%1</td></tr>").arg(metadataQuery.value(4).toString())); - retval.append(QString("<tr><td><i>Passes</i></td><td>%1</td></tr>").arg(QString::number(metadataQuery.value(6).toInt()))); - QDate added = metadataQuery.value(7).toDate(); - retval.append(QString("<tr><td><i>Added</i></td><td>%1</td></tr>").arg(added.toString("yyyy-MM-dd"))); - retval.append(QString("<tr><td><i>Comment</i></td><td>%1</td></tr>").arg(metadataQuery.value(5).toString())); - } - retval.append("</table></html>"); - return retval; -} - QList<QVariant> ArchiveModel::metadataList(int partId) const{ QSqlQuery metadataQuery(mDb); metadataQuery.prepare("SELECT sireleaseyear, tsourcemedium, tsubject, treleasegroup, tencoderopts, tcomment, sipasses, dadded FROM metadata WHERE iseriespart_id = :id"); |