# coding=utf-8
import json
import GWcatcher
import pymssql
import DatabaseManager
import time
conn_state = 1
try:
#conn = pymssql.connect(host="localhost", user="******", password="******", database="GoblinWOW", charset = "utf8", login_timeout = 5)
ms = DatabaseManager.DBManager("localhost", "sa", "sa", "GoblinWOW")
except:
print 'connect database failed'
conn_state = 0
if conn_state == 1:
#print 'success'
format = '%Y-%m-%d %H:%M:%S'
msql = "SELECT * FROM dbo.ItemInSale"
mlist = ms.ExecuteQuery(msql)
for row in mlist:
print str(row[0]) + "\t" + row[1] + "\t" + str(row[2])
s = GWcatcher.Spider()
try:
response = s.getPriceList(15, row[2])
data = json.loads(response)
recent_time = data[0][2]
recent_price = data[0][0]
min_price = data[0][0]
max_price = min_price
