def __init__(self):
# Postgres
host, port = 'localhost', 12432
db_name = 'scrapy'
self.postgres = pgs.Pgs(host=host, port=port, db_name=db_name, user=db_name, password=db_name)
# Redis
self.redis = rds.Rds(host=host, port=12379, db=2, password='******').redis_cli
def __init__(self):
# PostgreSQL
host = 'localhost'
port = 12432
scrapy = 'scrapy'
self.postgres = pgs.Pgs(host=host,
port=port,
db_name=scrapy,
user=scrapy,
password=scrapy)
# Redis
self.redis = rds.Rds(host=host, port=12379, db=1,
password='******').redis_cli
class Planet(object):
log.Logger()
# Postgres配置
host = 'localhost'
pgs_port = 12432
pgs_db_name = 'planet'
pgs_user = pgs_db_name
pgs_pwd = pgs_db_name
postgres = pgs.Pgs(host=host,
port=pgs_port,
db_name=pgs_db_name,
user=pgs_user,
password=pgs_pwd,
singleton=False)
# Redis配置
rds_port = 12379
rds_pwd = 'redis6379'
redis = rds.Rds(host=host, port=rds_port, password=rds_pwd).redis_cli
my_hash = None
my_user_id = None
headers = {
"User-Agent":
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36",
}
def __init__(self):
self.redis = Planet.redis
self.postgres = Planet.postgres
self.__get_my_info()
logging.info('Init my hash : %s and my user id : %s', Planet.my_hash,
Planet.my_user_id)
def handler(self, sql, params):
""" 处理数据
:param sql:
:param params:
:return:
"""
return self.postgres.handler(sql, params)
def __get_my_info(self):
"""获取个人info"""
key = 'planet:my:token'
Planet.headers['Authorization'] = "token " + self.redis.get(key)
api = 'https://www.quanquanyuanyuan.cn/huodong/dog/api/my-dog-hash'
resp = requests.post(api, json={}, headers=Planet.headers).json()
Planet.my_hash = resp['uid_hash']
Planet.my_user_id = resp['user_id']
def __init__(self):
# PostgreSQL
host = 'localhost'
port = 12432
db_name = 'scrapy'
username = db_name
password = db_name
self.postgres = pgs.Pgs(host=host,
port=port,
db_name=db_name,
user=username,
password=password)
# Redis
self.redis = rds.Rds(host=host, port=12379, db=1,
password='******').redis_cli
def redis_ip():
return rds.Rds(host=host, port=redis_port, db=14,
password=redis_pwd).redis_cli
class Planet(object):
log.Logger()
# Postgres配置
host = 'localhost'
pgs_port = 12432
pgs_db_name = 'planet'
pgs_user = pgs_db_name
pgs_pwd = pgs_db_name
postgres = pgs.Pgs(host=host,
port=pgs_port,
db_name=pgs_db_name,
user=pgs_user,
password=pgs_pwd,
singleton=False)
# Redis配置
rds_port = 12379
rds_pwd = 'redis6379'
redis = rds.Rds(host=host, port=rds_port, password=rds_pwd).redis_cli
my_hash = None
my_user_id = None
headers = {}
def __init__(self):
self.redis = Planet.redis
self.postgres = Planet.postgres
self.__get_my_hash()
self.__get_my_token()
self.__get_my_user_id()
logging.info('Init my hash : %s and my user id : %s', Planet.my_hash,
Planet.my_user_id)
def handler(self, sql, params):
""" 处理数据
:param sql:
:param params:
:return:
"""
return self.postgres.handler(sql, params)
def __get_my_user_id(self):
"""获取userId值"""
if not Planet.my_user_id:
key = 'planet:my:uid'
Planet.my_user_id = self.redis.get(key)
if not Planet.my_user_id:
api = 'https://www.quanquanyuanyuan.cn/huodong/dog/api/my-status'
resp = requests.post(api, json={},
headers=Planet.headers).json()
Planet.my_user_id = resp['notification_settings'][0]['user_id']
self.redis.set(key, Planet.my_user_id)
def __get_my_hash(self):
"""获取hash值"""
if not Planet.my_hash:
key = 'planet:my:hash'
Planet.my_hash = self.redis.get(key)
if not Planet.my_hash:
api = 'https://www.quanquanyuanyuan.cn/huodong/dog/api/my-dog-hash'
resp = requests.post(api, json={},
headers=Planet.headers).json()
Planet.my_hash = resp['uid_hash']
self.redis.set(key, Planet.my_hash)
def __get_my_token(self):
"""获取token值"""
key = 'planet:my:token'
Planet.headers['Authorization'] = self.redis.get(key)
import random
import itchat
from utils import match_util
from utils import rds
from blogs import read
from utils import robot
redis = rds.Rds(port=12379, db=15, password='******').redis_cli
js = "js:" # 简书统计获取标志
key = 'turing:{0}'
cmd = redis.get(key.format('cmd'))
jared = redis.get(key.format('jared'))
hello = redis.get(key.format('hello'))
bye = redis.get(key.format('bye'))
ex = int(redis.get(key.format('ex')))
@itchat.msg_register(itchat.content.TEXT)
def reply(msg):
"""注册微信文本消息
:param msg: 消息
:return: 回应消息
"""
receive_text = msg['Text']
to_user_id = msg['ToUserName'] # 接收人
from_user_id = msg['FromUserName'] # 发送人
if receive_text.__contains__(js):
def redis():
return rds.Rds(host='localhost', port=12379, db=14,
password='******').redis_cli
def __init__(self) -> None:
self.redis = rds.Rds(host='localhost',
port=12379,
db=5,
password='******').redis_cli
