def decode(self, s, _w=WHITESPACE.match):
dic = super(categoryDecode, self).decode(s)
print dic
categoryList = []
currentTime = int(time.time())
for categoryTmp in dic['result']:
category = Category()
category.cate_id = categoryTmp['cate_id']
category.cate_name = categoryTmp['cate_name']
category.parent_id = categoryTmp['parent_id']
category.parent_cate_name = categoryTmp['parent_cate_name']
category.sort_num = categoryTmp['sort_num']
category.cate_item_num = categoryTmp['cate_item_num']
category.description = categoryTmp['description']
category.listUrl = categoryTmp['listUrl']
category.shopName = categoryTmp['shopName']
category.shopLogo = categoryTmp['shopLogo']
category.update_time = currentTime
categoryList.append(category)
return categoryList
def getCategoryFromDb():
print '--- getCategoryFromDb start ---'
query = "select * from sh_category"
results = DbUtil.query(query)
print results
if results is None:
return None
categoryList = []
for row in results:
category = Category()
row_id = row[0]
cate_id = row[1]
cate_name = row[2]
parent_id = row[3]
parent_cate_name = row[4]
sort_num = row[5]
cate_item_num = row[6]
description = row[7]
listUrl = row[8]
shopName = row[9]
shopLogo = row[10]
updateTime = row[11]
category.cate_id = cate_id
category.cate_name = cate_name
category.parent_id = parent_id
category.parent_cate_name = parent_cate_name
category.sort_num = sort_num
category.cate_item_num = cate_item_num
category.description = description
category.listUrl = listUrl
category.shopName = shopName
category.shopLogo = shopLogo
category.update_time = updateTime
categoryList.append(category)
# print "row_id = %s, access_token = %s, expire_in = %s, update_time = %s " %(row_id, access_token, expire_in, update_time)
return categoryList
