Developed a full-stack academic management system as part of a collaborative software development project, enabling role-based access for instructors and students to manage classrooms, students, subjects, and grades. Implemented secure student account creation with authentication and protected access to academic records.

Built a responsive frontend using React and JavaScript, and a scalable backend using Python and Flask, exposing RESTful APIs for data management and client-server communication. Implemented JWT (JSON Web Token) authentication for secure session handling, route protection, and user verification. Designed and implemented a SQL relational database schema to efficiently manage users, grades, and academic entities.

Integrated Mailtrap as a third-party email API service to automate transactional email notifications, sending student credentials and onboarding messages upon account creation.

1) Installation:

If you use Github Codespaces (recommended) or Gitpod this template will already come with Python, Node and the Posgres Database installed. If you are working locally make sure to install Python 3.10, Node

It is recomended to install the backend first, make sure you have Python 3.10, Pipenv and a database engine (Posgress recomended)

1. Install the python packages: $ pipenv install
2. Create a .env file based on the .env.example: $ cp .env.example .env
3. Install your database engine and create your database, depending on your database you have to create a DATABASE_URL variable with one of the possible values, make sure you replace the valudes with your database information:

Engine	DATABASE_URL
SQLite	sqlite:////test.db
MySQL	mysql://username:password@localhost:port/example
Postgress	postgres://username:password@localhost:5432/example

4. Migrate the migrations: $ pipenv run migrate (skip if you have not made changes to the models on the ./src/api/models.py)
5. Run the migrations: $ pipenv run upgrade
6. Run the application: $ pipenv run start

Note: Codespaces users can connect to psql by typing: psql -h localhost -U gitpod example

Undo a migration

You are also able to undo a migration by running

$ pipenv run downgrade

Backend Populate Table Users

To insert test users in the database execute the following command:

$ flask insert-test-users 5

And you will see the following message:

  Creating test users
  test_user1@test.com created.
  test_user2@test.com created.
  test_user3@test.com created.
  test_user4@test.com created.
  test_user5@test.com created.
  Users created successfully!

Important note for the database and the data inside it

Every Github codespace environment will have its own database, so if you're working with more people eveyone will have a different database and different records inside it. This data will be lost, so don't spend too much time manually creating records for testing, instead, you can automate adding records to your database by editing commands.py file inside /src/api folder. Edit line 32 function insert_test_data to insert the data according to your model (use the function insert_test_users above as an example). Then, all you need to do is run pipenv run insert-test-data.

Front-End Manual Installation:

• Make sure you are using node version 20 and that you have already successfully installed and runned the backend.

1. Install the packages: $ npm install
2. Start coding! start the webpack dev server $ npm run start