qwazer / db2-table2sql

Apache License 2.0
4 stars 1 forks source link

output dir #2

Open qwazer opened 9 years ago

qwazer commented 9 years ago
Index: src/main/java/com/github/table2sql/db2/service/FileNameConstructor.java
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
--- src/main/java/com/github/table2sql/db2/service/FileNameConstructor.java (date 1435652115000)
+++ src/main/java/com/github/table2sql/db2/service/FileNameConstructor.java (date 1435652568000)
@@ -1,5 +1,6 @@
 package com.github.table2sql.db2.service;

+import org.apache.commons.io.FilenameUtils;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.core.convert.converter.Converter;
 import org.springframework.stereotype.Component;
@@ -17,8 +18,11 @@
     @Value("${file.name.template}")
     private String template ;

+    @Value("${outputDir}")
+    private String outputDir =".";

+
     public String convert(String s) {
         String schemaName = "";
         String tableName = "";
@@ -34,6 +38,7 @@
         }

         String result = template.replaceAll("\\{schema\\}", schemaName).replaceAll("\\{tablename\\}", tableName);
+        result = FilenameUtils.concat(outputDir, result);
         return result;
     }
 }
Index: src/main/resources/application.properties
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>NATIVE_TO_ASCII_windows-1251
===================================================================
--- src/main/resources/application.properties   (date 1435652115000)
+++ src/main/resources/application.properties   (date 1435652568000)
@@ -1,9 +1,10 @@
-    spring.datasource.url=jdbc:db2://localhost:50000/sample
-    spring.datasource.username=
-    spring.datasource.password=
-    spring.datasource.driverClassName=com.ibm.db2.jcc.DB2Driver
+spring.datasource.url=jdbc:db2://localhost:50000/sample
+spring.datasource.username=
+spring.datasource.password=
+spring.datasource.driverClassName=com.ibm.db2.jcc.DB2Driver
+outputDir=output
-    file.name.template=./{schema}/tabledata/{tablename}.inserts.sql
-    max.rows.size=1000
-    tableNames=SYSIBM.TABLES, SYSIBM.VIEWS, SAMPLE.MAIN_TABLE
-    query.to.find.tableNames.enable=false
-    query.to.find.tableNames=select table_schema || '.' || TABLE_NAME from SYSIBM.TABLES WHERE TABLE_SCHEMA='COMMON'
\ No newline at end of file
+file.name.template=./{schema}/tabledata/{tablename}.inserts.sql
+max.rows.size=1000
+tableNames=SYSIBM.TABLES, SYSIBM.VIEWS, SAMPLE.MAIN_TABLE
+query.to.find.tableNames.enable=false
+query.to.find.tableNames=select table_schema || '.' || TABLE_NAME from SYSIBM.TABLES WHERE TABLE_SCHEMA='COMMON'
\ No newline at end of file