1 package dst.ass1.jpa.model.impl;
3 import dst.ass1.jpa.model.ICourse;
4 import dst.ass1.jpa.model.ILecturer;
5 import dst.ass1.jpa.model.ILesson;
6 import dst.ass1.jpa.util.Constants;
8 import javax.persistence.*;
9 import java.util.ArrayList;
10 import java.util.Collection;
13 @Table(name = Constants.T_LECTURER)
14 @PrimaryKeyJoinColumn(name = "id")
15 @NamedQuery(name = Constants.Q_MOST_ACTIVE_LECTURER, query = "SELECT l" +
16 " FROM " + Constants.T_LECTURER + " l" +
17 " WHERE size(l.lessons) >= ALL(" +
18 " SELECT size(le.lessons) FROM " + Constants.T_LECTURER + " as le GROUP BY le" +
20 public class Lecturer extends Person implements ILecturer {
21 @OneToMany(targetEntity = Course.class)
22 private Collection<ICourse> courses = new ArrayList<>();
24 @ManyToMany(targetEntity = Lesson.class)
25 @JoinTable(name = Constants.J_LECTURER_LESSON,
27 @JoinColumn(name = Constants.I_LECTURER)
29 inverseJoinColumns = {
30 @JoinColumn(name = Constants.I_LESSON)
32 private Collection<ILesson> lessons = new ArrayList<>();
36 public Collection<ICourse> getCourses() {
41 public void setCourses(Collection<ICourse> courses) {
42 this.courses = courses;
46 public void addCourse(ICourse course) {
47 this.courses.add(course);
51 public Collection<ILesson> getLessons() {
56 public void setLessons(Collection<ILesson> lessons) {
57 this.lessons = lessons;
61 public void addLesson(ILesson lesson) {
62 this.lessons.add(lesson);