def __init__(self, _mps_id, _biz, _pass_ticket, _app_msg_token, _cookie, _offset=0): self.offset = _offset self.mps_id = _mps_id self.biz = _biz # 公众号标志 self.msg_token = _app_msg_token # 票据(非固定) self.pass_ticket = _pass_ticket # 票据(非固定) self.headers = { 'Cookie': _cookie, # Cookie(非固定) 'User-Agent': 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.132 ' } wx_mps = 'wxmps' # 这里数据库、用户、密码一致(需替换成实际的) self.postgres = pgs.Pgs(host='localhost', port='12432', db_name=wx_mps, user=wx_mps, password=wx_mps) self.elastic = es.Es(host='localhost', port=12900, index='mp', doc='article')
def elastic(): return es.Es(host=host, port=12900, index=near_job, doc='job')
import urllib3 import requests from bs4 import BeautifulSoup from datetime import datetime from utils import pgs, es urllib3.disable_warnings() wx_mps = 'wxmps' # 这里数据库、用户、密码一致(需替换成实际的) postgres = pgs.Pgs(host='localhost', port='12432', db_name=wx_mps, user=wx_mps, password=wx_mps) elastic = es.Es(host='localhost', port=12900, index='mp', doc='article') def load(): for i in [13, 14, 25, 3]: sql = "select id,mps_biz,last_msg_id,app_msg_token,pass_ticket,wap_sid2 from " \ "tb_mps where id = {} and show = True".format(i) result = postgres.fetch_all(sql) for r in result: r_id, r_mps_biz, r_last_msg_id, r_app_msg_token, r_pass_ticket, r_wap_sid2 = r[0], r[1], r[2], \ r[3], r[4], r[5] r_cookie = 'wxuin=1604513290; version=62060619; lang=zh_TW; pass_ticket={}; wap_sid2={}'.format( r_pass_ticket, r_wap_sid2) mps = WxMps(r_id, r_mps_biz, r_pass_ticket, r_app_msg_token, r_cookie, r_last_msg_id) mps.start()