private String generateQuery()

in services/library/src/main/java/com/google/cloud/pso/bq_pii_classifier/services/findings/FindingsReaderStandardDlp.java [43:65]

• 13 lines of code
• 1 McCabe index (conditional complexity)

    private String generateQuery(String dlpJobName) throws IOException {

        final URL url = Resources.getResource(sqlTemplatePath);

        String queryTemplate = Resources.toString(url, StandardCharsets.UTF_8);

        /*
        Since we have N taxonomies in N regions we need the table location in order to look up the correct set of
        policy tags.
        To avoid an API call to fetch the table location we extract the location info from the DLP job id given that
        we run the dlp job in the same region as the table
         */
        String region = Utils.extractDLPRegionFromJobNameToBQRegion(dlpJobName);

        return queryTemplate.replace("${project}", dlpProject)
                .replace("${dataset}", dlpDataset)
                .replace("${config_view_infotypes_policytags_map}", infoTypesPolicyTagsMapView)
                .replace("${config_view_dataset_domain_map}", datasetDomainMapView)
                .replace("${config_view_project_domain_map}", projectDomainMapView)
                .replace("${results_table}", dlpTable)
                .replace("${param_lookup_key}", dlpJobName)
                .replace("${param_region}", region);
    }