Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 9460:8d6e56e57c4a
log-Ausgaben crossSection isStart
| author | gernotbelger |
|---|---|
| date | Wed, 29 Aug 2018 16:57:13 +0200 |
| parents | 5e38e2924c07 |
| children | e28303971812 |
comparison
equal
deleted
inserted
replaced
| 9459:f06e3766997f | 9460:8d6e56e57c4a |
|---|---|
| 46 implements Serializable | 46 implements Serializable |
| 47 { | 47 { |
| 48 private static Logger log = | 48 private static Logger log = |
| 49 Logger.getLogger(CrossSection.class); | 49 Logger.getLogger(CrossSection.class); |
| 50 | 50 |
| 51 public static final MathContext PRECISION = new MathContext(6); | 51 private static final MathContext PRECISION = new MathContext(6); |
| 52 | 52 |
| 53 public static final String SQL_FAST_CROSS_SECTION_LINES = | 53 private static final String SQL_FAST_CROSS_SECTION_LINES = |
| 54 "SELECT km, x, y, csl.id AS csl_id " + | 54 "SELECT km, x, y, csl.id AS csl_id " + |
| 55 "FROM cross_section_lines csl JOIN cross_section_points csp " + | 55 "FROM cross_section_lines csl JOIN cross_section_points csp " + |
| 56 "ON csp.cross_section_line_id = csl.id " + | 56 "ON csp.cross_section_line_id = csl.id " + |
| 57 "WHERE csl.cross_section_id = :cs_id AND " + | 57 "WHERE csl.cross_section_id = :cs_id AND " + |
| 58 "km between :from_km AND :to_km " + | 58 "km between :from_km AND :to_km " + |
| 59 "ORDER BY csl.km, csl.id, csp.col_pos"; | 59 "ORDER BY csl.km, csl.id, csp.col_pos"; |
| 60 | 60 |
| 61 public static final String SQL_MIN_MAX = | 61 private static final String SQL_MIN_MAX = |
| 62 "SELECT * FROM ( "+ | 62 "SELECT * FROM ( "+ |
| 63 "SELECT cross_section_id, MIN(km) AS minkm, MAX(km) AS maxkm " + | 63 "SELECT cross_section_id, MIN(km) AS minkm, MAX(km) AS maxkm " + |
| 64 "FROM cross_section_lines " + | 64 "FROM cross_section_lines " + |
| 65 "WHERE cross_section_id IN " + | 65 "WHERE cross_section_id IN " + |
| 66 " (SELECT id FROM cross_sections WHERE river_id = :river_id) " + | 66 " (SELECT id FROM cross_sections WHERE river_id = :river_id) " + |