def update_uqer_factors(ds, **kwargs):
ref_date, _ = process_date(ds)
table = 'factor_uqer'
df = api.MktStockFactorsOneDayProGet(tradeDate=ref_date)
df.rename(columns={'tradeDate': 'Date', 'ticker': 'Code'}, inplace=True)
df.Code = df.Code.astype(int)
del df['secID']
engine1.execute("delete from {0} where Date = '{1}';".format(table, ref_date))
df.to_sql(table, engine1, index=False, if_exists='append')
table = 'uqer'
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_factors(ds, **kwargs):
ref_date, this_date = process_date(ds)
flag = check_holiday(this_date)
if not flag:
return
df = api.MktStockFactorsOneDayProGet(tradeDate=ref_date)
df.rename(columns={
'tradeDate': 'trade_date',
'ticker': 'code'
},
inplace=True)
df.code = df.code.astype(int)
del df['secID']
query = delete(Uqer).where(Uqer.trade_date == this_date)
engine.execute(query)
data_info_log(df, Uqer)
format_data(df, format='%Y-%m-%d')
df.to_sql(Uqer.__table__.name, engine, index=False, if_exists='append')
