Project

General

Profile

1
package eu.dnetlib.data.transform;
2

    
3
import java.io.*;
4
import java.util.*;
5
import java.util.Map.Entry;
6
import java.util.zip.GZIPInputStream;
7
import javax.xml.transform.TransformerConfigurationException;
8
import javax.xml.transform.TransformerFactoryConfigurationError;
9

    
10
import com.google.common.base.Function;
11
import com.google.common.collect.Iterables;
12
import com.google.common.collect.Lists;
13
import com.google.common.collect.Maps;
14
import com.google.common.collect.Sets;
15
import com.google.protobuf.InvalidProtocolBufferException;
16
import eu.dnetlib.data.mapreduce.hbase.index.config.*;
17
import eu.dnetlib.data.mapreduce.util.*;
18
import eu.dnetlib.data.proto.KindProtos.Kind;
19
import eu.dnetlib.data.proto.OafProtos.Oaf;
20
import eu.dnetlib.data.proto.TypeProtos.Type;
21
import eu.dnetlib.miscutils.functional.xml.IndentXmlString;
22
import org.apache.commons.io.IOUtils;
23
import org.apache.commons.lang.StringUtils;
24
import org.apache.commons.logging.Log;
25
import org.apache.commons.logging.LogFactory;
26
import org.dom4j.Document;
27
import org.dom4j.DocumentException;
28
import org.dom4j.io.SAXReader;
29
import org.json.JSONObject;
30
import org.junit.Before;
31
import org.junit.Test;
32

    
33
import static org.junit.Assert.*;
34

    
35
public class XsltRowTransformerFactoryTest {
36

    
37
	private static final Log log = LogFactory.getLog(XsltRowTransformerFactoryTest.class);
38
	private static String basePathProfiles = "/eu/dnetlib/test/profiles/TransformationRuleDSResources/TransformationRuleDSResourceType/";
39
	private XsltRowTransformerFactory factory;
40
	private EntityConfigTable entityConfigTable;
41

    
42
	@Before
43
	public void setUp() throws Exception {
44
		factory = new XsltRowTransformerFactory();
45
		entityConfigTable = IndexConfig.load(IndexConfigTest.config).getConfigMap();
46
	}
47

    
48
	@Test
49
	public void testParseManyAuthors() throws Exception {
50

    
51
		final Map<String, Object> xslParams = Maps.newHashMap();
52

    
53
		final Map<String, String> m = Maps.newHashMap();
54

    
55
		m.put("od______2367", "true"); // Puma
56
		m.put("od______2294", "true"); // UNIBI
57
		m.put("od________18", "false"); // Arxiv
58

    
59
		xslParams.put("mergeIdForHomonymsMap", m);
60

    
61
		final List<Row> rows = asRows(loadFromTransformationProfile("oaf_person2hbase.xml"), xslParams, load("recordManyAuthors.xml"));
62
		int authorCount = 0;
63
		for (final Row row : rows) {
64
			for (final Column<String, byte[]> col : row.getColumns()) {
65

    
66
				authorCount++;
67
				final OafDecoder d = OafDecoder.decode(col.getValue());
68
				assertNotNull(d);
69

    
70
				log.debug(d.getEntity().getPerson().getCoauthorList().size());
71
			}
72
		}
73
		log.info("authors' count: ---> " + authorCount);
74

    
75
	}
76

    
77
	@Test
78
	public void testParseAuthors() throws Exception {
79

    
80
		final Map<String, Object> xslParams = Maps.newHashMap();
81

    
82
		final Map<String, String> m = Maps.newHashMap();
83

    
84
		m.put("od______2367", "true"); // Puma
85
		m.put("od______2294", "true"); // UNIBI
86
		m.put("od________18", "false"); // Arxiv
87

    
88
		xslParams.put("mergeIdForHomonymsMap", m);
89

    
90
		final List<Row> rows = asRows(loadFromTransformationProfile("oaf_person2hbase.xml"), xslParams, load("recordArxiv.xml"));
91

    
92
		for (final Row row : rows) {
93
			for (final Column<String, byte[]> col : row.getColumns()) {
94

    
95
				final OafDecoder d = OafDecoder.decode(col.getValue());
96
				log.debug(d.getOaf());
97
			}
98
		}
99
	}
100

    
101
	@Test
102
	public void testParseOafClaimUpdate() throws Exception {
103
		doTest(loadFromTransformationProfile("claimUpdates_2_hbase.xsl"), load("recordClaimUpdate.xml"));
104
	}
105

    
106
	@Test
107
	public void testParseClaimUpdate() throws Exception {
108

    
109
		final List<Row> rows = Lists.newArrayList();
110
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordClaim.xml")));
111
		rows.addAll(asRows(loadFromTransformationProfile("claimUpdates_2_hbase.xsl"), load("recordClaimUpdate.xml")));
112

    
113
		printAll(mapAll(buildTable(rows)));
114
	}
115

    
116
	@Test
117
	public void testParseDatasetPUB() throws Exception {
118

    
119
		doTest(loadFromTransformationProfile("odf2hbase.xml"), load("recordDatasetPUB.xml"));
120
	}
121

    
122
	@Test
123
	public void testParseClaim() throws Exception {
124

    
125
		doTest(loadFromTransformationProfile("oaf2hbase.xml"), load("recordClaim.xml"));
126
	}
127

    
128
	@Test
129
	public void testParseClaimDataset() throws Exception {
130

    
131
		doTest(loadFromTransformationProfile("odf2hbase.xml"), load("recordClaimDataset.xml"));
132
	}
133

    
134
	@Test
135
	public void testParseACM() throws Exception {
136

    
137
		doTest(loadFromTransformationProfile("oaf2hbase.xml"), load("recordACM.xml"));
138
	}
139

    
140
	@Test
141
	public void testParseASB() throws Exception {
142

    
143
		doTest(loadFromTransformationProfile("oaf2hbase.xml"), load("recordASB.xml"));
144
	}
145

    
146
	@Test
147
	public void testParseProjectCorda() throws Exception {
148

    
149
		doTest(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordCorda.xml"));
150
	}
151

    
152
	@Test
153
	public void testParseProjectFCT() throws Exception {
154

    
155
		doTest(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordFCT.xml"));
156
	}
157

    
158

    
159
	@Test
160
	public void testParseOaf() throws Exception {
161

    
162
		doTest(loadFromTransformationProfile("oaf2hbase.xml"), load("record.xml"));
163
	}
164

    
165
	@Test
166
	public void testParseOafPublication() throws Exception {
167

    
168
		doTest(loadFromTransformationProfile("oaf_publication2hbase.xml"), load("record.xml"));
169
	}
170

    
171
	@Test
172
	public void testParseLindat() throws Exception {
173

    
174
		doTest(loadFromTransformationProfile("odf2hbase.xml"), load("recordLindat.xml"));
175
	}
176

    
177
	@Test
178
	public void testParseDatacite() throws Exception {
179

    
180
		doTest(loadFromTransformationProfile("odf2hbase.xml"), load("recordDatacite.xml"));
181
	}
182

    
183
	@Test
184
	public void testParseDatacite2() throws Exception {
185

    
186
		doTest(loadFromTransformationProfile("odf2hbase.xml"), load("recordDatacite2.xml"));
187
	}
188

    
189
	@Test
190
	public void testParseOpenTrials() throws Exception {
191

    
192
		doTest(loadFromTransformationProfile("odf2hbase.xml"), load("opentrials_datacite1.xml"));
193
	}
194

    
195
	@Test
196
	public void testLinkPangaea() throws Exception {
197

    
198
		final List<Row> rows = Lists.newArrayList();
199
		rows.addAll(asRows(loadFromTransformationProfile("odf2hbase.xml"), load("pangaeODF1.xml")));
200
		rows.addAll(asRows(loadFromTransformationProfile("odf2hbase.xml"), load("pangaeODF2.xml")));
201
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("pangaeOAF.xml")));
202
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordCordaPangaea.xml")));
203

    
204
		printAll(mapAll(buildTable(rows)));
205
	}
206

    
207
	@Test
208
	public void testPangaea() throws Exception {
209

    
210
		final List<Row> rows = Lists.newArrayList();
211
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("pangaeOAF2.xml")));
212
		printAll(mapAll(buildTable(rows)));
213
	}
214
	@Test
215
	public void testZenodo() throws Exception {
216

    
217
		final List<Row> rows = Lists.newArrayList();
218
		rows.addAll(asRows(loadFromTransformationProfile("odf2hbase.xml"), load("zenodoData.xml")));
219
		printAll(mapAll(buildTable(rows)));
220
	}
221

    
222
	@Test
223
	public void testLinkCorda() throws Exception {
224

    
225
		final List<Row> rows = Lists.newArrayList();
226
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordCorda.xml")));
227
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordCorda.xml")));
228

    
229
		printAll(mapAll(buildTable(rows)));
230
	}
231

    
232
	@Test
233
	public void testLinkFCT() throws Exception {
234

    
235
		final List<Row> rows = Lists.newArrayList();
236
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordFCT.xml")));
237
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordFCT.xml")));
238

    
239
		printAll(mapAll(buildTable(rows)));
240
	}
241

    
242
	@Test
243
	public void testLinkARC() throws Exception {
244

    
245
		final List<Row> rows = Lists.newArrayList();
246
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordARC.xml")));
247
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordARC.xml")));
248

    
249
		printAll(mapAll(buildTable(rows)));
250
	}
251

    
252
	@Test
253
	public void testLinkWT() throws Exception {
254

    
255
		final List<Row> rows = Lists.newArrayList();
256
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordWT.xml")));
257
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordWT.xml")));
258

    
259
		printAll(mapAll(buildTable(rows)));
260
	}
261

    
262

    
263

    
264
	@Test
265
	public void testLinkOrganization() throws Exception {
266

    
267
		final List<Row> rows = Lists.newArrayList();
268
		rows.addAll(asRows(loadFromTransformationProfile("organizations_2_hbase.xsl"), load("organization.xml")));
269
		rows.addAll(asRows(loadFromTransformationProfile("projectorganization_2_hbase.xsl"), load("project_organization.xml")));
270
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordCorda.xml")));
271

    
272
		printAll(mapAll(buildTable(rows)));
273
	}
274

    
275
	@Test
276
	public void testLinkOrganizationAffiliation() throws Exception {
277

    
278
		final List<Row> rows = Lists.newArrayList();
279
		rows.addAll(asRows(loadFromTransformationProfile("organizations_2_hbase.xsl"), load("organization.xml")));
280
		rows.addAll(asRows(loadFromTransformationProfile("resultorganization_2_hbase.xsl"), load("result_organization.xml")));
281
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("record.xml")));
282

    
283
		printAll(mapAll(buildTable(rows)));
284
	}
285

    
286
	@Test
287
	public void testUnpackAuthors() throws Exception {
288

    
289
		final Map<String, Object> xslParams = Maps.newHashMap();
290

    
291
		final Map<String, String> m = Maps.newHashMap();
292

    
293
		m.put("od______2367", "true"); // Puma
294
		m.put("od______2294", "true"); // UNIBI
295
		m.put("od________18", "false"); // Arxiv
296

    
297
		xslParams.put("mergeIdForHomonymsMap", m);
298

    
299
		final List<Row> rows = Lists.newArrayList();
300
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), xslParams, load("recordArxiv.xml")));
301
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), xslParams, load("recordArxiv2.xml")));
302
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), xslParams, load("recordPuma1.xml")));
303
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), xslParams, load("recordPuma2.xml")));
304
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), xslParams, load("recordUNIBI.xml")));
305

    
306
		printPersonFullnames(mapAll(buildTable(rows)));
307
	}
308

    
309
	@Test
310
	public void testDuplicates() throws Exception {
311
		final String mergeId = "50|dedup_wf_001::08ed625d07e5738b794ff14d6773fd9f";
312
		final List<Row> rows = Lists.newArrayList();
313

    
314
		final Function<Row, Row> f = new Function<Row, Row>() {
315
			@Override
316
			public Row apply(final Row rowIn) {
317

    
318
				final List<Column<String,byte[]>> cols = Lists.newArrayList();
319
				for(Column<String,byte[]> col : rowIn.getColumns()) {
320
					if (col.getName().equals("body")) {
321
						cols.add(new Column(col.getName(), col.getValue()));
322

    
323
					}
324
				}
325
				return new Row("result", rowIn.getKey(), cols);
326
			}
327
		};
328

    
329
		final List<Row> puma1 = asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordPuma1.xml"), f);
330
		puma1.add(new Row("resultResult_dedup_isMergedIn", mergeId));
331

    
332
		final List<Row> puma2 = asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordPuma2.xml"), f);
333
		puma2.add(new Row("resultResult_dedup_isMergedIn", mergeId));
334

    
335
		rows.addAll(puma1);
336
		rows.addAll(puma2);
337

    
338
		List<Oaf> duplicates = Lists.newArrayList();
339
		duplicates.add(getOafBody(puma1));
340
		duplicates.add(getOafBody(puma2));
341
		final Oaf.Builder oafMerge = OafEntityMerger.merge(mergeId, duplicates);
342

    
343
		final Row mergeRow = new Row("result", mergeId, Lists.<Column<String,byte[]>>newArrayList(new Column("body", oafMerge.build().toByteArray())));
344

    
345
		rows.add(mergeRow);
346

    
347
		printAll(mapAll(buildTable(rows)));
348
	}
349

    
350
	private Oaf getOafBody(final List<Row> rows) throws InvalidProtocolBufferException {
351
		for(Row row : rows) {
352
			if(StringUtils.startsWith(row.getKey(), "50")) {
353
				return Oaf.parseFrom(row.getColumn("body").getValue());
354

    
355
			}
356
		}
357
		return null;
358
	}
359

    
360
	@Test
361
	public void testParseDoajOAF() throws Exception {
362

    
363
		doTest(loadFromTransformationProfile("oaf2hbase.xml"), load("doajUniversityRecord.xml"));
364
	}
365

    
366
	@Test
367
	public void testParseDatasource() throws Exception {
368

    
369
		doTest(loadFromTransformationProfile("datasources_2_hbase.xsl"), load("datasourceNative.xml"));
370
	}
371
	@Test
372
	public void testParseDatasourcePiwik() throws Exception {
373

    
374
		doTest(loadFromTransformationProfile("datasources_2_hbase.xsl"), load("datasourcePiwik.xml"));
375
	}
376

    
377
	@Test
378
	public void testParseDataDatasource() throws Exception {
379

    
380
		doTest(loadFromTransformationProfile("datasources_2_hbase.xsl"), load("dataDatasource.xml"));
381
	}
382

    
383
	@Test
384
	public void testFromMongodbCompressedDump() throws Exception {
385
		doTestJsonGz(loadFromTransformationProfile("oaf2hbase.xml"), load("mdstore_cleaned.json.gz"));
386
	}
387

    
388
	@Test
389
	public void testLoadFromTransformationProfile() throws IOException {
390
		InputStream in = loadFromTransformationProfile("oaf2hbase.xml");
391
		log.info(IOUtils.toString(in));
392
	}
393

    
394
	@Test
395
	public void test_template() throws Exception {
396
		final String xslt = IOUtils.toString(loadFromTransformationProfile("oaf2hbase.xml"));
397
		final XsltRowTransformer transformer = factory.getTransformer(xslt);
398
		assertNotNull(transformer);
399

    
400
		final String record = IOUtils.toString(load("record.xml"));
401
		final List<Row> rows = transformer.apply(record);
402

    
403
		System.out.println(rows);
404
	}
405

    
406
	@Test
407
	public void testWrongCharsOrganization() throws Exception {
408
		final List<Row> rows = Lists.newArrayList();
409
		rows.addAll(asRows(loadFromTransformationProfile("organizations_2_hbase.xsl"), load("organizationWrongChars.xml")));
410
		printAll(mapAll(buildTable(rows)));
411
	}
412

    
413
	@Test
414
	public void testParseProjectWithFunderOriginalName() throws Exception {
415

    
416
		doTest(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectWithFunderOriginalName.xml"));
417
	}
418
	@Test
419
	public void testLinkFunderOriginalName() throws Exception {
420

    
421
		final List<Row> rows = Lists.newArrayList();
422
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectWithFunderOriginalName.xml")));
423
		rows.addAll(asRows(loadFromTransformationProfile("oaf2hbase.xml"), load("recordFunderOriginalName.xml")));
424

    
425
		printAll(mapAll(buildTable(rows)));
426
	}
427

    
428
	@Test
429
	public void testProjectExtraInfo() throws Exception {
430
		final List<Row> rows = Lists.newArrayList();
431
		rows.addAll(asRows(loadFromTransformationProfile("projects_2_hbase.xsl"), load("projectRecordExtraInfo.xml")));
432
		printAll(mapAll(buildTable(rows)));
433
	}
434

    
435
	private void doTest(final InputStream xsltStream, final InputStream recordStream) throws Exception {
436
		try {
437
			final List<Row> rows = asRows(xsltStream, recordStream);
438

    
439
			log.info(rows);
440

    
441
			final Map<String, Map<String, Map<String, byte[]>>> table = buildTable(rows);
442

    
443
			// System.out.println("\n" + table.toString());
444

    
445
			final Map<String, XmlRecordFactory> builders = mapAll(table);
446

    
447
			printAll(builders);
448
		} catch (final InvalidProtocolBufferException e) {
449
			throw new Exception(e);
450
		} catch (final TransformerConfigurationException e) {
451
			throw new Exception(e);
452
		} catch (final TransformerFactoryConfigurationError e) {
453
			throw new Exception(e);
454
		} catch (final DocumentException e) {
455
			throw new Exception(e);
456
		}
457
	}
458

    
459
	private void doTestJsonGz(final InputStream xsltStream, final InputStream recordStream) throws Exception {
460

    
461
		final Iterator<List<Row>> rowsIterator = asRowsJsonGzip(xsltStream, recordStream);
462

    
463
		int i = 0;
464
		while (rowsIterator.hasNext()) {
465
			final List<Row> rows = rowsIterator.next();
466
			i++;
467

    
468
			if ((i % 10000) == 0) {
469
				System.out.println(i);
470
			}
471

    
472
			final Map<String, Map<String, Map<String, byte[]>>> table = buildTableDoaj(rows);
473

    
474
			for (final Map<String, Map<String, byte[]>> m : table.values()) {
475
				for (final Map<String, byte[]> mv : m.values()) {
476
					for (final byte[] v : mv.values()) {
477
						final OafDecoder d = OafDecoder.decode(v);
478
						assertNotNull(d);
479
						assertNotNull(d.getOaf());
480

    
481
						switch (d.getKind()) {
482
						case entity:
483
							assertNotNull(d.getMetadata());
484
							if (d.getOaf().getEntity().getType().equals(Type.result)) {
485
								System.out.println(d.getOaf());
486
							}
487
							break;
488
						case relation:
489
							assertNotNull(d.getRel());
490
							break;
491
						default:
492
							break;
493
						}
494
					}
495
				}
496
			}
497
		}
498
	}
499

    
500
	private List<Row> asRows(final InputStream xsltStream, final InputStream recordStream, final Function<Row, Row> p) throws Exception {
501
		return asRows(xsltStream, new HashMap<String, Object>(), recordStream, p);
502
	}
503

    
504
	private List<Row> asRows(final InputStream xsltStream, final InputStream recordStream) throws Exception {
505
		return asRows(xsltStream, new HashMap<String, Object>(), recordStream);
506
	}
507

    
508
	private List<Row> asRows(final InputStream xsltStream, final Map<String, Object> params, final InputStream recordStream) throws Exception {
509
		return asRows(xsltStream, params, recordStream, null);
510
	}
511

    
512
	private List<Row> asRows(final InputStream xsltStream, final Map<String, Object> params, final InputStream recordStream, final Function<Row, Row> p) throws Exception {
513
		final String xslt = IOUtils.toString(xsltStream);
514
		final XsltRowTransformer transformer = factory.getTransformer(xslt, params);
515
		assertNotNull(transformer);
516

    
517
		final String record = IOUtils.toString(recordStream);
518
		final List<Row> rows = transformer.apply(record);
519

    
520
		assertNotNull(rows);
521
		assertFalse(rows.isEmpty());
522
		return p == null ? rows : Lists.newArrayList(Iterables.transform(rows, p));
523
	}
524

    
525
	private Iterator<List<Row>> asRowsJsonGzip(final InputStream xsltStream, final InputStream recordStreamJsonGzip) throws Exception {
526
		final String xslt = IOUtils.toString(xsltStream);
527
		final XsltRowTransformer transformer = factory.getTransformer(xslt);
528
		assertNotNull(transformer);
529
		assertNotNull(recordStreamJsonGzip);
530

    
531
		final GZIPInputStream stream = new GZIPInputStream(recordStreamJsonGzip);
532
		assertNotNull(stream);
533
		final BufferedReader inStream = new BufferedReader(new InputStreamReader(stream));
534
		assertNotNull(inStream);
535
		return new Iterator<List<Row>>() {
536

    
537
			String jsonRecord = null;
538

    
539
			@Override
540
			public boolean hasNext() {
541
				try {
542
					return (jsonRecord = inStream.readLine()) != null;
543
				} catch (final IOException e) {
544
					throw new RuntimeException(e);
545
				}
546
			}
547

    
548
			@Override
549
			public List<Row> next() {
550

    
551
				final JSONObject jsonObj = new JSONObject(jsonRecord);
552
				final String body = jsonObj.getString("body");
553
				try {
554
					assertTrue(StringUtils.isNotBlank(body));
555
					// System.out.println(body);
556
					final List<Row> rows = transformer.apply(body);
557
					assertNotNull(rows);
558
					assertFalse(rows.isEmpty());
559
					return rows;
560
				} catch (final Throwable e) {
561
					System.err.println("error transforming document: " + body);
562
					throw new RuntimeException(e);
563
				}
564
			}
565

    
566
			@Override
567
			public void remove() {
568
				throw new UnsupportedOperationException();
569
			}
570

    
571
		};
572

    
573
	}
574

    
575
	private Map<String, Map<String, Map<String, byte[]>>> buildTableDoaj(final List<Row> rows) throws UnsupportedEncodingException {
576
		final Map<String, Map<String, Map<String, byte[]>>> table = Maps.newHashMap();
577

    
578
		for (final Row row : rows) {
579
			final String rowKey = row.getKey();
580
			final String cf = row.getColumnFamily();
581
			if (!table.containsKey(rowKey)) {
582
				table.put(rowKey, new HashMap<String, Map<String, byte[]>>());
583
			}
584
			if (!table.get(rowKey).containsKey(cf)) {
585
				table.get(rowKey).put(row.getColumnFamily(), new HashMap<String, byte[]>());
586
			}
587
			for (final Column<String, byte[]> c : row.getColumns()) {
588
				// System.out.println(String.format("ADDING K:%s CF:%s Q:%s", rowKey, cf, c.getName()));
589
				table.get(rowKey).get(cf).put(c.getName(), c.getValue());
590
				if (cf.equals("result") && c.getName().equals("body")) {
591
					// System.out.println(String.format("ADDING K:%s CF:%s Q:%s", rowKey, cf, c.getName()));
592
					assertTrue(StringUtils.isNotBlank(new String(c.getValue(), "UTF-8")));
593
				}
594
			}
595
		}
596
		return table;
597

    
598
	}
599

    
600
	private Map<String, Map<String, Map<String, byte[]>>> buildTable(final List<Row> rows) throws UnsupportedEncodingException {
601
		final Map<String, Map<String, Map<String, byte[]>>> table = Maps.newHashMap();
602

    
603
		for (final Row row : rows) {
604
			final String rowKey = row.getKey();
605
			final String cf = row.getColumnFamily();
606
			if (!table.containsKey(rowKey)) {
607
				table.put(rowKey, new HashMap<String, Map<String, byte[]>>());
608
			}
609
			if (!table.get(rowKey).containsKey(cf)) {
610
				table.get(rowKey).put(row.getColumnFamily(), new HashMap<String, byte[]>());
611
			}
612
			for (final Column<String, byte[]> c : row.getColumns()) {
613
				System.out.println(String.format("ADDING K:%s CF:%s Q:%s", rowKey, cf, c.getName()));
614
				table.get(rowKey).get(cf).put(c.getName(), c.getValue());
615
				if (c.getName().equals("body")) {
616
					final String theBody = new String(c.getValue(), "UTF-8");
617
					assertTrue(StringUtils.isNotBlank(theBody));
618
					//System.out.println(theBody);
619
				}
620
			}
621
		}
622
		return table;
623

    
624
	}
625

    
626
	private Map<String, XmlRecordFactory> mapAll(final Map<String, Map<String, Map<String, byte[]>>> table) throws Exception {
627

    
628
		final Map<String, XmlRecordFactory> builders = Maps.newHashMap();
629
		for (final Entry<String, Map<String, Map<String, byte[]>>> e : table.entrySet()) {
630
			map(builders, e.getKey(), e.getValue());
631
		}
632
		return builders;
633
	}
634

    
635
	// private Map<String, XmlRecordFactory> mapResultsOnly(final Map<String, Map<String, Map<String, byte[]>>> table) throws Exception {
636
	//
637
	// final Map<String, XmlRecordFactory> builders = Maps.newHashMap();
638
	// for (final Entry<String, Map<String, Map<String, byte[]>>> e : table.entrySet()) {
639
	// final Type type = OafRowKeyDecoder.decode(e.getKey()).getType();
640
	// if (type == Type.result) {
641
	// map(builders, e.getKey(), e.getValue());
642
	// }
643
	// }
644
	// return builders;
645
	// }
646

    
647
	private void map(final Map<String, XmlRecordFactory> builders, final String rowKey, final Map<String, Map<String, byte[]>> row) throws Exception {
648

    
649
		final Type type = OafRowKeyDecoder.decode(rowKey).getType();
650

    
651
		final Map<String, byte[]> familyMap = row.get(type.toString());
652

    
653
		if (familyMap == null) return;
654

    
655
		final byte[] bodyB = familyMap.get("body");
656

    
657
		if (bodyB != null) {
658
			ensureBuilder(builders, rowKey);
659

    
660
			final Oaf oaf = UpdateMerger.mergeBodyUpdates(familyMap);
661

    
662
			final OafDecoder mainEntity = OafDecoder.decode(oaf);
663

    
664
			builders.get(rowKey).setMainEntity(mainEntity);
665

    
666
			for (final LinkDescriptor ld : entityConfigTable.getDescriptors(type)) {
667

    
668
				final String it = ld.getRelDescriptor().getIt();
669
				final Map<String, byte[]> cols = row.get(it);
670

    
671
				if ((cols != null) && !cols.isEmpty()) {
672

    
673
					for (final byte[] oafB : cols.values()) {
674

    
675
						final Oaf.Builder relBuilder = Oaf.newBuilder(Oaf.parseFrom(oafB));
676

    
677
						if (ld.isSymmetric()) {
678
							final RelDescriptor rd = ld.getRelDescriptor();
679

    
680
							relBuilder.getRelBuilder().setCachedTarget(mainEntity.getEntity()).setRelType(rd.getRelType()).setSubRelType(rd.getSubRelType());
681
						}
682

    
683
						relBuilder.getRelBuilder().setChild(ld.isChild());
684

    
685
						final Oaf.Builder oafBuilder = Oaf.newBuilder().setKind(Kind.relation).setLastupdatetimestamp(System.currentTimeMillis());
686
						oafBuilder.mergeFrom(relBuilder.build());
687

    
688
						final String targetId = ld.isSymmetric() ? oafBuilder.getRel().getTarget() : oafBuilder.getRel().getSource();
689
						ensureBuilder(builders, targetId);
690
						final OafDecoder decoder = OafDecoder.decode(oafBuilder.build());
691

    
692
						if (ld.isChild()) {
693
							builders.get(targetId).addChild(type, decoder);
694
						} else {
695
							builders.get(targetId).addRelation(type, decoder);
696
						}
697
					}
698

    
699
				}
700
			}
701
		}
702

    
703
	}
704

    
705
	private void printAll(final Map<String, XmlRecordFactory> builders) throws DocumentException {
706
		print(Sets.newHashSet(Type.values()), builders, null);
707
	}
708

    
709
	private void printPerson(final Map<String, XmlRecordFactory> builders) throws DocumentException {
710
		print(Sets.newHashSet(Type.person), builders, null);
711
	}
712

    
713
	private void printPersonFullnames(final Map<String, XmlRecordFactory> builders) throws DocumentException {
714

    
715
		final Map<Type, Set<String>> xpaths = Maps.newHashMap();
716

    
717
		final Set<String> personPaths = Sets.newHashSet();
718

    
719
		personPaths.add("//fullname");
720

    
721
		xpaths.put(Type.person, personPaths);
722

    
723
		print(Sets.newHashSet(Type.person), builders, xpaths);
724
	}
725

    
726
	private void print(final Set<Type> types, final Map<String, XmlRecordFactory> builders, final Map<Type, Set<String>> xpaths) throws DocumentException {
727
		final SAXReader r = new SAXReader();
728

    
729
		for (final Entry<String, XmlRecordFactory> e : builders.entrySet()) {
730
			final OafRowKeyDecoder kd = OafRowKeyDecoder.decode(e.getKey());
731

    
732
			if (!e.getValue().isValid()) throw new IllegalArgumentException("invalid builder: " + e.getKey());
733
			if (types.contains(kd.getType())) {
734
				final String val = IndentXmlString.apply(e.getValue().build());
735

    
736
				if ((xpaths != null) && !xpaths.isEmpty() && (xpaths.get(kd.getType()) != null)) {
737
					final Document doc = r.read(new StringReader(val));
738

    
739
					log.debug("\n" + e.getKey());
740
					for (final String xpath : xpaths.get(kd.getType())) {
741
						log.debug(doc.valueOf(xpath));
742
					}
743
				} else {
744
					log.info(val);
745
				}
746
			}
747
		}
748
	}
749

    
750
	private void printNoIndent(final Map<String, XmlRecordFactory> builders) {
751
		for (final Entry<String, XmlRecordFactory> e : builders.entrySet()) {
752
			if (e.getValue().isValid()) {
753
				log.debug(e.getValue().build());
754
			} else {
755
				log.debug("invalid builder: " + e.getKey());
756
			}
757
		}
758
	}
759

    
760
	private void ensureBuilder(final Map<String, XmlRecordFactory> builders, final String rowKey) throws Exception {
761
		if (!builders.containsKey(rowKey)) {
762
			builders.put(rowKey, newBuilder());
763
		}
764
	}
765

    
766
	private XmlRecordFactory newBuilder() throws TransformerConfigurationException, TransformerFactoryConfigurationError, DocumentException {
767
		return new XmlRecordFactory(entityConfigTable, ContextMapper.fromXml(Context.xml),
768
				RelClasses.fromJSon(RelClassesTest.relClassesJson), XmlRecordFactoryTest.SCHEMA_LOCATION, true, false, false, XmlRecordFactoryTest.specialDatasourceTypes);
769
	}
770

    
771
	private InputStream load(final String fileName) {
772
		return getClass().getResourceAsStream(fileName);
773
	}
774

    
775
	private InputStream loadFromTransformationProfile(final String profilePath) {
776
		log.info("Loading xslt from: " + basePathProfiles + profilePath);
777
		InputStream profile = getClass().getResourceAsStream(basePathProfiles + profilePath);
778
		SAXReader saxReader = new SAXReader();
779
		Document doc = null;
780
		try {
781
			doc = saxReader.read(profile);
782
		} catch (DocumentException e) {
783
			e.printStackTrace();
784
			throw new RuntimeException(e);
785
		}
786
		String xslt = doc.selectSingleNode("//SCRIPT/CODE/*[local-name()='stylesheet']").asXML();
787
		return IOUtils.toInputStream(xslt);
788
	}
789

    
790
}
    (1-1/1)