search

CentreForDigitalHumanities / idioms

Database of Dutch Dialect Idioms
https://dutchdialectidioms.uu.nl/
Other
0 stars 0 forks source link

Free text search #13

Closed ar-jan closed 1 year ago

ar-jan commented 2 years ago

Implement free text search for text fields. The old version works as follows:

Simple free-text searches require every search term to be present, as a whole or partial word. For more complex queries you can use AND, OR, and negation (a minus sign), enclose "a string in quotes" to match it exactly, or search for the keyword NULL, which means the field must be empty.

ar-jan commented 2 years ago

Most searches work. TODO: handling multiple quoted strings.

ar-jan commented 2 years ago

Quoted strings are now handled via pyparsing.

TODO: adding OR, negation, NULLs to the WHERE clause handling. Also accept AND keyword (the default for multiple words/phrases).

ar-jan commented 1 year ago

Done for the main strategy and sentence table columns (using SQLite FTS5).