DRIVING SCHOOL MANAGEMENT - Web Application

Application Engineering Project 2018/19, Computer and Software Engineering Course @ University of Minho, Braga - Portugal

• Gestão de Escolas de Condução

The main goal of this project is to develop a web application capable of managing any Driving School. In this project, we are using a lot of technologies that allow us to develop this management application, such as:

• UML modelation using Visual Paradigm;

• The backend is being developed using Java EE, Hibernate (MySQL) and Redis;

• Our frontend is being developed using React and Redux.

Contributors

Hugo Oliveira

Raphael Oliveira

João Vieira

Development setup

For develop and use our application, you must create a new user in your MySQL database. This user must have at least all permissions to use dsm database.

Please, follow the steps below:

• as root (sudo mysql -u root) create dsm user with dsm2019EA! password:

CREATE USER 'dsm'@'localhost' IDENTIFIED BY 'dsm2019EA!';
GRANT ALL PRIVILEGES ON *.* TO 'dsm'@'localhost';
FLUSH PRIVILEGES;

• with mysql client (mysql -u dsm -p), create dsm database:

CREATE DATABASE dsm CHARACTER SET utf8;

• create dsm database schema:

cd gestao-escola-conducao/docs/vpp/code
chmod +x *.sh
sh CompileAll.sh
sh RunCreateDSMDatabaseSchema.sh

• open IntellIj IDEA and prepare your env:

  • Setup GlassFish or WildFly server (File > Settings > Build ... > Application Servers)
  • Define output folder for compile and artifact files:
    • (File > Project Structure > Project
    • define output path: gestao-escola-conducao/dsm-backend/out
  • Add dependencies that are on lib folder (File > Project Structure > Libraries) and JUST add:
    • orm.jar
    • all jackson jar files
    • commons-pool2-2.6.2.jar
    • jedis-3.0.1.jar
  • Add a Artifact (File > Project Structure > Artifacts) and follow this steps:
    • + > Web Application:Exploded > From Modules
  • Press Apply and OK
  • Now you just need to setup your Edit Configurations on top right menu

Redis Service

• Download Redis image if is needed:

  docker pull redis:5.0.4

• Start Redis container:

  # without password
  docker run -p 6379:6379 redis:5.0.4
  
  # with password
  docker run -p 6379:6379 redis:5.0.4 --appendonly yes  --requirepass "dsmEA2019"

• To test if redis is working:

  # without password
  redis-cli -h 127.0.0.1 -p 6379
  
  # with password
  redis-cli -h 127.0.0.1 -p 6379 -a 'dsm2019EA'

• Kill it by doing CTRL-C