Re: [Pharo-users] World Cup 2018 with Glorp : SQL dump for SQLite : wc2018.sql

On Thu, Oct 11, 2018 at 06:45:07PM +0200, H. Hirzel wrote:

Hi Pierce

In your blog entry 'World Cup 2018 with Glorp' you write about an SQL dump file wc2018.sql and mention a repo?

https://github.com/openfootball/world-cup/tree/master/2018--russia

seems to be a candidate, but on SQL.

In which repo is it?

Hi Hannes, I built SQLite databases from the data in https://github.com/openfootball/datafile.git, then generated the SQLite dump files, which went into the 'data' directory in my repo https://github.com/PierceNg/footballdb-Glorp. I don't remember whether the WC 2018 dump file has the match results, but the WC 2014 one ought to contain the full tournament data. Pierce