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