R-code for Functions to Access Database Tables

Source: R/to_R_interface.R

R-code for Functions to Access Database Tables

rcode_DatabaseInterface(
  db = NULL,
  dbSchema = NULL,
  tableNamePattern = "",
  functionPrefix = "db_",
  pattern = "^",
  dbg = TRUE,
  sql.dbg = TRUE,
  create.create.functions = FALSE
)

Arguments

db

database name or file
dbSchema

database schema as returned by getDatabaseSchema
tableNamePattern

pattern matching the names of tables/views for which an accessor function is to be generated
functionPrefix

prefix to be given to each generated function. Default: "db_"
pattern

pattern matching the part of the table name that will be replaced with functionPrefix. Default: "^", i.e. the prefix will be appended to the start of the table name
dbg

if TRUE, progress messages are shown during the creation of the interface functions
sql.dbg

if TRUE, SQL strings used to access the database are shown when calling the interface functions
create.create.functions

if TRUE, functions for creating new records in the database tables are created