View Javadoc
1   package net.sumaris.core.extraction.dao.technical.table;
2   
3   /*-
4    * #%L
5    * SUMARiS:: Core Extraction
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.SortDirection;
26  import net.sumaris.core.extraction.vo.ExtractionFilterVO;
27  import net.sumaris.core.extraction.vo.ExtractionResultVO;
28  import net.sumaris.core.vo.technical.extraction.ExtractionProductColumnVO;
29  
30  import java.util.List;
31  import java.util.Map;
32  import java.util.Set;
33  
34  /**
35   * @author Benoit Lavenier <benoit.lavenier@e-is.pro>
36   */
37  public interface ExtractionTableDao {
38  
39      enum SQLAggregatedFunction {
40          SUM,
41          AVG,
42          COUNT,
43          COUNT_DISTINCT
44      }
45  
46      List<String> getAllTableNames();
47  
48      ExtractionResultVO getTable(String tableName);
49  
50      long getRowCount(String tableName);
51  
52      List<ExtractionProductColumnVO> getColumns(String tableName);
53  
54      ExtractionResultVO getTableRows(String tableName, ExtractionFilterVO filter, int offset, int size, String sort, SortDirection direction);
55  
56      ExtractionResultVO getTableGroupByRows(String tableName,
57                                             ExtractionFilterVO filter,
58                                             Set<String> groupByColumnNames,
59                                             Map<String, SQLAggregatedFunction> otherColumnNames,
60                                             int offset, int size, String sort, SortDirection direction);
61  
62      void dropTable(String tableName);
63  
64  }