sqlValues: sqlValues

In petermeissner/dbtools: Tooling Around Database Querying

Description

A function to generate SQL value lists, to be used with sql values keyword: "VALUES (1,2), (1,3), (2,7)".

Usage

sqlValues(x, ..., val_sep = "\n", conn = NULL)

Arguments

x	a vector or data.frame like
...	additional parameters passed through to methods (currently not used by standard methods)
val_sep	a string to be put between SQL values in addition to ","
conn	A database connection.

Value

an object of type SQL

Examples

#' # SQL VALUES list from vector
sqlValues(ANSI(), letters)
sqlValues(ANSI(), 4L:7L)
sqlValues(ANSI(), 1.3:7.1)
sqlValues(ANSI(), rep(Sys.time(), 10))

# SQL VALUES list from data.frame like
sqlValues(ANSI(), data.frame(letters, seq_along(letters), Sys.time()))

petermeissner/dbtools documentation built on May 21, 2019, 2:07 p.m.