Examples with DB_SCHEMA_COLUMN_NAME_RESOURCE_NAME org.wso2.carbon.identity.configuration.mgt.core.constant.ConfigurationConstants.DB_SCHEMA_COLUMN_NAME_RESOURCE_NAME used on opensource projects

Example 1 with DB_SCHEMA_COLUMN_NAME_RESOURCE_NAME

use of org.wso2.carbon.identity.configuration.mgt.core.constant.ConfigurationConstants.DB_SCHEMA_COLUMN_NAME_RESOURCE_NAME in project carbon-identity-framework by wso2.

the class ConfigurationDAOImpl method getFilesByResourceType.

@Override
public List<ResourceFile> getFilesByResourceType(String resourceTypeId, int tenantId) throws ConfigurationManagementServerException {
    JdbcTemplate jdbcTemplate = JdbcUtils.getNewTemplate();
    try {
        return jdbcTemplate.executeQuery(GET_FILES_BY_RESOURCE_TYPE_ID_SQL, ((resultSet, rowNumber) -> {
            String resourceFileId = resultSet.getString(DB_SCHEMA_COLUMN_NAME_ID);
            String resourceFileName = resultSet.getString(DB_SCHEMA_COLUMN_NAME_FILE_NAME);
            String resourceName = resultSet.getString(DB_SCHEMA_COLUMN_NAME_RESOURCE_NAME);
            String resourceTypeName = resultSet.getString(DB_SCHEMA_COLUMN_NAME_RESOURCE_TYPE_NAME);
            return new ResourceFile(resourceFileId, getFilePath(resourceFileId, resourceTypeName, resourceName), resourceFileName);
        }), preparedStatement -> {
            preparedStatement.setString(1, resourceTypeId);
            preparedStatement.setInt(2, tenantId);
        });
    } catch (DataAccessException e) {
        throw handleServerException(ERROR_CODE_GET_FILES_BY_TYPE, resourceTypeId, e);
    }
}