olympic-games

"Olympic-games" it's a test task from Brocoders for Node.js coders. Description here.

This task contain 2 stages:

• import data from CSV file to SQLite database
• create cli-tool for build charts.

Project structure:

.
├── charts/         # chart queries and builder
├── csv/            # csv file for import
├── db/             # sqlite db file
├── import/         # import to db scripts
└── node_modules/
./import.js         # csv parse and import
./stat              # cli-tool for show charts

Prepare database:

$ node import.js

View cli-charts:

$ ./stat [chart] [params]

Command examples:

$ ./stat medals UKR summer gold
$ ./stat medals USA winter
$ ./stat top-teams 1998 winter silver
$ ./stat top-teams summer