R/Call_Cohortlist.R

In OHDSI/Aegis: AEGIS: An open source spatial analysis tool based on CDM

Call.Cohortlist<-function(WebapiDBserver,WebapiDBschema,Resultschema, targettab="cohort", cdmVersion="5"){

  Sys.setlocale(category="LC_CTYPE", locale="C")
  ## Check if a cohort exists
  sql <- "SELECT distinct cohort_definition_id FROM @resultDatabaseSchema.@targettab order by cohort_definition_id"

  sql <- SqlRender::renderSql(sql,
                              resultDatabaseSchema=Resultschema,
                              targettab=targettab)$sql
  sql <- SqlRender::translateSql(sql,
                                 targetDialect=connectionDetails$dbms)$sql
  cohort<-DatabaseConnector::querySql(connection, sql)

  ##Check Cohort Definition
  sql <- 'SELECT name,id FROM @WebapiDBserver@WebapiDBschema.cohort_definition'
  sql <- SqlRender::renderSql(sql,
                              WebapiDBserver=if(WebapiDBserver==''){WebapiDBserver=''}else(WebapiDBserver= paste0('[',WebapiDBserver,']','.')),
                              WebapiDBschema=WebapiDBschema)$sql
  sql <- SqlRender::translateSql(sql,
                                 targetDialect=connectionDetails$dbms)$sql
  cohortName<-DatabaseConnector::querySql(connection, sql)

  ## Print List
  cohortList <- cbind(cohortName,'exists' = rep('Cohort does not exist',nrow(cohortName)))
  cohortList$exists <- as.character(cohortList$exists)
  for(i in cohort$COHORT_DEFINITION_ID){
    cohortList$exists[cohortList$ID == i] <- 'Cohort exists'
  }

  cohortList <- paste(cohortList$ID,cohortList$NAME,'(',cohortList$exists,')')

  return(cohortList)
}