tennis-crystal-ball icon indicating copy to clipboard operation
tennis-crystal-ball copied to clipboard

updating postgres database

Open blakehattingh opened this issue 2 years ago • 1 comments

I currently have the postgres database set up and populated - I set it up earlier this year. I am now looking to update the database, however when I run the dataload command on step 12 of #232 It throws errors. I am wondering if there is an alternative way to update the database or whether you could help with fixing the errors.

below is the error I am currently getting.

Loading Tennis Data Allocating DB connections.......... Loading players Loading file 'tennis_atp\atp_players.csv' Exception in thread "main" java.lang.Exception: Error processing record player_id: player_id, first_name: name_first, last_name: name_last, hand: hand, dob: dob, country: ioc at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)............

blakehattingh avatar Nov 15 '21 05:11 blakehattingh

Update is supported only with the state if Jeff Sackmann repo at the beginning of 2021. As the repo changes, it may break the UTS load.

As an alternative, you can refer the the UTS pre-populated database available as Docker image: https://github.com/mcekovic/tennis-crystal-ball/issues/337

mcekovic avatar Jan 27 '22 17:01 mcekovic