Add Professor Model and Update Review Model with New Fields and Professor Relationship

[angadb27]

WHAT DOES THIS PR DO?

• Creation of the Professor Model: The new Professor model in school/models.py includes first_name, last_name, and a many-to-many relationship with schools and courses.
  • Enhancement of the Review Model: The Review model has been updated with a foreign key to the Professor model. This change allows each review to be linked to a specific professor and the course the professor belongs to. Also added evaluation questions to the model.
  • Implementation of New Endpoint for Course-Specific Reviews: Added a new API endpoint allowing users to retrieve reviews for a specific course. This endpoint, formatted as {base_url}/reviews/{school_short_name}/{course_subject_catalog}, leverages the school's short name and a combination of the course's subject and catalog number to filter and present relevant reviews.
  • Refactored tests for review/views.py

WHAT ISSUES ARE RELATED TO THIS PR?

• [X] #129
• [X] #143
• [X] #144

HOW DO I TEST OUT THIS PR? Run this project locally and test the updated endpoints: Base URL: http://localhost:8000/api/v1. To test the endpoints, go to http://localhost:8000/api/v1/reviews/ - Use django restframework UI to try out the endpoints

Testing Endpoints:

• POST /reviews/

  Example request body:

  {
     "school": "UUID or short name of the school",  // Required
     "course": "UUID or 'subject catalog_number' of the course",  // Required
     "professor": "UUID or 'first_name last_name' of the professor",  // Required
     "review_text": "Your review text here",  // Required
     "term": "Spring/Fall/Summer/etc.",  // Required
    "grade_received": "A/B/C/D/F/N/A",  
     "delivery_method": "Online/In-Person/Hybrid/etc.", 
    "textbook_required": true or false, 
     "helpful_count": 12, 
     "year_taken": 2023,  
     "recommended": true or false,  
     "rating_course_overall": 1-5,  // Required
     "rating_course_content": 1-5,  // Required
     "rating_instructor_contribution": 1-5,  // Required
     "rating_course_organization": 1-5,  // Required
     "rating_instructor_explanation": 1-5,  // Required
     "rating_instructor_interest": 1-5,  // Required
     "rating_work_amount": 1-5,  // Required
     "rating_clarity_requirements": 1-5,  // Required
     "rating_class_time_use": 1-5,  // Required
     "rating_student_confidence": 1-5,  // Required
     "rating_question_quality": 1-5  // Required
  }

• PUT /reviews/{review_id}/

• Replace {review_id} with the UUID of the review you wish to update. Send a JSON payload with the updated details of the review. (same as POST request body)

• GET /reviews/{school_short_name}/{course_subject_catalog}

• Replace {school_short_name} with the short name of the school and {course_subject_catalog} with the combined subject and catalog number of the course to retrieve all reviews for that specific course.

  Example URL:
  http://localhost:8000/api/v1/reviews/UNLV/CS472

ADDITIONAL INFORMATION

• [x] Pipeline passing
• [X] Unit tests
• [X] Running locally

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Updated (UTC)
cs-472-group-2-project	✅ Ready (Inspect)	Visit Preview	Dec 3, 2023 3:30am
cs-472-group-2-project-backend	✅ Ready (Inspect)	Visit Preview	Dec 3, 2023 3:30am

[codecov-commenter]

Codecov Report

Attention: 2 lines in your changes are missing coverage. Please review.

Comparison is base (8421f30) 91.14% compared to head (f6ce63e) 92.04%.

Files	Patch %	Lines
api/review/serializers.py	95.45%	1 Missing :warning:
api/school/admin.py	93.33%	1 Missing :warning:

:exclamation: Your organization needs to install the Codecov GitHub app to enable full functionality.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #136 +/- ## ========================================== + Coverage 91.14% 92.04% +0.89% ========================================== Files 28 28 Lines 666 779 +113 ========================================== + Hits 607 717 +110 - Misses 59 62 +3 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.