[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.