def update_uqer_halt_list(ds, **kwargs): ref_date, _ = process_date(ds) table = 'halt_list' df = api.SecHaltGet(beginDate=ref_date, endDate=ref_date) df = df[df.assetClass == 'E'] df['Date'] = ref_date df.rename(columns={'ticker': 'Code'}, inplace=True) df.Code = df.Code.astype(int) del df['secID'] engine2.execute("delete from {0} where Date = '{1}';".format(table, ref_date)) df.to_sql(table, engine2, index=False, if_exists='append')
def update_uqer_halt_list(ds, **kwargs): ref_date, this_date = process_date(ds) flag = check_holiday(this_date) if not flag: return df = api.SecHaltGet(beginDate=ref_date, endDate=ref_date) df = df[df.assetClass == 'E'] df['trade_date'] = ref_date df.rename(columns={'ticker': 'code'}, inplace=True) df.code = df.code.astype(int) del df['secID'] query = delete(HaltList).where(HaltList.trade_date == this_date) engine.execute(query) data_info_log(df, HaltList) format_data(df) df.to_sql(HaltList.__table__.name, engine, index=False, if_exists='append')