diff options
author | Yorhel <git@yorhel.nl> | 2014-12-22 12:06:55 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2014-12-22 12:06:55 +0100 |
commit | b646361f63e066c6859a1f05e29af7d9c812a13a (patch) | |
tree | 89e848a66ad36c710a0ec5d0f3f9a9330d7c0368 /lib/VNDB/DB/VN.pm | |
parent | 12338003bde24a3a263abe8caca71b1836ecee83 (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.pm | 14 |
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; |