search

mcekovic / tennis-crystal-ball

Ultimate Tennis Statistics and Tennis Crystal Ball - Tennis Big Data Analysis and Prediction
Apache License 2.0
240 stars 34 forks source link

updating postgres database #366

Open blakehattingh opened 2 years ago

blakehattingh commented 2 years ago

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

mcekovic commented 2 years ago

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