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 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()
# -*-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()