def nearbytline(): db = conMySql.openSQL() #微博账号获取 weiboacount = conMySql.getweiboacount(db) app_key=weiboacount[1] app_secret=weiboacount[2] token=weiboacount[3] #poiinfo获取 poiinfo = conMySql.getPoiInfo(db) lat = poiinfo[2] lon = poiinfo[3] client = APIClient(app_key, app_secret, redirect_uri='') client.set_access_token(token, 0) data =client.place.nearby_timeline.get(lat=lat,long=lon,starttime='1422720000',range=3000,count=50) # print data["statuses"][0]["url_objects"][0]["object"]["object"]["address"]["fax"] # print data return data
def get_recent_reviews(): #请替换appkey和secret2 / appkey = "0774328852" secret = "d0b762b037dd433284fa87f00a267de1" apiUrl = "http://api.dianping.com/v1/review/get_recent_reviews" #传入参数 poiinfolist = conMySql.getDzdpPoiInfo(conMySql.openSQL()) # businessid = poiinfolist[2] paramSet = [] paramSet.append(("business_id", "18248918")) #参数排序与拼接 paramMap = {} for pair in paramSet: paramMap[pair[0]] = pair[1] codec = appkey for key in sorted(paramMap.iterkeys()): codec += key + paramMap[key] codec += secret #签名计算 sign = (hashlib.sha1(codec).hexdigest()).upper() #拼接访问的URL url_trail = "appkey=" + appkey + "&sign=" + sign for pair in paramSet: url_trail += "&" + pair[0] + "=" + pair[1] requestUrl = apiUrl + "?" + url_trail #模拟请求 response = urllib.urlopen(requestUrl) data = json.loads(response.read()) print data