sqlValues: sqlValues

In petermeissner/wikipediadumbs: Handling Wikipedia Page View Dumps

Description

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

Usage

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

Arguments

conn	A database connection.
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 ","

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/wikipediadumbs documentation built on Nov. 5, 2019, 12:19 a.m.