def update_price(ticker, interval, size, chk_for_duplicate=True):
count_duplicate = 0
count_create = 0
df_prices = av.get_prices(cfg.AV_APIKEY, ticker, interval, size)
if chk_for_duplicate:
for i in range(0, len(df_prices)):
if not pg.is_price_duplicate(ticker, interval,
df_prices[pg._COL_DATETIME][i]):
print(
f'{ticker} ({interval}) price on {str(df_prices[pg._COL_DATETIME][i])} created : {df_prices.iloc[i, :].values}'
)
pg.create_prices([df_prices.iloc[i, :].values])
count_create += 1
else:
print(
f'Duplicate {ticker} ({interval}) price on {str(df_prices[pg._COL_DATETIME][i])}'
)
count_duplicate += 1
else:
# To be used for batch imports or initialization
pg.create_prices(df_prices.values)
return count_create, count_duplicate
def update_price(ticker, interval, size):
count_duplicate = 0
count_create = 0
df_prices = av.get_prices(cfg.AV_APIKEY, ticker, interval, size)
for i in range(0, len(df_prices)):
if not pg.is_price_duplicate(ticker, interval,
df_prices[pg._COL_DATETIME][i]):
print(
f'{ticker} ({interval}) price on {str(df_prices[pg._COL_DATETIME][i])} created : {df_prices.iloc[i, :].values}'
)
pg.create_prices([df_prices.iloc[i, :].values])
count_create += 1
else:
print(
f'Duplicate {ticker} ({interval}) price on {str(df_prices[pg._COL_DATETIME][i])}'
)
count_duplicate += 1
return count_create, count_duplicate