edbQuery: Read all or part of a table in a database (referenced by...

In easydb: Generic S3 Classes for Simple Database Interfaces

Description

Read all or part of 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

edbQuery(edb, statement, formatCol = NULL, ...)

Arguments

edb	An object of class 'edb', such as returned by edb.
statement	Single character string. SQL statement / SQL query to be passed to the database.
formatCol	If not NULL, a named list of functions to be applied to certain columns after the data has been extracted from the database. The name of each list item gives the column to process, and the value of each item gives the function that must be applied. For instance formatCol = list("DATE"=as.Date) will apply the function as.Date to the column "DATE".
...	Additional parameters to be passed to class-specific method. See methods("edbRead")

Author(s)

Julien MOEYS <[e-mail]>

See Also

edb, edbWrite,

edbNames, edbColnames.

Examples

# See related methods for detailed examples:


# (for example ?edbQuery.RSQLite_SQLite) 


require( "easydb" ) 


methods( "edbRead" )

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