Unable to build en-england repo

mai...@gmail.com

unread,

Feb 4, 2015, 5:28:37 AM2/4/15

to open...@googlegroups.com

Hi Gerald,

I have been able to build the entire SQLite db successfully using the alternative method. I have tried for several days to build the en-england database, but it does not seem to work. I get the same error when trying both the rake script and sportdb command. I am a newbie to Ruby, but I am learning the language to understand the code.

The trace is listed below:

* When using Sportdb command: sportdb --dbname football.db update --include en-england

activerecord-utils/0.3.0 (activerecord/4.2.0) on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Country<

[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Region<

[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::City<

fetcher/0.4.4 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

datafile/0.1.1 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

sportdb-update/0.1.1 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

sportdb-service/0.4.0 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

sportdb/1.11.0 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

working directory: D:/Insights/openfootball

Connecting to db using settings:

{:adapter=>"sqlite3", :database=>"./football.db"}

[info] parsing data (setup) 'setups/all' (en-england/setups/all.txt)...

*** error: Couldn't find WorldDb::Model::Country

* When using the rake build command: rake build DATA=en --trace

before require 'active_record'

after require 'active_record'

before require 'active_support/all'

after require 'active_support/all'

before require 'worlddb'

activerecord-utils/0.3.0 (activerecord/4.2.0) on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Country<

[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Region<

[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::City<

after require 'worlddb'

before require 'sportdb'

fetcher/0.4.4 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

datafile/0.1.1 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

sportdb-update/0.1.1 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

sportdb-service/0.4.0 on Ruby 1.9.3 (2014-11-13) [i386-mingw32]

after require 'sportdb'

importing task >./tasks/about.rake<...

importing task >./tasks/basics/assocs.rake<...

importing task >./tasks/basics/grounds.rake<...

importing task >./tasks/basics/players.rake<...

importing task >./tasks/book.rake<...

importing task >./tasks/check.rake<...

importing task >./tasks/dump.rake<...

importing task >./tasks/logs.rake<...

importing task >./tasks/setups/admin.rake<...

importing task >./tasks/setups/all.rake<...

importing task >./tasks/setups/at.rake<...

importing task >./tasks/setups/cl.rake<...

importing task >./tasks/setups/copaamerica.rake<...

importing task >./tasks/setups/copalibertadores.rake<...

importing task >./tasks/setups/copasudamericana.rake<...

importing task >./tasks/setups/de.rake<...

importing task >./tasks/setups/en.rake<...

importing task >./tasks/setups/es.rake<...

importing task >./tasks/setups/eurocup.rake<...

importing task >./tasks/setups/fr.rake<...

importing task >./tasks/setups/goldcup.rake<...

importing task >./tasks/setups/history.rake<...

importing task >./tasks/setups/it.rake<...

importing task >./tasks/setups/mls.rake<...

importing task >./tasks/setups/northamericachampionsleague.rake<...

importing task >./tasks/setups/worldcup.rake<...

importing task >./tasks/stats/alltime.rake<...

importing task >./tasks/stats/matches.rake<...

importing task >./tasks/stats/standings.rake<...

importing task >./tasks/stats/stats.rake<...

using DATA_KEY >en<

{"adapter"=>"sqlite3", "database"=>"./build/football.db"}

-- create_table(:logs)

-> 2.0410s

-- create_table(:props)

-> 0.0625s

-- create_table(:tags)

-> 0.0675s

-- add_index(:tags, :key, {:unique=>true})

-> 0.0650s

-- create_table(:taggings)

-> 0.0650s

-- add_index(:taggings, :tag_id)

-> 0.0575s

-- add_index(:taggings, [:taggable_id, :taggable_type])

-> 0.0575s

-- add_index(:taggings, [:taggable_id, :taggable_type, :tag_id], {:unique=>true})

-> 0.0650s

-- create_table(:places)

-> 0.0650s

-- create_table(:names)

-> 0.2700s

-- create_table(:continents)

-> 0.0625s

-- add_index(:continents, :key, {:unique=>true})

-> 0.0625s

-- create_table(:country_codes)

-> 0.2850s

-- add_index(:country_codes, [:name, :kind], {:unique=>true})

-> 0.0600s

-- create_table(:countries)

-> 0.0825s

-- add_index(:countries, :key, {:unique=>true})

-> 0.0625s

-- add_index(:countries, :code, {:unique=>true})

-> 0.0625s

-- create_table(:regions)

-> 0.0800s

-- add_index(:regions, [:key, :country_id], {:unique=>true})

-> 0.2550s

-- create_table(:cities)

-> 0.0775s

-- create_table(:langs)

-> 0.0825s

-- create_table(:usages)

-> 0.0625s

-- create_table(:persons)

-> 0.2775s

-- create_table(:teams)

-> 0.0825s

-- add_index(:teams, :key, {:unique=>true})

-> 0.0650s

-- create_table(:grounds)

-> 0.0600s

-- add_index(:grounds, :key, {:unique=>true})

-> 0.0625s

-- create_table(:goals)

-> 0.2850s

-- create_table(:rosters)

-> 0.0625s

-- create_table(:events)

-> 0.0800s

-- add_index(:events, :key, {:unique=>true})

-> 0.0825s

-- create_table(:rounds)

-> 0.0625s

-- add_index(:rounds, :event_id)

-> 0.0575s

-- create_table(:groups)

-> 0.0800s

-- add_index(:groups, :event_id)

-> 0.0675s

-- create_table(:games)

-> 0.2900s

-- add_index(:games, :key, {:unique=>true})

-> 0.0650s

-- add_index(:games, :round_id)

-> 0.2450s

-- add_index(:games, :group_id)

-> 0.0800s

-- add_index(:games, :next_game_id)

-> 0.0625s

-- add_index(:games, :prev_game_id)

-> 0.0675s

-- add_index(:games, :team1_id)

-> 0.0625s

-- add_index(:games, :team2_id)

-> 0.0700s

-- create_table(:events_teams)

-> 0.0625s

-- add_index(:events_teams, [:event_id, :team_id], {:unique=>true})

-> 0.0775s

-- add_index(:events_teams, :event_id)

-> 0.0900s

-- create_table(:events_grounds)

-> 0.0625s

-- add_index(:events_grounds, [:event_id, :ground_id], {:unique=>true})

-> 0.0600s

-- add_index(:events_grounds, :event_id)

-> 0.0825s

-- create_table(:groups_teams)

-> 0.0625s

-- add_index(:groups_teams, [:group_id, :team_id], {:unique=>true})

-> 0.2850s

-- add_index(:groups_teams, :group_id)

-> 0.0675s

-- create_table(:seasons)

-> 0.2700s

-- create_table(:leagues)

-> 0.2800s

-- create_table(:badges)

-> 0.0800s

-- create_table(:assocs)

-> 0.0625s

-- add_index(:assocs, :key, {:unique=>true})

-> 0.0575s

-- create_table(:assocs_assocs)

-> 0.0900s

-- add_index(:assocs_assocs, [:assoc1_id, :assoc2_id], {:unique=>true})

-> 0.0800s

-- add_index(:assocs_assocs, :assoc1_id)

-> 0.0625s

-- add_index(:assocs_assocs, :assoc2_id)

-> 0.0675s

-- create_table(:group_standings)

-> 0.0600s

-- create_table(:group_standing_entries)

-> 0.0825s

-- create_table(:event_standings)

-> 0.0600s

-- create_table(:event_standing_entries)

-> 0.2925s

-- create_table(:alltime_standings)

-> 0.0700s

-- create_table(:alltime_standing_entries)

-> 0.0850s

[info] parsing data (setup) 'setups/countries' (../openmundi/world.db/setups/countries.txt)...

[info] parsing data (values) 'continents' (../openmundi/world.db/continents.txt)...

[info] parsing data (country) 'africa/countries' (../openmundi/world.db/africa/countries.txt)...

[info] parsing data (country) 'antartica/countries' (../openmundi/world.db/antartica/countries.txt)...

[info] parsing data (country) 'asia/countries' (../openmundi/world.db/asia/countries.txt)...

[info] parsing data (country) 'caribbean/countries' (../openmundi/world.db/caribbean/countries.txt)...

[info] parsing data (country) 'central-america/countries' (../openmundi/world.db/central-america/countries.txt)...

[info] parsing data (country) 'europe/countries' (../openmundi/world.db/europe/countries.txt)...

[info] parsing data (country) 'middle-east/countries' (../openmundi/world.db/middle-east/countries.txt)...

[info] parsing data (country) 'north-america/countries' (../openmundi/world.db/north-america/countries.txt)...

[info] parsing data (country) 'pacific/countries' (../openmundi/world.db/pacific/countries.txt)...

[info] parsing data (country) 'south-america/countries' (../openmundi/world.db/south-america/countries.txt)...

[info] parsing data (country) 'africa/countries_(terr)' (../openmundi/world.db/africa/countries_(terr).txt)...

[info] parsing data (country) 'antartica/countries_(terr)' (../openmundi/world.db/antartica/countries_(terr).txt)...

[info] parsing data (country) 'asia/countries_(terr)' (../openmundi/world.db/asia/countries_(terr).txt)...

[info] parsing data (country) 'caribbean/countries_(terr)' (../openmundi/world.db/caribbean/countries_(terr).txt)...

[info] parsing data (country) 'europe/countries_(terr)' (../openmundi/world.db/europe/countries_(terr).txt)...

[info] parsing data (country) 'north-america/countries_(terr)' (../openmundi/world.db/north-america/countries_(terr).txt)...

[info] parsing data (country) 'pacific/countries_(terr)' (../openmundi/world.db/pacific/countries_(terr).txt)...

[info] parsing data (country) 'south-america/countries_(terr)' (../openmundi/world.db/south-america/countries_(terr).txt)...

[info] parsing data (hash) 'africa/2-more/continents' (../openmundi/world.db/africa/2-more/continents.yml)...

[info] parsing data (hash) 'antartica/2-more/continents' (../openmundi/world.db/antartica/2-more/continents.yml)...

[info] parsing data (hash) 'asia/2-more/continents' (../openmundi/world.db/asia/2-more/continents.yml)...

[info] parsing data (hash) 'caribbean/2-more/continents' (../openmundi/world.db/caribbean/2-more/continents.yml)...

[info] parsing data (hash) 'central-america/2-more/continents' (../openmundi/world.db/central-america/2-more/continents.yml)...

[info] parsing data (hash) 'europe/2-more/continents' (../openmundi/world.db/europe/2-more/continents.yml)...

[info] parsing data (hash) 'middle-east/2-more/continents' (../openmundi/world.db/middle-east/2-more/continents.yml)...

[info] parsing data (hash) 'north-america/2-more/continents' (../openmundi/world.db/north-america/2-more/continents.yml)...

[info] parsing data (hash) 'pacific/2-more/continents' (../openmundi/world.db/pacific/2-more/continents.yml)...

[info] parsing data (hash) 'south-america/2-more/continents' (../openmundi/world.db/south-america/2-more/continents.yml)...

[info] parsing data (line) '1-codes/fifa' (../openmundi/world.db/1-codes/fifa.txt)...

[info] parsing data (line) '1-codes/fips' (../openmundi/world.db/1-codes/fips.txt)...

[info] parsing data (line) '1-codes/internet' (../openmundi/world.db/1-codes/internet.txt)...

[info] parsing data (line) '1-codes/ioc' (../openmundi/world.db/1-codes/ioc.txt)...

*** warning: found ndash U+2013 (–) in file >../openmundi/world.db/1-codes/ioc.txt<; converting to plain ascii hyphen_minus (-)

[info] parsing data (line) '1-codes/iso' (../openmundi/world.db/1-codes/iso.txt)...

[info] parsing data (line) '1-codes/motor' (../openmundi/world.db/1-codes/motor.txt)...

*** warning: found ndash U+2013 (–) in file >../openmundi/world.db/1-codes/motor.txt<; converting to plain ascii hyphen_minus (-)

using LOGLEVEL >debug<

[info] parsing data (setup) 'setups/all' (C:/Ruby193/lib/ruby/gems/1.9.1/gems/sportdb-models-1.11.0/data/setups/all.txt)...

[debug] skipping comment line

[debug] skipping blank line

[debug] fixture setup:

[debug] ["seasons"]

[debug] enter load( name=>>seasons<<)

[info] parsing data (season) 'seasons' (C:/Ruby193/lib/ruby/gems/1.9.1/gems/sportdb-models-1.11.0/data/seasons.txt)...

[debug] skipping comment line

[debug] skipping blank line

[debug] skipping comment line

[debug] skipping blank line

[debug] >2020/21<

[debug] find season key: 2020/21

[debug] create season:

[debug] {"key":"2020/21","title":"2020/21"}

[debug] >2019/20<

[debug] find season key: 2019/20

[debug] create season:

[debug] {"key":"2019/20","title":"2019/20"}

[debug] >2018/19<

[debug] find season key: 2018/19

[debug] create season:

[debug] {"key":"2018/19","title":"2018/19"}

[debug] >2017/18<

[debug] find season key: 2017/18

[debug] create season:

[debug] {"key":"2017/18","title":"2017/18"}

[debug] >2016/17<

[debug] find season key: 2016/17

[debug] create season:

[debug] {"key":"2016/17","title":"2016/17"}

[debug] >2015/16<

[debug] find season key: 2015/16

[debug] create season:

[debug] {"key":"2015/16","title":"2015/16"}

[debug] >2014/15<

[debug] find season key: 2014/15

[debug] create season:

[debug] {"key":"2014/15","title":"2014/15"}

[debug] >2013/14<

[debug] find season key: 2013/14

[debug] create season:

[debug] {"key":"2013/14","title":"2013/14"}

[debug] >2012/13<

[debug] find season key: 2012/13

[debug] create season:

[debug] {"key":"2012/13","title":"2012/13"}

[debug] >2011/12<

[debug] find season key: 2011/12

[debug] create season:

[debug] {"key":"2011/12","title":"2011/12"}

[debug] >2010/11<

[debug] find season key: 2010/11

[debug] create season:

[debug] {"key":"2010/11","title":"2010/11"}

[debug] >2009/10<

[debug] find season key: 2009/10

[debug] create season:

[debug] {"key":"2009/10","title":"2009/10"}

[debug] >2008/09<

[debug] find season key: 2008/09

[debug] create season:

[debug] {"key":"2008/09","title":"2008/09"}

[debug] >2007/08<

[debug] find season key: 2007/08

[debug] create season:

[debug] {"key":"2007/08","title":"2007/08"}

[debug] >2006/07<

[debug] find season key: 2006/07

[debug] create season:

[debug] {"key":"2006/07","title":"2006/07"}

[debug] >2005/06<

[debug] find season key: 2005/06

[debug] create season:

[debug] {"key":"2005/06","title":"2005/06"}

[debug] >2004/05<

[debug] find season key: 2004/05

[debug] create season:

[debug] {"key":"2004/05","title":"2004/05"}

[debug] >2003/04<

[debug] find season key: 2003/04

[debug] create season:

[debug] {"key":"2003/04","title":"2003/04"}

[debug] >2002/03<

[debug] find season key: 2002/03

[debug] create season:

[debug] {"key":"2002/03","title":"2002/03"}

[debug] >2001/02<

[debug] find season key: 2001/02

[debug] create season:

[debug] {"key":"2001/02","title":"2001/02"}

[debug] >2000/01<

[debug] find season key: 2000/01

[debug] create season:

[debug] {"key":"2000/01","title":"2000/01"}

[debug] skipping blank line

[debug] skipping comment line

[debug] skipping blank line

[debug] >2022<

[debug] find season key: 2022

[debug] create season:

[debug] {"key":"2022","title":"2022"}

[debug] >2021<

[debug] find season key: 2021

[debug] create season:

[debug] {"key":"2021","title":"2021"}

[debug] >2020<

[debug] find season key: 2020

[debug] create season:

[debug] {"key":"2020","title":"2020"}

[debug] >2019<

[debug] find season key: 2019

[debug] create season:

[debug] {"key":"2019","title":"2019"}

[debug] >2018<

[debug] find season key: 2018

[debug] create season:

[debug] {"key":"2018","title":"2018"}

[debug] >2017<

[debug] find season key: 2017

[debug] create season:

[debug] {"key":"2017","title":"2017"}

[debug] >2016<

[debug] find season key: 2016

[debug] create season:

[debug] {"key":"2016","title":"2016"}

[debug] >2015<

[debug] find season key: 2015

[debug] create season:

[debug] {"key":"2015","title":"2015"}

[debug] >2014<

[debug] find season key: 2014

[debug] create season:

[debug] {"key":"2014","title":"2014"}

[debug] >2013<

[debug] find season key: 2013

[debug] create season:

[debug] {"key":"2013","title":"2013"}

[debug] >2012<

[debug] find season key: 2012

[debug] create season:

[debug] {"key":"2012","title":"2012"}

[debug] >2011<

[debug] find season key: 2011

[debug] create season:

[debug] {"key":"2011","title":"2011"}

[debug] >2010<

[debug] find season key: 2010

[debug] create season:

[debug] {"key":"2010","title":"2010"}

[debug] >2009<

[debug] find season key: 2009

[debug] create season:

[debug] {"key":"2009","title":"2009"}

[debug] >2008<

[debug] find season key: 2008

[debug] create season:

[debug] {"key":"2008","title":"2008"}

[debug] >2007<

[debug] find season key: 2007

[debug] create season:

[debug] {"key":"2007","title":"2007"}

[debug] >2006<

[debug] find season key: 2006

[debug] create season:

[debug] {"key":"2006","title":"2006"}

[debug] >2005<

[debug] find season key: 2005

[debug] create season:

[debug] {"key":"2005","title":"2005"}

[debug] >2004<

[debug] find season key: 2004

[debug] create season:

[debug] {"key":"2004","title":"2004"}

[debug] >2003<

[debug] find season key: 2003

[debug] create season:

[debug] {"key":"2003","title":"2003"}

[debug] >2002<

[debug] find season key: 2002

[debug] create season:

[debug] {"key":"2002","title":"2002"}

[debug] >2001<

[debug] find season key: 2001

[debug] create season:

[debug] {"key":"2001","title":"2001"}

[debug] >2000<

[debug] find season key: 2000

[debug] create season:

[debug] {"key":"2000","title":"2000"}

[debug] skipping blank line

[debug] skipping comment line

[debug] skipping blank line

[debug] >2015.1<

[debug] find season key: 2015.1

[debug] create season:

[debug] {"key":"2015.1","title":"2015.1"}

[debug] >2015.2<

[debug] find season key: 2015.2

[debug] create season:

[debug] {"key":"2015.2","title":"2015.2"}

[debug] >2014.1<

[debug] find season key: 2014.1

[debug] create season:

[debug] {"key":"2014.1","title":"2014.1"}

[debug] >2014.2<

[debug] find season key: 2014.2

[debug] create season:

[debug] {"key":"2014.2","title":"2014.2"}

[debug] >2013.1<

[debug] find season key: 2013.1

[debug] create season:

[debug] {"key":"2013.1","title":"2013.1"}

[debug] >2013.2<

[debug] find season key: 2013.2

[debug] create season:

[debug] {"key":"2013.2","title":"2013.2"}

[debug] >2012.1<

[debug] find season key: 2012.1

[debug] create season:

[debug] {"key":"2012.1","title":"2012.1"}

[debug] >2012.2<

[debug] find season key: 2012.2

[debug] create season:

[debug] {"key":"2012.2","title":"2012.2"}

[debug] >2011.1<

[debug] find season key: 2011.1

[debug] create season:

[debug] {"key":"2011.1","title":"2011.1"}

[debug] >2011.2<

[debug] find season key: 2011.2

[debug] create season:

[debug] {"key":"2011.2","title":"2011.2"}

[debug] >2010.1<

[debug] find season key: 2010.1

[debug] create season:

[debug] {"key":"2010.1","title":"2010.1"}

[debug] >2010.2<

[debug] find season key: 2010.2

[debug] create season:

[debug] {"key":"2010.2","title":"2010.2"}

[debug] skipping blank line

[info] parsing data (setup) 'setups/all' (../en-england/setups/all.txt)...

[debug] skipping comment line

[debug] skipping blank line

[debug] skipping comment line

[debug] skipping blank line

[debug] skipping comment line

[debug] skipping blank line

[debug] skipping comment line

[debug] fixture setup:

[debug] ["en-england!/leagues","en-england!/clubs","en-england!/clubs_2","en-england!/clubs_wal","en-england!/2012-13/1-premierleague","en-england!/2013-14/1-premierleague","en-england!/2014-15/1-premierleague"]

[debug] enter load( name=>>en-england!/leagues<<)

I am getting stuck at a different place with ASCII encoding errors when trying with the MySql adapter. That is on a different system. I will post the details for that one later.

Regards,

- Maizar

Gerald Bauer

unread,

Feb 4, 2015, 10:30:20 AM2/4/15

to open...@googlegroups.com

Hello,

Thanks for your interest in football.db Sorry for the trouble.
The new [1] recommended way to build your own copy is now w/
Datafiles. For example, for the England 2014/15 season, try:

$ sportdb new en2014-15

That should do everything (download, build, etc.). If it fails please try:

$ sportdb --verbose new en2014-15

to get a more detailed error report. Cheers.

[1] openfootball.github.io/news.html

mai...@gmail.com

unread,

Feb 4, 2015, 1:18:56 PM2/4/15

to open...@googlegroups.com

Hi Gerald,

Thanks for providing the recommendation. The new method is simpler to use. I tried it and still got the same error :(

Command: sportdb --verbose new en2014-15

It looks like it's failing to load something from worldb-models? I have the latest version 2.2.0

sportdb (1.11.0)

sportdb-models (1.11.0)

sportdb-service (0.4.0)

sportdb-update (0.1.1)

worlddb (2.2.1)

worlddb-models (2.2.0)

[debug] enter load( name=>>en-england!/leagues<<)

*** error: Couldn't find WorldDb::Model::Country

The trace is attached for reference:

Regards,

- Maizar

newtrace.txt

Gerald Bauer

unread,

Feb 4, 2015, 2:17:01 PM2/4/15

to open...@googlegroups.com

Hello,
Thanks for the detailed stacktrace. Sorry it looks like the key for
England is broken. I renamed the key to eng from en (there is no .en
internet domain) in the world.db (the idea is to be in line w/ sco
for Scottland, wal for Wales, etc.) Now the country keys in
football.db needs to get changed/updated to eng (e.g. in leagues.txt
etc.) Will try to get it updated in the next days. Thanks for your
patience. Sorry for the trouble. Thanks again for trying. Cheers.

mai...@gmail.com

unread,

Feb 5, 2015, 2:51:48 PM2/5/15

to open...@googlegroups.com

Hi Gerald,

Thanks for sharing the fix. I am a newbie to Ruby and I started learning it just because I seem to have developed an interest in this program. So, I am still new to debugging. I will get the updates and retry this. The older posts seem to be misleading.

Regards,

- Maizar

Gerald Bauer

unread,

Feb 6, 2015, 4:23:42 AM2/6/15

to open...@googlegroups.com

Hello,

I've updated the country codes to eng. Please, note now the repo
changed to /eng-england (was /en-england).

If you retry:

$ sportdb new en2014-15

in a new (empty) folder it should works. Thanks for your patience
and welcome to the wonders of Ruby.

Cheers.

PS: The build with Datefiles is still kind of new. Before making it
"official" the idea is to test it out in the real world. To keep
up-to-date the "best" way is to follow the mailing list (that what
it's here for) and post any open question, comments, criticism, rants,
etc.

mai...@gmail.com

unread,

Feb 6, 2015, 12:51:50 PM2/6/15

to open...@googlegroups.com

Hi Gerald,

Thank you so much for fixing the issue. I was able to download the latest repo and build it successfully. There is a quick setting change needed in the settings.rb file.

EN_INCLUDE_PATH = "#{OPENFOOTBALL_ROOT}/eng-england"

Appreciate your help.

Regards,

- Maizar

Gerald Bauer

unread,

Feb 6, 2015, 1:18:03 PM2/6/15

to open...@googlegroups.com

Hello,

Great. Thanks for letting me know. Changed the settings.rb in the
build/ repo. Cheers.

mai...@gmail.com

unread,

Feb 26, 2015, 1:46:23 PM2/26/15

to open...@googlegroups.com

Hi Gerald,

How are you doing? I was trying to understand the difference between these 2 commands. Thought of asking you.

rake update data=eng

rake build DATA=en_2014_15 (Doing this seems to have wiped out the previous load)

Database: mysql

My objective: Update the tables in the database only for the current season. I am trying to avoid parsing through the entire Premier League again. Is this possible?

Once I update using either of the above commands, the goals table does not seem to have records. Where do I find the goal info?

Regards,

- Maizar

Gerald Bauer

unread,

Feb 26, 2015, 2:23:13 PM2/26/15

to open...@googlegroups.com

Hello,
FYI: You must use all UPCASE for your rake variables e.g. rake
update DATA=eng

To see the difference it's best to check the source of the
Rakefile. For now update - will NOT recreate the database schema and
will NOT update the world datasets but it will basically rebuild all
football datasets (delete the old ones first).

Yes, if you just want to update a single file season you can pass
it along and the parser will try to update the database records (you
will have to use your own little (custom) build script - just make
sure you do NOT call #delete_all or similar).

If you want to have goals added - somebody has to add the goals to
the dataset first ;-) sorry no magic here. For now only some world cup
datsets have goals included if you need some examples to get started.

Have a great weekend. Cheers.

mai...@gmail.com

unread,

Feb 27, 2015, 12:47:55 PM2/27/15

to open...@googlegroups.com

Hi Gerald,

Thanks for the clarification.I will try it out. Appreciate the quick response.

Regards,

- Maizar

mai...@gmail.com

unread,

Mar 8, 2015, 3:13:44 PM3/8/15

to open...@googlegroups.com

Hi Gerald,

You were correct about creating a custom build script for update. When I removed 'deletesport', it has stopped deleting all the records in MySQL.

desc 'update football.db'

task :update => [:deletesport, :importsport] do

puts 'Done.'

end

I still ended up having a failry large amount of tables without any data. Could you help me pinpoint the tables that should have some data after running 'builld' and 'update' commands for EPL?

empty tables list:

footballdb BASE TABLE alltime_standing_entries

footballdb BASE TABLE alltime_standings

footballdb BASE TABLE assocs

footballdb BASE TABLE assocs_assocs

footballdb BASE TABLE badges

footballdb BASE TABLE country_codes

footballdb BASE TABLE event_standing_entries

footballdb BASE TABLE event_standings

footballdb BASE TABLE events_grounds

footballdb BASE TABLE goals

footballdb BASE TABLE grounds

footballdb BASE TABLE group_standing_entries

footballdb BASE TABLE group_standings

footballdb BASE TABLE groups

footballdb BASE TABLE groups_teams

footballdb BASE TABLE langs

footballdb BASE TABLE names

footballdb BASE TABLE persons

footballdb BASE TABLE rosters

footballdb BASE TABLE usages

Regards,

- Maizar

Gerald Bauer

unread,

Mar 8, 2015, 5:32:43 PM3/8/15

to open...@googlegroups.com

Hello,
Thanks for the update. It looks good - all the empty tables are
extras - you might 1) add more datasets - the extras (e.g.
grounds/players/etc.) are not part of the standard / default build or
2) for the standings (stats) tables youl will have to run the (re)calc
script e.g.

All the standings (stats) table are empty unless you run the calc
stats scripts.
All the players tables (including squads/rosters/goals/persons) are
empty unless you import players and include goals in your fixtures.
The lang n usage are world.db table about language usage for
countries, states, etc. (and empty unless you import the language
dataset)
Badges is empty - that's for "tagging" winners, runnerups, etc.
Assoc/assocs is empty unless you import the football associations dataset.

Note: You might check the data model (diagram) [1] for the the core
classes that get used (populated) with the "core" relations.

Cheers.

[1] github.com/openfootball/openfootball.github.io/blob/master/i/footballdb-models.png

Reply all

Reply to author

Forward