1 package net.sumaris.core.util;
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25 import net.sumaris.core.dao.technical.schema.SumarisColumnMetadata;
26 import net.sumaris.core.vo.technical.extraction.ExtractionProductColumnVO;
27
28 import java.sql.Types;
29
30
31
32
33
34 public class ExtractionBeans {
35
36 public static ExtractionProductColumnVO toProductColumnVO(SumarisColumnMetadata columnMetadata) {
37 ExtractionProductColumnVOtionProductColumnVO.html#ExtractionProductColumnVO">ExtractionProductColumnVO column = new ExtractionProductColumnVO();
38
39 column.setLabel(StringUtils.underscoreToChangeCase(columnMetadata.getName()));
40 column.setName(columnMetadata.getName().toLowerCase());
41
42 column.setColumnName(columnMetadata.getName().toLowerCase());
43
44 column.setDescription(columnMetadata.getDescription());
45
46 String type;
47 switch (columnMetadata.getTypeCode()) {
48 case Types.NUMERIC:
49 case Types.INTEGER:
50 case Types.BIGINT:
51 type = "integer";
52 break;
53 case Types.FLOAT:
54 case Types.DOUBLE:
55 type = "double";
56 break;
57 case Types.VARCHAR:
58 case Types.LONGVARCHAR:
59 case Types.NVARCHAR:
60 case Types.CHAR:
61 type = "string";
62 break;
63 default:
64 type = columnMetadata.getTypeName().toLowerCase();
65 }
66 column.setType(type);
67 return column;
68 }
69 }