[Koha-bugs] [Bug 24975] Refactor database translations

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24975

--- Comment #83 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Created attachment 132575
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=132575&action=edit
Bug 24975: Fix db_t

The query here is difficult.. I wanted to return FULL LEFT JOIN, but
filtering on the joined data (l10n_targets.language) means we drop the
l10n_source rows where there are no corresponding l10n_targets with
language code.

I tried setting `l10n_targets.language => [ $language, undef ]` to
include null values, but that doesn't work either.  I then tried coming
up with a correlate subquery instead of the join and couldn't get dbic
to play nicely there either.

As such, I've fallen back to multiple queries over the relationship..
I'm sure we can do better... but this works for now.

-- 
You are receiving this mail because:
You are watching all bug changes.