trento-project / web / d07d72207b27be0b6996f91f0e942752f01da15f

88%

push

github

ActivityLog searching by metadata BE implementation (#3059)

* Creates migration for indexing jsonb

Containment is preferred over Existence.

* Adds custom postgrex types

This is needed to support the Postgres Jsonpath type.

* Implements context functions

...for  search by metadata. Specifically, this adds functions that validate the search string and then parse it into the format expected by Jsonpath. This implementation can be extended to do key:value look ups as well as range/numeric equality look ups on integer fields at a later point.

* Adds an additional query parameter...

... to the activity logs endpoint.

* Add support for AND

* Improves AND support

Makes capture binding late instead of early

* Makes function credo compliant

...by breaking it into two

* Squashed commit of the following:

commit 16dc8856c
Author: Gagandeep Bhatia <gagandeep.bhatia@suse.com>
Date:   Tue Nov 5 12:00:40 2024 +0100

    Adds tests

    - Adapts the public interface of the parse module a bit to allow better inspection of failing parse cases.
    - Parse failure is now an info level log message.
    - Adds tests cases for parse success and failure

commit 5aa83a4d7
Author: Gagandeep Bhatia <gagandeep.bhatia@suse.com>
Date:   Wed Oct 23 14:40:19 2024 +0200

    Connects new parser implementation

    ... to the context module

commit df0065d12
Author: Gagandeep Bhatia <gagandeep.bhatia@suse.com>
Date:   Wed Oct 23 13:25:02 2024 +0200

    PoC PEG based query parser

    Implements a parsing expression grammar (PEG) based metadata query parser that turns search strings into valid jsonpath expressions

* Improves parser tests

This adds expected parses for given test cases to assert against

* Adds support for additional search scenarios

- support for Numeric ranges
- Additional characters that the search ... (continued)

35 of 42 new or added lines in 3 files covered. (83.33%)

2972 of 3495 relevant lines covered (85.04%)

304.01 hits per line