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