Sport Center is a page dedicated to the collection of information on teams and leagues from around the world related to sport.
It is a Full Stack project made with:
| Programming Languages | Front-End Development | Back-End Development | Database | Data Recollection |
|---|---|---|---|---|
|
|
|
|
|
Currently there is no live visualization, since it is planned to migrate the database to MongoDB and make a modification to the Front-End to improve the view, which is currently very basic. As well as switching from JavaScript to TypeScript.
It would also be necessary to download the database, but as already said, the entire project is being restructured so that data consumption is done on a server already deployed.
git clone <url>
A command window should be opened inside the "sports_app_server" folder and the following commands are entered:
npm install
nodemon server.js
A command window should be opened inside the "sports_app_client" folder and the following commands are entered:
npm install
npm start
"More about creating the database", is a folder that contains information and Python code on how the information in the database was collected and manipulated. Inside this folder, there are 5 other folders.
- Diagram E-R: There is only one image of the diagram of the database entities, their attributes and relationships.
- Diagram BD: There is only one image, which is the same database diagram from the previous folder, but now in the format given by MSSQL (something more professional).
- Data Collection Codes: All the data was extracted from an API, and within this folder are all the codes made in Python to massively collect this data and store it in .CSV files for later migration to MSSQL. In folder 1 are all the calls to the APIs plus some modifications, since the information was very disorganized and a way to solve these problems had to be found. In folder 2, from the data already placed in .CSV, it was simply decided to further clean the information, put it in the proper format and create a new .CSV ready for migration to MSSQL.
- Database Creation Scripts: Here is the code that was used for the creation of the database structure in MSSQL.
- Database Insert Scripts: As previously said, once the .CSV files were made with all the necessary information, they were migrated to MSSQL, and from there they were inserted into the structures made previously so that it would be perfect, here is the code of the inserts.
This part was the most complicated of the entire project, since the API, despite having thousands of data, had disorganized data, without uniform format, etc. In total it took about 3 weeks to clean all the information and make it usable for the project, new IDs, new relationships had to be created, names changed to a standard format, etc., very hard work.
This repository is an extension of the original repositories, which can be found at the following links: