Get filepath with bash or python

[dalanicolai]

Hi everyone,

Excuse me for posting this seemingly very simple question, but I've already spent quite some time now to find out how to obtain the filepath of a book using either the caliber CLI or the database API.

I would like to use the calibre database to quicklaunch a book with ulauncher without opening the full calibre gui. For this I would like to implement the functionality in the "Tracker recoll docfetcher locate search" plugin.

Anybody knows a quick way to obtain the filepath using calibre tools?

(unfortunately I am only a hobbyist trying to learn python but understanding the calibre design is still quite overwhelming)

Thanks!

[BetterRed]

Have a look at the calibrespy plugin, you'll find what I think you're looking for in calibrespy_dialog.py at about line 1965

BR

[kovidgoyal]

calibredb list -f formats --for-machine

or using a python API, assuming you already have a db object

db.new_api.format_files(book_id)

[dalanicolai]

Ah... hi guys! Sorry I never saw your answers before. I think I never got notified about it.
Anyway thanks for your answers. In the meantime I got the extension working. If you like you can find it here https://github.com/dalanicolai/gnome-tracker-extension. Despite its name, it is actually a quite versatile deep file search extension and it includes a cb keyword to search directly in the calibre database file.
@kovidgoyal Thanks for creating calibre and share it. It is a truly awesome software obviously! (Just want to launch some books quickly sometimes without opening the calibre gui first)

[dalanicolai]

@kovidgoyal

Maybe I can ask you two more small question also, if you have time for it. Otherwise do not mind about answering at all, because the extension is working fine already.

1. I did not know from where to get the calibre library path unambiguously. For example it could be possible that a foreign user, like me, has accidently two calibre folders (two different languages) in his home directory.
I figured out that probably I get the correct used library path from the global.py file in the .config/calibre folder. I am hoping that this file always contains the correct in use calibre library path (in general).

2. I did not find an easy way to use some AND operator in sqlite. I want to be able to enter two query words that are contained either in the title or in the author_sort columns (I could not find simply an author column).

I ended up using a subquery as follows:

results = c.execute('select title, author_sort, path from books where (title like "%{}%" or author_sort like "%{}%") and id in (select id from books where title like "%{}%" or author_sort like "%{}%")'.format(queries[1], queries[1], queries[0], queries[0]))


I was hoping you remember how you would nicely execute a query like this in sqlite. Sorry I am only learning things by myself from the internet.
Again do not mind about answering if it costs too much time. I just assume you must be quite an expert and you can answer these question by heart.

In any case... thanks again!

[dalanicolai]

@kovidgoyal

Of course I did not see your message before I implemented this. I realize now that probably you use a similar solution as I did (with the subquery) using the python db api.

[kovidgoyal]

global.py.json does indeed store the last opened library in calibre. Note that there is no "correct" library since you can have as many libraries as you want in calibre.

[dalanicolai]

Last opened library was indeed what I was looking for. Thanks!