Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
lib/sportdb
test
.gitignore
CHANGELOG.md
Manifest.txt
NOTES.md
README.md
Rakefile

README.md

sportdb-readers - sport.db readers for leagues, seasons, clubs, match schedules and results, and more

Usage

Step 1

Setup the (SQL) database. Let's use and build a single-file SQLite database (from scratch), as an example:

require 'sportdb/readers'

SportDb.connect( adapter:  'sqlite3',
                 database: './england.db' )
SportDb.create_all       ## build database schema (tables, indexes, etc.)

Step 2

Let's read in some leagues, seasons, clubs, and match schedules and results. Let's use the public domain football.db datasets for England (see openfootball/england), as an example:

## turn on logging to console
ActiveRecord::Base.logger = Logger.new( STDOUT )

## assumes football.db datasets for England in ./england directory
##   see github.com/openfootball/england
SportDb::ConfReaderV2.read( './england/2015-16/.conf.txt' )
SportDb::MatchReaderV2.read( './england/2015-16/1-premierleague-i.txt' )
SportDb::MatchReaderV2.read( './england/2015-16/1-premierleague-ii.txt' )

## let's try another season
SportDb::ConfReaderV2.read( './england/2019-20/.conf.txt' )
SportDb::MatchReaderV2.read( './england/2019-20/1-premierleague.txt' )

All leagues, seasons, clubs, match days and rounds, match fixtures and results, and more are now in your (SQL) database of choice.

Or as an alternative use the read convenience all-in-one shortcut helper:

## assumes football.db datasets for England in ./england directory
##   see github.com/openfootball/england
SportDb.read( './england/2015-16/.conf.txt' )
SportDb.read( './england/2015-16/1-premierleague-i.txt' )
SportDb.read( './england/2015-16/1-premierleague-ii.txt' )

## let's try another season
SportDb.read( './england/2019-20/.conf.txt' )
SportDb.read( './england/2019-20/1-premierleague.txt' )

Or as an alternative pass in the "package" directory and let read figure out what datafiles to read:

## assumes football.db datasets for England in ./england directory
##   see github.com/openfootball/england
SportDb.read( './england' )

That's it.

License

The sportdb-readers scripts are dedicated to the public domain. Use it as you please with no restrictions whatsoever.

Questions? Comments?

Send them along to the Open Sports & Friends Forum/Mailing List. Thanks!

You can’t perform that action at this time.