1 package net.sumaris.core.extraction.dao.technical.table;
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.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
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 }