View Single Post
Old 12-09-2010, 01:22 PM   #2
silentguy
Connoisseur
silentguy doesn't littersilentguy doesn't littersilentguy doesn't litter
 
Posts: 88
Karma: 200
Join Date: Nov 2010
Location: Dortmund, Germany
Device: Kindle Paperwhite (10. Generation)
Okay, combining the hello world gui plugin with
db = self.gui.library_view.model().db
dupes = db.conn.get('select group_concat(id) from books group by UPPER(title) having count(*) > 1;')
allowed me to build a message box displaying the id's of duplicate books. next step, messing with the few and trying to figure out if my direct sql access is kinda bad :P
silentguy is offline   Reply With Quote