calibredb search and keywords

ehead · 12-31-2021, 11:15 AM

I'm trying to figure out how to use calibredb search with keywords like "not". I've tried many different approaches to putting it in quotes and none seem to work.

calibredb search --with-library "http://localhost:8080/#Calibre" title:"you are not so smart"

calibredb search --with-library "http://localhost:8080/#Calibre" title:"you are 'not' so smart"

calibredb search --with-library "http://localhost:8080/#Calibre" 'title:"you are not so smart"'

None of the above works. If I remove "not" then they all work, but I'd like to be able to search for exact titles (I'll probably prefix with the = if I can ever get this to work). Any help appreciated.

kovidgoyal · 12-31-2021, 10:28 PM

If you are running those commands via a shell, you need to escape the quotes or the shell will stirp them out.

On POSIXy shells, something like:

calibredb search --with-library "http://localhost:8080/#Calibre" 'title:"you are not so smart"'

ehead · 01-02-2022, 11:36 AM

Thanks.

I started suspecting this soon after making this post. Amazingly, a little research revealed this is apparently one of PowerShell's Achilles heels.
https://stackoverflow.com/questions/...line-arguments

I'm re-writing this in python and it seems to be working.

davidfor · 01-02-2022, 08:42 PM

For the record, Kovid didn't actually escape anything in his sample. In PowerShell, the following worked for me:

Code:

calibredb search --with-library "http://localhost:8080/#Calibre" 'title:\"you are not so smart\"'

12-31-2021, 11:15 AM	#1
ehead Member Posts: 13 Karma: 10 Join Date: Apr 2013 Device: Kobo Aura HD	calibredb search and keywords I'm trying to figure out how to use calibredb search with keywords like "not". I've tried many different approaches to putting it in quotes and none seem to work. calibredb search --with-library "http://localhost:8080/#Calibre" title:"you are not so smart" calibredb search --with-library "http://localhost:8080/#Calibre" title:"you are 'not' so smart" calibredb search --with-library "http://localhost:8080/#Calibre" 'title:"you are not so smart"' None of the above works. If I remove "not" then they all work, but I'd like to be able to search for exact titles (I'll probably prefix with the = if I can ever get this to work). Any help appreciated.

01-02-2022, 08:42 PM	#4
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	For the record, Kovid didn't actually escape anything in his sample. In PowerShell, the following worked for me: Code: calibredb search --with-library "http://localhost:8080/#Calibre" 'title:\"you are not so smart\"'

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calibredb inconsistent title: search results	Terry Brown	Library Management	2	05-05-2020 11:29 AM
Calibredb search	iomari	Calibre	4	04-16-2019 11:58 AM
Search keywords in yes/no columns	Jellby	Calibre	1	07-14-2014 10:58 AM
Another keywords question.	Gregg Bell	Writers' Corner	15	02-26-2013 01:00 PM
PDF, Tags and Keywords	RockyBubba	Library Management	4	04-03-2011 07:41 AM

12-31-2021, 10:28 PM	#2
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	If you are running those commands via a shell, you need to escape the quotes or the shell will stirp them out. On POSIXy shells, something like: calibredb search --with-library "http://localhost:8080/#Calibre" 'title:"you are not so smart"'

01-02-2022, 11:36 AM	#3
ehead Member Posts: 13 Karma: 10 Join Date: Apr 2013 Device: Kobo Aura HD	Thanks. I started suspecting this soon after making this post. Amazingly, a little research revealed this is apparently one of PowerShell's Achilles heels. https://stackoverflow.com/questions/...line-arguments I'm re-writing this in python and it seems to be working.

Advert