# HG changeset patch # User Raimund Renkert # Date 1423061574 -3600 # Node ID c7e86351d6baefbe7c2556c6da72b807de18c8c3 # Parent 82b616dcbd5371624ce8918ae57b5ec07fcd61ff Removed config files. diff -r 82b616dcbd53 -r c7e86351d6ba pom.xml --- a/pom.xml Wed Feb 04 15:52:20 2015 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,394 +0,0 @@ - - - 4.0.0 - - de.intevation - lada - 1.0-SNAPSHOT - war - - - - - UTF-8 - - 1.0.0.Final - - - - - - - - - - org.jboss.bom - jboss-javaee-6.0-with-tools - ${jboss.bom.version} - pom - import - - - org.jboss.bom - jboss-javaee-6.0-with-hibernate - ${jboss.bom.version} - pom - import - - - - - - - - - - - javax.enterprise - cdi-api - provided - - - - - org.jboss.spec.javax.annotation - jboss-annotations-api_1.1_spec - provided - - - - - org.jboss.spec.javax.ws.rs - jboss-jaxrs-api_1.1_spec - provided - - - - - org.hibernate.javax.persistence - hibernate-jpa-2.0-api - provided - - - - - org.jboss.spec.javax.ejb - jboss-ejb-api_3.1_spec - provided - - - - - - - org.hibernate - hibernate-validator - provided - - - org.slf4j - slf4j-api - - - - - - - org.jboss.spec.javax.faces - jboss-jsf-api_2.1_spec - provided - - - - - - - org.hibernate - hibernate-jpamodelgen - provided - - - - - org.hibernate - hibernate-validator-annotation-processor - provided - - - - - junit - junit - test - - - org.jboss.resteasy - resteasy-jaxrs - 2.2.2.GA - provided - - - org.jboss.resteasy - resteasy-jaxb-provider - 2.3.1.GA - provided - - - - org.jboss.resteasy - resteasy-multipart-provider - 2.3.1.GA - - - - commons-io - commons-io - 2.0.1 - - - org.apache.httpcomponents - httpcore - 4.1.4 - test - - - - - - org.jboss.arquillian.junit - arquillian-junit-container - test - - - - org.jboss.arquillian.protocol - arquillian-protocol-servlet - test - - - org.json - json - 20090211 - - - org.hibernate - hibernate-spatial - 4.0 - - - org.postgis - postgis-jdbc - 1.5.2 - - - - - - ${project.artifactId} - - - - maven-compiler-plugin - 2.3.1 - - 1.7 - 1.7 - - - - maven-war-plugin - 2.1.1 - - - false - - - - - - org.jboss.as.plugins - jboss-as-maven-plugin - 7.1.1.Final - - - - - - - - - default - - true - - - - - maven-surefire-plugin - 2.4.3 - - - - de.intevation.lada.test.singleprobe - ${basedir}/test/single.laf - - - de.intevation.lada.test.incompleteprobe - ${basedir}/test/incomplete.laf - - - de.intevation.lada.import - ${basedir}/config/import.json - - - - - - - - - - remote - - - - org.jboss.as.plugins - jboss-as-maven-plugin - 7.1.1.Final - - ike.polyhedra.intevation.de - 9999 - admin - secret - - - - deploy-jar - install - - deploy - - - - - - - - - - - - arq-jbossas-managed - - - org.jboss.as - jboss-as-arquillian-container-managed - test - - - - - - - - arq-jbossas-remote - - - org.jboss.as - jboss-as-arquillian-container-remote - test - - - - - - - - - - openshift - - - - maven-war-plugin - 2.1.1 - - deployments - ROOT - - - - - - - unit-tests - - - junit - junit - 4.10 - - - org.jboss.resteasy - resteasy-jaxrs - 2.2.2.GA - - - org.apache.httpcomponents - httpcore - 4.1.4 - - - - - - - OSGEO GeoTools repo - http://download.osgeo.org/webdav/geotools - - - Hibernate Spatial repo - http://www.hibernatespatial.org/repository - - - Lada Server - Lada server application. - -The Lada server provides RESTful services to grant access to laboratory data using authentication and validation. - diff -r 82b616dcbd53 -r c7e86351d6ba queryconf.json --- a/queryconf.json Wed Feb 04 15:52:20 2015 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,80 +0,0 @@ -[ -{ "id": 1, - "name": "Kein Filter", - "description": "Abfrage der Proben ohne Filter", - "sql": "select probe_id, mst_id, umw_id from l_probe", - "result": [ - {"dataIndex": "probeId", "header": "ProbeId", "width": 100}, - {"dataIndex": "mstId", "header": "MST", "width": 100}, - {"dataIndex": "umwId", "header": "Umweltbereich", "width": 100} - ], - "filters": [ - ] -}, -{ "id": 2, - "name": "MST und UMW", - "description": "Abfrage der Proben gefiltert nach Messtellen ID und ID des Umweltbereichs", - "sql": "select probe_id, mst_id, umw_id from l_probe where (mst_id = :mst_id OR '' = :mst_id) and (umw_id = :umw_id OR '' = :umw_id)", - "result": [ - {"dataIndex": "probeId", "header": "ProbeId", "width": 100}, - {"dataIndex": "mstId", "header": "MST", "width": 100}, - {"dataIndex": "umwId", "header": "Umweltbereich", "width": 100} - ], - "filters": [ - {"dataIndex": "mst_id", "type": "listmst", "label": "Messstelle"}, - {"dataIndex": "umw_id", "type": "listumw", "label": "Umweltbereich"} - ] -}, -{ "id": 3, - "name": "Proben pro Land", - "description": "Detailiertere Beschreibung der Abfrage", - "sql": "select probe_id, netzbetreiber_id, mst_id, umw_id, hauptproben_nr from l_probe where (netzbetreiber_id = :netz OR '' = :netz)", - "result": [ - {"dataIndex": "probeId", "header": "ProbeId", "width": 100}, - {"dataIndex": "netzbetreiberId", "header": "Land", "width": 100}, - {"dataIndex": "mstId", "header": "MST", "width": 100}, - {"dataIndex": "umwId", "header": "Umweltbereich", "width": 100}, - {"dataIndex": "hauptprobenNr", "header": "Proben-Nr", "width": 100} - ], - "filters": [ - {"dataIndex": "netz", "type": "listnetz", "label": "Land"} - ] -}, -{ "id": 4, - "name": "alle Proben mit Ort", - "description": "alle Proben mit Entnahmeort", - "sql": "select lp.probe_id, lp.netzbetreiber_id, lp.mst_id, lp.umw_id, lp.hauptproben_nr, ort.gem_id, s_verwaltungseinheit.bezeichnung from l_probe left outer join l_ort on (lp.probe_id = l_ort.probe_id) left outer join ort on (l_ort.ort_id = ort.ort_id) left outer join s_verwaltungseinheit on (ort.gem_id = s_verwaltungseinheit.gem_id) where l_ort.orts_typ = 'E' or l_ort.orts_typ is null", - "result": [ - {"dataIndex": "probeId", "header": "ProbeId", "width": 100}, - {"dataIndex": "netzbetreiberId", "header": "Land", "width": 50}, - {"dataIndex": "mstId", "header": "MST", "width": 60}, - {"dataIndex": "umwId", "header": "Umweltbereich", "width": 100}, - {"dataIndex": "hauptprobenNr", "header": "Proben-Nr", "width": 100}, - {"dataIndex": "gemId", "header": "Gem-ID", "width": 100}, - {"dataIndex": "bezeichnung", "header": "Gemeinde", "flex": 1} - ], - "filters": [ - ] -}, -{ "id": 5, - "name": "Proben pro Land und UMW (Multyselect)", - "description": "Abfrage aller Proben gefiltert pro Land und Umweltbereich (mit Mehrfachauswahl)", - "sql": "select lp.probe_id, lp.netzbetreiber_id, lp.mst_id, to_char(lp.probeentnahme_beginn,'YYYY-mm-dd HH24:MI') entnahme_von, to_char(lp.probeentnahme_ende,'YYYY-mm-dd HH24:MI') entnahme_bis, lp.umw_id, lp.hauptproben_nr, l_ort.orts_typ, ort.gem_id, s_verwaltungseinheit.bezeichnung from l_probe left outer join l_ort on (lp.probe_id = l_ort.probe_id) left outer join ort on (l_ort.ort_id = ort.ort_id) left outer join s_verwaltungseinheit on (ort.gem_id = s_verwaltungseinheit.gem_id) where (l_ort.orts_typ = 'E' or l_ort.orts_typ is null) and lp.netzbetreiber_id = :netz and (umw_id similar to (:umw_id) OR '' = :umw_id)", - "result": [ - {"dataIndex": "probeId", "header": "ProbeId", "width": 100}, - {"dataIndex": "netzbetreiberId", "header": "Land", "width": 50}, - {"dataIndex": "mstId", "header": "MST", "width": 50}, - {"dataIndex": "entnahmeVon", "header": "Entnahme von", "width": 120}, - {"dataIndex": "entnahmeBis", "header": "Entnahme bis", "width": 120}, - {"dataIndex": "umwId", "header": "Umweltbereich", "width": 100}, - {"dataIndex": "hauptprobenNr", "header": "Proben-Nr", "width": 100}, - {"dataIndex": "ortsTyp", "header": "Ortstyp", "width": 50}, - {"dataIndex": "genId", "header": "Gemeinde-ID", "width": 100}, - {"dataIndex": "bezeichnung", "header": "Gemeinde", "flex": 1} - ], - "filters": [ - {"dataIndex": "netz", "type": "listnetz", "label": "Land"}, - {"dataIndex": "umw_id", "type": "listumw", "label": "Umweltbereich", "multiselect":true} - ] -} -]