MobileRead Forums - View Single Post

silentguy · 12-09-2010, 12:16 PM

Hi!
I got the feeling that the duplicate check that calibre offers by default upon adding is not good enough, so I thought I'd try to understand how the search source code works and make a plugin that makes some searches to find duplicates and display them in the books list.
Sadly, I haven't neither been able to figure out how to properly search from a plugin not how to tell it to display only the books my search returned. Could someone point me in the right direction?
Essentially I just want it to display all the books with the following ids "select group_concat(id) from books group by UPPER(title) having count(*) > 1;"
Well, that query could probably be tweaked, but I thought before I thought about it more, I'd figure out the basics :P

12-09-2010, 12:16 PM	#1
silentguy Connoisseur Posts: 88 Karma: 200 Join Date: Nov 2010 Location: Dortmund, Germany Device: Kindle Paperwhite (10. Generation)	Find duplicate books... Hi! I got the feeling that the duplicate check that calibre offers by default upon adding is not good enough, so I thought I'd try to understand how the search source code works and make a plugin that makes some searches to find duplicates and display them in the books list. Sadly, I haven't neither been able to figure out how to properly search from a plugin not how to tell it to display only the books my search returned. Could someone point me in the right direction? Essentially I just want it to display all the books with the following ids "select group_concat(id) from books group by UPPER(title) having count(*) > 1;" Well, that query could probably be tweaked, but I thought before I thought about it more, I'd figure out the basics :P