dcdpr / jp / 24001655073

67%

push

github

fix(grizzly): Improve schema discovery and wildcard search (#516)

The schema discovery logic previously picked the first `Z_[0-9]*TAGS`
table without checking whether it actually linked `ZSFNOTE` and
`ZSFNOTETAG` rows. Some Bear databases have multiple candidate tables,
causing the wrong one to be selected and silently returning no results.

Discovery now enumerates all matching candidates and validates each by
confirming it produces at least one note-tag link. Candidates with no
valid foreign-key references are skipped with a debug log, and a warning
is emitted when no candidate passes validation.

Additionally, passing `queries: ["*"]` was treated as a literal SQL
character rather than a match-all wildcard, making tag-only filtering
impossible. Wildcard queries are now stripped before search dispatch,
falling through to the tag/ID-only path as intended.

Signed-off-by: Jean Mertz <git@jeanmertz.com>

65 of 70 new or added lines in 3 files covered. (92.86%)

19881 of 31041 relevant lines covered (64.05%)

162.64 hits per line