def fundrisk(innercode, checkdate):
"""
innercode from url:param innercode:
checkdate from url:param checkdate:
reult fundrisk with json type:return:
"""
innercodeCalc, result = ca.reshape_innercode(innercode=innercode, checkdate=checkdate, cache=ca.fundRiskCache)
"""
check the cache for the expected short fall already existed
"""
#innercodeCalc=innercode
result = df(result,columns=('innercode', 'es'))
if len(innercodeCalc) != 0:
startdate = datetime.strptime(checkdate, '%Y-%m-%d') - timedelta(days=730)
query = """select
financedata.ana_fnd_nav_calc.TRADEDATE,
financedata.ana_fnd_nav_calc.fac_unit_net,
financedata.ana_fnd_nav_calc.INNER_CODE
from
financedata.ana_fnd_nav_calc
where
financedata.ana_fnd_nav_calc.inner_code in ( %s )
and
financedata.ana_fnd_nav_calc.tradedate<= '%s'
and
financedata.ana_fnd_nav_calc.tradedate>= '%s'
""" % (','.join(innercodeCalc), checkdate, startdate.strftime('%Y-%m-%d'))
"""
asseemble the query
"""
indexPrice = GetDataFromDB(config, query)
indexPrice.columns = ['tradedate', 'close', 'innercode']
"""
get date from db
"""
grouped = indexPrice.groupby('innercode')
result_new = df(columns=('innercode', 'es'))
for i in innercodeCalc:
try:
dataForCalc = grouped.get_group(int(i))
es = cr.es(dataForCalc['tradedate'], dataForCalc['close'])
result_new.loc[len(result_new.index)]=[i,es]
except KeyError:
es = ''
result_new.loc[len(result_new.index)]=[i,es]
"""
constract the result maxtrix which innercode cannot be found in database
with empty es
"""
#save cache for new data
ca.set_cache(result_new=result_new, checkdate=checkdate,cache=ca.fundRiskCache)
"""
save the result in cache
"""
result = result.append(result_new,ignore_index=1)
result['checkdate'] = checkdate
else:
result['checkdate'] = checkdate
return (result.to_json(orient='index'))