Classes

Class	Line #	Total Statements	% Filtered	Complexity	Uncovered Elements	TOTAL Coverage	Actions
ExcelMarshaller	25	42	0%	23	11	0.82812582.8%	Show methods

Class ExcelMarshaller

Class ExcelMarshaller	Line # 25	Total Statements 42	% Filtered 0%	Complexity 23	Uncovered Elements 11	TOTAL Coverage 0.82812582.8%
ExcelMarshaller(File,String,Predicate<Row>,boolean)   ExcelMarshaller(File,String,Predicate<Row>,boolean)	3737	7.07	0.00%	1.01	0.00	1.0 1.0100%
ExcelMarshaller(File,Predicate<Row>,boolean)   ExcelMarshaller(File,Predicate<Row>,boolean)	4848	1.01	0.00%	1.01	0.00	1.0 1.0100%
create(File) : ExcelMarshaller   create(File) : ExcelMarshaller	5353	1.01	0.00%	1.01	0.00	1.0 1.0100%
create(File,Predicate<Row>,boolean) : ExcelMarshaller   create(File,Predicate<Row>,boolean) : ExcelMarshaller	5858	4.04	0.00%	1.01	0.00	1.0 1.0100%
read(File) : void   read(File) : void	6767	14.014	0.00%	5.05	2.02	0.85714287 0.8571428785.7%
setMember(ExcelSheet,int,Object,Member) : void   setMember(ExcelSheet,int,Object,Member) : void	8989	8.08	0.00%	5.05	1.01	0.9166667 0.916666791.7%
column(ExcelSheet,Member) : int   column(ExcelSheet,Member) : int	111111	3.03	0.00%	4.04	4.04	0.42857143 0.4285714342.9%
getLines(ExcelSheet) : SortedSet<Integer>   getLines(ExcelSheet) : SortedSet<Integer>	124124	2.02	0.00%	3.03	2.02	0.6666667 0.666666766.7%
get(Class<T>) : Map<Integer, T>   get(Class<T>) : Map<Integer, T>	130130	1.01	0.00%	1.01	0.00	1.0 1.0100%
addBeanFilter(Predicate<Object>) : void   addBeanFilter(Predicate<Object>) : void	135135	1.01	0.00%	1.01	1.01	0.0 0.00%

 

Contributing tests

Contributing tests

Select all

	Test contribution	Test	Result	Actions
	0.03125	net.technearts.ExcelMarshallerTest.testSimpleMembersnet.technearts.ExcelMarshallerTest.testSimpleMembers	1PASS
	0.03125	net.technearts.ExcelMarshallerTest.testEnumnet.technearts.ExcelMarshallerTest.testEnum	1PASS
	0.03125	net.technearts.ExcelMarshallerTest.testMemberWithSimpleValuenet.technearts.ExcelMarshallerTest.testMemberWithSimpleValue	1PASS
	0.03125	net.technearts.ExcelMarshallerTest.testMemberWithMultiValuenet.technearts.ExcelMarshallerTest.testMemberWithMultiValue	1PASS
	0.03125	net.technearts.ExcelMarshallerTest.testBeanMemberWithoutReferencenet.technearts.ExcelMarshallerTest.testBeanMemberWithoutReference	1PASS

 

Source view

1		package net.technearts;
2
3		import static org.apache.poi.ss.util.CellReference.convertColStringToIndex;
4
5		import java.io.File;
6		import java.io.IOException;
7		import java.util.HashSet;
8		import java.util.Map;
9		import java.util.Set;
10		import java.util.SortedSet;
11		import java.util.function.Predicate;
12
13		import org.apache.poi.ss.usermodel.CellType;
14		import org.apache.poi.ss.usermodel.Row;
15		import org.slf4j.Logger;
16		import org.slf4j.LoggerFactory;
17
18		import com.fasterxml.jackson.core.JsonParseException;
19		import com.fasterxml.jackson.databind.JsonMappingException;
20		import com.fasterxml.jackson.databind.ObjectMapper;
21		import com.fasterxml.jackson.dataformat.yaml.YAMLFactory;
22
23		import net.technearts.ExcelFile.ExcelSheet;
24
		82.8% Uncovered Elements: 11 (64) Complexity: 23 Complexity Density: 0.55
25		public class ExcelMarshaller {
26
27		private static final Logger LOG = LoggerFactory.getLogger("Marshaller");
28
29		private Mappings mappings;
30		private Set<String> sheets;
31		private String separator;
32		private Predicate<Row> rowFilter;
33		private boolean skipTitle;
34
35		private Repository repo;
36
		100% Uncovered Elements: 0 (7) Complexity: 1 Complexity Density: 0.14
37	5	private ExcelMarshaller(File yaml, String separator, Predicate<Row> rowFilter, boolean skipTitle)...
38		throws JsonParseException, JsonMappingException, IOException {
39	5	ObjectMapper mapper = new ObjectMapper(new YAMLFactory());
40	5	this.mappings = mapper.readValue(yaml, Mappings.class);
41	5	this.sheets = new HashSet<>();
42	5	this.separator = separator;
43	5	this.rowFilter = rowFilter;
44	5	this.skipTitle = skipTitle;
45	5	this.repo = new Repository();
46		}
47
		100% Uncovered Elements: 0 (1) Complexity: 1 Complexity Density: 1
48	5	private ExcelMarshaller(File yaml, Predicate<Row> rowFilter, boolean skipTitle)...
49		throws JsonParseException, JsonMappingException, IOException {
50	5	this(yaml, ";", rowFilter, skipTitle);
51		}
52
		100% Uncovered Elements: 0 (1) Complexity: 1 Complexity Density: 1
53	5	public static ExcelMarshaller create(File file)...
54		throws JsonParseException, JsonMappingException, IOException {
55	5	return create(file, any -> true, true);
56		}
57
		100% Uncovered Elements: 0 (4) Complexity: 1 Complexity Density: 0.25
58	5	public static ExcelMarshaller create(File file, Predicate<Row> rowFilter, boolean skipTitle)...
59		throws JsonParseException, JsonMappingException, IOException {
60	5	ExcelMarshaller marshaller = new ExcelMarshaller(file, rowFilter, skipTitle);
61	5	for (Mapping mapping : marshaller.mappings.getMappings()) {
62	25	marshaller.sheets.add(mapping.getSheet());
63		}
64	5	return marshaller;
65		}
66
		85.7% Uncovered Elements: 2 (14) Complexity: 5 Complexity Density: 0.36
67	5	public void read(File xls) {...
68	5	ExcelSheet sheet;
69	5	Class<?> klazz = null;
70	5	try (ExcelFile file = new ExcelFile(xls)) {
71	5	for (Mapping mapping : this.mappings.getMappings()) {
72	25	sheet = file.sheet(mapping.getSheet());
73	25	klazz = Class.forName(mapping.getClassName());
74	25	for (int line : getLines(sheet)) {
75	65	Object entity = klazz.newInstance();
76	65	for (Member member : mapping.getMembers()) {
77	185	setMember(sheet, line, entity, member);
78		}
79	65	repo.put(mapping, line, entity);
80		}
81		}
82		} catch (IOException e) {
83	0	throw new IllegalArgumentException("Arquivo excel não encontrado.", e);
84		} catch (ClassNotFoundException | IllegalAccessException | InstantiationException e) {
85	0	throw new IllegalArgumentException("Erro ao instanciar a classe " + klazz.getName(), e);
86		}
87		}
88
		91.7% Uncovered Elements: 1 (12) Complexity: 5 Complexity Density: 0.62
89	185	private final void setMember(ExcelSheet sheet, int line, Object entity, Member member) {...
90
91	185	try {
92	185	if (member.isMapped()) {
93	175	if (member.isReferenceBased()) {
94	135	sheet.read(line, column(sheet, member), ConverterFactory.converter(member), value -> repo
95		.set(entity, member, value, this.separator, this.mappings.getMappings()));
96		} else {
97	40	repo.set(entity, member, repo.get(member.getConverter(), line), this.separator,
98		this.mappings.getMappings());
99		}
100		} else {
101	10	sheet.read(line, column(sheet, member), value -> value,
102		value -> repo.set(member, line, value));
103		}
104		} catch (IllegalArgumentException e) {
105	20	LOG.debug("A coluna referente à " + member.getProperty() + " não foi encontrada.");
106		} catch (NullPointerException e) {
107	0	LOG.debug("### A coluna referente à " + member.getProperty() + " não foi encontrada. ###");
108		}
109		}
110
		42.9% Uncovered Elements: 4 (7) Complexity: 4 Complexity Density: 1.33
111	145	private final int column(ExcelSheet sheet, Member member) {...
112	145	try {
113	145	return member.isTitleBased()
114		? sheet.getColumn(cell -> CellType.STRING.equals(cell.getCellTypeEnum())
115		&& cell.getStringCellValue().equalsIgnoreCase(member.getTitle()))
116		: convertColStringToIndex(member.getColumn());
117		} catch (Exception e) {
118	0	throw new IllegalArgumentException("Coluna "
119	0	+ (member.isTitleBased() ? member.getTitle() : member.getColumn()) + " não encontrada.",
120		e);
121		}
122		}
123
		66.7% Uncovered Elements: 2 (6) Complexity: 3 Complexity Density: 1.5
124	25	private final SortedSet<Integer> getLines(ExcelSheet sheet) {...
125	25	SortedSet<Integer> rows =
126		sheet.getRows(row -> row.getFirstCellNum() >= 0 && rowFilter.test(row));
127	25	return rows.isEmpty() ? rows : skipTitle ? rows.tailSet(rows.first() + 1) : rows;
128		}
129
		100% Uncovered Elements: 0 (1) Complexity: 1 Complexity Density: 1
130	5	@SuppressWarnings("unchecked")...
131		public final <T> Map<Integer, T> get(Class<T> klazz) {
132	5	return (Map<Integer, T>) repo.get(klazz);
133		}
134
		0% Uncovered Elements: 1 (1) Complexity: 1 Complexity Density: 1
135	0	public void addBeanFilter(Predicate<Object> predicate) {...
136	0	repo.addFilter(predicate);
137		}
138
139		}