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