Added a new quick starter sample using the Mauritius Premier League to get you started creating your own leagues/cups/etc. from scratch.
You can test drive the quick starter sample with a single command e.g.:
$ sportdb build
To start from scratch follow these six steps:
- Step 1: Add all leagues
- Step 2: Add all clubs
- Step 3: Add all match fixtures and results
- Step 4: Add the league season “front matter” settings
- Step 5: Add a setups file list (also known as manifest)
- Step 6: Add a datafile build script - That’s it. Done.
Using a file structure like:
├── 2014-15 # 2014-15 season folder | ├── league-i.txt # match fixtures / results - matchdays 1-18 | ├── league-ii.txt # - matchdays 19-36 | └── league.yml # "front matter" settings ├── setups | └── all.txt # file list (manifest) ├── leagues.txt # all leagues ├── clubs.txt # all clubs └── Datafile # build script
That’s it. Now try:
$ sqlite3 sport.db SQLite version 3.7.16 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select * from countries; 1|Mauritius|mauritius|mu|1|MUS|||1261200|2040|||f|t|f|f| sqlite> select * from teams; 1|joachim|Cercle de Joachim||CDJ|Cercle de Joachim SC|Joachim|1||t|||||f| 2|chamarel|Chamarel SC||CHA|Chamarel|Chamarel Sport Club|1||t|||||f|
and so on and so forth.