R/ConceptPrevalenceCountsForConceptIds.R

Defines functions getConceptPrevalenceCountsForConceptIds

#' @export
getConceptPrevalenceCountsForConceptIds <- function(dataSource = .GlobalEnv,
                                                    conceptIdsList) {
  
  sql <- "select *
          from concept_prevalence.cp_master
          where concept_id in (@concept_list);"
  if (length(conceptIdsList) > 0) {
    data <-
      renderTranslateQuerySql(
        connection = dataSource$connection,
        concept_list = conceptIdsList,
        sql = sql, 
        snakeCaseToCamelCase = TRUE
      ) %>%  
      dplyr::arrange(1)
    return(data) 
  } else {
    return(dplyr::tibble())
  }
}
gowthamrao/ConceptSetDiagnosticsOld documentation built on March 1, 2021, 12:03 a.m.