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);
    }
}