RSQL {RSQL}

rsql

Description

A package to work with SQL datasources in a simple manner

Usage

.onLoad(libname, pkgname)

Arguments

libname

Library name

pkgname

Package name

Author(s)

Alejandro Baranek <[e-mail]>, Leonardo Javier Belen <[e-mail]> Executes code while loading the package.

Examples

library(RSQL)
library(RSQLite)
db.name <- getMtcarsdbPath(copy = TRUE)
rsql <- createRSQL(drv = RSQLite::SQLite(), dbname = db.name)
select_sql <- rsql$gen_select(
  select_fields = "*", # c("wt", "qsec"),
  table = "mtcars",
  where_values = data.frame(carb = 8)
)
mtcars.observed <- rsql$execute_select(select_sql)
mtcars.observed