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
|