def recover(self):
userName = self.receiveUsername()
result = UserController.getEmail(userName)
if result:
codigo = ''.join(
random.choice(string.ascii_uppercase + string.digits)
for _ in range(8))
MailUtil.sendRecovery(result, codigo)
self.connection.send({
"operacion": "RecoveryCode",
"resultado": "OK"
})
cod = self.connection.receive()
if (cod == codigo):
self.connection.send({
"operacion": "ChangePassword",
"resultado": "OK"
})
newPassword = self.connection.receiveLogin()
UserController.setNewPassword(userName, newPassword)
self.connection.send("Contraseña cambiada con éxito")
else:
self.connection.send({
"operacion": "ChangePassword",
"resultado": "ERROR"
})
# Hecho asi , hay una sola oportunidad para poner el codigo correctamente
else:
self.connection.send({
"operacion": "RecoveryCode",
"resultado": "ERROR"
})
def file2mysql(db, tableName, fileName):
if not os.path.exists(fileName):
return False
try:
# 获取文本文件中字段名称
f = open(fileName)
tablefiled = f.readline().split(" ")
tablefiled = ["id"] + tablefiled
# 从文本中提取数据
datalist = []
f = open(fileName)
for l in f.readlines()[1:]:
temp = [str(uuid.uuid1())]
temp.extend(l.split(" "))
datalist.append(temp)
# 判断datalist是否为空，为空的话则发邮件提醒
if len(datalist) == 0:
MailUtil.sendMail(configFile = "config/config_mail.ini",
section = "mail",
subject="旅游数据断流提醒",
context="文件空，文件名：" + fileName)
logging.info("文件空，文件名：" + fileName)
else:
# 将list格式数据插入数据库
insertDatas(db, tableName, tablefiled, datalist)
logging.info("Success to insert mysql. fileName is: " + fileName)
except:
logging.error("Error: unable to save to mysql. fileName is: " + fileName)
return True
def dayreport_generate(importdate):
try:
starttime = time.localtime(time.time())
conn = MySQLdb.connect(host='localhost',user='******',passwd='123456',db='stock',charset="utf8")
cursor = conn.cursor()
#importdate = time.strftime('%Y-%m-%d',time.localtime(time.time()))
#importdate='2015-11-13'
sql ="select * from stock_basic where code not in(select stockno from stock_day_report where importdate like'"+importdate+"%')"
cursor.execute(sql)
for stockrow in cursor.fetchall():
stockno = stockrow[0]
#stockno='600000'
stockname=stockrow[1]
print stockno+stockname
#获得同花顺的相关数据
#在这个地方增加循环的操作
#http://stockpage.10jqka.com.cn/realHead_v2.html#hs_600061
url = "http://stockpage.10jqka.com.cn/"+stockno
request = urllib2.Request(url)
response = urllib2.urlopen(request)
content = response.read()
soup = BeautifulSoup(content,'html5lib')
csvout = csv.writer(sys.stdout)
###获得主营业务
request = urllib2.Request("http://stockpage.10jqka.com.cn/"+stockno+"/operate/")
response = urllib2.urlopen(request)
contentZyyw = response.read()
soupZyyw = BeautifulSoup(contentZyyw,"html5lib")
csvout1 = csv.writer(sys.stdout)
cplxTag = soupZyyw.find("ul",class_="main_intro_list")
if cplxTag==None:
cplx = ""
else:
cplx = cplxTag.li.p.text
print cplx
sshySql= "select * from stock_industry_classified where code=\'"+stockno+"\'"
print sshySql
cursor.execute(sshySql)
sshy = ""
for rowSshy in cursor.fetchall():
sshy = rowSshy[3].strip()
print soup.find_all("dl", class_="company_details")
for content1 in soup.find_all("dl", class_="company_details"):
print "company_details"
print content1
for details in content1.find_all("dt"):
if details.string==unicode("所属地域：","utf-8"):
ssdy= details.next_sibling.next_sibling.string.strip()
print details.string+ssdy
elif details.string==unicode("涉及概念：","utf-8"):
sjgn = details.next_sibling.next_sibling["title"]
print sjgn
elif details.string==unicode("主营业务：","utf-8"):
zyyw = details.next_sibling.next_sibling.string
print zyyw
elif details.string==unicode("上市日期：","utf-8"):
sssj = details.next_sibling.next_sibling.string
print sssj
elif details.string==unicode("每股净资产：","utf-8"):
mgjzc = details.next_sibling.next_sibling.string[:-1]
print mgjzc[:-1]
elif details.string==unicode("每股收益：","utf-8"):
mgsy = details.next_sibling.next_sibling.string[:-1]
print mgsy[:-1]
elif details.string==unicode("净利润：","utf-8"):
jlr = details.next_sibling.next_sibling.string[:-2]
print jlr[:-2]
elif details.string==unicode("净利润增长率：","utf-8"):
jlrzzl = details.next_sibling.next_sibling.string[:-1]
print jlrzzl[:-1]
elif details.string==unicode("营业收入：","utf-8"):
yysr = details.next_sibling.next_sibling.string[:-2]
print yysr[:-2]
elif details.string==unicode("每股现金流：","utf-8"):
mgxjl = details.next_sibling.next_sibling.string[:-1]
print mgxjl[:-1]
elif details.string==unicode("每股公积金：","utf-8"):
mggjj = details.next_sibling.next_sibling.string[:-1]
print mggjj[:-1]
elif details.string==unicode("每股未分配利润：","utf-8"):
mgwfplr = details.next_sibling.next_sibling.string[:-1]
print mgwfplr[:-1]
elif details.string==unicode("总股本：","utf-8"):
zgb = details.next_sibling.next_sibling.string[:-1]
print zgb[:-1]
elif details.string==unicode("流通股：","utf-8"):
ltg = details.next_sibling.next_sibling.string[:-1]
print ltg[:-1]
#从东方财富抓取数据
if stockno[0:2]=="60":
dfUrl = "http://quote.eastmoney.com/sh"+stockno+".html"
else:
dfUrl = "http://quote.eastmoney.com/sz"+stockno+".html"
request = urllib2.Request(dfUrl)
response = urllib2.urlopen(request)
dfcontent = response.read()
dfSoup = BeautifulSoup(dfcontent,"lxml")
csvout = csv.writer(sys.stdout)
hxTableTag = dfSoup.find("table",id="rtp2")
print "hxtabletag"
print hxTableTag
if hxTableTag!=None:
trContent = hxTableTag.find_all("tr")
dtsyl = trContent[0].find_all("td")[1].text[6:]
sjl = trContent[1].find_all("td")[1].text[4:]
mlv = trContent[4].find_all("td")[0].text[4:][:-1]
jlv = trContent[4].find_all("td")[1].text[4:][:-1]
roe = trContent[5].find_all("td")[0].text[4:][:-1]
fzl = trContent[5].find_all("td")[1].text[4:][:-1]
zsz = trContent[6].find_all("td")[1].text[3:][:-1]
print "zsz"+zsz
ltsz = trContent[7].find_all("td")[1].text[3:][:-1]
print "jlv" +trContent[4].find_all("td")[1].text[4:]
#获得解禁时间
jjSql = "select min(jjsj) jjsj from stock_jjsj where stockno='"+stockno+"' and jjsj>='"+importdate+"'"
cursor.execute(jjSql)
jjRow = cursor.fetchone()
print jjRow
if jjRow[0] ==None:
jjsj = ""
else:
jjsj = jjRow[0]
#获得上月收盘价
#获得本日收盘价
#获得上个月
pre_month = dateutil.get_pre_month()
print pre_month
syspjSQL ="select * from stock_day_data where date=(select max(date) from stock_day_data where code='"+stockno+"' and left(date,7)='"+pre_month+"') and code='"+stockno+"' "
brspjSQL = "select * from stock_day_data where date like'"+importdate+"%' and code='"+stockno+"'"
cursor.execute(syspjSQL)
syspjRow = cursor.fetchone()
print syspjRow
if syspjRow==None:
syspj = ""
else:
syspj = str(syspjRow[4])
if syspj is None :
syspj=""
#本日收盘价
cursor.execute(brspjSQL)
brspjRow = cursor.fetchone()
print brspjRow
if None==brspjRow:
print "brspj"
brspj = ""
else:
brspj = str(brspjRow[4])
tenHolder = getTenHolder(stockno)
if tenHolder.find("'") !=-1:
tenHolder = tenHolder.replace("'", "\\'")
gdrs = getGdbhs(stockno)
insertsql = "insert into stock_day_report (stockno,stockname,importdate,ssdy,sjgn,cplx,sshy,sssj,mgjzc,mgsy,jlr,jlrzzl,yysr,mgxjl,mggjj,mgwfplr,zgb,ltg," \
"zsz,ltsz,sjl,dtsyl," \
"mlv,jlv,roe,fzl,jjsj,syspj,brspj,tenholder,gdrs" \
") " \
"values(\'"+stockno+"\',\'"+stockname+"\',\'"+importdate+"\',\'"+ssdy+"\',\'"+sjgn+"\',\'"+cplx+"\',\'"+sshy+"\',\'"+sssj+"\',\'"+mgjzc+"\',\'"+mgsy+"\',\'"+jlr+"\',\'"+jlrzzl+"\',\'"+yysr+"\',\'"+mgxjl+"\',\'"+mggjj+"\',\'"+mgwfplr+"\',\'"+zgb+"\',\'"+ltg+"\'," \
"\'"+zsz+"\',\'"+ltsz+"\',\'"+sjl+"\',\'"+dtsyl+"\',\'"+mlv+"\',\'"+jlv+"\',\'"+roe+"\',\'"+fzl+"\',\'"+jjsj+"\',\'"+syspj+"\',\'"+brspj+"\',\'"+tenHolder+"\',\'"+gdrs+"\')"
print insertsql
cursor.execute(insertsql)
conn.commit()
cursor.close()
df = pd.read_sql("select * from stock_day_report where importdate='"+importdate+"' and brspj!=0 order by sshy,ltg,zgb",conn)
df.rename(columns={'stockno':'股票代码','stockname':'股票名称','sshy':'所属行业','sjgn':'涉及概念','brspj':'本日收盘价','syspj':'上月收盘价','ltg':'流通股','zgb':'总股本','jlr':'净利润','yysr':'营业收入','mgjzc':'每股净资产','mgsy':'每股收益','jlrzzl':'净利润增长率','mgxjl':'每股现金流','mggjj':'每股公积金','mgwfplr':'每股未分配利润','dtsyl':'动态市盈率','sjl':'市净率','ltsz':'流通市值','zsz':'总市值','jjsj':'解禁时间','mlv':'毛利率','jlv':'净利率','roe':'ROE','fzl':'负债率','importdate':'导入日期','sssj':'上市时间','cplx':'产品类型','ssdy':'所属地域','lrzy':'利润总额','tenholder':'十大持股人','gdrs':'股东人数'}, inplace=True)
print df
#首先执行相关数据导入操作
df.to_csv('d:/'+importdate+'.csv',encoding='gbk', index=False)
if mailutil.send_mail("每日股票报告", importdate +"report", r"d:/"+importdate+".csv"):
print "1111"
else:
print "2222！"
except Exception,e:
print e.message
print e
#!/usr/bin/env python
import os
import MySQLdb
import sys
import MailUtil
#os.system("mmm_control show")
db_conn=MySQLdb.connect("host","user",'password','databasename')
db_cursor=db_conn.cursor()
db_cursor.execute("show processlist")
conncount=db_cursor.rowcount
#print conncount
if conncount>50:
MailUtil.sendNotification("Too many connection on database server,connections now:%d" % conncount)
#os.system("mmm_control set_offline db1");
pass
try:
oaCursor.execute("""(select t1.requestid,t2.currentnodeid
from formtable_main_11 t1
left join workflow_requestbase t2 on t1.requestid=t2.requestid
where t2.currentnodeid <> 261 and t1.bm is null )
union
(select t1.requestid,t2.currentnodeid
from formtable_main_15 t1
left join workflow_requestbase t2 on t1.requestid=t2.requestid
where t2.currentnodeid <> 270 and t1.bm is null )
""")
rows = oaCursor.fetchall()
if (len(rows) > 0):
mailTag = True
for row in rows:
mailText += str(row[0]) + " "
mailText += "流程无部门\n"
if mailTag:
MailUtil.sendTextMailTo(["*****@*****.**"], "销售订单表单检查",
mailText)
except Exception as e:
JobLog.logger.error("销售订单表单检查：%s".format(e), exc_info=True)
raise
finally:
oaCursor.close()
oaConn.close()
JobLog.logger.debug("销售订单表单检查：OA Database Disconnected")
