sportdb - sport.db Command Line Tool in Ruby

Build Status

Usage

The sportdb gem lets you load fixtures in plain text into your sports database (also includes schema & models for easy reuse)

SYNOPSIS
    sportdb [global options] command [command options] [arguments...]

VERSION
    1.6

GLOBAL OPTIONS
    -d, --dbpath=PATH - Database path (default: .)
    -n, --dbname=NAME - Database name (default: sport.db)
    --verbose         - (Debug) Show debug messages
    --version         - Show version

COMMANDS
    create        - Create DB schema
    setup, s      - Create DB schema 'n' load all world and sports data
    update, up, u - Update all sports data
    load, l       - Load sports fixtures
    logs          - Show logs
    props         - Show props
    stats         - Show stats
    test          - (Debug) Test command suite
    help          - Shows a list of commands or help for one command

setup Command

NAME
    setup - Create DB schema 'n' load all world and sports data

SYNOPSIS
    sportdb [global options] setup [command options] NAME

COMMAND OPTIONS
    -i, --include=PATH  - Sports data path (default: .)
    --worldinclude=PATH - World data path (default: none)

EXAMPLES
    sportdb setup --include ./at-austria --worldinclude ./world.db
    sportdb setup 2013_14 --include ./at-austria --worldinclude ./world.db

update Command

NAME
    update - Update all sports data

SYNOPSIS
    sportdb [global options] update [command options] NAME

COMMAND OPTIONS
    --delete           - Delete all sports data records
    -i, --include=PATH - Sports data path (default: .)

EXAMPLES
    sportdb update --include ./at-austria
    sportdb update --include ./at-austria --delete
    sportdb update 2013_14 --include ./at-austria --delete

load Command

NAME
    load - Load sports fixtures

SYNOPSIS
    sportdb [global options] load [command options] NAME

COMMAND OPTIONS
    --delete - Delete all sports data records

EXAMPLES
    sportdb load --include ./at-austria 2013_14/bl
    sportdb load --include ./at-austria 2013_14/bl 2013_14/cup

Install

Just install the gem:

$ gem install sportdb

Free Open Public Domain Datasets

  • football.db - free open public domain football (soccer) data for use in any (programming) language
  • formula1.db - free open public domain Formula 1/Formula One data for use in any (programming) language
  • sport.db - free open public domain sports data for use in any (programming) language
  • ski.db - free open public domain Ski Alpin/Alpine Ski data for use in any (programming) language

Questions? Comments?

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

License

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