def init_securities(df, security_type='stock', provider=Provider.EASTMONEY): db_engine = get_db_engine(store_category=StoreCategory.meta) security_schema = get_security_schema(security_type) current = get_securities(columns=[security_schema.id], provider=provider) df = df[~df['id'].isin(current['id'])] df.to_sql(security_schema.__tablename__, db_engine, index=False, if_exists='append')
def df_to_db(df, data_schema, provider): store_category = get_store_category(data_schema) db_engine = get_db_engine(provider, store_category=store_category) current = get_data(data_schema=data_schema, columns=[data_schema.id]) df = df[~df['id'].isin(current['id'])] df.to_sql(data_schema.__tablename__, db_engine, index=False, if_exists='append')
def init_securities(df, security_type='stock', provider=Provider.EASTMONEY): df = df.drop_duplicates(subset=['id']) data_schema = get_security_schema(security_type) store_category = get_store_category(data_schema=data_schema) db_engine = get_db_engine(provider, store_category=store_category) security_schema = get_security_schema(security_type) current = get_securities(security_type=security_type, columns=[security_schema.id], provider=provider) df = df[~df['id'].isin(current['id'])] df.to_sql(security_schema.__tablename__, db_engine, index=False, if_exists='append')