Page 1 of 1

Duplicate songs tables

Posted: Mon Sep 08, 2014 3:38 pm
by eljuanchosf
Guys,

I'm working in developing a script (soon to be an extension) to smartly delete dups.
How can I query the database to retrieve a list of all the dup files?

Thanks!

Re: Duplicate songs tables

Posted: Mon Sep 08, 2014 5:09 pm
by Lowlander
There is no table for that, you'd need to do some query yourself that matches fields (ie. like same Artist and same Title) to determine if files are duplicates.

You may want to check if you're not duplicating features already in the Advanced Duplicate Find & Fix Addon: http://www.mediamonkey.com/forum/viewto ... +duplicate

Re: Duplicate songs tables

Posted: Mon Sep 08, 2014 5:47 pm
by Guest
Oh! Ok, thanks.
How about the Duplicate by Content? Is there a way I can search that?

Thanks!!

Re: Duplicate songs tables

Posted: Mon Sep 08, 2014 5:58 pm
by Guest
I think I've fount what I was looking for. There is and index, idxSongsSignature that works on Songs.SignPart1.

Thank you!