Utility scripts for Perseus app

Brief description of scripts to use the Perseus results app without the web interface (these scripts need to be run from the host machine)

admin.rb

Provides options to:

• Set the active competition. All displays & results inputs screens read/write data for this competition.
• Purge the Event Stream (e.g. of results from a previous round).

Run

$ ./admin.rb -w <competition_id> # sets the active competition
$ ./admin.rb -p                  # purges the broadcast stream

registration.rb

Read a CSV file containing climber information and update the database to include these climbers

Run

$ ./registration.rb -f <filename>	
# reads <filename> and adds any new climbers into the database

The required file format is a comma-delimited CSV file with headers as follow:

per_id,lastname,firstname,club,nation,birthyear,gender
2000104,Abbey,Sam,,,,M
2000347,Acereda Ortiz,Carla,,,1998,F

startlist.rb

Read a CSV file containing the startlist for some specified competition, round and category

Run

$ ./startlist.rb -f <filename>	
# reads <filename> and creates the startlist for a new round

The required file format is a comma-delimited CSV file with headers as follow:

wet_id, route, grp_id, per_id, start_order, rank_prev_heat 

results-delete.rb

Delete all results within some round of a competition for either: (a) a specified category; (b) a defined competitor; or (c) the competitor with start number [x]. This in effect erases the results completely.

Run

$ ./results-delete.rb -w <competition_id> -r <round> -c <category_id> [-p <person_id> | -s <start_nr>]

results-export.rb

Export results for some round

Run

$ ./results-export.rb -w <competition_id> -r <round> -c <category_id>

results-reset.rb

Reset all results within some round of a competition for either: (a) a specified category; (b) a defined competitor; or (c) the competitor with start number [x]. This simply resets the results (i.e. as though the relevant competitor has not yet started the round)

Run

$ ./results-reset.rb -w <competition_id> -r <round> -c <category_id> [-p <person_id> | -s <start_nr>]