dive4elements/river: backend/src/main/java/org/dive4elements/river/model/CrossSection.java annotate

annotate backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 5844:4dd33b86dc61

Added header to river backend.

author	Sascha L. Teichmann <teichmann@intevation.de>
date	Fri, 26 Apr 2013 08:25:41 +0200
parents	5aa05a7a34b7
children	4c3ccf2b0304

rev	line source
5844 4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	2 * Software engineering by Intevation GmbH
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	3 *
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	4 * This file is Free Software under the GNU AGPL (>=v3)
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	6 * documentation coming with Dive4Elements River for details.
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	7 */
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	8
5829 18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	9 package org.dive4elements.river.model;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	11 import java.io.Serializable;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	12
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	13 import java.util.List;
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	14 import java.util.ArrayList;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	15
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	16 import java.awt.geom.Point2D;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18 import javax.persistence.Entity;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19 import javax.persistence.Id;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20 import javax.persistence.Table;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	21 import javax.persistence.GeneratedValue;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	22 import javax.persistence.Column;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 import javax.persistence.SequenceGenerator;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	24 import javax.persistence.GenerationType;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25 import javax.persistence.OneToOne;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26 import javax.persistence.OneToMany;
1210 31d8638760b1 New. The hibernate models Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1204 diff changeset	27 import javax.persistence.OrderBy;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 import javax.persistence.JoinColumn;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	30 import java.math.MathContext;
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	31 import java.math.BigDecimal;
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	32
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	33 import org.hibernate.Session;
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	34 import org.hibernate.SQLQuery;
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	35 import org.hibernate.Query;
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	36
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	37 import org.hibernate.type.StandardBasicTypes;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	38
5829 18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	39 import org.dive4elements.river.backend.SessionHolder;
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	40
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 @Entity
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	42 @Table(name = "cross_sections")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43 public class CrossSection
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44 implements Serializable
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	45 {
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	46 public static final MathContext PRECISION = new MathContext(6);
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	47
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	48 public static final String SQL_FAST_CROSS_SECTION_LINES =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	49 "SELECT km, x, y, csl.id AS csl_id " +
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	50 "FROM cross_section_lines csl JOIN cross_section_points csp " +
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	51 "ON csp.cross_section_line_id = csl.id " +
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	52 "WHERE csl.cross_section_id = :cs_id AND " +
3334 2ae732e2c65c FLYS backend: Removed trailing whitespace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2380 diff changeset	53 "km between :from_km AND :to_km " +
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	54 "ORDER BY csl.id, csp.col_pos";
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	55
1203 3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	56 private Integer id;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	57 private River river;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	58 private TimeInterval timeInterval;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	59 private String description;
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	60 private List<CrossSectionLine> lines;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	62 public CrossSection() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64
1204 22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	65 public CrossSection(
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	66 River river,
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	67 TimeInterval timeInterval,
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	68 String description
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	69 ) {
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	70 this.river = river;
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	71 this.timeInterval = timeInterval;
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	72 this.description = description;
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	73 }
22858e7cca79 Integrated PRF parsing into importer. Needs testing! Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1203 diff changeset	74
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75 @Id
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76 @SequenceGenerator(
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77 name = "SEQUENCE_CROSS_SECTIONS_ID_SEQ",
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	78 sequenceName = "CROSS_SECTIONS_ID_SEQ",
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 allocationSize = 1)
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80 @GeneratedValue(
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81 strategy = GenerationType.SEQUENCE,
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 generator = "SEQUENCE_CROSS_SECTIONS_ID_SEQ")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 @Column(name = "id")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84 public Integer getId() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	85 return id;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	86 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	87
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	88 public void setId(Integer id) {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	89 this.id = id;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	90 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	91
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	92 @OneToOne
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	93 @JoinColumn(name = "river_id")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94 public River getRiver() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 return river;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 public void setRiver(River river) {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 this.river = river;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 @OneToOne
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 @JoinColumn(name = "time_interval_id")
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 public TimeInterval getTimeInterval() {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105 return timeInterval;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108 public void setTimeInterval(TimeInterval timeInterval) {
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 this.timeInterval = timeInterval;
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111
1202 44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	112 @Column(name = "description")
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	113 public String getDescription() {
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	114 return description;
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	115 }
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	116
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	117 public void setDescription(String description) {
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	118 this.description = description;
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	119 }
44581b40b968 Schema: Added description column to the cross section table Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1194 diff changeset	120
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	121 @OneToMany
1210 31d8638760b1 New. The hibernate models Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1204 diff changeset	122 @OrderBy("km")
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	123 @JoinColumn(name="cross_section_id")
1203 3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	124 public List<CrossSectionLine> getLines() {
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	125 return lines;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	126 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	127
1203 3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	128 public void setLines(List<CrossSectionLine> lines) {
3c01bef43a98 Querprofile: Added a table to map the points to a given km. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1202 diff changeset	129 this.lines = lines;
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 }
2379 8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	131
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	132 public List<CrossSectionLine> getLines(double startKm, double endKm) {
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	133 Session session = SessionHolder.HOLDER.get();
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	134 Query query = session.createQuery(
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	135 "from CrossSectionLine where crossSection=:crossSection " +
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	136 "and km between :startKm and :endKm order by km");
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	137 query.setParameter("crossSection", this);
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	138 query.setParameter("startKm", new BigDecimal(startKm, PRECISION));
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	139 query.setParameter("endKm", new BigDecimal(endKm, PRECISION));
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	140
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	141 return query.list();
8be27b950dbe CrossSection: Added method to extract the lines of a given km range. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1210 diff changeset	142 }
2380 e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	143
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	144 public List<FastCrossSectionLine> getFastLines(
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	145 double startKm,
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	146 double endKm
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	147 ) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	148 Session session = SessionHolder.HOLDER.get();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	149
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	150 SQLQuery sqlQuery = session.createSQLQuery(SQL_FAST_CROSS_SECTION_LINES)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	151 .addScalar("km", StandardBasicTypes.DOUBLE)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	152 .addScalar("x", StandardBasicTypes.DOUBLE)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	153 .addScalar("y", StandardBasicTypes.DOUBLE)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	154 .addScalar("csl_id", StandardBasicTypes.INTEGER);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	155
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	156 sqlQuery
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	157 .setInteger("cs_id", getId())
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	158 .setDouble("from_km", startKm)
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	159 .setDouble("to_km", endKm);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	160
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	161 List<Object []> results = sqlQuery.list();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	162
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	163 ArrayList<Point2D> points = new ArrayList<Point2D>(500);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	164 ArrayList<FastCrossSectionLine> lines =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	165 new ArrayList<FastCrossSectionLine>();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	166
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	167 Integer lastId = null;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	168 Double lastKm = null;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	169
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	170 for (Object [] result: results) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	171 Double km = (Double)result[0];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	172 Double x = (Double)result[1];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	173 Double y = (Double)result[2];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	174 Integer id = (Integer)result[3];
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	175
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	176 if (lastId != null && !lastId.equals(id)) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	177 points.trimToSize();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	178 FastCrossSectionLine line =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	179 new FastCrossSectionLine(lastKm, points);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	180 lines.add(line);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	181 points = new ArrayList<Point2D>(500);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	182 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	183
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	184 Point2D p = new Point2D.Double(x, y);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	185
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	186 if (CrossSectionLine.isValid(p)) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	187 points.add(p);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	188 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	189
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	190 lastKm = km;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	191 lastId = id;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	192 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	193
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	194 if (lastId != null) {
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	195 points.trimToSize();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	196 FastCrossSectionLine line =
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	197 new FastCrossSectionLine(lastKm, points);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	198 lines.add(line);
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	199 }
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	200
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	201 lines.trimToSize();
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	202
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	203 return lines;
e237a08acf6e Create fast cross section lines in the backend now. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2379 diff changeset	204 }
1194 491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	205 }
491892931761 Added Hibernate models for cross-sections and their points. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	206 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 5844:4dd33b86dc61