Examples of ExportTargetTableBean

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
    public void checkExportParamTest02() throws Exception {
        JobFlowParamLoader loader = new JobFlowParamLoader();

        // 設定
        Map<String, ExportTargetTableBean> targetTable = new LinkedHashMap<String, ExportTargetTableBean>();
        ExportTargetTableBean table1 = new ExportTargetTableBean();
        // 重複チェックを行うか否か
        table1.setDuplicateCheck(true);
        // Export対象テーブルに対応する異常データテーブル
        table1.setErrorTableName("XXX_ERROR");
        // Export中間TSVファイルに対応するカラム名
        table1.setExportTsvColumns(Arrays.asList(new String[]{"TEXTDATA1", "INTDATA1", "DATEDATA1"}));
        // Export対象テーブルのカラム名
        table1.setExportTableColumns(Arrays.asList(new String[]{"TEXTDATA1", "INTDATA1"}));
        // 異常データテーブルのカラム名
        table1.setErrorTableColumns(Arrays.asList(new String[]{"INTDATA1"}));
        // キー項目のカラム名
        table1.setKeyColumns(Arrays.asList(new String[]{"TEXTDATA1"}));
        // エラーコードを格納するカラム名
        table1.setErrorCodeColumn("ERROR_CODE");
        // 重複チェックエラーのエラーコードの値
        table1.setErrorCode("ERR01");
        // Export対象テーブルに対応するJavaBeanのクラス名
        table1.setExportTargetType(this.getClass());
        // Export対象テーブルのデータをHDFS上に書き出す際のファイルパス
        List<String> list1 = new ArrayList<String>();
        list1.add("hdfs://localhost/user/asakusa/import/11/XXX_1");
        table1.setDfsFilePaths(list1);
        targetTable.put("EXP_TARGET1", table1);

        ExportTargetTableBean table2 = new ExportTargetTableBean();
        // 重複チェックを行うか否か
        table2.setDuplicateCheck(false);
        // Export対象テーブルに対応する異常データテーブル
        table2.setErrorTableName(null);
        // Export中間TSVファイルに対応するカラム名
        table2.setExportTsvColumns(Arrays.asList(new String[]{"TEXTDATA1", "INTDATA1", "DATEDATA1"}));
        // Export対象テーブルのカラム名
        table2.setExportTableColumns(Arrays.asList(new String[]{"TEXTDATA1", "INTDATA1"}));
        // 異常データテーブルのカラム名
        table2.setErrorTableColumns(Arrays.asList(new String[]{}));
        // キー項目のカラム名
        table2.setKeyColumns(Arrays.asList(new String[]{}));
        // エラーコードを格納するカラム名
        table2.setErrorCodeColumn(null);
        // 重複チェックエラーのエラーコードの値
        table2.setErrorCode(null);
        // Export対象テーブルに対応するJavaBeanのクラス名
        table2.setExportTargetType(this.getClass());
        // Export対象テーブルのデータをHDFS上に書き出す際のファイルパス
        List<String> list2 = new ArrayList<String>();
        list2.add("hdfs://localhost/user/asakusa/import/11/XXX_1");
        table2.setDfsFilePaths(list2);
        targetTable.put("EXP_TARGET2", table2);

        // テスト実行
        boolean result = loader.checkExportParam(targetTable, targetName, "1", "dummyFileName");
        assertTrue(result);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

85
86
87
88
89
90
91
92
93
94
95
96
        ExporterBean bean = new ExporterBean();
        bean.setJobflowSid("11");
        bean.setJobflowId("jobflow1");
        bean.setExecutionId("11-1");
        Map<String, ExportTargetTableBean> targetTable = new HashMap<String, ExportTargetTableBean>();
        targetTable.put("table1", new ExportTargetTableBean());
        targetTable.put("table2", new ExportTargetTableBean());
        bean.setExportTargetTable(targetTable);

        Properties p = ConfigurationLoader.getProperty();
        p.setProperty(Constants.PROP_KEY_EXPORT_TSV_DELETE, TsvDeleteType.TRUE.getSymbol());
        ConfigurationLoader.setProperty(p);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

132
133
134
135
136
137
138
139
140
141
142
143
        ExporterBean bean = new ExporterBean();
        bean.setJobflowSid("11");
        bean.setJobflowId("jobflow1");
        bean.setExecutionId("11-1");
        Map<String, ExportTargetTableBean> targetTable = new HashMap<String, ExportTargetTableBean>();
        targetTable.put("table1", new ExportTargetTableBean());
        targetTable.put("table2", new ExportTargetTableBean());
        bean.setExportTargetTable(targetTable);

        Properties p = ConfigurationLoader.getProperty();
        p.setProperty(Constants.PROP_KEY_EXPORT_TSV_DELETE, TsvDeleteType.FALSE.getSymbol());
        ConfigurationLoader.setProperty(p);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

179
180
181
182
183
184
185
186
187
188
189
190
        ExporterBean bean = new ExporterBean();
        bean.setJobflowSid("11");
        bean.setJobflowId("jobflow1");
        bean.setExecutionId("11-1");
        Map<String, ExportTargetTableBean> targetTable = new HashMap<String, ExportTargetTableBean>();
        targetTable.put("table1", new ExportTargetTableBean());
        targetTable.put("table2", new ExportTargetTableBean());
        bean.setExportTargetTable(targetTable);

        Properties p = ConfigurationLoader.getProperty();
        p.setProperty(Constants.PROP_KEY_EXPORT_TSV_DELETE, TsvDeleteType.TRUE.getSymbol());
        ConfigurationLoader.setProperty(p);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

236
237
238
239
240
241
242
243
244
245
246
247
        ExporterBean bean = new ExporterBean();
        bean.setJobflowSid("11");
        bean.setJobflowId("jobflow1");
        bean.setExecutionId("11-1");
        Map<String, ExportTargetTableBean> targetTable = new HashMap<String, ExportTargetTableBean>();
        targetTable.put("table1", new ExportTargetTableBean());
        targetTable.put("table2", new ExportTargetTableBean());
        bean.setExportTargetTable(targetTable);

        Properties p = ConfigurationLoader.getProperty();
        p.setProperty(Constants.PROP_KEY_EXPORT_TSV_DELETE, TsvDeleteType.FALSE.getSymbol());
        ConfigurationLoader.setProperty(p);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

293
294
295
296
297
298
299
300
301
302
303
304
        ExporterBean bean = new ExporterBean();
        bean.setJobflowSid("11");
        bean.setJobflowId("jobflow1");
        bean.setExecutionId("11-1");
        Map<String, ExportTargetTableBean> targetTable = new HashMap<String, ExportTargetTableBean>();
        targetTable.put("table1", new ExportTargetTableBean());
        targetTable.put("table2", new ExportTargetTableBean());
        bean.setExportTargetTable(targetTable);

        Properties p = ConfigurationLoader.getProperty();
        p.setProperty(Constants.PROP_KEY_EXPORT_TSV_DELETE, TsvDeleteType.TRUE.getSymbol());
        ConfigurationLoader.setProperty(p);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

350
351
352
353
354
355
356
357
358
359
360
361
        ExporterBean bean = new ExporterBean();
        bean.setJobflowSid("11");
        bean.setJobflowId("jobflow1");
        bean.setExecutionId("11-1");
        Map<String, ExportTargetTableBean> targetTable = new HashMap<String, ExportTargetTableBean>();
        targetTable.put("table1", new ExportTargetTableBean());
        targetTable.put("table2", new ExportTargetTableBean());
        bean.setExportTargetTable(targetTable);

        Properties p = ConfigurationLoader.getProperty();
        p.setProperty(Constants.PROP_KEY_EXPORT_TSV_DELETE, TsvDeleteType.FALSE.getSymbol());
        ConfigurationLoader.setProperty(p);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

407
408
409
410
411
412
413
414
415
416
417
418
        ExporterBean bean = new ExporterBean();
        bean.setJobflowSid("11");
        bean.setJobflowId("jobflow1");
        bean.setExecutionId("11-1");
        Map<String, ExportTargetTableBean> targetTable = new HashMap<String, ExportTargetTableBean>();
        targetTable.put("table1", new ExportTargetTableBean());
        targetTable.put("table2", new ExportTargetTableBean());
        bean.setExportTargetTable(targetTable);

        Properties p = ConfigurationLoader.getProperty();
        p.setProperty(Constants.PROP_KEY_EXPORT_TSV_DELETE, TsvDeleteType.TRUE.getSymbol());
        ConfigurationLoader.setProperty(p);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
1886
    public void checkExportParamTest13() throws Exception {
        JobFlowParamLoader loader = new JobFlowParamLoader();

        // 設定
        Map<String, ExportTargetTableBean> targetTable = new LinkedHashMap<String, ExportTargetTableBean>();
        ExportTargetTableBean table1 = new ExportTargetTableBean();
        // 重複チェックを行うか否か
        table1.setDuplicateCheck(true);
        // Export対象テーブルに対応する異常データテーブル
        table1.setErrorTableName("XXX_ERROR");
        // Export中間TSVファイルに対応するカラム名
        table1.setExportTsvColumns(Arrays.asList(new String[]{"TEXTDATA1", "INTDATA1", "DATEDATA1"}));
        // Export対象テーブルのカラム名
        table1.setExportTableColumns(Arrays.asList(new String[]{"TEXTDATA1", "TEMP_SID"}));
        // 異常データテーブルのカラム名
        table1.setErrorTableColumns(Arrays.asList(new String[]{"INTDATA1"}));
        // キー項目のカラム名
        table1.setKeyColumns(Arrays.asList(new String[]{"TEXTDATA1"}));
        // エラーコードを格納するカラム名
        table1.setErrorCodeColumn("ERROR_CODE");
        // 重複チェックエラーのエラーコードの値
        table1.setErrorCode("ERR01");
        // Export対象テーブルに対応するJavaBeanのクラス名
        table1.setExportTargetType(this.getClass());
        // Export対象テーブルのデータをHDFS上に書き出す際のファイルパス
        List<String> list1 = new ArrayList<String>();
        list1.add("hdfs://localhost/user/asakusa/import/11/XXX_1");
        table1.setDfsFilePaths(list1);
        targetTable.put("EXP_TARGET1", table1);

        // テスト実行
        boolean result = loader.checkExportParam(targetTable, targetName, "1", "dummyFileName");
        assertFalse(result);
View Full Code Here

Examples of com.asakusafw.bulkloader.bean.ExportTargetTableBean

188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
        // テストデータをセット
        util1.storeToDatabase(false);

        // ExportBeanを生成
        Map<String, ExportTargetTableBean> targetTable = new LinkedHashMap<String, ExportTargetTableBean>();
        ExportTargetTableBean table1 = new ExportTargetTableBean();
        table1.setDuplicateCheck(false);
        table1.addExportFile(new File(new File ("src/test/data/exporter/EXP_EXP_TARGET1_1.tsv").getAbsolutePath()));
        table1.addExportFile(new File(new File ("src/test/data/exporter/EXP_EXP_TARGET1_2.tsv").getAbsolutePath()));
        table1.setExportTsvColumns(Arrays.asList(new String[]{"SID", "VERSION_NO", "TEXTDATA1", "INTDATA1", "DATEDATA1"}));
        targetTable.put("IMPORT_TARGET1", table1);
        ExportTargetTableBean table2 = new ExportTargetTableBean();
        table2.setDuplicateCheck(false);
        table2.addExportFile(new File(new File ("src/test/data/exporter/EXP_EXP_TARGET2_1.tsv").getAbsolutePath()));
        table2.setExportTsvColumns(Arrays.asList(new String[]{"TEXTDATA2", "INTDATA2", "DATEDATA2"}));
        targetTable.put("IMPORT_TARGET2", table2);
        ExporterBean bean = new ExporterBean();
        bean.setExportTargetTable(targetTable);
        bean.setJobflowSid("11");
        bean.setJobflowId(jobflowId);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.