RSQL: rsql
In rOpenStats/rsql: Database Agnostic Package to Generate and Process 'SQL' Queries in R
RSQL R Documentation
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 <abaranek@dc.uba.ar>, Leonardo Javier Belen <leobelen@gmail.com>
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
rOpenStats/rsql documentation built on Aug. 22, 2023, 2:16 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| RSQL | R Documentation |
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 <abaranek@dc.uba.ar>, Leonardo Javier Belen <leobelen@gmail.com> 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
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.