This repository contains the code used in the development of the Final Degree Project for the Faculty of Computer Science of Complutense University of Madrid.

Luis Caballero Molero

Pablo Agustín Chicharro Gómez

Luis López Sáez

Jesús Correas Fernández

Pablo Gordillo Alguacil

This Final Degree Project consists in the development of an application that handles the students’ enrolment process and transcripts for both courses that they take at their home university and courses that they take abroad. Our project is mainly focused on the selection and enrolment of an Erasmus course, by automating the process and limiting human interaction to the bare minimum required.

To achieve this goal, we have profited from the benefits that the blockchain technology provides, mainly the fact that it guarantees a decentralized system capable of ensuring transaction integrity between many participants. This is the reason why the blockchain plays a fundamental role in verifying the security and safety with regards to everything that is stored in the system guaranteeing that no information has been tampered with.

The development of the application covers from the planning stage all the way to the implementation phase, including the development of the user interfaces and the backend architecture. This project explores a very valuable alternative for all those students and teachers that are involved in the Erasmus programme processes, attempting to make it as accessible as possible.

This is a micro-services based application using Docker Compose. There is a docker-compose.yml with the configuration of the services that is used to launch the system. There are two types of containers that are used: container images that are downloaded from the docker hub and used directly, and custom containers which have their own folder and set up in the project.

• nginx: Contains the configuration for the reverse-proxy nginx-hosted server.
• frontend: Contains the React frontend service.
• api: Contains the Express API service.
• truffle: Contains the Express & Truffle Blockchain API service.
• Database: Contains the database schema for the deployed database. The real database scripts is stored in api/scripts/init-db.sql

To launch the application, from the application's root folder, run:

docker compose up

• The frontend service will be available through web browser at: http://localhost:3000

To run Truffle commands, run this command from a separate terminal:

docker exec -it tfg-truffle-1 sh

If the above command doesn't work, run docker ps and use the container ID for the Truffle container.

• Enter the Truffle shell:

truffle console --network development

• Deploy the TFG contract:

truffle migrate --network development

• Copy the generated TFG smart contract address into the constant NEW_CONTRACT_ADDRESS in the file truffle/replace_contract_address.js

• Run the edited file from the truffle console

node replace_contract_address.js

The blockchain service will now be fully operational, and the application is now usable.

To stop the application, press Ctrl+C in your docker terminal (not the truffle terminal).

• To run the application again, you will only need to execute the initial command:

docker compose up

• Otherwise, in order to reset the application to a default state, run:

docker compose down

You will have to repeat the set up process to be able to use the application again.

• Navigate to: http://localhost:8080
• Login credentials:
  • Email: admin@admin.com
  • Password: admin

1. Click "Add new server" in the center panel.
2. Under the Connection tab, set the following:
   • Host name: db
   • Port: 5432
   • Username/Password: postgres

• In the left column, expand the server you added:

  Servers → [Your Server] → Databases → [Your DB] → Schemas → public → Tables
  

• Right-click the desired table and select View/Edit Data.

1. Click Tools → Query Tool.
2. Use the text area to write queries or scripts.
3. Click the > (Execute) button to run queries.
4. Results will appear in the Data Output section below.

• Use the following connection in Truffle:

  http://ganache:8545
  

If not using the container, use the appropriate IP and port:

• GUI Version: http://127.0.0.1:7545
• CLI Version: http://127.0.0.1:8545

These are the test accounts generated by ganache by our current configuration. They will be automatically assigned to new participants of the system by the application. If you modify the Ganache configuration, these may change.