RANKING-APP

Purpose of this website is to offer long term statisctics for table tennis players who play in Finland.

Check the production here

Participate in usability survey here (Finnish)

Developed in co-operation with Finnish table tennis association

DEVELOPMENT

For decoding excel files to base64

HOW TO RUN

Prerequisities: Docker

Copy the content from .env.dist to .env in the root of repository, and add correct credentials

Run the following in the root of this repository

docker-compose up

Application opens in localhost:3000

HOW TO RUN TESTS

The following commands will work when the containers are running.

BACKEND UNIT TESTS

Requires database and backend containers running.

docker exec rankingapp-backend npm run test:unit

RUN TESTS IN SINGLE FILE:

docker exec rankingapp-backend ./node_modules/.bin/jest --config jest.config.js --verbose --runInBand --forceExit --coverage tests/unit/services/rankingService.test.js

FRONTEND UNIT TESTS

Requires frontend container running, run all tests:

docker exec rankingapp-frontend npm run test

all from single file by defining the describe, for example:

docker exec rankingapp-frontend npm run test -- -t 'rankingReducer'

END TO END TESTS

RUN ALL TESTS:

docker exec rankingapp-backend npm run test:e2e

RUN TESTS IN SINGLE FILE:

docker exec rankingapp-backend ./node_modules/.bin/jest NODE_ENV=e2etest TEST_PORT=3003 --config jest.config.js --runInBand --forceExit ./tests/e2e/aboutpage.test.js

HOW TO CONNECT TO DATABASE

docker exec -it rankingapp-database mongo
connect("mongodb://database:27017")
use devDB

now you can run queries, for example

show collections
db.users.find()

to see that the admin is seeded correctly

LINTING

To check code formatting, for backend

docker exec rankingapp-backend npm run lint

and frontend

docker exec rankingapp-frontend npm run lint

AUDIT

To find vulnerabilties in npm packages, for backend

docker exec rankingapp-backend npm audit