public BasicTypeDefine reconvert()

in seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/snowflake/SnowflakeTypeConverter.java [188:343]
156 lines of code
23 McCabe index (conditional complexity)

    public BasicTypeDefine reconvert(Column column) {
        BasicTypeDefine.BasicTypeDefineBuilder builder =
                BasicTypeDefine.builder()
                        .name(column.getName())
                        .nullable(column.isNullable())
                        .comment(column.getComment())
                        .defaultValue(column.getDefaultValue());
        switch (column.getDataType().getSqlType()) {
            case TINYINT:
            case SMALLINT:
                builder.columnType(SNOWFLAKE_SMALLINT);
                builder.dataType(SNOWFLAKE_SMALLINT);
                break;
            case INT:
                builder.columnType(SNOWFLAKE_INTEGER);
                builder.dataType(SNOWFLAKE_INTEGER);
                break;
            case BIGINT:
                builder.columnType(SNOWFLAKE_BIGINT);
                builder.dataType(SNOWFLAKE_BIGINT);
                break;
            case DECIMAL:
                DecimalType decimalType = (DecimalType) column.getDataType();
                long precision = decimalType.getPrecision();
                int scale = decimalType.getScale();
                if (precision <= 0) {
                    precision = DEFAULT_PRECISION;
                    scale = DEFAULT_SCALE;
                    log.warn(
                            "The decimal column {} type decimal({},{}) is out of range, "
                                    + "which is precision less than 0, "
                                    + "it will be converted to decimal({},{})",
                            column.getName(),
                            decimalType.getPrecision(),
                            decimalType.getScale(),
                            precision,
                            scale);
                } else if (precision > MAX_PRECISION) {
                    scale = (int) Math.max(0, scale - (precision - MAX_PRECISION));
                    precision = MAX_PRECISION;
                    log.warn(
                            "The decimal column {} type decimal({},{}) is out of range, "
                                    + "which exceeds the maximum precision of {}, "
                                    + "it will be converted to decimal({},{})",
                            column.getName(),
                            decimalType.getPrecision(),
                            decimalType.getScale(),
                            MAX_PRECISION,
                            precision,
                            scale);
                }
                if (scale < 0) {
                    scale = 0;
                    log.warn(
                            "The decimal column {} type decimal({},{}) is out of range, "
                                    + "which is scale less than 0, "
                                    + "it will be converted to decimal({},{})",
                            column.getName(),
                            decimalType.getPrecision(),
                            decimalType.getScale(),
                            precision,
                            scale);
                } else if (scale > MAX_SCALE) {
                    scale = MAX_SCALE;
                    log.warn(
                            "The decimal column {} type decimal({},{}) is out of range, "
                                    + "which exceeds the maximum scale of {}, "
                                    + "it will be converted to decimal({},{})",
                            column.getName(),
                            decimalType.getPrecision(),
                            decimalType.getScale(),
                            MAX_SCALE,
                            precision,
                            scale);
                }
                builder.columnType(String.format("%s(%s,%s)", SNOWFLAKE_DECIMAL, precision, scale));
                builder.dataType(SNOWFLAKE_DECIMAL);
                builder.precision(precision);
                builder.scale(scale);
                break;
            case FLOAT:
                builder.columnType(SNOWFLAKE_FLOAT4);
                builder.dataType(SNOWFLAKE_FLOAT4);
                break;
            case DOUBLE:
                builder.columnType(SNOWFLAKE_DOUBLE_PRECISION);
                builder.dataType(SNOWFLAKE_DOUBLE_PRECISION);
                break;
            case BOOLEAN:
                builder.columnType(SNOWFLAKE_BOOLEAN);
                builder.dataType(SNOWFLAKE_BOOLEAN);
                break;
            case STRING:
                if (column.getColumnLength() != null) {
                    if (column.getColumnLength() > 16777216) {
                        builder.columnType(SNOWFLAKE_BINARY);
                        builder.dataType(SNOWFLAKE_BINARY);
                    } else if (column.getColumnLength() > 0) {
                        builder.columnType(
                                String.format(
                                        "%s(%s)", SNOWFLAKE_VARCHAR, column.getColumnLength()));
                        builder.dataType(SNOWFLAKE_VARCHAR);
                    } else {
                        builder.columnType(SNOWFLAKE_STRING);
                        builder.dataType(SNOWFLAKE_STRING);
                    }
                } else {
                    builder.columnType(SNOWFLAKE_STRING);
                    builder.dataType(SNOWFLAKE_STRING);
                }
                builder.length(column.getColumnLength());
                break;
            case DATE:
                builder.columnType(SNOWFLAKE_DATE);
                builder.dataType(SNOWFLAKE_DATE);
                break;
            case BYTES:
                builder.columnType(SNOWFLAKE_GEOMETRY);
                builder.dataType(SNOWFLAKE_GEOMETRY);
                break;
            case TIME:
                if (column.getScale() > 9) {
                    log.warn(
                            "The timestamp column {} type time({}) is out of range, "
                                    + "which exceeds the maximum scale of {}, "
                                    + "it will be converted to time({})",
                            column.getName(),
                            column.getScale(),
                            9,
                            9);
                }
                builder.columnType(SNOWFLAKE_TIME);
                builder.dataType(SNOWFLAKE_TIME);
                break;
            case TIMESTAMP:
                if (column.getScale() > 9) {
                    log.warn(
                            "The timestamp column {} type timestamp({}) is out of range, "
                                    + "which exceeds the maximum scale of {}, "
                                    + "it will be converted to timestamp({})",
                            column.getName(),
                            column.getScale(),
                            9,
                            9);
                }
                builder.columnType(SNOWFLAKE_TIMESTAMP);
                builder.dataType(SNOWFLAKE_TIMESTAMP);
                break;
            default:
                throw CommonError.convertToSeaTunnelTypeError(
                        DatabaseIdentifier.SNOWFLAKE,
                        column.getDataType().getSqlType().toString(),
                        column.getName());
        }
        return builder.build();
    }