dbSendUpdate: Send a data-altering SQL statement to the database.

Description

dbSendUpdate is used to send a data-altering statement to a MonetDB database, e.g. CREATE TABLE or INSERT. As a convenience feature, a placeholder (? character) can be used in the SQL statement, and bound to parameters given in the varargs group before execution. This is especially useful when scripting database updates, since the parameters will be automatically quoted. The dbSendUpdateAsync function is used when the database update is called from finalizers, to avoid very esoteric concurrency problems. Here, the update is not guaranteed to be immediately run. Also, the method returns immediately.

Usage

dbSendUpdate( conn, statement, ..., async=FALSE )

Arguments

conn

A MonetDB.R database connection. Created using dbConnect with the MonetDB.R database driver.

statement

A SQL statement to be sent to the database, e.g. 'UPDATE' or 'INSERT'.

...

Parameters to be bound to '?' characters in the query, similar to JDBC.

async

Behave like dbSendUpdateAsync? Defaults to FALSE.

Value

Returns TRUE if the update was successful.

Examples

Run this code

# connect to MonetDB
conn <- dbConnect(MonetDB.R(), "monetdb://localhost/acs")
# create table
dbSendUpdate(conn, "CREATE TABLE foo(a INT,b VARCHAR(100))")
# insert value, bind parameters to placeholders in statement
dbSendUpdate(conn, "INSERT INTO foo VALUES(?,?)", 42, "bar")

Run the code above in your browser using DataLab