Mercurial > lada > lada-server

annotate src/main/java/de/intevation/lada/utils/QueryTools.java @ 304:2d3f293899e8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Set default values for width and flex.
author Raimund Renkert <rrenkert@intevation.de>
date Fri, 16 Aug 2013 14:40:01 +0200
parents dc2e1668a179
children b9295222ff06
rev   line source
297
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
1 package de.intevation.lada.utils;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
2
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
3 import java.io.IOException;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
4 import java.nio.ByteBuffer;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
5 import java.nio.charset.Charset;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
6 import java.nio.file.Files;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
7 import java.nio.file.Paths;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
8 import java.util.ArrayList;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
9 import java.util.List;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
10
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
11 import org.json.JSONArray;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
12 import org.json.JSONException;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
13 import org.json.JSONObject;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
14
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
15 import de.intevation.lada.model.query.QueryConfig;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
16 import de.intevation.lada.model.query.QueryFilter;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
17 import de.intevation.lada.model.query.ResultConfig;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
18
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
19
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
20 public class QueryTools
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
21 {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
22 public static String readConfigFile() {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
23 String file = System.getProperty("de.intevation.lada.sqlconfig");
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
24 try {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
25 byte[] encoded = Files.readAllBytes(Paths.get(file));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
26 Charset encoding = Charset.defaultCharset();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
27 return encoding.decode(ByteBuffer.wrap(encoded)).toString();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
28 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
29 catch (IOException ioe) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
30 return null;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
31 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
32 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
33
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
34 public static List<QueryConfig> getConfig() {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
35 String content = readConfigFile();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
36 if (content == null) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
37 return null;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
38 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
39 List<QueryConfig> configs = new ArrayList<QueryConfig>();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
40 JSONArray queries;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
41 try {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
42 queries = new JSONArray(content);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
43 for (int i = 0; i < queries.length(); i++) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
44 JSONObject query = queries.getJSONObject(i);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
45 QueryConfig qConf = new QueryConfig();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
46 qConf.setId(query.getInt("id"));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
47 qConf.setName(query.getString("name"));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
48 qConf.setDescription(query.getString("description"));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
49 qConf.setSql(query.getString("sql"));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
50 JSONArray filters = query.getJSONArray("filters");
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
51 List<QueryFilter> qFilters = new ArrayList<QueryFilter>();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
52 for (int j = 0; j < filters.length(); j++) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
53 JSONObject filter = filters.getJSONObject(j);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
54 QueryFilter qFilter = new QueryFilter();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
55 qFilter.setDataIndex(filter.getString("dataIndex"));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
56 qFilter.setType(filter.getString("type"));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
57 qFilters.add(qFilter);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
58 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
59 qConf.setFilters(qFilters);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
60 JSONArray results = query.getJSONArray("result");
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
61 List<ResultConfig> sResults = new ArrayList<ResultConfig>();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
62 for (int k = 0; k < results.length(); k++) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
63 JSONObject result = results.getJSONObject(k);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
64 ResultConfig config = new ResultConfig();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
65 config.setDataIndex(result.getString("dataIndex"));
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
66 config.setHeader(result.getString("header"));
304
2d3f293899e8 Set default values for width and flex.
Raimund Renkert <rrenkert@intevation.de>
parents: 297
diff changeset
67 config.setWidth(result.optInt("width", 100));
2d3f293899e8 Set default values for width and flex.
Raimund Renkert <rrenkert@intevation.de>
parents: 297
diff changeset
68 config.setFlex(result.optInt("flex", 0));
297
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
69 sResults.add(config);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
70 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
71 qConf.setResults(sResults);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
72 configs.add(qConf);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
73 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
74 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
75 catch (JSONException e) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
76 return null;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
77 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
78 return configs;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
79 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
80
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
81 public static JSONObject getQueryById(String id) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
82 try {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
83 String content = readConfigFile();
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
84 if (content != null) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
85 JSONArray queries = new JSONArray(content);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
86 for (int i = 0; i < queries.length(); i++) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
87 JSONObject query = queries.getJSONObject(i);
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
88 if (query.getString("id").equals(id)) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
89 return query;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
90 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
91 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
92 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
93 return null;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
94 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
95 catch (JSONException e) {
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
96 return null;
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
97 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
98 }
dc2e1668a179 New utility class for creating and reading query configs.
Raimund Renkert <rrenkert@intevation.de>
parents:
diff changeset
99 }
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)