[Bug 42744] New: Add Database backend for patron search (denormalized table)
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 Bug ID: 42744 Summary: Add Database backend for patron search (denormalized table) Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: tomascohen@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle@bywatersolutions.com Depends on: 42508 Adds a zero-dependency Database backend for patron search using a denormalized table (patron_search_index) with MariaDB FULLTEXT indexes. Uses the field-group model: one row per patron per field group, enabling targeted search and weighted relevance. The same search interface as the ES backend, selected via the factory classes. Components: - patron_search_index table (field-group model) - Koha::SearchEngine::Database::Indexer::Patrons - Koha::SearchEngine::Database::Search::Patrons - Koha::SearchEngine::Search::Patrons (factory) - Koha::SearchEngine::Indexer::Patrons (factory) - patron_search_index.pl CLI tool with --backend switch - Integration tests starts_with uses LIKE on borrowers columns directly (fast with indexes). contains uses FULLTEXT BOOLEAN MODE on the index table. Facet filters and library scoping via standard SQL. This provides a patron search solution for installations that cannot deploy Elasticsearch. Depends on bug 42508. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42508 [Bug 42508] Add Elasticsearch patron search feature -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |tomascohen@gmail.com |ity.org | Patch complexity|--- |Medium patch Status|NEW |Needs Signoff -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #1 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 199791 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199791&action=edit Bug 42744: Add patron search/indexer factory classes Patch from commit 05040ae -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #2 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 199792 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199792&action=edit Bug 42744: Add Database patron search backend (field-group model) Patch from commit a8dc72e -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #3 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 199793 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199793&action=edit Bug 42744: Make search controller backend-agnostic Patch from commit 4d3c13e -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #4 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 199794 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199794&action=edit Bug 42744: Use libraries_where_can_see_patrons for DB search scoping Patch from commit f03d301 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #5 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 199795 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199795&action=edit Bug 42744: Rename es_patron_index.pl to patron_search_index.pl Patch from commit b8d90b3 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #6 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 199796 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199796&action=edit Bug 42744: Always use patrons.pl for patron search Patch from commit 1e73af0 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #7 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 199797 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199797&action=edit Bug 42744: Add tests for Database patron search backend Patch from commit 5706e42 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@openfifth.c | |o.uk, | |pedro.amorim@openfifth.co.u | |k -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 Mark Hofstetter <mark@hofstetter.at> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mark@hofstetter.at -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tomascohen@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #199791|0 |1 is obsolete| | Attachment #199792|0 |1 is obsolete| | Attachment #199793|0 |1 is obsolete| | Attachment #199794|0 |1 is obsolete| | Attachment #199795|0 |1 is obsolete| | Attachment #199796|0 |1 is obsolete| | Attachment #199797|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #8 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 207551 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207551&action=edit Bug 42744: Add patron search/indexer factory classes -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #9 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 207552 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207552&action=edit Bug 42744: Add Database patron search backend (field-group model) -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #10 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 207553 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207553&action=edit Bug 42744: Make search controller backend-agnostic -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #11 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 207554 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207554&action=edit Bug 42744: Use libraries_where_can_see_patrons for DB search scoping -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #12 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 207555 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207555&action=edit Bug 42744: Rename es_patron_index.pl to patron_search_index.pl -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #13 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 207556 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207556&action=edit Bug 42744: Always use patrons.pl for patron search -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42744 --- Comment #14 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 207557 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=207557&action=edit Bug 42744: Add tests for Database patron search backend -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org