Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/sinfo/Infrastructure.java @ 9115:a165cd63099f
Added datacage select and chart display for river infrastructure heights loaded from database
| author | mschaefer |
|---|---|
| date | Mon, 04 Jun 2018 11:55:08 +0200 |
| parents | 4c5eeaff554c |
| children | 1614cb14308f |
comparison
equal
deleted
inserted
replaced
| 9114:31b3cae5de0d | 9115:a165cd63099f |
|---|---|
| 23 import javax.persistence.OneToMany; | 23 import javax.persistence.OneToMany; |
| 24 import javax.persistence.OneToOne; | 24 import javax.persistence.OneToOne; |
| 25 import javax.persistence.SequenceGenerator; | 25 import javax.persistence.SequenceGenerator; |
| 26 import javax.persistence.Table; | 26 import javax.persistence.Table; |
| 27 | 27 |
| 28 import org.dive4elements.river.backend.SessionHolder; | |
| 28 import org.dive4elements.river.model.AnnotationType; | 29 import org.dive4elements.river.model.AnnotationType; |
| 29 import org.dive4elements.river.model.River; | 30 import org.dive4elements.river.model.River; |
| 31 import org.hibernate.Query; | |
| 32 import org.hibernate.Session; | |
| 30 | 33 |
| 31 /** | 34 /** |
| 32 * Hibernate binding for the DB table infrastructure | 35 * Hibernate binding for the DB table infrastructure |
| 33 * | 36 * |
| 34 * @author Matthias Schäfer | 37 * @author Matthias Schäfer |
| 82 this.dataprovider = dataprovider; | 85 this.dataprovider = dataprovider; |
| 83 this.evaluation_by = evaluation_by; | 86 this.evaluation_by = evaluation_by; |
| 84 this.values = new ArrayList<>(); | 87 this.values = new ArrayList<>(); |
| 85 } | 88 } |
| 86 | 89 |
| 90 | |
| 87 /***** METHODS *****/ | 91 /***** METHODS *****/ |
| 88 | 92 |
| 89 @Id | 93 @Id |
| 90 @SequenceGenerator(name = "SEQUENCE_INFRASTRUCTURE_ID_SEQ", sequenceName = "INFRASTRUCTURE_ID_SEQ", allocationSize = 1) | 94 @SequenceGenerator(name = "SEQUENCE_INFRASTRUCTURE_ID_SEQ", sequenceName = "INFRASTRUCTURE_ID_SEQ", allocationSize = 1) |
| 91 @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_INFRASTRUCTURE_ID_SEQ") | 95 @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_INFRASTRUCTURE_ID_SEQ") |
| 183 } | 187 } |
| 184 | 188 |
| 185 public void addValue(final InfrastructureValue value) { | 189 public void addValue(final InfrastructureValue value) { |
| 186 this.values.add(value); | 190 this.values.add(value); |
| 187 } | 191 } |
| 192 | |
| 193 /** | |
| 194 * Get data series by id | |
| 195 */ | |
| 196 public static Infrastructure getSeries(final int id) { | |
| 197 final Session session = SessionHolder.HOLDER.get(); | |
| 198 final Query query = session.createQuery("FROM Infrastructure WHERE (id=:id)"); | |
| 199 query.setParameter("id", id); | |
| 200 return (Infrastructure) query.list().get(0); | |
| 201 } | |
| 188 } | 202 } |