View Javadoc
1   package net.sumaris.core.util;
2   
3   /*-
4    * #%L
5    * SUMARiS:: Core
6    * %%
7    * Copyright (C) 2018 - 2019 SUMARiS Consortium
8    * %%
9    * This program is free software: you can redistribute it and/or modify
10   * it under the terms of the GNU General Public License as
11   * published by the Free Software Foundation, either version 3 of the
12   * License, or (at your option) any later version.
13   * 
14   * This program is distributed in the hope that it will be useful,
15   * but WITHOUT ANY WARRANTY; without even the implied warranty of
16   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17   * GNU General Public License for more details.
18   * 
19   * You should have received a copy of the GNU General Public
20   * License along with this program.  If not, see
21   * <http://www.gnu.org/licenses/gpl-3.0.html>.
22   * #L%
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   * Helper class
32   * @author Benoit Lavenier <benoit.lavenier@e-is.pro>*
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  }