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_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)