Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/model/BedHeightSingle.java @ 5181:9d36ddf7dbd3
Change IllegalArgumentException to HibernateException.
author | Raimund Renkert <rrenkert@intevation.de> |
---|---|
date | Thu, 07 Mar 2013 10:44:27 +0100 |
parents | 5d8db3349b77 |
children |
line wrap: on
line source
package de.intevation.flys.model; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; import javax.persistence.GeneratedValue; import javax.persistence.Column; import javax.persistence.SequenceGenerator; import javax.persistence.GenerationType; import javax.persistence.JoinColumn; import javax.persistence.OneToOne; import javax.persistence.OneToMany; import org.hibernate.Session; import org.hibernate.Query; import de.intevation.flys.backend.SessionHolder; @Entity @Table(name = "bed_height_single") public class BedHeightSingle implements Serializable { private Integer id; private Integer year; private Integer soundingWidth; private String evaluationBy; private String description; private River river; private BedHeightType type; private LocationSystem locationSystem; private ElevationModel curElevationModel; private ElevationModel oldElevationModel; private Range range; private List<BedHeightSingleValue> values; public BedHeightSingle() { } public BedHeightSingle( River river, Integer year, Integer soundingWidth, BedHeightType type, LocationSystem locationSystem, ElevationModel curElevationModel, Range range ) { this( river, year, soundingWidth, type, locationSystem, curElevationModel, null, range, null, null); } public BedHeightSingle( River river, Integer year, Integer soundingWidth, BedHeightType type, LocationSystem locationSystem, ElevationModel curElevationModel, ElevationModel oldElevationModel, Range range, String evaluationBy, String description ) { this.river = river; this.year = year; this.soundingWidth = soundingWidth; this.type = type; this.locationSystem = locationSystem; this.curElevationModel = curElevationModel; this.oldElevationModel = oldElevationModel; this.range = range; this.evaluationBy = evaluationBy; this.description = description; } @Id @SequenceGenerator( name = "SEQUENCE_BED_HEIGHT_SINGLE_ID_SEQ", sequenceName = "BED_HEIGHT_SINGLE_ID_SEQ", allocationSize = 1) @GeneratedValue( strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_BED_HEIGHT_SINGLE_ID_SEQ") @Column(name = "id") public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } @OneToOne @JoinColumn(name = "river_id" ) public River getRiver() { return river; } public void setRiver(River river) { this.river = river; } @Column(name = "year") public Integer getYear() { return year; } public void setYear(Integer year) { this.year = year; } @Column(name = "sounding_width") public Integer getSoundingWidth() { return soundingWidth; } public void setSoundingWidth(Integer soundingWidth) { this.soundingWidth = soundingWidth; } @OneToOne @JoinColumn(name = "type_id") public BedHeightType getType() { return type; } public void setType(BedHeightType type) { this.type = type; } @OneToOne @JoinColumn(name = "location_system_id") public LocationSystem getLocationSystem() { return locationSystem; } public void setLocationSystem(LocationSystem locationSystem) { this.locationSystem = locationSystem; } @OneToOne @JoinColumn(name = "cur_elevation_model_id") public ElevationModel getCurElevationModel() { return curElevationModel; } public void setCurElevationModel(ElevationModel curElevationModel) { this.curElevationModel = curElevationModel; } @OneToOne @JoinColumn(name = "old_elevation_model_id") public ElevationModel getOldElevationModel() { return oldElevationModel; } public void setOldElevationModel(ElevationModel oldElevationModel) { this.oldElevationModel = oldElevationModel; } @OneToOne @JoinColumn(name = "range_id") public Range getRange() { return range; } public void setRange(Range range) { this.range = range; } @Column(name = "evaluation_by") public String getEvaluationBy() { return evaluationBy; } public void setEvaluationBy(String evaluationBy) { this.evaluationBy = evaluationBy; } @Column(name = "description") public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } @OneToMany @JoinColumn(name = "bed_height_single_id") public List<BedHeightSingleValue> getValues() { return values; } public void setValues(List<BedHeightSingleValue> values) { this.values = values; } public static List<BedHeightSingle> getBedHeightSingles( River river, double kmLo, double kmHi ) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from BedHeightSingle where river=:river"); query.setParameter("river", river); // TODO Do km range filtering in SQL statement List<BedHeightSingle> singles = query.list(); List<BedHeightSingle> good = new ArrayList<BedHeightSingle>(); for (BedHeightSingle s: singles) { for (BedHeightSingleValue value: s.getValues()) { double station = value.getStation().doubleValue(); if (station >= kmLo && station <= kmHi) { good.add(s); break; } } } return good; } public static BedHeightSingle getBedHeightSingleById(int id) { Session session = SessionHolder.HOLDER.get(); Query query = session.createQuery( "from BedHeightSingle where id=:id"); query.setParameter("id", id); List<BedHeightSingle> singles = query.list(); return singles != null ? singles.get(0) : null; } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :