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()
def loadFromEbay():
itemList = []
# Get first page, which also gets the total number of pages
totalNumberOfPages = getPage(1,pageSize,itemList)
# Already got first page, so start at page 2
for pageNo in (range(2,totalNumberOfPages+1)):
getPage(pageNo,pageSize,itemList)
# Clean up the table
cursor.execute("DELETE FROM ebayList")
# Add the new data to the table
for (title,itemId,quantity) in itemList:
cursor.execute("INSERT INTO ebayList (title,itemId,quantity) VALUES (?,?,?)",(title,itemId,quantity))
c.commit()
def loadFromEbay():
# specify the connection to the eBay Sandbox environment
connection = httplib.HTTPSConnection(serverUrl)
itemList = []
# Get first page, which also gets the total number of pages
totalNumberOfPages = getPage(connection,1,pageSize,itemList)
# Already got first page, so start at page 2
for pageNo in (range(2,totalNumberOfPages+1)):
getPage(connection,pageNo,pageSize,itemList)
# Clean up the table
cursor.execute("DELETE FROM ebayList")
# Add the new data to the table
for (title,itemId,quantity) in itemList:
cursor.execute("INSERT INTO ebayList (title,itemId,quantity) VALUES (?,?,?)",(title,itemId,quantity))
c.commit()
cursor.execute('SELECT SUM(quantity) FROM binItems WHERE binId = ? and itemId = ? GROUP BY binId',(delBin,delItem))
(foundQty,) = cursor.fetchone()
if foundQty < totalToMove:
raise ValueError, "<p class=error>Didn't find enough items to move</p>"
cursor.execute('DELETE FROM binItems WHERE binId = ? and itemId = ?',(delBin,delItem))
for (binId,binQty) in moveDetails:
cursor.execute('INSERT INTO binItems (binId,itemId,quantity) VALUES (?,?,?)',(binId,delItem,binQty))
if foundQty > totalToMove:
cursor.execute('INSERT INTO binItems (binId,itemId,quantity) VALUES (?,?,?)',(delBin,delItem,foundQty-totalToMove))
cursor.execute('''INSERT INTO history (historyDate,body) VALUES (DATETIME('now'),?)''',(history,))
c.commit()
# Redirect to same page, so page reload doesn't re-add move
printRedirect('Move completed','binList.py',0)
sys.exit()
except Exception,e:
c.rollback()
errorString = "<p class=error>Problem with database update:</p><pre>%s</pre>"%str(sys.exc_info())
printHeader2('Bin/stock list',errorString)
#########################################
cursor.execute('''
SELECT
binId,itemId,Bin.name,Item.manufacturer,Item.brand,Item.name,SUM(quantity)
FROM
