Skip to content
Branch: master
Find file History
Latest commit 3591b54 Nov 26, 2019
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
attic up tool Nov 24, 2019
bin add commands Feb 13, 2017
lib up tool Nov 26, 2019
script add commands Feb 13, 2017
test up tool Nov 26, 2019
.gitignore add commands Feb 13, 2017
CHANGELOG.md use CHANGELOG Aug 18, 2019
Manifest.txt
NOTES.md up tool Nov 26, 2019
README.md Update README.md Nov 22, 2019
Rakefile up auto conf Nov 26, 2019

README.md

sportdb - sport.db Command Line Tool

Usage

The sportdb tool lets you read in (parse) datasets (e.g. leagues, clubs, match schedules, etc.) in plain text into your sports SQL database of choice (e.g. SQLite, PostgreSQL, etc.)

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

VERSION
    2.0

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
    new, n        - Build DB w/ quick starter Datafile templates
    build, b      - Build DB (download/create/read); use ./Datafile - zips get downloaded to ./tmp
    serve, server - Start web service (HTTP JSON API)

MORE COMMANDS    
    create        - Create DB schema
    download, dl  - Download datasets; use ./Datafile - zips get downloaded to ./tmp
    read, r       - Read datasets; use ./Datafile - zips required in ./tmp
    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

new Command

NAME
    new - Build DB w/ quick starter Datafile templates
SYNOPSIS
    sportdb [global options] new NAME

EXAMPLES
    sportdb new eng2019-20
    sportdb new eng

build Command

NAME
    build - Build DB (download/create/read); use ./Datafile - zips get downloaded to ./tmp

SYNOPSIS
    sportdb [global options] build

EXAMPLES
    sportdb build

serve Command

NAME
    serve - Start web service (HTTP JSON API)

SYNOPSIS
    sportdb [global options] serve

EXAMPLES
    sportdb serve

Install

Just install the gem:

$ gem install sportdb

More Documentation / Getting Started Guides

See the football.db League Starter Sample - Mauritius Premier League if you want to start from scratch (zero) with your very own league.

See the football.db Quick Starter Datafile Templates if you want to read in ready-to-use / ready-to-fork dataset packages incl. the English Premier League, the German Bundesliga, the Spanish Primera División and some more.

License

The sportdb 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.