Mercurial > dive4elements > river

comparison backend/src/main/java/org/dive4elements/river/model/sinfo/BedMobility.java @ 9038:4c5eeaff554c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Database column "comment" renamed to "notes" (restrictions in Oracle)
author mschaefer
date Wed, 02 May 2018 06:56:21 +0200
parents 6e5ff436febe
children
comparison
equal deleted inserted replaced
9037:1574ce45c98d 9038:4c5eeaff554c
50 50
51 private String kmrange_info; 51 private String kmrange_info;
52 52
53 private String filename; 53 private String filename;
54 54
55 private String comment; 55 private String notes;
56 56
57 private River river; 57 private River river;
58 58
59 private List<BedMobilityValue> values; 59 private List<BedMobilityValue> values;
60 60
63 63
64 public BedMobility() { 64 public BedMobility() {
65 } 65 }
66 66
67 67
68 public BedMobility(final River river, final String filename, final String kmrange_info, final String comment) { 68 public BedMobility(final River river, final String filename, final String kmrange_info, final String notes) {
69 this.river = river; 69 this.river = river;
70 this.filename = filename; 70 this.filename = filename;
71 this.kmrange_info = kmrange_info; 71 this.kmrange_info = kmrange_info;
72 this.comment = comment; 72 this.notes = notes;
73 this.values = new ArrayList<>(); 73 this.values = new ArrayList<>();
74 } 74 }
75 75
76 /***** METHODS *****/ 76 /***** METHODS *****/
77 77
113 113
114 public void setKmrange_info(final String kmrange_info) { 114 public void setKmrange_info(final String kmrange_info) {
115 this.kmrange_info = kmrange_info; 115 this.kmrange_info = kmrange_info;
116 } 116 }
117 117
118 @Column(name = "comment") 118 @Column(name = "notes")
119 public String getComment() { 119 public String getNotes() {
120 return this.comment; 120 return this.notes;
121 } 121 }
122 122
123 public void setComment(final String comment) { 123 public void setNotes(final String notes) {
124 this.comment = comment; 124 this.notes = notes;
125 } 125 }
126 126
127 @OneToMany 127 @OneToMany
128 @JoinColumn(name = "bed_mobility_id") 128 @JoinColumn(name = "bed_mobility_id")
129 public List<BedMobilityValue> getValues() { 129 public List<BedMobilityValue> getValues() {
141 /** 141 /**
142 * Selects a bed mobility series of a river from the database 142 * Selects a bed mobility series of a river from the database
143 */ 143 */
144 public static BedMobility queryForRiver(final River river) { 144 public static BedMobility queryForRiver(final River river) {
145 final Session session = SessionHolder.HOLDER.get(); 145 final Session session = SessionHolder.HOLDER.get();
146 final Query query = session.createQuery("FROM BedMobilty WHERE river=:river"); 146 final Query query = session.createQuery("FROM BedMobility WHERE river=:river");
147 query.setParameter("river", river); 147 query.setParameter("river", river);
148 final List<BedMobility> rows = query.list(); 148 final List<BedMobility> rows = query.list();
149 if (rows != null) 149 if (rows != null)
150 return rows.get(0); 150 return rows.get(0);
151 else 151 else
http://dive4elements.wald.intevation.org