From 2450ce5ee53fbb20751daf77acf7c481e526f144 Mon Sep 17 00:00:00 2001
From: Dennis Kao <ulysseskao@gmail.com>
Date: Mon, 25 Nov 2013 00:29:52 +0800
Subject: [PATCH] add color table
---
xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml | 3 ++-
xdgnjobs/pom.xml | 2 +-
xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwner2CSVJob.java | 32 +++++++++++++++++++++++++++-----
xdgnjobs/ximple-spatialjob/pom.xml | 6 ++++++
4 files changed, 36 insertions(+), 7 deletions(-)
diff --git a/xdgnjobs/pom.xml b/xdgnjobs/pom.xml
index e99d776..b00f555 100644
--- a/xdgnjobs/pom.xml
+++ b/xdgnjobs/pom.xml
@@ -19,7 +19,7 @@
<src.output>${basedir}/target</src.output>
<java5>1.6</java5>
<xdgnio.version>2.1.0</xdgnio.version>
- <gt.version>10.1.x</gt.version>
+ <gt.version>10.2.x</gt.version>
<failIfNoTests>false</failIfNoTests>
<stress.skip.pattern></stress.skip.pattern>
<online.skip.pattern></online.skip.pattern>
diff --git a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml
index 148770e..9cd604d 100644
--- a/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml
+++ b/xdgnjobs/ximple-jobcarrier/src/main/resources/quartz_jobs.xml
@@ -26,7 +26,8 @@
<description>A job that convert dgn to postgis</description>
<!--job-class>com.ximple.eofms.jobs.OracleConvertDgn2PostGISJob</job-class-->
<!--job-class>com.ximple.eofms.jobs.GeoserverIntegrateConfigJob</job-class-->
- <job-class>com.ximple.eofms.jobs.OracleTransformColorOwnerJob</job-class>
+ <!--job-class>com.ximple.eofms.jobs.OracleTransformColorOwnerJob</job-class-->
+ <job-class>com.ximple.eofms.jobs.OracleTransformColorOwner2CSVJob</job-class>
<!--volatility>false</volatility-->
<durability>false</durability>
<recover>false</recover>
diff --git a/xdgnjobs/ximple-spatialjob/pom.xml b/xdgnjobs/ximple-spatialjob/pom.xml
index 670bb58..63f4aac 100644
--- a/xdgnjobs/ximple-spatialjob/pom.xml
+++ b/xdgnjobs/ximple-spatialjob/pom.xml
@@ -161,6 +161,12 @@
<artifactId>mysql-connector-java</artifactId>
</dependency-->
+ <dependency>
+ <groupId>net.sf.opencsv</groupId>
+ <artifactId>opencsv</artifactId>
+ <version>2.3</version>
+ </dependency>
+
<!-- Ximple Library -->
<dependency>
<groupId>com.ximple.eofms</groupId>
diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwner2CSVJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwner2CSVJob.java
index 55f09c4..87d2441 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwner2CSVJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleTransformColorOwner2CSVJob.java
@@ -13,8 +13,11 @@
import java.util.TreeMap;
import au.com.bytecode.opencsv.CSVWriter;
+import au.com.bytecode.opencsv.ResultSetHelper;
+import au.com.bytecode.opencsv.ResultSetHelperService;
import com.ximple.eofms.jobs.context.AbstractOracleJobContext;
import com.ximple.eofms.jobs.context.postgis.OracleConvertPostGISJobContext;
+import com.ximple.eofms.util.DefaultColorTable;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.geotools.data.DataStore;
@@ -45,7 +48,7 @@
private static final boolean useTpclidText = false;
- private static final int FETCHSIZE = 30;
+ private static final int FETCHSIZE = 100;
private static final int COMMITSIZE = 100;
protected static class Pair {
@@ -240,9 +243,15 @@
logger.info("target schema:" + targetSchemaName);
stmt = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(FETCH_CONNFDR);
- rs.setFetchSize(50);
+ rs.setFetchSize(FETCHSIZE);
+
+ ResultSetHelper resultService = new ResultSetHelperService();
+ final String[] header = new String[] { "tid", "oid", "owner" };
CSVWriter writer = new CSVWriter(new FileWriter("featureowner.csv"), ',');
- writer.writeAll(rs, true);
+ writer.writeNext(header);
+ while (rs.next()) {
+ writer.writeNext(resultService.getColumnValues(rs));
+ }
writer.flush();
writer.close();
} finally {
@@ -262,9 +271,22 @@
logger.info("target schema:" + targetSchemaName);
stmt = connection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(FETCH_COLORTAB);
- rs.setFetchSize(50);
+ rs.setFetchSize(FETCHSIZE);
+
+ ResultSetHelper resultService = new ResultSetHelperService();
+ DefaultColorTable colorTable = (DefaultColorTable) DefaultColorTable.getInstance();
+
+ final String[] header = new String[] { "tid", "oid", "dyncolor" };
CSVWriter writer = new CSVWriter(new FileWriter("featurecolor.csv"), ',');
- writer.writeAll(rs, true);
+ // writer.writeAll(rs, true);
+ writer.writeNext(header);
+ while (rs.next()) {
+ int colorId = rs.getInt(3);
+ String[] values = resultService.getColumnValues(rs);
+ String colorText = colorTable.getColorCode(colorId);
+ values[2] = colorText;
+ writer.writeNext(values);
+ }
writer.flush();
writer.close();
} finally {
--
Gitblit v0.0.0-SNAPSHOT