calibrestekje 0.0.1

Library prototyping based on Calibre

Calibrestekje is a Python library which provides a way to work with the Calibre database outside the context of the Calibre desktop and web interfaces. A set of generated SQLAlchemy bindings (see sqlacodegen for more) are provided which allow for the read/write access to an existing Calibre metadata database (a file typically called metadata.db). These bindings are more fine grained than Calibres database interface and provide direct access to the Database table layer.

from calibrestekje import Book, Publisher, init_session

session = init_session("sqlite:///mymetadata.db")

publisher = (session.query(Publisher)
                    .filter(Publisher.name == "MIT Press").one())

books = (session.query(Book)
                .filter(Book.publishers.contains(publisher)))

print(f"Books published by MIT Press: {books.count()}")