Golang REST server from a three table MariaDB database

The mission is to develop a backend application in Golang that is a REST server for a battles and players game in a MariaDB database.

The mission includes developing the automatic tests, scripts to build, MariaDB access configuration, etc.

All the code and libraries must be open source or common Golang libraries.

You will be provided with an already configured (development) server in Ubuntu with MariaDB.

This backend application must be able to be replicated easily to another (production) server.

There will be an nginx proxy but tests can be coded to run in localhost:8080.

There are three MariaDB tables: PLAYERS, BATTLES and FIGHTERS (players asigned to battles)

This backend application must do the following procedure:

1.- Fetch all records from the DB to Golang maps (in memory).

2.- Respond all REST requests until QUIT

3.- Dump substitutions to MariaDB.

There are SIX REST requests to implement:

POST /login

GET /battles

GET /battle/:idBattle/fighters

PUT /replace/:idBattle/:idPlayer

PATCH /battle/:idBattle/endsin/:minutes

PATCH /battle/:idBattle/:idplayer/newStatus

The authentication schema for the login is JWT (unless we agree on a better alternative)

Golang MariaDB MySQL RESTful

Project ID: #17658316

About the project