From 8411b83125c4abfb8e77a772664ff66a528ae393 Mon Sep 17 00:00:00 2001 From: APTX Date: Thu, 25 Apr 2013 19:23:51 +0200 Subject: [PATCH] Add Min/MaxRelatedEpNo variables to the rename script env. This allows to add an episode range the file covers, rather than just the first/main episode number. --- localmylist/renameutils.cpp | 3 +++ localmylist/share/schema/schema.sql | 12 +++++++++++- 2 files changed, 14 insertions(+), 1 deletion(-) diff --git a/localmylist/renameutils.cpp b/localmylist/renameutils.cpp index 4e4892d..a1e115f 100644 --- a/localmylist/renameutils.cpp +++ b/localmylist/renameutils.cpp @@ -60,6 +60,9 @@ void setupRenameEnv(const QSqlRecord &record, RenameParser::Environment &env) env["CurrentFilePath"] = QFileInfo(record.value("path").toString()).path(); env["HostId"] = record.value("host_id").toString(); env["CurrentHostId"] = QString::number(MyList::instance()->hostId()); + + env["MinRelatedEpNo"] = record.value("min_related_epno").toString(); + env["MaxRelatedEpNo"] = record.value("max_related_epno").toString(); } } // namespace LocalMyList diff --git a/localmylist/share/schema/schema.sql b/localmylist/share/schema/schema.sql index c7743a0..be2f313 100644 --- a/localmylist/share/schema/schema.sql +++ b/localmylist/share/schema/schema.sql @@ -265,7 +265,17 @@ CREATE VIEW rename_data AS e.title_kanji AS episode_title_kanji, e.length AS episode_length, e.airdate, e.state, e.type, e.recap, e.rating, e.votes, e.my_vote, e.my_vote_date, f.anidb_update, f.entry_update, f.my_update, f.ed2k, f.size, f.length, f.extension, f.group_name, f.group_name_short, f.crc, f.release_date, f.version, f.censored, f.deprecated, f.source, q.quality_id, f.quality, f.resolution, f.video_codec, f.audio_codec, f.audio_language, f.subtitle_language, f.aspect_ratio, f.my_watched, f.my_state, f.my_file_state, f.my_storage, f.my_source, - f.my_other, fl.location_id, fl.host_id, fl.path, fl.renamed, fl.failed_rename + f.my_other, fl.location_id, fl.host_id, fl.path, fl.renamed, fl.failed_rename, + (SELECT min(fere.epno) min_related_epno FROM file sqf + JOIN episode e ON e.eid = sqf.eid + JOIN file_episode_rel fer ON fer.fid = sqf.fid + JOIN episode fere ON fere.eid = fer.eid AND fere.aid = sqf.aid AND fere.type = e.type + WHERE sqf.fid = f.fid), + (SELECT max(fere.epno) max_related_epno FROM file sqf + JOIN episode e ON e.eid = sqf.eid + JOIN file_episode_rel fer ON fer.fid = sqf.fid + JOIN episode fere ON fere.eid = fer.eid AND fere.aid = sqf.aid AND fere.type = e.type + WHERE sqf.fid = f.fid) FROM file f JOIN anime a ON a.aid = f.aid JOIN episode e ON e.eid = f.eid -- 2.52.0