Calibre file name resolution

[gribbli]

Hi guys,

I have been using Calibre ever since I got the Kindle 3 at launch and with some rare free time on my hands I decided to use the pair as the basis for some other technologies I am experimenting with.

So yesterday I knocked together a quick web app for use on the kindle browser, which allows me to view and search my calibre book collection and select books to have emailed to the the device.

All works pretty well, my only concern is resolving the filename in order to ensure successful sending of the book. At the moment I am using a join of the books and data table in from the sqlite db, where path/name is exact but the file format column is uppercase. I am running on linux:mint so case sensitivity is a potential issue. So my question is, is there anywhere that holds the full filename+exact extension that I have overlooked, or even just more reliable data for ensuring the matching?

@Mods: If I have posted this in the wrong place by all means kick me in the right direction.

Cheers,
gribbli

[Starson17]

Originally Posted by gribbli

I am using a join of the books and data table in from the sqlite db, where path/name is exact but the file format column is uppercase. I am running on linux:mint so case sensitivity is a potential issue. So my question is, is there anywhere that holds the full filename+exact extension that I have overlooked, or even just more reliable data for ensuring the matching?

AFAIK, the extension is stored upper case in the database list and is always lower case as part of the filename. If you're worried, take a look at calibre.gui2.actions.copy_to_library and see:

Spoiler:

    def doit(self):
        from calibre.library.database2 import LibraryDatabase2
        newdb = LibraryDatabase2(self.loc)
        for i, x in enumerate(self.ids):
            mi = self.db.get_metadata(x, index_is_id=True, get_cover=True)
            self.progress(i, mi.title)
            fmts = self.db.formats(x, index_is_id=True)
            if not fmts: fmts = []
            else: fmts = fmts.split(',')
            paths = [self.db.format_abspath(x, fmt, index_is_id=True) for fmt in
                    fmts]
            print 'paths are: ', paths

The paths of format_abspath in the print statement I added at the end are the fully qualified path/filenames including extensions.

[kovidgoyal]

the full path is not stored anywhere you have to compose it from the format and name fields of the data table and the path field of the books table. And always lowercase the format.

[gribbli]

Thanks for the info guys, I had to add a lower() conversion on the extension to get it working in the first place so it sounds like I have already got it covered. With that part working, next job is to see if I can add to the Calibre library using the Kindle