dive4elements/gnv-client: gnv-artifacts/src/main/java/de/intevation/gnv/state/layer/LayerOutputState.java comparison

comparison gnv-artifacts/src/main/java/de/intevation/gnv/state/layer/LayerOutputState.java @ 728:f6630d0203da

Put all Attributes of the Databasetables into the Shapefile which will be produced for the Product Layer gnv-artifacts/trunk@764 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Tim Englich <tim.englich@intevation.de>
date	Fri, 12 Mar 2010 11:36:38 +0000
parents	9ba6bb85d6dd
children	d23ad22bcfe7

comparison

equal deleted inserted replaced

-:22dc921cd8b1
+:f6630d0203da
 import java.io.File;
 import java.io.IOException;
 import java.io.OutputStream;
 import java.util.Collection;
-import java.util.HashMap;
 import java.util.Iterator;
-import java.util.Map;
 import org.apache.log4j.Logger;
 import org.w3c.dom.Document;
 import org.w3c.dom.Element;
 import org.w3c.dom.Node;
 import de.intevation.gnv.artifacts.context.GNVArtifactContext;
 import de.intevation.gnv.geobackend.base.Result;
 import de.intevation.gnv.geobackend.base.query.QueryExecutor;
 import de.intevation.gnv.geobackend.base.query.QueryExecutorFactory;
 import de.intevation.gnv.geobackend.base.query.exception.QueryException;
-import de.intevation.gnv.raster.PaletteManager;
 import de.intevation.gnv.state.InputData;
 import de.intevation.gnv.state.OutputStateBase;
 import de.intevation.gnv.state.exception.StateException;
 import de.intevation.gnv.utils.ArtifactXMLUtilities;
 import de.intevation.gnv.utils.FileUtils;
 /**
 * The ID for the Query fetching the Geometry from the DB
 * which should be used to Clip the Layerdata
 */
 private String geometryQueryID = null;
+private String columnQueryID = null;
 /**
 * The ID for the Value which will hold the Geometrie-Value
 */
 private String geometryID = null;
 String[] queryValues = null;
 if (it.hasNext()){
 Result resultValue = it.next();
 String table = resultValue.getString(0);
 String where = resultValue.getString(1);
+String columns = this.fetchColumns(table);
 templateID = resultValue.getString(2);
 if (this.geometryID != null){
 InputData geometryInputData =
 this.inputData.get(this.geometryID);
 if (geometryInputData != null){
 }
 } catch (QueryException e) {
 log.error(e,e);
 // TODO: what should happen??
 }
-queryValues = new String[]{table,
+queryValues = new String[]{columns,
+table,
 where,
 geometryWKT};
 }else{
 // TODO: Look into the presetting for an WKT
-queryValues = new String[]{table,where};
+queryValues = new String[]{columns,table,where};
 }
 }else{
 // TODO: Look into the presetting for an WKT
-queryValues = new String[]{table,where};
+queryValues = new String[]{columns,table,where};
 }
 }
 try {
 }
 }
 return data;
 }
+private String fetchColumns(String tableName){
+String returnValue = null;
+try {
+String[] filter = tableName.toUpperCase().split("\\.");
+QueryExecutor queryExecutor = QueryExecutorFactory.getInstance()
+.getQueryExecutor();
+Collection<Result> columnData = queryExecutor.
+executeQuery(this.columnQueryID,
+filter);
+if (columnData != null && !columnData.isEmpty()){
+StringBuffer sb = new StringBuffer();
+synchronized (sb) {
+Iterator<Result> it = columnData.iterator();
+while(it.hasNext()){
+Result current = it.next();
+sb.append(current.getString(0));
+if (it.hasNext()){
+sb.append(" , ");
+}
+}
+}
+returnValue = sb.toString();
+}
+} catch (QueryException e) {
+log.error(e,e);
+}
+return returnValue;
+}
 @Override
 public void setup(Node configuration) {
 log.debug("LayerOutputState.setup");
 super.setup(configuration);
 this.dataQueryID = Config.getStringXPath(configuration,
 "queryID-layerdata");
 this.geometryID = Config.getStringXPath(configuration,
 "inputvalue-geometry");
 this.geometryQueryID =  Config.getStringXPath(configuration,
 "queryID-geometry");
+this.columnQueryID =   "layer_colums"; //Config.getStringXPath(configuration,
+// "queryID-columns");
 }
 protected String writeToShapeFile(
 String             uuid,
 Collection<Result> data,
 if (returnValue.equalsIgnoreCase("linestring")){
 returnValue = "Line";
 }
 return returnValue;
 }
-private static Map<Integer, PaletteManager> getPalettes(
-CallContext callContext
-) {
-//TODO: customize for product Layer
-GNVArtifactContext context =
-(GNVArtifactContext)callContext.globalContext();
-Map<Integer, PaletteManager> palettes =
-(Map<Integer, PaletteManager>)context.get(
-GNVArtifactContext.PALETTES_KEY);
-return palettes != null
-? palettes
-: new HashMap<Integer, PaletteManager>();
-}
 }

Mercurial > dive4elements > gnv-client

comparison gnv-artifacts/src/main/java/de/intevation/gnv/state/layer/LayerOutputState.java @ 728:f6630d0203da