Changeset 2d57cad in Git
- Timestamp:
- 01/16/22 17:12:01 (3 years ago)
- Branches:
- main
- Children:
- 7fafead
- Parents:
- 839f96a
- Files:
-
- 176 added
- 1 deleted
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
pom.xml
r839f96a r2d57cad 59 59 <scope>test</scope> 60 60 </dependency> 61 61 62 <dependency> 62 63 <groupId>org.springframework.boot</groupId> 63 64 <artifactId>spring-boot-starter-data-jpa</artifactId> 64 <version>RELEASE</version>65 <scope>compile</scope>66 65 </dependency> 66 <dependency> 67 <groupId>org.springframework.boot</groupId> 68 <artifactId>spring-boot-actuator</artifactId> 69 </dependency> 70 <dependency> 71 <groupId>com.h2database</groupId> 72 <artifactId>h2</artifactId> 73 </dependency> 74 <dependency> 75 <groupId>org.postgresql</groupId> 76 <artifactId>postgresql</artifactId> 77 </dependency> 78 <dependency> 79 <groupId>com.jcraft</groupId> 80 <artifactId>jsch</artifactId> 81 <version>0.1.55</version> 82 </dependency> 83 67 84 </dependencies> 68 85 -
src/main/java/com/wediscussmovies/project/model/Discussion.java
r839f96a r2d57cad 3 3 import javax.persistence.*; 4 4 import java.sql.Date; 5 import java.util.List; 5 import java.util.Collection; 6 import java.util.Objects; 6 7 7 8 @Entity 9 @Table(name = "discussions", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies") 8 10 public class Discussion { 11 @GeneratedValue(strategy = GenerationType.IDENTITY) 9 12 @Id 10 @GeneratedValue 11 private int discussion_id; 13 @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 String text; 21 @Basic 22 @Column(name = "title") 23 private String title; 24 @Basic 25 @Column(name = "date") 26 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; 12 36 13 37 @ManyToOne 14 @Column(name = "movie_id") 15 private Movie movie; 38 @JoinColumn(name = "user_id", referencedColumnName = "user_id", nullable = false,insertable = false, updatable = false) 39 private User usersByUserId; 40 @ManyToOne 41 @JoinColumn(name = "movie_id", referencedColumnName = "movie_id",insertable = false, updatable = false) 42 private Movie moviesByMovieId; 43 @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; 16 48 17 @ManyToOne()18 @Column(name = "person_id")19 private Person person;49 public int getDiscussionId() { 50 return discussionId; 51 } 20 52 21 @ManyToOne22 @Column(name = "user_id")23 private User user;53 public void setDiscussionId(int discussionId) { 54 this.discussionId = discussionId; 55 } 24 56 25 @Column(name = "text", length = 1000, nullable = false) 26 private String text; 57 public String getType() { 58 return type; 59 } 27 60 28 @Column(name = "title", length = 1000, nullable = false) 29 private String title; 61 public void setType(String type) { 62 this.type = type; 63 } 30 64 31 @Column(name = "date", nullable = false) 32 private Date date; 65 public String getText() { 66 return text; 67 } 33 68 34 @OneToMany 35 private List<Reply> replies; 69 public void setText(String text) { 70 this.text = text; 71 } 72 73 public String getTitle() { 74 return title; 75 } 76 77 public void setTitle(String title) { 78 this.title = title; 79 } 80 81 public Date getDate() { 82 return date; 83 } 84 85 public void setDate(Date date) { 86 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; 175 } 176 177 public Discussion() { 178 } 179 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 } 36 189 } 37 38 39 /*40 create table discussions(41 discussion_id serial primary key,42 type char(1) not null,43 text varchar(1000) not null,44 title varchar(250) not null,45 date date not null,46 user_id integer not null,47 movie_id integer,48 person_id integer,49 constraint fk_user_created foreign key (user_id) references users(user_id)50 on delete cascade on update cascade,51 constraint ck_type_discussion check( (type = 'M' and movie_id notnull and person_id isnull)52 or (type='P' and person_id notnull and movie_id isnull)),53 constraint fk_discussion_movie foreign key (movie_id) references movies(movie_id)54 on delete cascade on update cascade,55 constraint fk_discussion_person foreign key (person_id) references persons(person_id)56 on delete cascade on update cascade57 );58 59 */ -
src/main/java/com/wediscussmovies/project/model/Genre.java
r839f96a r2d57cad 1 1 package com.wediscussmovies.project.model; 2 2 3 import javax.persistence.Column; 4 import javax.persistence.Entity; 5 import javax.persistence.GeneratedValue; 6 import javax.persistence.Id; 3 import javax.persistence.*; 4 import java.util.Collection; 7 5 8 @Entity(name="genres") 6 @Entity 7 @Table(name = "genres", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies") 9 8 public class Genre { 9 @GeneratedValue(strategy = GenerationType.IDENTITY) 10 10 @Id 11 @GeneratedValue 12 @Column(name="genre_id", nullable = false, unique = true) 13 private int genre_id; 11 @Column(name = "genre_id") 12 private int genreId; 13 @Basic 14 @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; 14 20 15 @Column(name="genre_type", length = 100, nullable = false, unique = true) 16 private String genre_type; 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; 75 } 76 77 public Genre() { 78 } 17 79 } 18 19 /*20 21 create table genres(22 genre_id serial primary key,23 genre_type varchar(100) not null unique24 );25 26 */ -
src/main/java/com/wediscussmovies/project/model/Movie.java
r839f96a r2d57cad 3 3 import javax.persistence.*; 4 4 import java.sql.Date; 5 import java.util.List; 5 import java.util.Collection; 6 import java.util.Objects; 6 7 7 @Entity(name="movies") 8 @Entity 9 @Table(name = "movies", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies") 8 10 public class Movie { 11 @GeneratedValue(strategy = GenerationType.IDENTITY) 9 12 @Id 10 @GeneratedValue 11 @Column(name="movie_id", nullable = false) 12 private int movie_id; 13 @Column(name = "movie_id") 14 private int movieId; 15 @Basic 16 @Column(name = "title") 17 private String title; 18 @Basic 19 @Column(name = "description") 20 private String description; 21 @Basic 22 @Column(name = "image_url") 23 private String imageUrl; 24 @Basic 25 @Column(name = "airing_date") 26 private Date airingDate; 27 @Basic 28 @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; 43 @ManyToOne 44 @JoinColumn(name = "director_id", referencedColumnName = "person_id",insertable = false, updatable = false) 45 private Person personsByDirectorId; 13 46 14 @Column(name="title", length = 150, unique = true, nullable = false) 15 private String Title; 47 public int getMovieId() { 48 return movieId; 49 } 16 50 17 @Column(name="description", nullable = false, length = 1000) 18 private String description; 51 public void setMovieId(int movieId) { 52 this.movieId = movieId; 53 } 19 54 20 @Column(name="image_url", length = 300, nullable = false) 21 private String image_url; 55 public String getTitle() { 56 return title; 57 } 22 58 23 @Column(name="airing_date") 24 private Date airing_date; 59 public void setTitle(String title) { 60 this.title = title; 61 } 25 62 26 @Column(name="imdb_rating") 27 private float imdb_rating; 63 public String getDescription() { 64 return description; 65 } 28 66 29 @Column(name="director_id")30 @ManyToOne31 private Person director;67 public void setDescription(String description) { 68 this.description = description; 69 } 32 70 33 @ManyToMany(mappedBy = "movie_actors") 34 private List<Person> actors; 71 public String getImageUrl() { 72 return imageUrl; 73 } 35 74 36 @ManyToMany(mappedBy = "movie_genres") 37 private List<Genre> genres; 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) { 122 this.title = title; 123 this.description = description; 124 this.imageUrl = imageUrl; 125 this.airingDate = airingDate; 126 this.imdbRating = imdbRating; 127 this.directorId = directorId; 128 } 129 130 public Movie() { 131 } 132 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 } 144 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 } 38 192 } 39 40 41 /*42 43 create table movies(44 movie_id serial primary key,45 title varchar(150) not null unique,46 description varchar(1000) not null,47 image_url varchar(300) not null,48 airing_date date not null,49 imdb_rating float,50 director_id integer,51 constraint fk_movie_director foreign key (director_id) references persons(person_id)52 on delete cascade on update cascade,53 constraint ck_person_is_director check( check_constraint_person(director_id) = 'D')54 );55 */ -
src/main/java/com/wediscussmovies/project/model/Person.java
r839f96a r2d57cad 3 3 import javax.persistence.*; 4 4 import java.sql.Date; 5 import java.util. List;5 import java.util.Collection; 6 6 7 @Entity(name="persons") 7 @Entity 8 @Table(name = "persons", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies") 8 9 public class Person { 10 @GeneratedValue(strategy = GenerationType.IDENTITY) 9 11 @Id 10 @GeneratedValue 11 private int person_id; 12 @Column(name = "person_id") 13 private int personId; 14 @Basic 15 @Column(name = "name") 16 private String name; 17 @Basic 18 @Column(name = "surname") 19 private String surname; 20 @Basic 21 @Column(name = "type") 22 private String type; 23 @Basic 24 @Column(name = "date_of_birth") 25 private Date dateOfBirth; 26 @Basic 27 @Column(name = "image_url") 28 private String imageUrl; 29 @Basic 30 @Column(name = "description") 31 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; 12 40 13 @Column(name="name", length=100, nullable=false, unique=false) 14 private String name; 41 public int getPersonId() { 42 return personId; 43 } 15 44 16 @Column(name="surname", length=100, nullable=false, unique=false) 17 private String surname; 45 public void setPersonId(int personId) { 46 this.personId = personId; 47 } 18 48 19 @Column(name="type", nullable = false) 20 private PersonType personType; 49 public String getName() { 50 return name; 51 } 21 52 22 @Column(name="date_of_birth", nullable=false) 23 private Date date_of_birth; 53 public void setName(String name) { 54 this.name = name; 55 } 24 56 25 @Column(name="image_url", length=300, nullable=false, unique=false) 26 private String image_url; 57 public String getSurname() { 58 return surname; 59 } 27 60 28 @Column(name="description", length=300, nullable=false, unique=false) 29 private String description; 61 public void setSurname(String surname) { 62 this.surname = surname; 63 } 30 64 31 @ManyToMany 32 private List<Movie> acts_in; 65 public String getType() { 66 return type; 67 } 68 69 public void setType(String type) { 70 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) { 94 this.description = description; 95 } 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 } 33 158 } 34 35 36 /*37 create table persons(38 person_id serial primary key,39 name varchar(100) not null,40 surname varchar(100) not null,41 type char(1) not null,42 date_of_birth date not null,43 image_url varchar(300) not null,44 description varchar(300) not null,45 constraint ck_type check (type ='A' or type='D')46 );47 */ -
src/main/java/com/wediscussmovies/project/model/Reply.java
r839f96a r2d57cad 4 4 import java.sql.Date; 5 5 6 @Entity(name="replies") 6 @Entity 7 @Table(name = "replies", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies") 8 @IdClass(RepliesEntityPK.class) 7 9 public class Reply { 8 10 @Id 9 @GeneratedValue 11 @Column(name = "discussion_id",insertable = false, updatable = false) 12 private int discussionId; 13 @GeneratedValue(strategy = GenerationType.IDENTITY) 14 @Id 10 15 @Column(name = "reply_id") 11 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; 12 32 13 @ManyToOne14 @Column(name = "discussion_id")15 private Discussion discussion;33 public int getDiscussionId() { 34 return discussionId; 35 } 16 36 17 @ManyToOne18 @Column(name = "user_id")19 private User user;37 public void setDiscussionId(int discussionId) { 38 this.discussionId = discussionId; 39 } 20 40 21 @Column(name = "date", nullable = false) 22 private Date date; 41 public int getReplyId() { 42 return replyId; 43 } 23 44 24 @Column(name= "text", length = 1000, nullable = false) 25 private String text; 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 } 26 114 } 27 28 29 /*30 31 create table replies(32 discussion_id integer,33 reply_id serial,34 text varchar(1000) not null,35 date date not null,36 user_id integer not null,37 constraint pk_replies primary key(discussion_id,reply_id),38 constraint fk_user_create_reply foreign key (user_id) references users(user_id)39 on delete cascade on update cascade,40 constraint fk_reply_discussion foreign key (discussion_id) references discussions(discussion_id)41 on delete cascade on update cascade42 43 44 );45 */ -
src/main/java/com/wediscussmovies/project/model/User.java
r839f96a r2d57cad 2 2 3 3 import javax.persistence.*; 4 import java.util. List;4 import java.util.Collection; 5 5 6 @Entity(name="users") 6 @Entity 7 @Table(name = "users", schema = "project", catalog = "db_202122z_va_prj_wediscussmovies") 7 8 public class User { 9 @GeneratedValue(strategy = GenerationType.IDENTITY) 8 10 @Id 9 @GeneratedValue 10 @Column(name="user_id", nullable = false) 11 private int user_id; 11 @Column(name = "user_id") 12 private int userId; 13 @Basic 14 @Column(name = "username") 15 private String username; 16 @Basic 17 @Column(name = "name") 18 private String name; 19 @Basic 20 @Column(name = "surname") 21 private String surname; 22 @Basic 23 @Column(name = "email") 24 private String email; 25 @Basic 26 @Column(name = "password") 27 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; 12 40 13 @Column(name="username", length=50, nullable=false, unique=false) 14 private String username; 41 public int getUserId() { 42 return userId; 43 } 15 44 16 @Column(name="name", length=50, nullable=false, unique=false) 17 private String name; 45 public void setUserId(int userId) { 46 this.userId = userId; 47 } 18 48 19 @Column(name="surname", length=50, nullable=false, unique=false) 20 private String surname; 49 public String getUsername() { 50 return username; 51 } 21 52 22 @Column(name="email", length=50, nullable=false, unique=false) 23 private String email; 53 public void setUsername(String username) { 54 this.username = username; 55 } 24 56 25 @Column(name="password", length=100, nullable=false, unique=true) 26 private String password; 57 public String getName() { 58 return name; 59 } 27 60 28 //TODO("RATES_MOVIE")29 @ManyToMany(mappedBy = "movie_likes")30 private List<Movie> likes_movie;61 public void setName(String name) { 62 this.name = name; 63 } 31 64 32 @ManyToMany(mappedBy = "user_genres") 33 private List<Genre> likes_genres; 65 public String getSurname() { 66 return surname; 67 } 34 68 69 public void setSurname(String surname) { 70 this.surname = surname; 71 } 72 73 public String getEmail() { 74 return email; 75 } 76 77 public void setEmail(String email) { 78 this.email = email; 79 } 80 81 public String getPassword() { 82 return password; 83 } 84 85 public void setPassword(String password) { 86 this.password = password; 87 } 88 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; 163 } 35 164 } 36 37 38 /*39 create table users(40 user_id serial primary key,41 username varchar(50) not null unique,42 name varchar(50) not null,43 surname varchar(50) not null,44 email varchar(100) not null unique,45 password varchar(30) not null,46 constraint ck_password check(length(password) >= 9)47 );48 */ -
src/main/resources/application.properties
r839f96a r2d57cad 1 1 spring.profiles.active=prod
Note:
See TracChangeset
for help on using the changeset viewer.