2023 upe David Rodriguez Rives


April 24th - April 30th

This week I prepared the PaginaTorneo.html script for being able to load and write puntuations from PostgreSQL (named PaginaTorneo4).
First of all, I exposed the 5432 in the Dockerfile and docker-compose.yml files for the docker to connect and I used the psycopg2 package to connect the script to docker.
After that I corrected the puntuationsFromSQL function for it to order automatically the rows by puntuation and dont deppend on another functions
I then used a VIEW called participantsView for a faster lecture of the data both for MySQL and PostgreSQL.

I fixed some bugs in TorneoAutomatico.py script regarding the record and upload of videos and preparing in to do it automatically for several users.