/** * <p>Constructor which initializes with the connection object on which metadata * is sought * @param driver's connection object. * @throws SQLException if the connection is already closed. */ DatabaseMetaDataImpl(ConnectionImpl connection) { this.driverConnection = connection; if (PropertiesUtils.getBooleanProperty(connection.getConnectionProps(), REPORT_AS_VIEWS, true)) { TABLE_TYPE = "CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' WHEN IsPhysical <> 'true' AND UCASE(Type) = 'TABLE' THEN 'VIEW' ELSE UCASE(Type) END"; //$NON-NLS-1$ } else { TABLE_TYPE = "CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END"; //$NON-NLS-1$ } String nullSortProp = connection.getConnectionProps().getProperty(NULL_SORT); if (nullSortProp != null) { nullSort = StringUtil.caseInsensitiveValueOf(NullSort.class, nullSortProp); } QUERY_TABLES = new StringBuffer("SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME") //$NON-NLS-1$ .append(", ").append(TABLE_TYPE).append(" AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM") //$NON-NLS-1$ //$NON-NLS-2$ .append(", NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL") //$NON-NLS-1$ .append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".Tables g ") //$NON-NLS-1$ //$NON-NLS-2$ .append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$ .append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$ .append(" AND UCASE(Name)") .append(LIKE_ESCAPE).toString(); //$NON-NLS-1$ }
/** * <p>Constructor which initializes with the connection object on which metadata * is sought * @param driver's connection object. * @throws SQLException if the connection is already closed. */ DatabaseMetaDataImpl(ConnectionImpl connection) { this.driverConnection = connection; if (PropertiesUtils.getBooleanProperty(connection.getConnectionProps(), REPORT_AS_VIEWS, true)) { TABLE_TYPE = "CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' WHEN IsPhysical <> 'true' AND UCASE(Type) = 'TABLE' THEN 'VIEW' ELSE UCASE(Type) END"; //$NON-NLS-1$ } else { TABLE_TYPE = "CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END"; //$NON-NLS-1$ } String nullSortProp = connection.getConnectionProps().getProperty(NULL_SORT); if (nullSortProp != null) { nullSort = StringUtil.caseInsensitiveValueOf(NullSort.class, nullSortProp); } QUERY_TABLES = new StringBuffer("SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME") //$NON-NLS-1$ .append(", ").append(TABLE_TYPE).append(" AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM") //$NON-NLS-1$ //$NON-NLS-2$ .append(", NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL") //$NON-NLS-1$ .append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".Tables g ") //$NON-NLS-1$ //$NON-NLS-2$ .append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$ .append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$ .append(" AND UCASE(Name)") .append(LIKE_ESCAPE).toString(); //$NON-NLS-1$ }
c.setSearchType(StringUtil.caseInsensitiveValueOf(SearchType.class, v));
c.setSearchType(StringUtil.caseInsensitiveValueOf(SearchType.class, v));
c.setSearchType(StringUtil.caseInsensitiveValueOf(SearchType.class, v));
public static EdmPrimitiveTypeKind odataType(BaseColumn c) { String runtimeType = c.getRuntimeType(); //try to map to the specific type if (c.getDatatype() != null && (c.getDatatype().getName().equalsIgnoreCase(DataTypeManager.DefaultDataTypes.GEOMETRY) || c.getDatatype().getName().equalsIgnoreCase(DataTypeManager.DefaultDataTypes.GEOGRAPHY))) { boolean geometry = c.getDatatype().getName().equalsIgnoreCase(DataTypeManager.DefaultDataTypes.GEOMETRY); String type = c.getProperty(BaseColumn.SPATIAL_TYPE, false); if (type != null) { try { return StringUtil.caseInsensitiveValueOf(EdmPrimitiveTypeKind.class, (geometry?"Geometry":"Geography")+type); //$NON-NLS-1$ //$NON-NLS-2$ } catch (IllegalArgumentException e) { } } //unknown or null case if (geometry) { return EdmPrimitiveTypeKind.Geometry; } return EdmPrimitiveTypeKind.Geography; } return odataType(runtimeType); }
public static EdmPrimitiveTypeKind odataType(BaseColumn c) { String runtimeType = c.getRuntimeType(); //try to map to the specific type if (c.getDatatype() != null && (c.getDatatype().getName().equalsIgnoreCase(DataTypeManager.DefaultDataTypes.GEOMETRY) || c.getDatatype().getName().equalsIgnoreCase(DataTypeManager.DefaultDataTypes.GEOGRAPHY))) { boolean geometry = c.getDatatype().getName().equalsIgnoreCase(DataTypeManager.DefaultDataTypes.GEOMETRY); String type = c.getProperty(BaseColumn.SPATIAL_TYPE, false); if (type != null) { try { return StringUtil.caseInsensitiveValueOf(EdmPrimitiveTypeKind.class, (geometry?"Geometry":"Geography")+type); //$NON-NLS-1$ //$NON-NLS-2$ } catch (IllegalArgumentException e) { } } //unknown or null case if (geometry) { return EdmPrimitiveTypeKind.Geometry; } return EdmPrimitiveTypeKind.Geography; } return odataType(runtimeType); }