make Qiqqa's DBExplorer more useful

GerHobbelt commented 5 years ago

How to go there? Qiqqa::Home > Configuration > Support Functions > LibraryDB Explorer 🍰

🎉 Revision: 6dcc971766edf407e9748c01a28aaf264743983c DBExplorer severely enhanced:

now supports wildcards in query parameters (% and _, but also * and ?, which are the MSDOS wildcards which translate directly to the SQL wildcards)
now supports GETting multiple records.
when GETting multiple records, DBExplorer not only prints the BibTeX for each record, but also the identifying fingerprint, verification MD5 and most importantly: the PARSED BibTeX (iff available) and BibTeX parse error diagnostics report.
when GETting multiple records, the DBExplorer output is also dumped to the file Qiqqa.DBexplorer.QueryDump.txt in the Qiqqa Library base directory. A previous DBExplorer query report dump will be REPLACED.
an extra input field has been added which allows the user to specify a maximum number of records to fetch: this speeds up queries and their reporting when working on large libraries with query criterai which would produce 1000nds of records if left unchecked.

This allows to use the DBExplorer as a rough diagnostics tool to check the library internals, including a way to find erroneous/offending BibTeX entries which may cause havoc in Qiqqa elsewhere.

GerHobbelt commented 5 years ago

Done as per #33 (and, consequently, available in https://github.com/GerHobbelt/qiqqa-open-source/releases/tag/v81.0.7158.38371)

GerHobbelt commented 5 years ago

Closing ^{and decluttering the issue list so it stays workable for me}: fixed in https://github.com/GerHobbelt/qiqqa-open-source mainline=master branch, pending #15 / any maintainer rights/actions.

GerHobbelt commented 5 years ago

The experimental code has been added to the v82 release tree, but I think there's still bugs in there, so we'll keep it vewwy quiet. 😉

jimmejardine / qiqqa-open-source

make Qiqqa's DBExplorer more useful #36