summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/VN.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2014-12-22 12:06:55 +0100
committerYorhel <git@yorhel.nl>2014-12-22 12:06:55 +0100
commitb646361f63e066c6859a1f05e29af7d9c812a13a (patch)
tree89e848a66ad36c710a0ec5d0f3f9a9330d7c0368 /lib/VNDB/DB/VN.pm
parent12338003bde24a3a263abe8caca71b1836ecee83 (diff)
DB: Merge name/title fetching in main fetching functions
And call bbSubstLinks() from Handler::Discussions rather than DB::Discussions - it's not a transformation that the DB layer should do, IMO.
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r--lib/VNDB/DB/VN.pm14
1 files changed, 2 insertions, 12 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index ecf49f96..aaca4da5 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -7,7 +7,7 @@ use Exporter 'import';
use VNDB::Func 'gtintype', 'normalize_query';
use Encode 'decode_utf8';
-our @EXPORT = qw|dbVNGet dbVNRevisionInsert dbVNImageId dbScreenshotAdd dbScreenshotGet dbScreenshotRandom dbVNHasChar dbVNTitles|;
+our @EXPORT = qw|dbVNGet dbVNRevisionInsert dbVNImageId dbScreenshotAdd dbScreenshotGet dbScreenshotRandom dbVNHasChar|;
# Options: id, rev, char, search, length, lang, olang, plat, tag_inc, tag_exc, tagspoil,
@@ -32,7 +32,7 @@ sub dbVNGet {
my @where = (
$o{id} ? (
- 'v.id = ?' => $o{id} ) : (),
+ 'v.id IN(!l)' => [ ref $o{id} ? $o{id} : [$o{id}] ] ) : (),
$o{rev} ? (
'c.rev = ?' => $o{rev} ) : (),
$o{char} ? (
@@ -291,15 +291,5 @@ sub dbVNHasChar {
}
-sub dbVNTitles {
- my ($self, @vids) = @_;
- return $self->dbAll(q|
- SELECT v.id, vr.title
- FROM vn v
- JOIN vn_rev vr ON vr.id = v.latest
- WHERE v.id IN (!l)|, \@vids
- );
-}
-
1;