"No module named calibrelibrary.database2" error

[bob.f]

Would someone mind helping me troubleshoot the following error please?

C:\Program Files\Calibre2
>calibre-debug.exe -c "from calibrelibrary.database2 import LibraryDatabase2; db = LibraryDatabase2('c:\Users\Andrew\Calibre\ Library'); db.execute('select * from books b where b.id = 3094');"
Python function terminated unexpectedly
  No module named calibrelibrary.database2 (Error Code: 1)
Traceback (most recent call last):
  File "site.py", line 101, in main
  File "site.py", line 78, in run_entry_point
  File "site-packages\calibre\debug.py", line 276, in main
  File "<string>", line 1, in <module>
ImportError: No module named calibrelibrary.database2

[theducks]

Where did you get that commandline (those arguments)?

[kovidgoyal]

That command line you are using is obsolete. If you want to list the books in the calibre database from the command line use the calibredb tool. https://manual.calibre-ebook.com/gen...calibredb.html

[bob.f]

Originally Posted by kovidgoyal

That command line you are using is obsolete. If you want to list the books in the calibre database from the command line use the calibredb tool. https://manual.calibre-ebook.com/gen...calibredb.html

Thanks Kovid. I'm familiar with calibredb, but as far as I know it doesn't support issuing arbitrary queries against metadata.db, which is what I was trying to achieve here.

Instead, I am using sqlite to attach to and query the database directly.

[kovidgoyal]

calibredb supports the full calibre search language, what are yo utrying to achieve?

[bob.f]

Originally Posted by kovidgoyal

calibredb supports the full calibre search language, what are yo utrying to achieve?

I have a script that can be used to produce a selection of ten random books by creating a search filter of the form "id:x or id:y or id:z" etc.

In order to do this the script generates a count of all my unread books then generates 10 random numbers and executes a number of queries with the LIMIT 1 clause to select a random book (excluding certain criteria such as custom columns and tags).

I am aware of the read random book feature but I wanted something a little different.

[kovidgoyal]

You can do all that with calibredb. Use calibredb search to get the ids of all unread books, with whatever other criteria you need. Have your script pick a random one from that list.

You can also do that in the calibre GUI. Create a Virtual library to show your unread books (virtual libraries are based on arbitrary search expressions). Then the pickk a random book feature will pick a book from that virtual library.

[bob.f]

Originally Posted by kovidgoyal

You can do all that with calibredb. Use calibredb search to get the ids of all unread books, with whatever other criteria you need. Have your script pick a random one from that list.

You can also do that in the calibre GUI. Create a Virtual library to show your unread books (virtual libraries are based on arbitrary search expressions). Then the pickk a random book feature will pick a book from that virtual library.

Nice, thanks Kovid. Keep up the good work