[Tutor] finding duplicates within a tuple of tuples

[Norman Khine]

hello,

i have this tuple:

http://paste.lisp.org/+2F4X

i have this, which does what i want:

from collections import defaultdict

d = defaultdict(set)
for id, url in result:
	d[url].add(id)
for url in sorted(d):
	if len(d[url]) > 1:
		print('%d -- %s' % (len(d[url]), url))

so here the code checks for duplicate urls and counts the number of occurences.

but i am sort of stuck in that i want to now update the id of the
related table and update the

basically i have two tables:

id, url
24715L, 'http://aqoon.local/muesli/2-muesli-tropical-500g.html'
24719L, 'http://aqoon.local/muesli/2-muesli-tropical-500g.html'

id, tid,
1, 24715L
2, 24719L

so i want to first update t(2)'s tid to t(1)'s id for each duplicate
and then delete the row id = 24719L

thanks

-- 
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ
ǝq s,ʇǝן ʇǝʎ
%>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or
chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] )