MobileRead Forums - View Single Post - Best way to locate a book id from title, author or another data?

Pepin33 · 08-29-2012, 06:27 AM

I'm working in a plugin to update books from one library.

I load a catalog from a file, and then I need to search the database for those books. But I have no IDs, but titles, authors or another data. In fact, I have an unique number for each book, but it's not calibre ID, but a custom column ID.

I know I can load all IDs from db in a list, and then use db.title, db.authors or db.xxx to locate the ID for the books (I suppose it must also be any other function for locating a book ID using a custom column ¿?). But... I think there must be a more eficcient way to do this. Any help?

08-29-2012, 06:27 AM	#1
Pepin33 Zealot Posts: 109 Karma: 419 Join Date: Aug 2012 Location: Spain Device: Kindle Touch	Best way to locate a book id from title, author or another data? I'm working in a plugin to update books from one library. I load a catalog from a file, and then I need to search the database for those books. But I have no IDs, but titles, authors or another data. In fact, I have an unique number for each book, but it's not calibre ID, but a custom column ID. I know I can load all IDs from db in a list, and then use db.title, db.authors or db.xxx to locate the ID for the books (I suppose it must also be any other function for locating a book ID using a custom column ¿?). But... I think there must be a more eficcient way to do this. Any help? Last edited by Pepin33; 08-29-2012 at 06:34 AM.