Ignore:
File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/main/java/com/wediscussmovies/project/model/Reply.java

    r2a5d6a3 r2d57cad  
    11package com.wediscussmovies.project.model;
    2 
    3 import lombok.Data;
    42
    53import javax.persistence.*;
    64import java.sql.Date;
    7 import java.util.Optional;
    85
    9 @Data
    106@Entity
    11 @Table(name="replies")
     7@Table(name = "replies", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies")
     8@IdClass(RepliesEntityPK.class)
    129public class Reply {
    1310    @Id
    14     @GeneratedValue
     11    @Column(name = "discussion_id",insertable = false, updatable = false)
     12    private int discussionId;
     13    @GeneratedValue(strategy = GenerationType.IDENTITY)
     14    @Id
    1515    @Column(name = "reply_id")
    16     private int reply_id;
     16    private int replyId;
     17    @Basic
     18    @Column(name = "text")
     19    private String text;
     20    @Basic
     21    @Column(name = "date")
     22    private Date date;
     23    @Basic
     24    @Column(name = "user_id")
     25    private int userId;
     26    @ManyToOne
     27    @JoinColumn(name = "discussion_id", referencedColumnName = "discussion_id", nullable = false,insertable = false, updatable = false)
     28    private Discussion discussionsByDiscussionId;
     29    @ManyToOne
     30    @JoinColumn(name = "user_id", referencedColumnName = "user_id", nullable = false,insertable = false, updatable = false)
     31    private User usersByUserId;
    1732
    18     @ManyToOne
    19     @Column(name = "discussion_id")
    20     private Discussion discussion;
     33    public int getDiscussionId() {
     34        return discussionId;
     35    }
    2136
    22     @ManyToOne
    23     @Column(name = "user_id")
    24     private User user;
     37    public void setDiscussionId(int discussionId) {
     38        this.discussionId = discussionId;
     39    }
    2540
    26     @Column(name = "date", nullable = false)
    27     private Date date;
     41    public int getReplyId() {
     42        return replyId;
     43    }
    2844
    29     @Column(name= "text", length = 1000, nullable = false)
    30     private String text;
     45    public void setReplyId(int replyId) {
     46        this.replyId = replyId;
     47    }
    3148
    32     public Reply(Discussion discussion, User user, Date date, String text) {
    33         this.discussion = discussion;
    34         this.user = user;
    35         this.date = date;
     49    public String getText() {
     50        return text;
     51    }
     52
     53    public void setText(String text) {
    3654        this.text = text;
    3755    }
     56
     57    public Date getDate() {
     58        return date;
     59    }
     60
     61    public void setDate(Date date) {
     62        this.date = date;
     63    }
     64
     65    public int getUserId() {
     66        return userId;
     67    }
     68
     69    public void setUserId(int userId) {
     70        this.userId = userId;
     71    }
     72
     73    @Override
     74    public boolean equals(Object o) {
     75        if (this == o) return true;
     76        if (o == null || getClass() != o.getClass()) return false;
     77
     78        Reply that = (Reply) o;
     79
     80        if (discussionId != that.discussionId) return false;
     81        if (replyId != that.replyId) return false;
     82        if (userId != that.userId) return false;
     83        if (text != null ? !text.equals(that.text) : that.text != null) return false;
     84        if (date != null ? !date.equals(that.date) : that.date != null) return false;
     85
     86        return true;
     87    }
     88
     89    @Override
     90    public int hashCode() {
     91        int result = discussionId;
     92        result = 31 * result + replyId;
     93        result = 31 * result + (text != null ? text.hashCode() : 0);
     94        result = 31 * result + (date != null ? date.hashCode() : 0);
     95        result = 31 * result + userId;
     96        return result;
     97    }
     98
     99    public Discussion getDiscussionsByDiscussionId() {
     100        return discussionsByDiscussionId;
     101    }
     102
     103    public void setDiscussionsByDiscussionId(Discussion discussionsByDiscussionId) {
     104        this.discussionsByDiscussionId = discussionsByDiscussionId;
     105    }
     106
     107    public User getUsersByUserId() {
     108        return usersByUserId;
     109    }
     110
     111    public void setUsersByUserId(User usersByUserId) {
     112        this.usersByUserId = usersByUserId;
     113    }
    38114}
    39 
    40 
    41 /*
    42 
    43     create table replies(
    44         discussion_id integer,
    45         reply_id serial,
    46         text varchar(1000) not null,
    47         date date not null,
    48         user_id integer not null,
    49         constraint pk_replies primary key(discussion_id,reply_id),
    50         constraint fk_user_create_reply foreign key (user_id) references users(user_id)
    51         on delete cascade on update cascade,
    52         constraint fk_reply_discussion foreign key (discussion_id) references discussions(discussion_id)
    53         on delete cascade on update cascade
    54 
    55 
    56     );
    57  */
Note: See TracChangeset for help on using the changeset viewer.