Norman Khine wrote:
> 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
Assuming your first table is 'd' and your second table is 't', could you do
this?
for url in sorted(d):
# Get the ID of the first element for updating t's records
update_id = d[url][0]
# For all duplicate URLs, remove the dict item from d and
# update t's records
while len(d[url]) > 1:
pop_id = d[url].pop()
for (k, v) in t.iteritems():
if v == pop_id:
t[k] = update_id
There may be a more terse way of updating the values in t that I'm not seeing
right now.
matt
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
