tabletop

Description

Tabletop is a website where users can organise and join tabletop games events.

Matches can be either sparrings or tournaments.

Tournament scores are submitted by events' organisers, therefore each registered game has a ranking of players.

Users have a variety of statistics and they can get achievements for being active players.

Team

• sniezek (project idea, Server architecture, Events)
• pwolaq (App architecture, Events)
• Ninani (Tournaments)
• rafalgrm (Tournaments)
• ravinha (Tournaments)
• kakoniec (Games)
• ew940709 (Games)
• Matikul (Users)
• Szagrat (Users)
• rafalzelazko (Users)
• l0rd11 (Achievements)
• Vlizer (Achievements)

Database

Starting stanalone

Start a MySQL server (mysqld.exe). At first you have to connect to it with a MySQL client (mysql.exe) and create the database and user and grant all permissions:

mysql> create database db_example; -- Create the new database
mysql> create user 'springuser'@'localhost' identified by 'ThePassword'; -- Creates the user
mysql> grant all on db_example.* to 'springuser'@'localhost'; -- Gives all the privileges to the new user on the newly created database

Starting in Docker

• Windows 7: https://docs.docker.com/toolbox/toolbox_install_windows/ - it wil start Docker in a virtual machine with its own ip address logged during the start of the VM so you have to use it to conect to the database or start the database locally on your machine with the setings from the next paragraph.
• Windows 10 :https://docs.docker.com/docker-for-windows/

Assuming you have alredy started Docker, type:

docker run --name demo-mysql -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=db_example -e MYSQL_USER=springuser -e MYSQL_PASSWORD=ThePassword -p 3306:3306 -d mysql:5.6

Server

Starting

$ cd server
$ gradlew bootRun

Server will be available at localhost:8080.

Stack

• Spring Boot
• Spring Security
• Spring Data JPA
• Spring Data REST

App

$ cd app

Setup

Execute this once:

$ npm install

And then every time you want to start the application:

$ npm start

App will be available at localhost:3000

Stack

• React
• Redux
• Material Design Lite
• React MDL

Useful commands

Extracted from React Redux starter kit:

npm run <script>	Description
start	Serves your app at localhost:3000. HMR will be enabled in development.
compile	Compiles the application to disk (~/dist by default).
lint	Lint all .js files.
lint:fix	Lint and fix all .js files. Read more on this.

Achievements

You need:

• sbt

Setup

To run it type:

$ sbt run

Service will be available at localhost:9000