hackingthemarkets / ark-funds-tracker Goto Github PK

Hi Larry, Thanks a lot for your fantastic videos. I just run your 'populate_etf.py'-script and face some issues with dublicate keys in the DB:

PRNT
ARKF
ARKQ
ARKG
Traceback (most recent call last):
File "c:\Users\katsu\VC Code\Ark track\populate_etf.py", line 35, in
cursor.execute("""
File "C:\Users\katsu\AppData\Local\Programs\Python\Python39\lib\site-packages\psycopg2\extras.py", line 146, in execute
return super(DictCursor, self).execute(query, vars)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "etf_holding_pkey"
DETAIL: Key (etf_id, holding_id, dt)=(36, 10124, 2021-02-05) already exists.

Have you seen similar issues and is there an easy way to work around it?

please help
when executing this command: docker exec -it timescaledb
I am getting :
Error: No such container: timescaledb

what I am missing here?

docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
fb2c42e7ce16 tradekit-main_web "uvicorn web.main:ap…" 8 hours ago Up 8 hours 0.0.0.0:8000->80/tcp tradekit-main_web_1
72e3fd4f55ef timescale/timescaledb:latest-pg12 "docker-entrypoint.s…" 8 hours ago Up 8 hours 0.0.0.0:5432->5432/tcp timescale
c50ce03b742f docker/getting-started "nginx -g 'daemon of…" 8 hours ago Up 8 hours 0.0.0.0:80->80/tcp elated_perlman

docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
tradekit-main_web latest 8b0769c6346e 8 hours ago 6.2GB
timescale/timescaledb latest-pg12 317be8f7278e 10 days ago 190MB
docker/getting-started latest 3c156928aeec 10 months ago 24.8MB