sql_run: utility function to run sql query

In afsc-assessments/afscdata: An R Package for Extraction of AFSC Fishery Data

utility function to run sql query

Description

utility function to run sql query

Usage

sql_run(database, query)

Arguments

database	which database to connect to 'akfin' or 'afsc'
query	the sql query code

Examples

## Not run: 
.d = sql_read("fsh_catch.sql")
.d = sql_filter(sql_precode = "<=", 2011, sql_code = .d, flag = "-- insert year")
.d = sql_filter(x = area, sql_code = .d, flag = "-- insert region")
.d = sql_filter(sql_precode = "IN", x = c("PEL7", "PELS"), 
                   sql_code = .d, flag = "-- insert species")

afsc = DBI::dbConnect(odbc::odbc(), "afsc", UID = "afsc_user", PWD = "afsc_pwd") 
 
sql_run(afsc, query) %>%
         vroom::vroom_write(here::here(year, 'data', 'raw', 'fsh_catch_data.csv'))
DBI::dbDisconnect(afsc)

## End(Not run)

afsc-assessments/afscdata documentation built on Oct. 26, 2024, 2:03 p.m.