python获取浏览器cookies登录熊猫tv

在C:\Users\lenovo\AppData\Local\Google\Chrome\User Data\Default路径下查找已经在chrome上登录的cookies，然后用requests访问

http://www.panda.tv/ajax_get_myinfo

获取账号信息

from os import getenv
import sqlite3
import win32crypt
import requests
import Cookiestest
import json

def getPandaCookies():
    conn = sqlite3.connect(getenv("LOCALAPPDATA") + "\Google\Chrome\User Data\Default\Cookies")
    cursor = conn.cursor()
    cursor.execute('select host_key,name,encrypted_value from cookies where host_key like "%panda.tv%"')
    cookies=""
    for result in cursor.fetchall():
        # print result
        value = win32crypt.CryptUnprotectData(result[2], None, None, None, 0)[1]
        if value:
            cookies+="%s=%s; "%(result[1],value)
            # print 'host_key: ' + result[0]
            # print 'name: ' + result[1]
            # print 'Password: ' + value
        else:
           print "no password found"
    cursor.close()
    return cookies

Url="http://www.panda.tv/ajax_get_myinfo"
cookies=getPandaCookies()
headers = {"Cookie":cookies,
            "Host":"www.panda.tv",
           "Accept-Encoding":"gzip, deflate",
           "Referer":"http://www.panda.tv/personal",
           "User-Agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:53.0) Gecko/20100101 Firefox/53.0",
           "Accept":"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
           }
html=requests.get(Url,headers=headers)
html.encoding="utf-8"
print html.text
data=json.loads(html.text)
print data["data"]["nickName"]