public String evalFieldType(MappingField mf) {
if (mf.getCustomDbType() != null) return mf.getCustomDbType();
switch (mf.getColumnType()) {
case INT:
// 用户自定义了宽度
if (mf.getWidth() > 0) return "NUMERIC(" + mf.getWidth() + ")";
// 用数据库的默认宽度
return "INT";
case FLOAT:
// 用户自定义了精度
if (mf.getWidth() > 0 && mf.getPrecision() > 0) {
return "NUMERIC(" + mf.getWidth() + "," + mf.getPrecision() + ")";
}
// 用默认精度
if (mf.getTypeMirror().isDouble()) return "NUMERIC(15,10)";
return "NUMERIC";
case BINARY:
return "BYTEA";
case DATETIME:
return "TIMESTAMP";
default:
break;
}
return super.evalFieldType(mf);
}
@Override
protected String evalFieldType(MappingField mf) {
if (mf.getCustomDbType() != null) return mf.getCustomDbType();
switch (mf.getColumnType()) {
case BOOLEAN:
return "SMALLINT";
case INT:
// 用户自定义了宽度
// if (mf.getWidth() > 0)
// return "decimal(" + mf.getWidth() + ")";
// 用数据库的默认宽度
return "INTEGER";
case FLOAT:
// 用户自定义了精度
if (mf.getWidth() > 0 && mf.getPrecision() > 0) {
return "decimal(" + mf.getWidth() + "," + mf.getPrecision() + ")";
}
// 用默认精度
if (mf.getTypeMirror().isDouble()) return "decimal(15,10)";
return "FLOAT";
default:
break;
}
return super.evalFieldType(mf);
}
public String evalFieldType(MappingField mf) {
if (mf.getCustomDbType() != null) return mf.getCustomDbType();
switch (mf.getColumnType()) {
case CHAR:
return "CHAR(" + mf.getWidth() + ")";
case BOOLEAN:
return "BOOLEAN";
case VARCHAR:
return "VARCHAR(" + mf.getWidth() + ")";
case TEXT:
return "TEXT";
case BINARY:
return "BLOB";
case TIMESTAMP:
return "TIMESTAMP";
case DATETIME:
return "DATETIME";
case DATE:
return "DATE";
case TIME:
return "TIME";
case INT:
// 用户自定义了宽度
if (mf.getWidth() > 0) return "INT(" + mf.getWidth() + ")";
// 用数据库的默认宽度
return "INT";
case FLOAT:
// 用户自定义了精度
if (mf.getWidth() > 0 && mf.getPrecision() > 0) {
return "NUMERIC(" + mf.getWidth() + "," + mf.getPrecision() + ")";
}
// 用默认精度
if (mf.getTypeMirror().isDouble()) return "NUMERIC(15,10)";
return "FLOAT";
case PSQL_ARRAY:
return "ARRAY";
case PSQL_JSON:
case MYSQL_JSON:
return "JSON";
// TODO 这里不用加 default 么
}
throw Lang.makeThrow(
"Unsupport colType '%s' of field '%s' in '%s' ",
mf.getColumnType(), mf.getName(), mf.getEntity().getType().getName());
}
