#去哪儿网爬虫数据库配置信息
from peewee import *
import redis
#mysql
db = MySQLDatabase("qunaer.com", host="127.0.0.1", port=3306, user="root", password="123456")
# m_HOST = 'rm-8vbo8i67d84txyal1io.mysql.zhangbei.rds.aliyuncs.com'
# m_USER = 'daping'
# m_PASSWORD = 'Daping123'
# m_DB = 'service'
# m_PORT = 3306
# m_CHARSET = "utf-8"
#redis
#r=redis.Redis(host='58.221.24.242',port='18503',db='4',password=None,decode_responses=True)
r_HOST = "58.221.24.242"
r_PORT = "18503"
r_DB = "4"
r_PASSWORD = None
r_DECODE_RESPONSES = True
#mysql_db
# db = MySQLDatabase(m_DB,host=m_HOST,port=m_PORT,user=m_USER,password=m_PASSWORD)
#redis_db
r=redis.Redis(host=r_HOST,port=r_PORT,db=r_DB,password=None,decode_responses=True)
# ODPS
ODPS_ID = "LTAIPyvGKEmu9cqu"
ODPS_KEY = "oNaAKmIVqeAqeJ9jnok3PHuv7r5bfo"
ODPS_PROJECT = "businessdata"
ODPS_ENDPOINT = "http://service.odps.aliyun.com/api"
#cookies datas
#payload = "{"b":{"bizVersion":"17","cityUrl":" ","fromDate":" ","toDate":" ","q":"","qFrom":3,"start":0,"num":20,"minPrice":0,"maxPrice":-1,"level":"","sort":0,"cityType":1,"fromForLog":1,"uuid":"","userName":"","userId":"","fromAction":"","searchType":0,"hourlyRoom":false,"locationAreaFilter":[],"comprehensiveFilter":[],"channelId":1},"qrt":"h_hlist","source":"website"}"
payload = "{"b":{"bizVersion":"17","cityUrl":" ","fromDate":" ","toDate":" ","q":"","qFrom":3,"start":0,"num":20,"minPrice":0,"maxPrice":-1,"level":"","sort":0,"cityType":1,"fromForLog":1,"uuid":"","userName":"","userId":"","fromAction":"","searchType":0,"hourlyRoom":false,"locationAreaFilter":[{"params":"大兴区","reqParams":[{"param":"大兴区","title":"大兴区","secondShowSelected":false,"jsonExtra":"{}","suggestType":"district"}],"filterType":"ADMINISTRATIVE_DISTRICT"}],"comprehensiveFilter":[],"channelId":1},"qrt":"h_hlist","source":"website"}"
headers = {
'content-type': 'application/json;charset=UTF-8',
'referer': ' ',
'Cookie': 'QN1=00001480319827120b981f99; Cookie_1=value; QN300=hotel.qunar.com'
}
url_hotel_api = "https://hotel.qunar.com/napi/list" # 此处为酒店参数获取入口请求url
# ADSL
NAME = "宽带连接",
USERNAME = "079109382221",
PASSWORD = "66668888"
#
#vacation_url = "https://dujia.qunar.com/golfz/routeList/adaptors/pcTop?isTouch=0&t=all&o=pop-desc&lm=0%2C60&fhLimit=0%2C60&q=%E4%B8%8A%E6%B5%B7&d=%E5%8D%97%E9%80%9A&s=all&qs_ts=1597025404801&tf=Ihot_02&ti=3&tm=l02&sourcepage=list&userResident=%E5%8D%97%E9%80%9A&random=749376&aroundWeight=1&qssrc=eyJ0cyI6IjE1OTcwMjU2OTU3NTIiLCJzcmMiOiJhbGwuZW52YyIsImFjdCI6InNjcm9sbCIsInJhbmRvbSI6IjM5NTUyIn0%3D&m=l%2CbookingInfo%2CbrowsingInfo%2Clm&displayStatus=pc&ddf=true&userId=00001b802e1827051e5021c6&hlFields=title&gpscity=%E5%8D%97%E9%80%9A&lines6To10=0"
# vacation_payload = {}
# vacation_headers = {
# 'authority': 'dujia.qunar.com',
# 'pragma': 'no-cache',
# 'cache-control': 'no-cache',
# 'accept': 'application/json, text/javascript, */*; q=0.01',
# 'x-requested-with': 'XMLHttpRequest',
# 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36',
# 'sec-fetch-site': 'same-origin',
# 'sec-fetch-mode': 'cors',
# 'referer': 'https://dujia.qunar.com/pdqk/list_%E5%8D%97%E9%80%9A_%E9%81%B5%E4%B9%89_all?ti=3&tm=l01_all_search_newano',
# 'accept-encoding': 'gzip, deflate, br',
# 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8',
# 'cookie': 'DJ001=WyLljZfpgJoiXQ%3D%3D; QN1=00001b802e1827051e5021c6; HN1=v13682028f1bec89b222a940ba2fafd0dc; HN2=qnknsucsuccql; _i=ueHd86Mrat09otByUhkN1z6Cb4AX; QN269=1741D341D6C611EA8254FA163E26B699; fid=9d5930b9-43a0-493c-8391-cf3ddac5bc00; csrfToken=yYUyq7lihjTg4w5pCvii6wJT2LcNNJmA; QN300=auto_4e0d874a; QN99=1066; QN277=auto_4e0d874a; QN205=auto_4e0d874a; QunarGlobal=10.86.213.148_-ba9ffe3_173c6c832d4_-3d55|1596768404567; QN601=9502f35a4c69033ef0aa76a8bddcfc25; QN163=0; QN48=000030802f10271a34a878cb; QN6=auto_4e0d874a; QN49="64040021,57967441"; activityClose=1; JSESSIONID=1CA5D0A42A2B3F32FD0E60F15B881E96; _vi=f2Dh_DZGCGEMM1ExErF2xRPZXRDShBVIILyucEfMy1Cn8H46wGs6HGXyt3_coS1cg7QokPl1eVIVn25fmgQqJGdssYuntU5BWLkb3Hmw9YOhyAJ-XhSlIUYG5LB8TRZdxRKVHaT-g_BWxicZo4GkpDokzu49SzNQZ75KPD45QXii; QN100=WyLoi4%2Flt5585Y2X6YCaIiwi5LiK5rW3fCJd; QN271=a9a7bab2-3785-4e8d-b91a-354782f8ef72; QN267=0161810418d1168341; QN243=397; QN1=00001480319827120b981f99; QN300=hotel.qunar.com'
# }
tickect_url = 'https://piao.qunar.com/ticket/list_%E5%A6%82%E7%9A%8B%E5%B8%82.html?from=mps_search_suggest_c&keyword=%E5%A6%82%E7%9A%8B%E5%B8%82&page=1' # 门票的拼接url
# headers = {
# 'authority': 'hotel.qunar.com',
# 'pragma': 'no-cache',
# 'cache-control': 'no-cache',
# 'accept': 'application/json, text/plain, */*',
# 'origin': 'https://hotel.qunar.com',
# 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36',
# 'content-type': 'application/json;charset=UTF-8',
# 'sec-fetch-site': 'same-origin',
# 'sec-fetch-mode': 'cors',
# 'referer': 'https://hotel.qunar.com/cn/beijing_city/?fromDate=2020-08-18&toDate=2020-08-19&cityName=%E5%8C%97%E4%BA%AC',
# 'accept-encoding': 'gzip, deflate, br',
# 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8',
# 'cookie': 'QN1=00001b802e182745d9185ebc; HN1=v1a95faeae098745669d934051c3283282; HN2=qnknulqnqqnln; csrfToken=N4NEpCHNlbEdXAhCexr1WczknJ8zmRwD; _i=DFiEZCZ3I9Uw7zh6-9NMPqz-RBiw; QN269=A8740870DB9811EABB0CFA163E1F2D15; fid=57de3f4c-5444-4903-9b99-caac372c08f3; QN300=auto_4e0d874a; QN99=7381; QunarGlobal=10.86.213.148_-ba9ffe3_173dc07cc32_4864|1597126000429; QN601=770dca7728ac950f57548e9889e230d5; QN163=0; QN48=000018002f102745db804cd8; QN667=A; QN49="43539161,18548727"; QN205=auto_4e0d874a; QN277=auto_4e0d874a; QN6=auto_4e0d874a; activityClose=1; QN57=15976482472570.7233627222513455; QN100=WyLlkajlj6N8Iiwi5Li95rGffCJd; QN243=766; QN58=1597648247255%7C1597649508681%7C4; tabIndex=0; cityUrl= ; cityName= ; checkInDate= ; checkOutDate= ; _vi=UTCDr76UQw4vd1zYDrCLrqXv-PtbtW1XraxASSbIiubE2lwumysYODNklYKWd1Teq6FP-orL_yMouB6udcPpSVwLBRA-ytC9YQicJkGtSCa5IGehhao5y2utC6IUpJ_InDRo_HN0whKhSrj42H2PR1a7GT07GDd-hONBT9DTHSQi; QN267=1533671350a978d148; QN271=ab274efa-f7bc-463c-ac82-a3f70fe4922c; __qt=v1%7CVTJGc2RHVmtYMSt3WU13K3RIYlpEaTRsc2xFK3lnMDJXM291RE96TnBIaXdVOXZNMFNEL2daUUtrOGhrK1pnSmYwTENUdVBWYU1JcXJtVFB0V1p1TDhlUGJ6Z0VqWTlYdTYweDVlUisveDE2RzFib01GdUZJc2pJbE5aVkRnMGhOOU1FVFVLMTFpL29OY1FTSkZOdk9xcFVGS2xUQVViaUIzdEp2alhEaGFJPQ%3D%3D%7C1597655466537%7CVTJGc2RHVmtYMTljMnhlTzAydDJ3alZySVd2ZENmOGU0emZiUk1KNVExMkNZZmNNaWhZNWxvUXFJMHJBZTNyRG9qWnF1WnVaZjh3OUhvb0o5NGh5T0E9PQ%3D%3D%7CVTJGc2RHVmtYMSswQWwvR1VGTk1mRVRRRnlYdlZPbmNtUVhyME96K2ZtTzZuNStaOWNsQUtubjROUnl2TlhVamJpK3pzQjg4d2tUdHU1N1NtT1NuWVF4bkN1cWw0eGlRNGlSVlM0SVdjZE43QmQ0UGhCMWZoTVlnYnp0MithOVA3R0NWQlIxZDJPRXJtWi80VUh0SDNMQThlTXVkMk9rc2g5SmJHSXFCc2s0RVhmd3RjeURlWVRaR2VRQXBxd1o4VU9mTGtBZW9VQWVMUlNFMG1HaitSK25oZGo4SXd0VDZ2Z0g1dWtBSDVRZWJJSW1CQytzTG45Vk1rdEV4endTQUd5ZHpveTExczhKakk3aTdRWmZST25QK1NINTd0UmhNYjdUd1VPUFVuMlJXWjQ1ZlJwUDVxd0ZMekZSWGFYeWdONjlSR3hjSXNkOFZPakQ0b1ptSkhjeExaeGF4QldnNFd4WnZ6cXBob0trOUNvaytqc3RQU2l6Y2NBNmdENlhvV2hKV3EyZDFpNG5Rd1NGMVlWdFR2VzBLdytqVjF5Z1c1ckhtWWd2dWo4MlVUblQ1WlQ4RG5iY2xPYU5FcXR3TXpRRjNUVkp5TjNMWExYVTc3TmJXa2lCTno5bjBkUkw4UlR5Z2pvdFd0cmJ5alNXenBqb3FYYlRPaGNrWDViQnJOY1o1bWgveGdrYi9jY3QxTWZ3VG0yVXhHdEl5WTBSR0lTZkpMVXp0aXVCVXZLa1pQYnUvbFU0bXkrd2pRQkx1M3dwbXlubGhmYi9nYWJKd21hcnpkcnBjRXBOK2J5ZjU1eXJPL2RCdmJ4aTBGdUNKTkZGWDM1SHFWclQ3dUtpN0crRFVnV08rS3dZZ0p0SFcxWmM4dmcvM3FTYzI2SDRBbGhpZlo4WjJXcXM9; QN1=00001480319827120b981f99; QN300=hotel.qunar.com'
# }