Mercurial > dive4elements > river

comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadFactory.java @ 6477:d1502b8dd091

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
'start' is a reserved word in Oracle
author Tom Gottfried <tom@intevation.de>
date Thu, 27 Jun 2013 16:24:55 +0200
parents c74261e05a62
children b24dc0320b75
comparison
equal deleted inserted replaced
6476:d30ae7275e5a 6477:d1502b8dd091
53 53
54 /** Query to get name for wst_id and column_pos. */ 54 /** Query to get name for wst_id and column_pos. */
55 public static final String SQL_SELECT_EPOCHS = 55 public static final String SQL_SELECT_EPOCHS =
56 "SELECT DISTINCT " + 56 "SELECT DISTINCT " +
57 " sy.description AS description, " + 57 " sy.description AS description, " +
58 " ti.start_time AS start, " + 58 " ti.start_time AS startYear, " +
59 " ti.stop_time AS end, " + 59 " ti.stop_time AS end, " +
60 " u.name AS unit" + 60 " u.name AS unit" +
61 " FROM sediment_yield sy " + 61 " FROM sediment_yield sy " +
62 " JOIN rivers r ON sy.river_id = r.id " + 62 " JOIN rivers r ON sy.river_id = r.id " +
63 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " + 63 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
88 " ORDER BY syv.station"; 88 " ORDER BY syv.station";
89 89
90 public static final String SQL_SELECT_UNKNOWN_DATA = 90 public static final String SQL_SELECT_UNKNOWN_DATA =
91 "SELECT" + 91 "SELECT" +
92 " sy.description AS description, " + 92 " sy.description AS description, " +
93 " ti.start_time AS start, " + 93 " ti.start_time AS startYear, " +
94 " ti.stop_time AS end, " + 94 " ti.stop_time AS end, " +
95 " syv.value AS load, " + 95 " syv.value AS load, " +
96 " syv.station AS km, " + 96 " syv.station AS km, " +
97 " u.name AS unit " + 97 " u.name AS unit " +
98 " FROM sediment_yield sy " + 98 " FROM sediment_yield sy " +
107 " ORDER BY syv.station"; 107 " ORDER BY syv.station";
108 108
109 public static final String SQL_SELECT_UNKNOWN = 109 public static final String SQL_SELECT_UNKNOWN =
110 "SELECT DISTINCT " + 110 "SELECT DISTINCT " +
111 " sy.description AS description, " + 111 " sy.description AS description, " +
112 " ti.start_time AS start, " + 112 " ti.start_time AS startYear, " +
113 " ti.stop_time AS end " + 113 " ti.stop_time AS end " +
114 "FROM sediment_yield sy " + 114 "FROM sediment_yield sy " +
115 " JOIN rivers r ON sy.river_id = r.id " + 115 " JOIN rivers r ON sy.river_id = r.id " +
116 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " + 116 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
117 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " + 117 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " +
266 return loads; 266 return loads;
267 } 267 }
268 else if (type.equals("epoch")) { 268 else if (type.equals("epoch")) {
269 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS) 269 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS)
270 .addScalar("description", StandardBasicTypes.STRING) 270 .addScalar("description", StandardBasicTypes.STRING)
271 .addScalar("start", StandardBasicTypes.DATE) 271 .addScalar("startYear", StandardBasicTypes.DATE)
272 .addScalar("end", StandardBasicTypes.DATE); 272 .addScalar("end", StandardBasicTypes.DATE);
273 sqlQuery.setString("name", river); 273 sqlQuery.setString("name", river);
274 sqlQuery.setDouble("startKm", startKm); 274 sqlQuery.setDouble("startKm", startKm);
275 sqlQuery.setDouble("endKm", endKm); 275 sqlQuery.setDouble("endKm", endKm);
276 List<Object []> results = sqlQuery.list(); 276 List<Object []> results = sqlQuery.list();
518 Session session = SessionHolder.HOLDER.get(); 518 Session session = SessionHolder.HOLDER.get();
519 SQLQuery sqlQuery = null; 519 SQLQuery sqlQuery = null;
520 520
521 sqlQuery = session.createSQLQuery(SQL_SELECT_UNKNOWN_DATA) 521 sqlQuery = session.createSQLQuery(SQL_SELECT_UNKNOWN_DATA)
522 .addScalar("description", StandardBasicTypes.STRING) 522 .addScalar("description", StandardBasicTypes.STRING)
523 .addScalar("start", StandardBasicTypes.DATE) 523 .addScalar("startYear", StandardBasicTypes.DATE)
524 .addScalar("end", StandardBasicTypes.DATE) 524 .addScalar("end", StandardBasicTypes.DATE)
525 .addScalar("load", StandardBasicTypes.DOUBLE) 525 .addScalar("load", StandardBasicTypes.DOUBLE)
526 .addScalar("km", StandardBasicTypes.DOUBLE) 526 .addScalar("km", StandardBasicTypes.DOUBLE)
527 .addScalar("unit", StandardBasicTypes.STRING); 527 .addScalar("unit", StandardBasicTypes.STRING);
528 sqlQuery.setString("name", river); 528 sqlQuery.setString("name", river);
551 551
552 public static SedimentLoad[] getSedimentLoadUnknown(String river) { 552 public static SedimentLoad[] getSedimentLoadUnknown(String river) {
553 Session session = SessionHolder.HOLDER.get(); 553 Session session = SessionHolder.HOLDER.get();
554 SQLQuery sqlQuery = session.createSQLQuery(SQL_SELECT_UNKNOWN) 554 SQLQuery sqlQuery = session.createSQLQuery(SQL_SELECT_UNKNOWN)
555 .addScalar("description", StandardBasicTypes.STRING) 555 .addScalar("description", StandardBasicTypes.STRING)
556 .addScalar("start", StandardBasicTypes.DATE) 556 .addScalar("startYear", StandardBasicTypes.DATE)
557 .addScalar("end", StandardBasicTypes.DATE); 557 .addScalar("end", StandardBasicTypes.DATE);
558 sqlQuery.setString("river", river); 558 sqlQuery.setString("river", river);
559 List<Object[]> results = sqlQuery.list(); 559 List<Object[]> results = sqlQuery.list();
560 SedimentLoad[] loads = new SedimentLoad[results.size()]; 560 SedimentLoad[] loads = new SedimentLoad[results.size()];
561 int counter = 0; 561 int counter = 0;
http://dive4elements.wald.intevation.org