in seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/sqlite/SqliteTypeMapper.java [97:172]
public SeaTunnelDataType<?> mapping(ResultSetMetaData metadata, int colIndex)
throws SQLException {
String columnTypeName = metadata.getColumnTypeName(colIndex).toUpperCase().trim();
switch (columnTypeName) {
case SQLITE_BIT:
case SQLITE_BOOLEAN:
return BasicType.BOOLEAN_TYPE;
case SQLITE_TINYINT:
case SQLITE_TINYINT_UNSIGNED:
case SQLITE_SMALLINT:
case SQLITE_SMALLINT_UNSIGNED:
return BasicType.SHORT_TYPE;
case SQLITE_MEDIUMINT:
case SQLITE_MEDIUMINT_UNSIGNED:
case SQLITE_INT:
case SQLITE_INTEGER:
return BasicType.INT_TYPE;
case SQLITE_INT_UNSIGNED:
case SQLITE_INTEGER_UNSIGNED:
case SQLITE_BIGINT:
case SQLITE_BIGINT_UNSIGNED:
case SQLITE_NUMERIC:
return BasicType.LONG_TYPE;
case SQLITE_DECIMAL:
case SQLITE_DECIMAL_UNSIGNED:
case SQLITE_DOUBLE:
case SQLITE_DOUBLE_PRECISION:
case SQLITE_REAL:
return BasicType.DOUBLE_TYPE;
case SQLITE_FLOAT:
return BasicType.FLOAT_TYPE;
case SQLITE_FLOAT_UNSIGNED:
log.warn("{} will probably cause value overflow.", SQLITE_FLOAT_UNSIGNED);
return BasicType.FLOAT_TYPE;
case SQLITE_DOUBLE_UNSIGNED:
log.warn("{} will probably cause value overflow.", SQLITE_DOUBLE_UNSIGNED);
return BasicType.DOUBLE_TYPE;
case SQLITE_CHARACTER:
case SQLITE_VARYING_CHARACTER:
case SQLITE_NATIVE_CHARACTER:
case SQLITE_NVARCHAR:
case SQLITE_NCHAR:
case SQLITE_LONGNVARCHAR:
case SQLITE_LONGVARCHAR:
case SQLITE_CLOB:
case SQLITE_CHAR:
case SQLITE_TINYTEXT:
case SQLITE_MEDIUMTEXT:
case SQLITE_TEXT:
case SQLITE_VARCHAR:
case SQLITE_JSON:
case SQLITE_LONGTEXT:
case SQLITE_DATE:
case SQLITE_TIME:
case SQLITE_DATETIME:
case SQLITE_TIMESTAMP:
return BasicType.STRING_TYPE;
case SQLITE_TINYBLOB:
case SQLITE_MEDIUMBLOB:
case SQLITE_BLOB:
case SQLITE_LONGBLOB:
case SQLITE_VARBINARY:
case SQLITE_BINARY:
case SQLITE_LONGVARBINARY:
return PrimitiveByteArrayType.INSTANCE;
// Doesn't support yet
case SQLITE_UNKNOWN:
default:
final String jdbcColumnName = metadata.getColumnName(colIndex);
throw CommonError.convertToSeaTunnelTypeError(
DatabaseIdentifier.SQLITE, columnTypeName, jdbcColumnName);
}
}