Ignore:
Timestamp:
01/16/22 20:22:55 (2 years ago)
Author:
Test <matonikolov77@…>
Branches:
main
Children:
3ded84d
Parents:
2d57cad (diff), 7bc8942 (diff)
Note: this is a merge changeset, the changes displayed below correspond to the merge itself.
Use the (diff) links above to see all the changes relative to each parent.
Message:

Resolving models

Location:
src/main/java/com/wediscussmovies/project/model
Files:
14 added
12 deleted
7 edited

Legend:

Unmodified
Added
Removed

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

    r2d57cad r7fafead  
    11package com.wediscussmovies.project.model;
     2
     3import com.wediscussmovies.project.model.enumerations.DiscussionType;
     4import lombok.Data;
    25
    36import javax.persistence.*;
    47import java.sql.Date;
    58import java.util.Collection;
     9import java.util.List;
    610import java.util.Objects;
    711
     12@Data
    813@Entity
    914@Table(name = "discussions", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies")
    1015public class Discussion {
     16
    1117    @GeneratedValue(strategy = GenerationType.IDENTITY)
    1218    @Id
    1319    @Column(name = "discussion_id")
    14     private int discussionId;
    15     @Basic
    16     @Column(name = "type")
    17     private String type;
    18     @Basic
    19     @Column(name = "text")
     20    private Long id;
     21
     22    @Enumerated
     23    private DiscussionType type;
     24
    2025    private String text;
    21     @Basic
    22     @Column(name = "title")
     26
    2327    private String title;
    24     @Basic
    25     @Column(name = "date")
     28
    2629    private Date date;
    27     @Basic
    28     @Column(name = "user_id")
    29     private int userId;
    30     @Basic
    31     @Column(name = "movie_id")
    32     private Integer movieId;
    33     @Basic
    34     @Column(name = "person_id")
    35     private Integer personId;
     30
     31
     32
     33
    3634
    3735    @ManyToOne
    38     @JoinColumn(name = "user_id", referencedColumnName = "user_id", nullable = false,insertable = false, updatable = false)
    39     private User usersByUserId;
     36    @JoinColumn(name = "user_id", referencedColumnName = "user_id", nullable = false)
     37    private User user;
     38
    4039    @ManyToOne
    41     @JoinColumn(name = "movie_id", referencedColumnName = "movie_id",insertable = false, updatable = false)
    42     private Movie moviesByMovieId;
     40    @JoinColumn(name = "movie_id", referencedColumnName = "movie_id")
     41    private Movie movie;
     42
    4343    @ManyToOne
    44     @JoinColumn(name = "person_id", referencedColumnName = "person_id",insertable = false, updatable = false)
    45     private Person personsByPersonId;
    46     @OneToMany(mappedBy = "discussionsByDiscussionId")
    47     private Collection<Reply> repliesByDiscussionId;
     44    @JoinColumn(name = "person_id", referencedColumnName = "person_id")
     45    private Person person;
    4846
    49     public int getDiscussionId() {
    50         return discussionId;
    51     }
    5247
    53     public void setDiscussionId(int discussionId) {
    54         this.discussionId = discussionId;
    55     }
    5648
    57     public String getType() {
    58         return type;
    59     }
    6049
    61     public void setType(String type) {
     50
     51
     52    public Discussion(DiscussionType type, String text, String title, Date date, User user, Movie movie, Person person, List<Reply> replies) {
    6253        this.type = type;
    63     }
    64 
    65     public String getText() {
    66         return text;
    67     }
    68 
    69     public void setText(String text) {
    7054        this.text = text;
    71     }
    72 
    73     public String getTitle() {
    74         return title;
    75     }
    76 
    77     public void setTitle(String title) {
    7855        this.title = title;
    79     }
    80 
    81     public Date getDate() {
    82         return date;
    83     }
    84 
    85     public void setDate(Date date) {
    8656        this.date = date;
    87     }
    88 
    89     public int getUserId() {
    90         return userId;
    91     }
    92 
    93     public void setUserId(int userId) {
    94         this.userId = userId;
    95     }
    96 
    97     public Integer getMovieId() {
    98         return movieId;
    99     }
    100 
    101     public void setMovieId(Integer movieId) {
    102         this.movieId = movieId;
    103     }
    104 
    105     public Integer getPersonId() {
    106         return personId;
    107     }
    108 
    109     public void setPersonId(Integer personId) {
    110         this.personId = personId;
    111     }
    112 
    113     @Override
    114     public boolean equals(Object o) {
    115         if (this == o) return true;
    116         if (o == null || getClass() != o.getClass()) return false;
    117 
    118         Discussion that = (Discussion) o;
    119 
    120         if (discussionId != that.discussionId) return false;
    121         if (userId != that.userId) return false;
    122         if (!Objects.equals(type, that.type)) return false;
    123         if (!Objects.equals(text, that.text)) return false;
    124         if (!Objects.equals(title, that.title)) return false;
    125         if (!Objects.equals(date, that.date)) return false;
    126         if (!Objects.equals(movieId, that.movieId)) return false;
    127         if (!Objects.equals(personId, that.personId)) return false;
    128 
    129         return true;
    130     }
    131 
    132     @Override
    133     public int hashCode() {
    134         int result = discussionId;
    135         result = 31 * result + (type != null ? type.hashCode() : 0);
    136         result = 31 * result + (text != null ? text.hashCode() : 0);
    137         result = 31 * result + (title != null ? title.hashCode() : 0);
    138         result = 31 * result + (date != null ? date.hashCode() : 0);
    139         result = 31 * result + userId;
    140         result = 31 * result + (movieId != null ? movieId.hashCode() : 0);
    141         result = 31 * result + (personId != null ? personId.hashCode() : 0);
    142         return result;
    143     }
    144 
    145     public User getUsersByUserId() {
    146         return usersByUserId;
    147     }
    148 
    149     public void setUsersByUserId(User usersByUserId) {
    150         this.usersByUserId = usersByUserId;
    151     }
    152 
    153     public Movie getMoviesByMovieId() {
    154         return moviesByMovieId;
    155     }
    156 
    157     public void setMoviesByMovieId(Movie moviesByMovieId) {
    158         this.moviesByMovieId = moviesByMovieId;
    159     }
    160 
    161     public Person getPersonsByPersonId() {
    162         return personsByPersonId;
    163     }
    164 
    165     public void setPersonsByPersonId(Person personsByPersonId) {
    166         this.personsByPersonId = personsByPersonId;
    167     }
    168 
    169     public Collection<Reply> getRepliesByDiscussionId() {
    170         return repliesByDiscussionId;
    171     }
    172 
    173     public void setRepliesByDiscussionId(Collection<Reply> repliesByDiscussionId) {
    174         this.repliesByDiscussionId = repliesByDiscussionId;
     57        this.user = user;
     58        this.movie = movie;
     59        this.person = person;
    17560    }
    17661
    … …  
    17863    }
    17964
    180     public Discussion(String type, String text, String title, Date date, int userId, Integer movieId, Integer personId) {
    181         this.type = type;
    182         this.text = text;
    183         this.title = title;
    184         this.date = date;
    185         this.userId = userId;
    186         this.movieId = movieId;
    187         this.personId = personId;
    188     }
     65
    18966}

  • src/main/java/com/wediscussmovies/project/model/Genre.java

    r2d57cad r7fafead  
    11package com.wediscussmovies.project.model;
     2
    23
    34import javax.persistence.*;
    45import java.util.Collection;
     6import lombok.Data;
     7
    58
    69@Entity
    710@Table(name = "genres", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies")
     11@Data
    812public class Genre {
     13
    914    @GeneratedValue(strategy = GenerationType.IDENTITY)
    1015    @Id
    1116    @Column(name = "genre_id")
    12     private int genreId;
    13     @Basic
     17    private Long id;
     18
    1419    @Column(name = "genre_type")
    15     private String genreType;
    16     @OneToMany(mappedBy = "genresByGenreId")
    17     private Collection<MovieGenresEntity> movieGenresByGenreId;
    18     @OneToMany(mappedBy = "genresByGenreId")
    19     private Collection<UserGenresEntity> userGenresByGenreId;
     20    private String genre;
    2021
    21     public int getGenreId() {
    22         return genreId;
    23     }
    24 
    25     public void setGenreId(int genreId) {
    26         this.genreId = genreId;
    27     }
    28 
    29     public String getGenreType() {
    30         return genreType;
    31     }
    32 
    33     public void setGenreType(String genreType) {
    34         this.genreType = genreType;
    35     }
    36 
    37     @Override
    38     public boolean equals(Object o) {
    39         if (this == o) return true;
    40         if (o == null || getClass() != o.getClass()) return false;
    41 
    42         Genre that = (Genre) o;
    43 
    44         if (genreId != that.genreId) return false;
    45         if (genreType != null ? !genreType.equals(that.genreType) : that.genreType != null) return false;
    46 
    47         return true;
    48     }
    49 
    50     @Override
    51     public int hashCode() {
    52         int result = genreId;
    53         result = 31 * result + (genreType != null ? genreType.hashCode() : 0);
    54         return result;
    55     }
    56 
    57     public Collection<MovieGenresEntity> getMovieGenresByGenreId() {
    58         return movieGenresByGenreId;
    59     }
    60 
    61     public void setMovieGenresByGenreId(Collection<MovieGenresEntity> movieGenresByGenreId) {
    62         this.movieGenresByGenreId = movieGenresByGenreId;
    63     }
    64 
    65     public Collection<UserGenresEntity> getUserGenresByGenreId() {
    66         return userGenresByGenreId;
    67     }
    68 
    69     public void setUserGenresByGenreId(Collection<UserGenresEntity> userGenresByGenreId) {
    70         this.userGenresByGenreId = userGenresByGenreId;
    71     }
    72 
    73     public Genre(String genreType) {
    74         this.genreType = genreType;
     22    public Genre(String genre) {
     23        this.genre = genre;
    7524    }
    7625
    7726    public Genre() {
    7827    }
     28
    7929}

  • src/main/java/com/wediscussmovies/project/model/Movie.java

    r2d57cad r7fafead  
    11package com.wediscussmovies.project.model;
     2
     3import lombok.Data;
    24
    35import javax.persistence.*;
    46import java.sql.Date;
    57import java.util.Collection;
     8import java.util.Comparator;
     9import java.util.List;
    610import java.util.Objects;
     11
    712
    813@Entity
    914@Table(name = "movies", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies")
     15@Data
    1016public class Movie {
     17
    1118    @GeneratedValue(strategy = GenerationType.IDENTITY)
    1219    @Id
    1320    @Column(name = "movie_id")
    14     private int movieId;
    15     @Basic
    16     @Column(name = "title")
     21    private Long id;
     22
    1723    private String title;
    18     @Basic
    19     @Column(name = "description")
     24
    2025    private String description;
    21     @Basic
     26
    2227    @Column(name = "image_url")
    2328    private String imageUrl;
    24     @Basic
     29
     30
    2531    @Column(name = "airing_date")
    26     private Date airingDate;
    27     @Basic
     32    private Date aringDate;
     33
    2834    @Column(name = "imdb_rating")
    29     private Double imdbRating;
    30     @Basic
    31     @Column(name = "director_id")
    32     private Integer directorId;
    33     @OneToMany(mappedBy = "moviesByMovieId")
    34     private Collection<Discussion> discussionsByMovieId;
    35     @OneToMany(mappedBy = "moviesByMovieId")
    36     private Collection<MovieActorsEntity> movieActorsByMovieId;
    37     @OneToMany(mappedBy = "moviesByMovieId")
    38     private Collection<MovieGenresEntity> movieGenresByMovieId;
    39     @OneToMany(mappedBy = "moviesByMovieId")
    40     private Collection<MovieLikesEntity> movieLikesByMovieId;
    41     @OneToMany(mappedBy = "moviesByMovieId")
    42     private Collection<MovieRatesEntity> movieRatesByMovieId;
     35    private Double imbdRating;
     36
     37    @ManyToMany
     38    private List<Genre> genres;
     39
     40    @ManyToMany
     41    private List<Person> likes;
     42
     43    @ManyToMany
     44    private List<Person> actors;
     45
     46
     47
     48
    4349    @ManyToOne
    44     @JoinColumn(name = "director_id", referencedColumnName = "person_id",insertable = false, updatable = false)
    45     private Person personsByDirectorId;
     50    @JoinColumn(name = "director_id")
     51    private Person director;
    4652
    47     public int getMovieId() {
    48         return movieId;
     53
     54
     55
     56
     57
     58    public boolean isFromGenre(Genre genre){
     59
     60     return    genres
     61                .stream()
     62                .anyMatch(g -> Objects.equals(g.getId(), genre.getId()));
     63
     64    }
     65    public boolean hasActor(Person p){
     66        return
     67                actors
     68                        .stream()
     69                        .anyMatch(a -> Objects.equals(a.getPersonId(), p.getPersonId()));
     70
     71
    4972    }
    5073
    51     public void setMovieId(int movieId) {
    52         this.movieId = movieId;
     74    public boolean isDirectedBy(Person p){
     75        return Objects.equals(director.getPersonId(), p.getPersonId());
    5376    }
    5477
    55     public String getTitle() {
    56         return title;
    57     }
     78    public static Comparator<Movie> comparatorTitle = Comparator.comparing(Movie::getTitle);
    5879
    59     public void setTitle(String title) {
    60         this.title = title;
    61     }
    6280
    63     public String getDescription() {
    64         return description;
    65     }
     81    public Movie( String title, String description, String imageUrl, Date aringDate, Double imbdRating,Person director, List<Person> actors, List<Genre> genres) {
    6682
    67     public void setDescription(String description) {
    68         this.description = description;
    69     }
    70 
    71     public String getImageUrl() {
    72         return imageUrl;
    73     }
    74 
    75     public void setImageUrl(String imageUrl) {
    76         this.imageUrl = imageUrl;
    77     }
    78 
    79     public Date getAiringDate() {
    80         return airingDate;
    81     }
    82 
    83     public void setAiringDate(Date airingDate) {
    84         this.airingDate = airingDate;
    85     }
    86 
    87     public Double getImdbRating() {
    88         return imdbRating;
    89     }
    90 
    91     public void setImdbRating(Double imdbRating) {
    92         this.imdbRating = imdbRating;
    93     }
    94 
    95     public Integer getDirectorId() {
    96         return directorId;
    97     }
    98 
    99     public void setDirectorId(Integer directorId) {
    100         this.directorId = directorId;
    101     }
    102 
    103     @Override
    104     public boolean equals(Object o) {
    105         if (this == o) return true;
    106         if (o == null || getClass() != o.getClass()) return false;
    107 
    108         Movie that = (Movie) o;
    109 
    110         if (movieId != that.movieId) return false;
    111         if (!Objects.equals(title, that.title)) return false;
    112         if (!Objects.equals(description, that.description)) return false;
    113         if (!Objects.equals(imageUrl, that.imageUrl)) return false;
    114         if (!Objects.equals(airingDate, that.airingDate)) return false;
    115         if (!Objects.equals(imdbRating, that.imdbRating)) return false;
    116         if (!Objects.equals(directorId, that.directorId)) return false;
    117 
    118         return true;
    119     }
    120 
    121     public Movie(String title, String description, String imageUrl, Date airingDate, Double imdbRating, Integer directorId) {
    12283        this.title = title;
    12384        this.description = description;
    12485        this.imageUrl = imageUrl;
    125         this.airingDate = airingDate;
    126         this.imdbRating = imdbRating;
    127         this.directorId = directorId;
     86        this.aringDate = aringDate;
     87        this.imbdRating = imbdRating;
     88        this.genres = genres;
     89        this.likes = likes;
     90        this.actors = actors;
     91        this.director = director;
    12892    }
    12993
    … …  
    13195    }
    13296
    133     @Override
    134     public int hashCode() {
    135         int result = movieId;
    136         result = 31 * result + (title != null ? title.hashCode() : 0);
    137         result = 31 * result + (description != null ? description.hashCode() : 0);
    138         result = 31 * result + (imageUrl != null ? imageUrl.hashCode() : 0);
    139         result = 31 * result + (airingDate != null ? airingDate.hashCode() : 0);
    140         result = 31 * result + (imdbRating != null ? imdbRating.hashCode() : 0);
    141         result = 31 * result + (directorId != null ? directorId.hashCode() : 0);
    142         return result;
    143     }
    14497
    145     public Collection<Discussion> getDiscussionsByMovieId() {
    146         return discussionsByMovieId;
    147     }
    148 
    149     public void setDiscussionsByMovieId(Collection<Discussion> discussionsByMovieId) {
    150         this.discussionsByMovieId = discussionsByMovieId;
    151     }
    152 
    153     public Collection<MovieActorsEntity> getMovieActorsByMovieId() {
    154         return movieActorsByMovieId;
    155     }
    156 
    157     public void setMovieActorsByMovieId(Collection<MovieActorsEntity> movieActorsByMovieId) {
    158         this.movieActorsByMovieId = movieActorsByMovieId;
    159     }
    160 
    161     public Collection<MovieGenresEntity> getMovieGenresByMovieId() {
    162         return movieGenresByMovieId;
    163     }
    164 
    165     public void setMovieGenresByMovieId(Collection<MovieGenresEntity> movieGenresByMovieId) {
    166         this.movieGenresByMovieId = movieGenresByMovieId;
    167     }
    168 
    169     public Collection<MovieLikesEntity> getMovieLikesByMovieId() {
    170         return movieLikesByMovieId;
    171     }
    172 
    173     public void setMovieLikesByMovieId(Collection<MovieLikesEntity> movieLikesByMovieId) {
    174         this.movieLikesByMovieId = movieLikesByMovieId;
    175     }
    176 
    177     public Collection<MovieRatesEntity> getMovieRatesByMovieId() {
    178         return movieRatesByMovieId;
    179     }
    180 
    181     public void setMovieRatesByMovieId(Collection<MovieRatesEntity> movieRatesByMovieId) {
    182         this.movieRatesByMovieId = movieRatesByMovieId;
    183     }
    184 
    185     public Person getPersonsByDirectorId() {
    186         return personsByDirectorId;
    187     }
    188 
    189     public void setPersonsByDirectorId(Person personsByDirectorId) {
    190         this.personsByDirectorId = personsByDirectorId;
    191     }
    19298}

  • src/main/java/com/wediscussmovies/project/model/Person.java

    r2d57cad r7fafead  
    11package com.wediscussmovies.project.model;
     2
     3import com.wediscussmovies.project.model.enumerations.PersonType;
     4import lombok.Data;
    25
    36import javax.persistence.*;
    47import java.sql.Date;
    58import java.util.Collection;
     9import java.util.List;
    610
    711@Entity
    812@Table(name = "persons", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies")
     13@Data
    914public class Person {
    1015    @GeneratedValue(strategy = GenerationType.IDENTITY)
    1116    @Id
    1217    @Column(name = "person_id")
    13     private int personId;
    14     @Basic
    15     @Column(name = "name")
     18    private Long personId;
     19
    1620    private String name;
    17     @Basic
    18     @Column(name = "surname")
     21
    1922    private String surname;
    20     @Basic
    21     @Column(name = "type")
    22     private String type;
    23     @Basic
     23
     24    @Enumerated
     25    private PersonType type;
     26
    2427    @Column(name = "date_of_birth")
    25     private Date dateOfBirth;
    26     @Basic
     28    private Date birthDate;
     29
    2730    @Column(name = "image_url")
    2831    private String imageUrl;
    29     @Basic
    30     @Column(name = "description")
     32
    3133    private String description;
    32     @OneToMany(mappedBy = "personsByPersonId")
    33     private Collection<Discussion> discussionsByPersonId;
    34     @OneToMany(mappedBy = "personsByActorId")
    35     private Collection<MovieActorsEntity> movieActorsByPersonId;
    36     @OneToMany(mappedBy = "personsByDirectorId")
    37     private Collection<Movie> moviesByPersonId;
    38     @OneToMany(mappedBy = "personsByPersonId")
    39     private Collection<PersonRatesEntity> personRatesByPersonId;
    4034
    41     public int getPersonId() {
    42         return personId;
     35
     36
     37    public Person() {
    4338    }
    4439
    45     public void setPersonId(int personId) {
    46         this.personId = personId;
    47     }
    48 
    49     public String getName() {
    50         return name;
    51     }
    52 
    53     public void setName(String name) {
     40    public Person(String name, String surname, PersonType type, Date date_of_birth, String image_url, String description) {
    5441        this.name = name;
    55     }
    56 
    57     public String getSurname() {
    58         return surname;
    59     }
    60 
    61     public void setSurname(String surname) {
    6242        this.surname = surname;
    63     }
    64 
    65     public String getType() {
    66         return type;
    67     }
    68 
    69     public void setType(String type) {
    7043        this.type = type;
    71     }
    72 
    73     public Date getDateOfBirth() {
    74         return dateOfBirth;
    75     }
    76 
    77     public void setDateOfBirth(Date dateOfBirth) {
    78         this.dateOfBirth = dateOfBirth;
    79     }
    80 
    81     public String getImageUrl() {
    82         return imageUrl;
    83     }
    84 
    85     public void setImageUrl(String imageUrl) {
    86         this.imageUrl = imageUrl;
    87     }
    88 
    89     public String getDescription() {
    90         return description;
    91     }
    92 
    93     public void setDescription(String description) {
     44        this.birthDate = date_of_birth;
     45        this.imageUrl = image_url;
    9446        this.description = description;
    9547    }
    96 
    97     @Override
    98     public boolean equals(Object o) {
    99         if (this == o) return true;
    100         if (o == null || getClass() != o.getClass()) return false;
    101 
    102         Person that = (Person) o;
    103 
    104         if (personId != that.personId) return false;
    105         if (name != null ? !name.equals(that.name) : that.name != null) return false;
    106         if (surname != null ? !surname.equals(that.surname) : that.surname != null) return false;
    107         if (type != null ? !type.equals(that.type) : that.type != null) return false;
    108         if (dateOfBirth != null ? !dateOfBirth.equals(that.dateOfBirth) : that.dateOfBirth != null) return false;
    109         if (imageUrl != null ? !imageUrl.equals(that.imageUrl) : that.imageUrl != null) return false;
    110         if (description != null ? !description.equals(that.description) : that.description != null) return false;
    111 
    112         return true;
    113     }
    114 
    115     @Override
    116     public int hashCode() {
    117         int result = personId;
    118         result = 31 * result + (name != null ? name.hashCode() : 0);
    119         result = 31 * result + (surname != null ? surname.hashCode() : 0);
    120         result = 31 * result + (type != null ? type.hashCode() : 0);
    121         result = 31 * result + (dateOfBirth != null ? dateOfBirth.hashCode() : 0);
    122         result = 31 * result + (imageUrl != null ? imageUrl.hashCode() : 0);
    123         result = 31 * result + (description != null ? description.hashCode() : 0);
    124         return result;
    125     }
    126 
    127     public Collection<Discussion> getDiscussionsByPersonId() {
    128         return discussionsByPersonId;
    129     }
    130 
    131     public void setDiscussionsByPersonId(Collection<Discussion> discussionsByPersonId) {
    132         this.discussionsByPersonId = discussionsByPersonId;
    133     }
    134 
    135     public Collection<MovieActorsEntity> getMovieActorsByPersonId() {
    136         return movieActorsByPersonId;
    137     }
    138 
    139     public void setMovieActorsByPersonId(Collection<MovieActorsEntity> movieActorsByPersonId) {
    140         this.movieActorsByPersonId = movieActorsByPersonId;
    141     }
    142 
    143     public Collection<Movie> getMoviesByPersonId() {
    144         return moviesByPersonId;
    145     }
    146 
    147     public void setMoviesByPersonId(Collection<Movie> moviesByPersonId) {
    148         this.moviesByPersonId = moviesByPersonId;
    149     }
    150 
    151     public Collection<PersonRatesEntity> getPersonRatesByPersonId() {
    152         return personRatesByPersonId;
    153     }
    154 
    155     public void setPersonRatesByPersonId(Collection<PersonRatesEntity> personRatesByPersonId) {
    156         this.personRatesByPersonId = personRatesByPersonId;
    157     }
    15848}

  • src/main/java/com/wediscussmovies/project/model/RepliesEntityPK.java

    r2d57cad r7fafead  
    88
    99public class RepliesEntityPK implements Serializable {
     10    @Id
    1011    @Column(name = "discussion_id")
    11     @Id
    12     private int discussionId;
    13     @Column(name = "reply_id")
     12    private Long discussionId;
    1413    @Id
    1514    @GeneratedValue(strategy = GenerationType.IDENTITY)
    16     private int replyId;
     15    @Column(name = "reply_id")
     16    private Long replyId;
    1717
    18     public int getDiscussionId() {
    19         return discussionId;
    20     }
    2118
    22     public void setDiscussionId(int discussionId) {
    23         this.discussionId = discussionId;
    24     }
    2519
    26     public int getReplyId() {
    27         return replyId;
    28     }
    29 
    30     public void setReplyId(int replyId) {
    31         this.replyId = replyId;
    32     }
    33 
    34     @Override
    35     public boolean equals(Object o) {
    36         if (this == o) return true;
    37         if (o == null || getClass() != o.getClass()) return false;
    38 
    39         RepliesEntityPK that = (RepliesEntityPK) o;
    40 
    41         if (discussionId != that.discussionId) return false;
    42         if (replyId != that.replyId) return false;
    43 
    44         return true;
    45     }
    46 
    47     @Override
    48     public int hashCode() {
    49         int result = discussionId;
    50         result = 31 * result + replyId;
    51         return result;
    52     }
    5320}

  • src/main/java/com/wediscussmovies/project/model/Reply.java

    r2d57cad r7fafead  
    11package com.wediscussmovies.project.model;
     2
     3import lombok.Data;
    24
    35import javax.persistence.*;
    46import java.sql.Date;
     7import java.util.Optional;
    58
    69@Entity
    710@Table(name = "replies", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies")
    811@IdClass(RepliesEntityPK.class)
     12@Data
    913public class Reply {
    1014    @Id
    11     @Column(name = "discussion_id",insertable = false, updatable = false)
    12     private int discussionId;
     15    @Column(name = "discussion_id")
     16    private Long discussionId;
     17
    1318    @GeneratedValue(strategy = GenerationType.IDENTITY)
    1419    @Id
    1520    @Column(name = "reply_id")
    16     private int replyId;
    17     @Basic
    18     @Column(name = "text")
     21    private Long replyId;
     22
    1923    private String text;
    20     @Basic
    21     @Column(name = "date")
     24
    2225    private Date date;
    23     @Basic
    24     @Column(name = "user_id")
    25     private int userId;
     26
    2627    @ManyToOne
    2728    @JoinColumn(name = "discussion_id", referencedColumnName = "discussion_id", nullable = false,insertable = false, updatable = false)
    28     private Discussion discussionsByDiscussionId;
     29    private Discussion discussion;
     30
    2931    @ManyToOne
    30     @JoinColumn(name = "user_id", referencedColumnName = "user_id", nullable = false,insertable = false, updatable = false)
    31     private User usersByUserId;
     32    @JoinColumn(name = "user_id")
     33    private User user;
    3234
    33     public int getDiscussionId() {
    34         return discussionId;
     35
     36
     37
     38    public Reply(Discussion discussion, User user, Date date, String text) {
     39        this.discussion = discussion;
     40        this.user = user;
     41        this.date = date;
     42        this.text = text;
     43
    3544    }
    3645
    37     public void setDiscussionId(int discussionId) {
    38         this.discussionId = discussionId;
     46    public Reply() {
     47
    3948    }
    4049
    41     public int getReplyId() {
    42         return replyId;
    43     }
    4450
    45     public void setReplyId(int replyId) {
    46         this.replyId = replyId;
    47     }
    48 
    49     public String getText() {
    50         return text;
    51     }
    52 
    53     public void setText(String text) {
    54         this.text = text;
    55     }
    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     }
    11451}

  • src/main/java/com/wediscussmovies/project/model/User.java

    r2d57cad r7fafead  
    33import javax.persistence.*;
    44import java.util.Collection;
     5import java.util.List;
    56
    67@Entity
    … …  
    1011    @Id
    1112    @Column(name = "user_id")
    12     private int userId;
    13     @Basic
    14     @Column(name = "username")
     13    private Long userId;
     14
    1515    private String username;
    16     @Basic
    17     @Column(name = "name")
     16
    1817    private String name;
    19     @Basic
    20     @Column(name = "surname")
     18
    2119    private String surname;
    22     @Basic
    23     @Column(name = "email")
     20
    2421    private String email;
    25     @Basic
    26     @Column(name = "password")
     22
    2723    private String password;
    28     @OneToMany(mappedBy = "usersByUserId")
    29     private Collection<Discussion> discussionsByUserId;
    30     @OneToMany(mappedBy = "usersByUserId")
    31     private Collection<MovieLikesEntity> movieLikesByUserId;
    32     @OneToMany(mappedBy = "usersByUserId")
    33     private Collection<MovieRatesEntity> movieRatesByUserId;
    34     @OneToMany(mappedBy = "usersByUserId")
    35     private Collection<PersonRatesEntity> personRatesByUserId;
    36     @OneToMany(mappedBy = "usersByUserId")
    37     private Collection<Reply> repliesByUserId;
    38     @OneToMany(mappedBy = "usersByUserId")
    39     private Collection<UserGenresEntity> userGenresByUserId;
    4024
    41     public int getUserId() {
    42         return userId;
    43     }
     25    @ManyToMany
     26    private List<Movie> movies;
    4427
    45     public void setUserId(int userId) {
    46         this.userId = userId;
    47     }
    4828
    49     public String getUsername() {
    50         return username;
    51     }
    5229
    53     public void setUsername(String username) {
     30
     31    public User(String username, String name, String surname, String email, String password) {
    5432        this.username = username;
    55     }
    56 
    57     public String getName() {
    58         return name;
    59     }
    60 
    61     public void setName(String name) {
    6233        this.name = name;
    63     }
    64 
    65     public String getSurname() {
    66         return surname;
    67     }
    68 
    69     public void setSurname(String surname) {
    7034        this.surname = surname;
    71     }
    72 
    73     public String getEmail() {
    74         return email;
    75     }
    76 
    77     public void setEmail(String email) {
    7835        this.email = email;
    79     }
    80 
    81     public String getPassword() {
    82         return password;
    83     }
    84 
    85     public void setPassword(String password) {
    8636        this.password = password;
    8737    }
    8838
    89     @Override
    90     public boolean equals(Object o) {
    91         if (this == o) return true;
    92         if (o == null || getClass() != o.getClass()) return false;
    93 
    94         User that = (User) o;
    95 
    96         if (userId != that.userId) return false;
    97         if (username != null ? !username.equals(that.username) : that.username != null) return false;
    98         if (name != null ? !name.equals(that.name) : that.name != null) return false;
    99         if (surname != null ? !surname.equals(that.surname) : that.surname != null) return false;
    100         if (email != null ? !email.equals(that.email) : that.email != null) return false;
    101         if (password != null ? !password.equals(that.password) : that.password != null) return false;
    102 
    103         return true;
    104     }
    105 
    106     @Override
    107     public int hashCode() {
    108         int result = userId;
    109         result = 31 * result + (username != null ? username.hashCode() : 0);
    110         result = 31 * result + (name != null ? name.hashCode() : 0);
    111         result = 31 * result + (surname != null ? surname.hashCode() : 0);
    112         result = 31 * result + (email != null ? email.hashCode() : 0);
    113         result = 31 * result + (password != null ? password.hashCode() : 0);
    114         return result;
    115     }
    116 
    117     public Collection<Discussion> getDiscussionsByUserId() {
    118         return discussionsByUserId;
    119     }
    120 
    121     public void setDiscussionsByUserId(Collection<Discussion> discussionsByUserId) {
    122         this.discussionsByUserId = discussionsByUserId;
    123     }
    124 
    125     public Collection<MovieLikesEntity> getMovieLikesByUserId() {
    126         return movieLikesByUserId;
    127     }
    128 
    129     public void setMovieLikesByUserId(Collection<MovieLikesEntity> movieLikesByUserId) {
    130         this.movieLikesByUserId = movieLikesByUserId;
    131     }
    132 
    133     public Collection<MovieRatesEntity> getMovieRatesByUserId() {
    134         return movieRatesByUserId;
    135     }
    136 
    137     public void setMovieRatesByUserId(Collection<MovieRatesEntity> movieRatesByUserId) {
    138         this.movieRatesByUserId = movieRatesByUserId;
    139     }
    140 
    141     public Collection<PersonRatesEntity> getPersonRatesByUserId() {
    142         return personRatesByUserId;
    143     }
    144 
    145     public void setPersonRatesByUserId(Collection<PersonRatesEntity> personRatesByUserId) {
    146         this.personRatesByUserId = personRatesByUserId;
    147     }
    148 
    149     public Collection<Reply> getRepliesByUserId() {
    150         return repliesByUserId;
    151     }
    152 
    153     public void setRepliesByUserId(Collection<Reply> repliesByUserId) {
    154         this.repliesByUserId = repliesByUserId;
    155     }
    156 
    157     public Collection<UserGenresEntity> getUserGenresByUserId() {
    158         return userGenresByUserId;
    159     }
    160 
    161     public void setUserGenresByUserId(Collection<UserGenresEntity> userGenresByUserId) {
    162         this.userGenresByUserId = userGenresByUserId;
     39    public User() {
    16340    }
    16441}
Note: See TracChangeset for help on using the changeset viewer.