edbDelete: Delete all or some rows in a table in a database (referenced...

In easydb: Generic S3 Classes for Simple Database Interfaces

Description

Delete all or some rows in a table in a database (referenced by 'edb').

Generic function that call class-specific method corresponding

to the class of the edb object provided.

Usage

edbDelete(edb, tableName, sRow = NULL, sRowOp = c("AND", 


    "OR")[1], logOp = FALSE, logRandId = rnorm(1), 


    logMsg = as.character(NA), logTableName = "edbLog", 


    logCreateTableIfNotExist = TRUE, ...)

Arguments

edb	An object of class 'edb', such as returned by edb.
tableName	Single character string. Name of the table to read in 'edb'.
sRow	A list of named items. List of contrains/criterion to be applied on tableName to retrieve a subset of rows. Each item in sRow must be named after the columns on which the constrain apply. The (vector of) value(s) of each items are the possible values that can be retrieved. Values can be character or numeric. If NULL (the default), all values are returned.
sRowOp	A single character string. Operator to be used to combine multiple constrains in sRow. Possible values are "OR" or "AND". Default value is "AND".
logOp	Single logical. If TRUE, then a log of the operation is written into the database, using the function edbLog. See the arguments below and edbLog for more details.
logRandId	Single numerical. See edbLog.
logMsg	Single character string. See edbLog.
logTableName	Single character string. See edbLog.
logCreateTableIfNotExist	Single logical. See edbLog.
...	Additional parameters to be passed to class-specific method. See methods("edbDelete")

Author(s)

Julien MOEYS <[e-mail]>

See Also

edb, edbWrite,

edbNames, edbColnames,

edbRead.

Examples

# See related methods for detailed examples:


# (for example ?edbDelete.RSQLite_SQLite) 


require( "easydb" ) 


methods( "edbDelete" )

easydb documentation built on May 2, 2019, 4:47 p.m.