Changeset 2d57cad in Git for src/main/java/com/wediscussmovies/project/model/Discussion.java

Timestamp:

01/16/22 17:12:01 (3 years ago)

Author:

Test <matonikolov77@…>

Branches:

main

Children:

7fafead

Parents:

839f96a

Message:

Initial model part

File:

• src/main/java/com/wediscussmovies/project/model/Discussion.java (modified) (1 diff)

src/main/java/com/wediscussmovies/project/model/Discussion.java

@@ -3 +3 @@
 import javax.persistence.*;
 import java.sql.Date;
-import java.util.List;
+import java.util.Collection;
+import java.util.Objects;
 
 @Entity
+@Table(name = "discussions", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies")
 public class Discussion {
+    @GeneratedValue(strategy = GenerationType.IDENTITY)
     @Id
-    @GeneratedValue
-    private int discussion_id;
+    @Column(name = "discussion_id")
+    private int discussionId;
+    @Basic
+    @Column(name = "type")
+    private String type;
+    @Basic
+    @Column(name = "text")
+    private String text;
+    @Basic
+    @Column(name = "title")
+    private String title;
+    @Basic
+    @Column(name = "date")
+    private Date date;
+    @Basic
+    @Column(name = "user_id")
+    private int userId;
+    @Basic
+    @Column(name = "movie_id")
+    private Integer movieId;
+    @Basic
+    @Column(name = "person_id")
+    private Integer personId;
 
     @ManyToOne
-    @Column(name = "movie_id")
-    private Movie movie;
+    @JoinColumn(name = "user_id", referencedColumnName = "user_id", nullable = false,insertable = false, updatable = false)
+    private User usersByUserId;
+    @ManyToOne
+    @JoinColumn(name = "movie_id", referencedColumnName = "movie_id",insertable = false, updatable = false)
+    private Movie moviesByMovieId;
+    @ManyToOne
+    @JoinColumn(name = "person_id", referencedColumnName = "person_id",insertable = false, updatable = false)
+    private Person personsByPersonId;
+    @OneToMany(mappedBy = "discussionsByDiscussionId")
+    private Collection<Reply> repliesByDiscussionId;
 
-    @ManyToOne()
-    @Column(name = "person_id")
-    private Person person;
+    public int getDiscussionId() {
+        return discussionId;
+    }
 
-    @ManyToOne
-    @Column(name = "user_id")
-    private User user;
+    public void setDiscussionId(int discussionId) {
+        this.discussionId = discussionId;
+    }
 
-    @Column(name = "text", length = 1000, nullable = false)
-    private String text;
+    public String getType() {
+        return type;
+    }
 
-    @Column(name = "title", length = 1000, nullable = false)
-    private String title;
+    public void setType(String type) {
+        this.type = type;
+    }
 
-    @Column(name = "date", nullable = false)
-    private Date date;
+    public String getText() {
+        return text;
+    }
 
-    @OneToMany
-    private List<Reply> replies;
+    public void setText(String text) {
+        this.text = text;
+    }
+
+    public String getTitle() {
+        return title;
+    }
+
+    public void setTitle(String title) {
+        this.title = title;
+    }
+
+    public Date getDate() {
+        return date;
+    }
+
+    public void setDate(Date date) {
+        this.date = date;
+    }
+
+    public int getUserId() {
+        return userId;
+    }
+
+    public void setUserId(int userId) {
+        this.userId = userId;
+    }
+
+    public Integer getMovieId() {
+        return movieId;
+    }
+
+    public void setMovieId(Integer movieId) {
+        this.movieId = movieId;
+    }
+
+    public Integer getPersonId() {
+        return personId;
+    }
+
+    public void setPersonId(Integer personId) {
+        this.personId = personId;
+    }
+
+    @Override
+    public boolean equals(Object o) {
+        if (this == o) return true;
+        if (o == null || getClass() != o.getClass()) return false;
+
+        Discussion that = (Discussion) o;
+
+        if (discussionId != that.discussionId) return false;
+        if (userId != that.userId) return false;
+        if (!Objects.equals(type, that.type)) return false;
+        if (!Objects.equals(text, that.text)) return false;
+        if (!Objects.equals(title, that.title)) return false;
+        if (!Objects.equals(date, that.date)) return false;
+        if (!Objects.equals(movieId, that.movieId)) return false;
+        if (!Objects.equals(personId, that.personId)) return false;
+
+        return true;
+    }
+
+    @Override
+    public int hashCode() {
+        int result = discussionId;
+        result = 31 * result + (type != null ? type.hashCode() : 0);
+        result = 31 * result + (text != null ? text.hashCode() : 0);
+        result = 31 * result + (title != null ? title.hashCode() : 0);
+        result = 31 * result + (date != null ? date.hashCode() : 0);
+        result = 31 * result + userId;
+        result = 31 * result + (movieId != null ? movieId.hashCode() : 0);
+        result = 31 * result + (personId != null ? personId.hashCode() : 0);
+        return result;
+    }
+
+    public User getUsersByUserId() {
+        return usersByUserId;
+    }
+
+    public void setUsersByUserId(User usersByUserId) {
+        this.usersByUserId = usersByUserId;
+    }
+
+    public Movie getMoviesByMovieId() {
+        return moviesByMovieId;
+    }
+
+    public void setMoviesByMovieId(Movie moviesByMovieId) {
+        this.moviesByMovieId = moviesByMovieId;
+    }
+
+    public Person getPersonsByPersonId() {
+        return personsByPersonId;
+    }
+
+    public void setPersonsByPersonId(Person personsByPersonId) {
+        this.personsByPersonId = personsByPersonId;
+    }
+
+    public Collection<Reply> getRepliesByDiscussionId() {
+        return repliesByDiscussionId;
+    }
+
+    public void setRepliesByDiscussionId(Collection<Reply> repliesByDiscussionId) {
+        this.repliesByDiscussionId = repliesByDiscussionId;
+    }
+
+    public Discussion() {
+    }
+
+    public Discussion(String type, String text, String title, Date date, int userId, Integer movieId, Integer personId) {
+        this.type = type;
+        this.text = text;
+        this.title = title;
+        this.date = date;
+        this.userId = userId;
+        this.movieId = movieId;
+        this.personId = personId;
+    }
 }
-
-
-/*
-    create table discussions(
-        discussion_id serial primary key,
-        type char(1) not null,
-        text varchar(1000) not null,
-        title varchar(250) not null,
-        date date not null,
-        user_id integer not null,
-        movie_id integer,
-        person_id integer,
-        constraint fk_user_created foreign key (user_id) references users(user_id)
-        on delete cascade on update cascade,
-        constraint ck_type_discussion check( (type = 'M' and movie_id notnull and person_id isnull)
-        or (type='P' and person_id  notnull and movie_id isnull)),
-        constraint fk_discussion_movie foreign key (movie_id) references movies(movie_id)
-        on delete cascade on update cascade,
-        constraint fk_discussion_person foreign key (person_id) references persons(person_id)
-        on delete cascade on update cascade
-    );
-
- */