| 1 | package edu.ucsb.cs156.courses.entities; | |
| 2 | ||
| 3 | import jakarta.persistence.Entity; | |
| 4 | import jakarta.persistence.GeneratedValue; | |
| 5 | import jakarta.persistence.GenerationType; | |
| 6 | import jakarta.persistence.Id; | |
| 7 | import jakarta.persistence.Table; | |
| 8 | import jakarta.persistence.UniqueConstraint; | |
| 9 | import lombok.AllArgsConstructor; | |
| 10 | import lombok.Builder; | |
| 11 | import lombok.Data; | |
| 12 | import lombok.NoArgsConstructor; | |
| 13 | ||
| 14 | /** | |
| 15 |  * GradeHistory - Entity for grade history data. Each object represents one row from the CSV files | |
| 16 |  * located in this repository: <a href= | |
| 17 |  * "https://github.com/rtora/UCSB_Grades">https://github.com/rtora/UCSB_Grades</a> | |
| 18 |  * | |
| 19 |  * <p>There is a unique constraint on the combination of year, quarter, subjectArea, course, | |
| 20 |  * instructor, and grade, since we do not want duplicate rows of data for the same course. | |
| 21 |  */ | |
| 22 | @Data | |
| 23 | @Builder | |
| 24 | @AllArgsConstructor | |
| 25 | @NoArgsConstructor | |
| 26 | @Entity(name = "historygrade") | |
| 27 | @Table( | |
| 28 |     uniqueConstraints = { | |
| 29 |       @UniqueConstraint( | |
| 30 |           name = "UniqueGradeHistory", | |
| 31 |           columnNames = {"yyyyq", "course", "instructor", "grade", "count"}) | |
| 32 |     }) | |
| 33 | public class GradeHistory { | |
| 34 |   @Id | |
| 35 |   @GeneratedValue(strategy = GenerationType.IDENTITY) | |
| 36 |   private Long id; | |
| 37 | ||
| 38 |   private String yyyyq; | |
| 39 |   private String course; | |
| 40 |   private String instructor; | |
| 41 |   private String grade; | |
| 42 |   private int count; | |
| 43 | ||
| 44 |   public String getSubjectArea() { | |
| 45 | 
2
1. getSubjectArea : negated conditional → KILLED 2. getSubjectArea : replaced return value with "" for edu/ucsb/cs156/courses/entities/GradeHistory::getSubjectArea → KILLED  | 
    if (course == null) return null; | 
| 46 | 
1
1. getSubjectArea : replaced return value with "" for edu/ucsb/cs156/courses/entities/GradeHistory::getSubjectArea → KILLED | 
    return course.substring(0, 8).trim(); | 
| 47 |   } | |
| 48 | ||
| 49 |   public String getCourseNum() { | |
| 50 | 
2
1. getCourseNum : negated conditional → KILLED 2. getCourseNum : replaced return value with "" for edu/ucsb/cs156/courses/entities/GradeHistory::getCourseNum → KILLED  | 
    if (course == null) return null; | 
| 51 | 
1
1. getCourseNum : replaced return value with "" for edu/ucsb/cs156/courses/entities/GradeHistory::getCourseNum → KILLED | 
    return course.substring(8).trim(); | 
| 52 |   } | |
| 53 | } | |
Mutations | ||
| 45 | 
 
 1.1 2.2  | 
|
| 46 | 
 
 1.1  | 
|
| 50 | 
 
 1.1 2.2  | 
|
| 51 | 
 
 1.1  |