def get_cat_info_by_num_iid(num_iid):
'''
根据链接地址获取商品信息，存到数据库中
'''
req = topapi.ItemGetRequest(topconfig.URL, topconfig.PORT)
req.set_app_info(top.appinfo(topconfig.APPKEY, topconfig.APP_SECRECT))
req.fields = "detail_url,num_iid,title,cid,desc,pic_url,price,item_imgs"
req.num_iid = num_iid
resp = req.getResponse()
item_detail = resp['item_get_response']['item']
cat = Cats(
num_iid=item_detail['num_iid'],
cid=item_detail['cid'],
title=item_detail['title'],
img_url=item_detail['pic_url'],
click_url=item_detail['detail_url'],
price=item_detail['price'],
item_imgs=item_detail['item_imgs'],
desc=item_detail['desc'],
is_taobaoke=False,
#这里默认还有一个字段，获取卖家信用，但是在沙盒中无法测试此参数的有效性，暂时不填上
seller_credit_score=item_detail.get('score', -1))
print item_detail
cat.save()
def get_taobaoke_cat_info_by_num_iid(num_iid):
'''
获取淘宝客商品详细信息，并存入到数据库中
'''
req = topapi.TaobaokeItemsDetailGetRequest(topconfig.URL, topconfig.PORT)
req.set_app_info(top.appinfo(topconfig.APPKEY, topconfig.APP_SECRECT))
req.fields = 'desc,click_url,shop_click_url,seller_credit_score,num_iid,cid,\
title,nick,pic_url,price,desc,item_imgs'
req.pid = topconfig.PID
req.num_iids = num_iid
#存入数据库
resp = req.getResponse()
#print resp
item_detail = resp['taobaoke_items_detail_get_response'][
'taobaoke_item_details']['taobaoke_item_detail'][0]
print item_detail
cat = Cats(num_iid=item_detail['item']['num_iid'],
cid=item_detail['item']['cid'],
title=item_detail['item']['title'],
img_url=item_detail['item']['pic_url'],
click_url=item_detail['click_url'],
price=item_detail['item']['price'],
seller_credit_score=item_detail['seller_credit_score'],
desc=item_detail['item']['desc'],
item_imgs=item_detail['item']['item_imgs'],
is_taobaoke=True)
cat.save()
def add():
data = request.get_json()
name = data['name']
price = data['price']
breed = data['breed']
cat = Cats(name=name, price=price, breed=breed)
db.session.add(cat)
db.session.commit()
return json.dumps("Added"), 200
def get_cat_info_by_num_iid(num_iid):
'''
根据链接地址获取商品信息，存到数据库中
'''
req = topapi.ItemGetRequest(topconfig.URL, topconfig.PORT)
req.set_app_info(top.appinfo(topconfig.APPKEY, topconfig.APP_SECRECT))
req.fields = "detail_url,num_iid,title,cid,desc,pic_url,price,item_imgs"
req.num_iid = num_iid
resp = req.getResponse()
item_detail = resp['item_get_response']['item']
cat = Cats(num_iid=item_detail['num_iid'], cid=item_detail['cid'],
title=item_detail['title'], img_url=item_detail['pic_url'],
click_url=item_detail['detail_url'], price=item_detail['price'],
item_imgs=item_detail['item_imgs'], desc=item_detail['desc'], is_taobaoke=False,
#这里默认还有一个字段，获取卖家信用，但是在沙盒中无法测试此参数的有效性，暂时不填上
seller_credit_score = item_detail.get('score', -1))
print item_detail
cat.save()
def get_taobaoke_cat_info_by_num_iid(num_iid):
'''
获取淘宝客商品详细信息，并存入到数据库中
'''
req = topapi.TaobaokeItemsDetailGetRequest(topconfig.URL, topconfig.PORT)
req.set_app_info(top.appinfo(topconfig.APPKEY, topconfig.APP_SECRECT))
req.fields = 'desc,click_url,shop_click_url,seller_credit_score,num_iid,cid,\
title,nick,pic_url,price,desc,item_imgs'
req.pid = topconfig.PID
req.num_iids = num_iid
#存入数据库
resp = req.getResponse()
#print resp
item_detail = resp['taobaoke_items_detail_get_response']['taobaoke_item_details']['taobaoke_item_detail'][0]
print item_detail
cat = Cats(num_iid=item_detail['item']['num_iid'], cid=item_detail['item']['cid'],
title=item_detail['item']['title'], img_url=item_detail['item']['pic_url'],
click_url=item_detail['click_url'], price=item_detail['item']['price'],
seller_credit_score=item_detail['seller_credit_score'], desc=item_detail['item']['desc'],
item_imgs=item_detail['item']['item_imgs'], is_taobaoke=True)
cat.save()
def get_data(username):
if "username" not in session or username != session['username']:
raise Unauthorized()
user = User.query.get(username)
breed = request.form.get("feline")
breed = breed.lower()
if breed not in data_breeds:
flash(f'{breed} is not a cat breed')
return redirect(f'/users/{user.username}')
q = {'name': breed}
res = requests.get(url, headers=headers, params=q)
cat = res.json()
# kitty = session[IMG_KEY] # kitty[#][1]['item']
for i in range(0, len(cat)):
q_img = {'limit': '5', "breed_id": cat[i]['id']}
r_img = requests.get(url_img, headers=headers, params=q_img)
img = r_img.json()
# print(len(img))
if len(img) > 0:
for j in range(0, len(img)):
# kitty.append({'image': img[j]['url'], responses[i]})
if Cats.query.filter_by(img=img[j]['url']).first() is None:
cats = Cats(img=img[j]['url'], breed=cat[i]['name'])
db.session.add(cats)
db.session.commit()
# return redirect(f'/users/{user.username}')
kitties = Cats.query.all()
adopt = Adopt.query.all()
# flash(len(img))
return render_template('show.html', cats=kitties, user=user, adopt=adopt)
