add fdx-commons and fdx-consultation

Kenmegne

7 days ago 23a46b4be35277e06ec89f48730eeb694e686be8

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
package com.megatim.fdxcommons.tools.utils;
 
import java.util.HashSet;
import java.util.Set;
 
/**
 *
 * @author ASUS
 */
public class CustomColumns {
 
    public static final Set<String> columnsSet = new HashSet<>();
    public static final Set<String> pkAutoIncrementColumnsQuerySet = new HashSet<>();
    public static final Set<String> pkNotAutoIncrementColumnsQuerySet = new HashSet<>();
 
    public static final String IS_DELETED_COLUMN = "fdx_is_deleted";
 
    public static final int IS_DELETED_COLUMN_DEFAULT_VALUE = 0;
    public static final int IS_DELETED_COLUMN_DELETED_VALUE = 1;
    public static final String IS_DELETED_COLUMN_QUERY = IS_DELETED_COLUMN + " SMALLINT NOT NULL DEFAULT " + IS_DELETED_COLUMN_DEFAULT_VALUE + ", ";
 
    public static final String INDEX_COLUMN = "fdx_index";
    public static final String API_INDEX_COLUMN_QUERY = INDEX_COLUMN + " BIGSERIAL PRIMARY KEY, ";
    public static final String FDXCONSULTATION_INDEX_COLUMN_QUERY = INDEX_COLUMN + " BIGINT PRIMARY KEY, ";
 
    public static final String DATE_ACTION_COLUMN = "fdx_date_action";
    public static final String DATE_ACTION_QUERY = DATE_ACTION_COLUMN + " TIMESTAMP NULL, ";
 
    public static final String DATA_PRODUCTION_ID_COLUMN = "fdx_data_production_id";
    public static final String DATA_PRODUCTION_ID_COLUMN_QUERY = DATA_PRODUCTION_ID_COLUMN + " BIGINT NOT NULL, ";
 
    static {
        columnsSet.add(IS_DELETED_COLUMN);
        columnsSet.add(INDEX_COLUMN);
        columnsSet.add(DATE_ACTION_COLUMN);
        columnsSet.add(DATA_PRODUCTION_ID_COLUMN);
 
        pkAutoIncrementColumnsQuerySet.add(IS_DELETED_COLUMN_QUERY);
        pkAutoIncrementColumnsQuerySet.add(DATE_ACTION_QUERY);
        pkAutoIncrementColumnsQuerySet.add(DATA_PRODUCTION_ID_COLUMN_QUERY);
        
        pkNotAutoIncrementColumnsQuerySet.addAll(pkAutoIncrementColumnsQuerySet);
        
        pkAutoIncrementColumnsQuerySet.add(API_INDEX_COLUMN_QUERY);
        pkNotAutoIncrementColumnsQuerySet.add(FDXCONSULTATION_INDEX_COLUMN_QUERY);
    }
}