def update_uqer_universe_security_master(ds, **kwargs):
ref_date, this_date = process_date(ds)
flag = check_holiday(this_date)
if not flag:
return
df = api.EquGet(equTypeCD='A')
if df.empty:
return
query = delete(SecurityMaster)
engine.execute(query)
df = df[df.ticker.str.len() <= 6]
df['code'] = df.ticker.astype(int)
df['listDate'] = pd.to_datetime(df['listDate'], format='%Y-%m-%d')
df['endDate'] = pd.to_datetime(df['endDate'], format='%Y-%m-%d')
df['delistDate'] = pd.to_datetime(df['delistDate'], format='%Y-%m-%d')
del df['ticker']
del df['secID']
data_info_log(df, SecurityMaster)
df.to_sql(SecurityMaster.__table__.name,
engine,
index=False,
if_exists='append')
def update_stock(self):
pdb.set_trace()
stock_df = DataAPI.EquGet(secID=u"",
ticker=u"",
equTypeCD=u"A",
listStatusCD=u"",
field=u"secID,ticker",
pandas="1")
stock_df = stock_df[:-1]
stock_df = stock_df.rename(columns={'ticker': 'code'})
stock_df['code'] = stock_df['code'].apply(lambda x: int(x))
stock_df.to_csv('stock_info.csv', encoding='UTF-8')
