Escape punctuation in search terms

farmfreshmeth / music_browser

Allow guests to search and browse the Studio84 music collection

0 stars 0 forks source link

Escape punctuation in search terms #40

Open farmfreshmeth opened 4 months ago

farmfreshmeth commented 4 months ago

Try searching "don't". Seems wrong

hunxjunedo commented 4 months ago

Hey @farmfreshmeth, requesting assignment, would love to contribute if open to external contributions.

farmfreshmeth commented 4 months ago

Really? Feel free to fork it and go nuts, @hunxjunedo. Send a pull request if you have something special. (It's a super niche app -- can't imagine it's worth your time)

farmfreshmeth commented 2 months ago

CNR

farmfreshmeth commented 2 months ago

Correction: on iOS (w/ certain settings?), single quote is replaced by apostrophe. Data contains both single quotes, apostrophes, and contracted words without punctuation ("donʼt", "don't", and "dont"). Folder, artist, item, and track searches are ILIKEs.

Convert to ts_queries? Use regexp search? Force all single quotes to apostrophes in database and automatically substitute single quotes for apostrophes in search strings?

hunxjunedo commented 2 months ago

How's it going lol