You will need to iterate through all of the records, for each record you need to determine if its data is the exact same anywhere else in the database. If so, tag it for deletion. At the end you will need to determine which of the duplicated records to keep, and then delete the rest.
Does this help? -Thadeus On Mon, Dec 7, 2009 at 5:28 AM, Vincent Borghi <[email protected]> wrote: > Hi, just simple advice needed: > > I have a web2py application whose data is made of an sqlite table > (that I have obtained by importing in web2py an excel-generated CSV file). > > Now I see that in fact the original CSV data included many duplicate lines, > so my sqlite table has the same duplicate lines that differ only by their > id. > > What simple method do you recommend to eliminate the duplicate lines > perhaps from within the web2py framework and without stopping the > application...? > > thanks > > -- > > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
