New In-Place (In-Situ) Datafile for English Premier League (/eng-england) - Use $ sportdb build

[Gerald Bauer]

Hello,

I've added a new in-place ("in-situ") datafile to the /eng-england
repo [1] e.g.:

################################################
# Datafile for England (and Wales)
#
# use (inside the eng-england/ folder)
# $ sportdb build

inline do
Country.parse 'eng', 'England', 'ENG', '130_395 km²', '53_013_000'
Country.parse 'wal', 'Wales', 'WAL', '20_779 km²', '3_064_000'
end

football 'eng-england'


Why? Now you can build, that is, read in the datasets into your SQL
database of choice with a single command (and with zero dependencies
on any other repos) e.g. use:

$ git clone https://github.com/openfootball/eng-england
$ cd eng-england
$ sportdb build # will use the local (in-place) ./Datafile

That's it. Try:

$ sqlite3 sportd.db

SQLite version 3.7.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite3> select * from teams;

1|chelsea|Chelsea||CHE|Chelsea FC|FC Chelsea|1||t|1905|//
London|www.chelseafc.com
2|arsenal|Arsenal||ARS|Arsenal FC|FC Arsenal|1||t|1886|//
London|www.arsenal.com
3|tottenham|Tottenham Hotspur||TOT|Tottenham|Spurs|1||t|1882|//
London|www.tottenhamhotspur.com
4|westham|West Ham United||WHU|West Ham|1||t|1895|// London|www.whufc.com
5|crystalpalace|Crystal Palace||CRY|C Palace|Palace|1||t|1905|//
London|www.cpfc.co.uk
6|manutd|Manchester United||MUN|Man Utd|Manchester U.|1||t|1878|//
Manchester|www.manutd.com
7|mancity|Manchester City||MCI|Man City|Man. City|1||t|1880|//
Manchester|www.mcfc.co.uk
8|everton|Everton||EVE|Everton FC|FC Everton|1||t|1878|//
Liverpool|www.evertonfc.com
9|liverpool|Liverpool||LIV|Liverpool FC|FC Liverpool|1||t|1892|//
Liverpool|www.liverpoolfc.com


And so on. If you try it out let us know how it goes. Questions,
comments as always welcome.

Cheers.

[1] github.com/openfootball/eng-england