R/query_raw_github.R

Defines functions query_raw_github

Documented in query_raw_github

#' Query raw github sql
#' @importFrom DatabaseConnector dbGetQuery
#' @importFrom readr read_file
#' @export

query_raw_github <- 
    function(conn,
             raw_github_link) {
        
                tmp_sql <- tempfile(fileext = ".txt")
                
                download.file(raw_github_link,
                              destfile = tmp_sql)
                
                
                DatabaseConnector::dbGetQuery(conn = conn,
                                              statement = readr::read_file(tmp_sql))
                
                
                unlink(tmp_sql)
        
    }
patelm9/seagull documentation built on July 19, 2020, 5:52 a.m.