package com.walker.jdbc.generator.db;

import com.walker.jdbc.generator.util.StringUtils;

import java.util.Map;

/**
 * 数据库列定义。
 * @author 时克英
 * @date 2022-08-16
 */
public class Column {
    private String name;
    private String type;
    private String not_null;
    private Integer length;
    private Integer digits;
    private String comment;

    public Column(Map columnMap)
    {
        this.name = StringUtils.safeToString(columnMap.get("COLUMN_NAME"));
        this.type = getType(StringUtils.safeToString(columnMap.get("TYPE_NAME")), StringUtils.intValue(columnMap.get("COLUMN_SIZE")), StringUtils.intValue(columnMap.get("DECIMAL_DIGITS")));
        this.length = Integer.valueOf(StringUtils.intValue(columnMap.get("COLUMN_SIZE")));
        String isNullable = StringUtils.safeToString(columnMap.get("IS_NULLABLE"));
        this.comment = StringUtils.safeToString(columnMap.get("REMARKS"));
        this.digits = Integer.valueOf(StringUtils.intValue(columnMap.get("DECIMAL_DIGITS")));
        if (isNullable.equals("NO"))
            this.not_null = "true";
        else
            this.not_null = "";
    }

    public Integer getLength()
    {
        return this.length;
    }

    public String getName() {
        return this.name;
    }

    public String getNot_null() {
        return this.not_null;
    }

    public String getType() {
        return this.type;
    }

    private String getType(String type_name, int column_size, int decimal_digits) {
        if (type_name.contains("CHAR"))
            return "string";
        if (("NUMBER".equals(type_name)) || ("DECIMAL".equals(type_name))) {
            if (decimal_digits == 0) {
                if (column_size <= 8) {
                    return "int";
                }
                return "long";
            }

            if (column_size < 14) {
                return "double";
            }
            return "big_decimal";
        }

        if (("DATE".equals(type_name)) || ("DATETIME".equals(type_name)) || (type_name.startsWith("TIMESTAMP")))
            return "date";
        if ("INT".equals(type_name))
            return "int";
        if (("Long".equals(type_name)) || ("BIGINT".equals(type_name)))
            return "long";
        if ("FLOAT".equals(type_name))
            return "float";
        if ("SMALLINT".equals(type_name))
            return "int";
        if ("TINYINT".equals(type_name))
            return "byte";
        if ("DOUBLE".equals(type_name))
            return "double";
        if (("CLOB".equals(type_name)) || ("TEXT".equals(type_name)) || ("MEDIUMTEXT".equals(type_name)) || ("LONGTEXT".equals(type_name)))
            return "materialized_clob";
        if (type_name.contains("BLOB")) {
            return "materialized_blob";
        }
        throw new RuntimeException("类型 " + type_name + " 不支持! ");
    }

    public String getComment()
    {
        return this.comment;
    }

    public Integer getDigits() {
        return this.digits;
    }

    public void setDigits(Integer digits) {
        this.digits = digits;
    }
}