def push_msg(name, price, percent, status):
cfg = Toolkit.getUserData('data.cfg')
from_mail = cfg['from_mail']
password = cfg['password']
to_mail = cfg['to_mail']
obj = MailSend('smtp.qq.com', from_mail, password, to_mail)
obj.send_txt(name, price, percent, status)
def Aliyun(self):
passwd = Toolkit.getUserData('data.cfg')['alipasswd']
print(passwd)
conn = pymysql.connect(host='', # 远程主机的ip地址，
user='', # MySQL用户名
db='', # database名
passwd=passwd, # 数据库密码
port=3306, # 数据库监听端口，默认3306
charset="utf8") # 指定utf8编码的连接
cursor = conn.cursor()
cursor.execute('SELECT VERSION()')
data = cursor.fetchone()
print(data)
# 已经连通了，可以开搞。
id = 31
cmd1 = "insert into `aws_user_action_history_data`(`history_id`,`associate_content`,`associate_attached`,`addon_data`) values ('%d','huati','',''),('%d','','',''),('%d','Rocky-Title','ROCK-Content','')" % (
id, id + 1, id + 2)
cursor.execute(cmd1)
# conn.commit()
topic_id = 7
title = "Hello" + str(topic_id)
cmd2 = "insert into `aws_topic`(`topic_id`,`topic_title`,`add_time`,`discuss_count`,`topic_description`,`topic_pic`,`topic_lock`,`focus_count`,`user_related`,`url_token`,`merged_id`,`seo_title`,`parent_id`,`is_parent`,`discuss_count_last_week`,`discuss_count_last_month`,`discuss_count_update`) values('%d','huati5','1493370061','1','',null,'0','1','0',null,'0',null,'0','0','1','1','1493370061')" % topic_id
cursor.execute(cmd2)
# cursor.commit()
arti_id = 5
cmd3 = "insert into `aws_article`(`id`,`uid`,`title`,`message`,`comments`,`views`,`add_time`,`has_attach`,`lock`,`votes`,`title_fulltext`,`category_id`,`is_recommend`,`chapter_id`,`sort`) values('%d','1','ddThe Rocky23 IC ************TITLE','dddThe Rocky IC Content !!!!!!!!','0','1','1493370061','0','0','0','ic title','1','0',null,'0')" % arti_id
cursor.execute(cmd3)
# cursor.commit()
cmd4 = "insert into `aws_topic_relation`(`id`,`topic_id`,`item_id`,`add_time`,`uid`,`type`) values('3','4','3','1493370061','1','article')"
# cursor.execute(cmd4)
conn.commit()
conn.close()
def push_msg(name, price, percent, status):
cfg = Toolkit.getUserData('data.cfg')
from_mail = cfg['from_mail']
password = cfg['password']
to_mail = cfg['to_mail']
obj = MailSend('smtp.qq.com', from_mail, password, to_mail)
obj.send_txt(name, price, percent, status)
def save_sql(self):
data = Toolkit.getUserData()
sql_pwd = data['mysql_password']
self.engine = create_engine(
'mysql://*****:*****@localhost/daily_data?charset=utf8' % sql_pwd)
self.df_today_all = ts.get_today_all()
self.df_today_all.to_sql(self.today, self.engine)
def save_sql(self):
cfg_file=os.path.join(os.path.dirname(__file__),'data.cfg')
data=Toolkit.getUserData(cfg_file)
sql_pwd=data['MYSQL_PASSWORD']
self.engine=create_engine('mysql+pymysql://root:%s@localhost/db_daily?charset=utf8' %sql_pwd)
# self.df_today_all=ts.get_today_all()
self.df_today_all.to_sql(self.today,self.engine,if_exists='replace')
def __init__(self):
self.host = 'http://www.jubi.com'
with open('coin_list.cfg') as f:
c_content = f.read()
self.d_content = json.loads(c_content)
# x=zip(* d_content)
# print x
#为什么得不到想要的结果?
self.coin_list = self.d_content.keys()
self.coin_name = self.d_content.values()
self.private_key = Toolkit.getUserData('data.cfg')['private_key']
self.public_key = Toolkit.getUserData('data.cfg')['public_key']
self.md5 = self.getHash(self.private_key)
def quanshan():
data = Toolkit.getUserData('data.cfg')
print data
ts.set_broker('htzq', user=data['huatai'], passwd=data['huatai_passwd'])
ts.get_broker()
htzq = ts.TraderAPI('htzq')
htzq.login()
info = htzq.baseinfo()
print info
def save_sql(self):
cfg_file = os.path.join(os.path.dirname(__file__), 'data.cfg')
data = Toolkit.getUserData(cfg_file)
sql_pwd = data['MYSQL_PASSWORD']
self.engine = create_engine(
'mysql+pymysql://root:%s@localhost/db_daily?charset=utf8' %
sql_pwd)
# self.df_today_all=ts.get_today_all()
self.df_today_all.to_sql(self.today, self.engine, if_exists='replace')
def __init__(self):
cfg = Toolkit.getUserData("data.cfg")
self.public_key = cfg['public_key']
self.private_key = cfg['private_key']
self.w_name = u'Stefan'
itchat.auto_login(hotReload=True)
account = itchat.get_friends(self.w_name)
for i in account:
# print("pinyin: ",i[u'PYQuanPin'])
if i[u'PYQuanPin'] == self.w_name:
self.toName = i['UserName']
def __init__(self):
cfg = Toolkit.getUserData('data.cfg')
self.public_key = cfg['public_key']
self.private_key = cfg['private_key']
self.host = 'https://www.jubi.com'
self.coin_list = [
'IFC', 'DOGE', 'EAC', 'DNC', 'MET', 'ZET', 'SKT', 'YTC', 'PLC',
'LKC', 'JBC', 'MRYC', 'GOOC', 'QEC', 'PEB', 'XRP', 'NXT', 'WDC',
'MAX', 'ZCC', 'HLB', 'RSS', 'PGC', 'RIO', 'XAS', 'TFC', 'BLK',
'FZ', 'ANS', 'XPM', 'VTC', 'KTC', 'VRC', 'XSGS', 'LSK', 'PPC',
'ETC', 'GAME', 'LTC', 'ETH', 'BTC'
]
def turnover(self, coin):
i = coin.lower()
coins = Toolkit.getUserData('coins.csv')
total = long(coins[i])
p = self.getOrder(i)
print(p)
amount = 0.00
for j in p:
t = j['amount']
amount = float(t) + amount
#current=float(self.real_time_ticker(i)['last'])
turn_over = amount * 1.00 / total * 100
print(turn_over)
def xueqiu_login_url():
xueqiu_login_url = 'https://xueqiu.com/snowman/login'
agent = 'Mozilla/5.0 (Windows NT 5.1; rv:33.0) Gecko/20100101 Firefox/33.0'
headers = {
'Host': 'xueqiu.com',
'Referer': 'https://xueqiu.com/',
'Origin': 'https://xueqiu.com',
'User-Agent': agent
}
account = Toolkit.getUserData('data.cfg')
data = {
'username': account['snowball_user'],
'password': account['snowball_password']
}
s = session.post(xueqiu_login_url, data=data, headers=headers)
def send_139():
cfg = Toolkit.getUserData('data.cfg')
sender = cfg['mail_user']
passwd = cfg['mail_pass']
receiver = cfg['receiver']
msg = MIMEText('Python mail test', 'plain', 'utf-8')
msg['From'] = Header('FromTest', 'utf-8')
msg['To'] = Header('ToTest', 'utf-8')
subject = 'Python SMTP Test'
msg['Subject'] = Header(subject, 'utf-8')
try:
obj = smtplib.SMTP()
obj.connect('smtp.126.com', 25)
obj.login(sender, passwd)
obj.sendmail(sender, receiver, msg.as_string())
except smtplib.SMTPException, e:
print(e)
def __init__(self, send=None):
cfg = Toolkit.getUserData('data.cfg')
self.public_key = cfg['public_key']
self.private_key = cfg['private_key']
self.send = send
from_mail = cfg['from_mail']
password = cfg['password']
to_mail = cfg['to_mail']
smtp_server = 'smtp.qq.com'
self.server = smtp_server
self.username = from_mail.split("@")[0]
self.from_mail = from_mail
self.password = password
self.to_mail = to_mail
self.coin_list = [
'IFC', 'DOGE', 'EAC', 'DNC', 'MET', 'ZET', 'SKT', 'YTC', 'PLC',
'LKC', 'JBC', 'MRYC', 'GOOC', 'QEC', 'PEB', 'XRP', 'NXT', 'WDC',
'MAX', 'ZCC', 'HLB', 'RSS', 'PGC', 'RIO', 'XAS', 'TFC', 'BLK',
'FZ', 'ANS', 'XPM', 'VTC', 'KTC', 'VRC', 'XSGS', 'LSK', 'PPC',
'ETC', 'GAME', 'LTC', 'ETH', 'BTC'
]
# 初始化邮箱设置读取需要股票信息
# 这样子只登陆一次
if self.send == 'msn':
try:
self.smtp = smtplib.SMTP_SSL(port=465)
self.smtp.connect(self.server)
self.smtp.login(self.username, self.password)
except smtplib.SMTPException as e:
print(e)
return 0
if send == 'wechat':
self.w_name = 'wwwei'
self.w_name1 = 'aiweichuangyi'
itchat.auto_login(hotReload=True)
account = itchat.get_friends(self.w_name)
for i in account:
if i['PYQuanPin'] == self.w_name:
self.toName = i['UserName']
#print(self.toName)
if i['PYQuanPin'] == self.w_name1:
self.toName1 = i['UserName']
# -*-coding=utf-8-*-
from toolkit import Toolkit
from sqlalchemy import create_engine
import redis
import MySQLdb
MYSQL_USER = Toolkit.getUserData('data.cfg')['MYSQL_USER']
MYSQL_PASSWORD = Toolkit.getUserData('data.cfg')['MYSQL_PASSWORD']
MYSQL_HOST = Toolkit.getUserData('data.cfg')['MYSQL_HOST']
MYSQL_PORT = Toolkit.getUserData('data.cfg')['MYSQL_PORT']
REDIS_HOST = 'localhost'
def get_engine(db):
engine = create_engine(
'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format(
MYSQL_USER, MYSQL_PASSWORD, MYSQL_HOST, MYSQL_PORT, db))
return engine
def get_mysql_conn(db):
conn = MySQLdb.connect(MYSQL_HOST,
MYSQL_USER,
MYSQL_PASSWORD,
db,
charset='utf8')
return conn
# -*-coding=utf-8-*-
from toolkit import Toolkit
from sqlalchemy import create_engine
import redis
import os
import MySQLdb
cfg_file=os.path.join(os.path.dirname(__file__),'data.cfg')
MYSQL_USER = Toolkit.getUserData(cfg_file)['MYSQL_USER']
MYSQL_REMOTE_USER = Toolkit.getUserData(cfg_file)['MYSQL_REMOTE_USER']
MYSQL_PASSWORD = Toolkit.getUserData(cfg_file)['MYSQL_PASSWORD']
MYSQL_HOST = Toolkit.getUserData(cfg_file)['MYSQL_HOST']
MYSQL_REMOTE = Toolkit.getUserData(cfg_file)['MYSQL_REMOTE']
MYSQL_PORT = Toolkit.getUserData(cfg_file)['MYSQL_PORT']
REDIS_HOST='localhost'
EMAIL_USER = Toolkit.getUserData(cfg_file)['EMAIL_USER']
EMAIL_PASS = Toolkit.getUserData(cfg_file)['EMAIL_PASSWORD']
SMTP_HOST = Toolkit.getUserData(cfg_file)['SMTP_HOST']
FROM_MAIL = Toolkit.getUserData(cfg_file)['FROM_MAIL']
TO_MAIL = Toolkit.getUserData(cfg_file)['TO_MAIL']
def get_engine(db):
engine = create_engine('mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format(MYSQL_USER, MYSQL_PASSWORD, MYSQL_HOST, MYSQL_PORT, db))
return engine
def get_mysql_conn(db):
conn = MySQLdb.connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASSWORD,db,charset='utf8')
return conn
from lxml import etree
url='https://xueqiu.com/snowman/login'
session = requests.session()
session.cookies = cookielib.LWPCookieJar(filename="cookies")
try:
session.cookies.load(ignore_discard=True)
except:
print("Cookie can't load")
agent = 'Mozilla/5.0 (Windows NT 5.1; rv:33.0) Gecko/20100101 Firefox/33.0'
headers = {'Host': 'xueqiu.com',
'Referer': 'https://xueqiu.com/',
'Origin':'https://xueqiu.com',
'User-Agent': agent}
account=Toolkit.getUserData('data.cfg')
print(account['snowball_user'])
print(account['snowball_password'])
data={'username':account['snowball_user'],'password':account['snowball_password']}
s=session.post(url,data=data,headers=headers)
print(s.status_code)
#print(s.text)
session.cookies.save()
fav_temp='https://xueqiu.com/favs?page=1'
collection=session.get(fav_temp,headers=headers)
fav_content= collection.text
p=re.compile('"maxPage":(\d+)')
maxPage=p.findall(fav_content)[0]
#目前也只是第一页而已
print(maxPage)
def __init__(self):
Toolkit.getUserData()
def __init__(self):
Toolkit.getUserData()
# -*-coding=utf-8-*-
from toolkit import Toolkit
from sqlalchemy import create_engine
import redis
import os
import MySQLdb
cfg_file = os.path.join(os.path.dirname(__file__), 'data.cfg')
MYSQL_USER = Toolkit.getUserData(cfg_file)['MYSQL_USER']
MYSQL_REMOTE_USER = Toolkit.getUserData(cfg_file)['MYSQL_REMOTE_USER']
MYSQL_PASSWORD = Toolkit.getUserData(cfg_file)['MYSQL_PASSWORD']
MYSQL_HOST = Toolkit.getUserData(cfg_file)['MYSQL_HOST']
MYSQL_REMOTE = Toolkit.getUserData(cfg_file)['MYSQL_REMOTE']
MYSQL_PORT = Toolkit.getUserData(cfg_file)['MYSQL_PORT']
REDIS_HOST = 'localhost'
EMAIL_USER = Toolkit.getUserData(cfg_file)['EMAIL_USER']
EMAIL_PASS = Toolkit.getUserData(cfg_file)['EMAIL_PASSWORD']
SMTP_HOST = Toolkit.getUserData(cfg_file)['SMTP_HOST']
FROM_MAIL = Toolkit.getUserData(cfg_file)['FROM_MAIL']
TO_MAIL = Toolkit.getUserData(cfg_file)['TO_MAIL']
def get_engine(db):
engine = create_engine(
'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'.format(
MYSQL_USER, MYSQL_PASSWORD, MYSQL_HOST, MYSQL_PORT, db))
return engine
def get_mysql_conn(db):
except Exception as e:
print(e)
finally:
return data
def login(self):
postdata = self.get_info()
postdata['loginname'] = self.un
postdata['nloginpwd'] = self.pw
postdata['loginpwd'] = self.pw
try:
self.headers['Host'] = 'passport.jd.com'
self.headers['Origin'] = 'https://passport.jd.com'
self.headers['X-Requested-With'] = 'XMLHttpRequest'
login_page = self.session.post(self.post_url,
data=postdata,
headers=self.headers)
print(login_page.text) #若返回{“success”:”http://www.jd.com”}，说明登录成功
except Exception as e:
print(e)
if __name__ == "__main__":
#username = input("plz enter username:"******"plz enter password:")
username = Toolkit.getUserData('data.cfg')['jd_username']
password = Toolkit.getUserData('data.cfg')['jd_password']
print username, password
JD = JDlogin(username, password)
JD.login()
