run_sql: Run SQL script from file

In exoulster/dbhelper: DB helper functions

Description

Run SQL script from file

Usage

run_sql(
  conn,
  sql_statement,
  ...,
  start_date = NA,
  end_date = NA,
  by = NA,
  offset = NA,
  verbose = FALSE
)

run_sql_script(
  conn,
  filename,
  ...,
  start_date = NA,
  end_date = NA,
  by = NA,
  offset = NA,
  verbose = FALSE
)

run_sql_script_by(conn, filename, start_date, end_date, by = "month")

Arguments

conn	database connection
sql_statement	sql statement to run. Multiple sql statements should be seperated by semicolon(;)
by	period definition in string
filename	file name with full path

exoulster/dbhelper documentation built on July 13, 2020, 12:03 a.m.