def importCountFromEbay(itemId): cursor.execute('''SELECT manufacturer,brand,name,countOnEbay FROM Item WHERE itemId = ?''',(int(itemId),)) for itemDetails in cursor: (manufacturer,brand,name,countOnEbay) = itemDetails (manufacturer,brand,name,countOnEbay) = itemDetails count = ebayFindItem(getItemName(manufacturer,brand,name)) print count if count != countOnEbay: cursor.execute('UPDATE Item SET countOnEbay = ? WHERE itemId = ?',(count,itemId)) c.commit()
def importCountFromEbay(itemId): cursor.execute('''SELECT manufacturer,brand,name,countOnEbay FROM Item WHERE itemId = ?''',(int(itemId),)) for itemDetails in cursor: (manufacturer,brand,name,countOnEbay) = itemDetails print "Looking for %s on EBay... "%getItemName(manufacturer,brand,name) (manufacturer,brand,name,countOnEbay) = itemDetails count = ebayFindItem(getItemName(manufacturer,brand,name)) print "Found %d listings<br />"%count if count != countOnEbay: cursor.execute('UPDATE Item SET countOnEbay = ? WHERE itemId = ?',(count,itemId)) c.commit()