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')