Path: csiph.com!usenet.pasdenom.info!news.albasani.net!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
MIME-Version: 1.0
Date: Wed, 5 Dec 2012 23:50:49 +0100
Subject: Confused compare function :)
From: Anatoli Hristov <tolidtm@gmail.com>
To: python-list@python.org
Content-Type: text/plain; charset=UTF-8
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.534.1354747852.29569.python-list@python.org>
Lines: 63
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:34338

Hi all,

I'm confused again with a compare update function. The problem is that
my function does not work at all and I don't get it where it comes
from.

in my DB I have total of 754 products. when I run the function is says:
Total updated: 754
Total not found with in the distributor: 747
I just don't get it, can you find my  mistake ?

Thanks in advance

def Change_price():
    total = 0
    tnf = 0
    for row in DB: # DB is mySQL DB, logically I get out 1 SKU and I
compare it with next loop
        isku = row["sku"]
        isku = isku.lower()
        iprice = row["price"]
        iprice = int(iprice)
        found = 0
        try:
            for x in PRICELIST:# here is my next loop in a CSV file
which is allready in a list PRICELIST
                try:
                    dprice = x[6]
                    dprice = dprice.replace(",",".") # As in the
PRICELIST the prices are with commas I replace the comma as python
request it
                    dprice = float(dprice)
                    newprice = round(dprice)*1.10
                    dsku = x[4]
                    dsku = dsku.lower()
                    stock = int(x[7])
                    if isku == dsku and newprice < int(iprice):# If
found the coresponded SKU and the price is higher than the one in the
CSV I update the price
                        print dsku, x[6], dprice, newprice
                        Update_SQL(newprice, isku)# goes to the SQL Update
                        print isku, newprice
                        if isku == dsku:# Just a check to see if it works
                            print "Found %s" %dsku
                            found = 1
                        else:
                            found = 0
                except IndexError:
                    pass
                except ValueError:
                    pass
                except TypeError:
                    pass
        except IndexError:
            pass
        if found == 1:
            print "%s This is match" % isku
        if found == 0:
            print "%s Not found" % isku
            tnf = tnf +1
        total = total +1
    print "Total updated: %s" % total
    print"Total not found with in the distributor: %s" % tnf