query-RequeteDBwheredate-method: query method loads a request to the database and returns...

In stacomirtools: Connection Class for Package stacomiR

query method loads a request to the database and returns either an error or a data.frame

Description

query method loads a request to the database and returns either an error or a data.frame

Usage

## S4 method for signature 'RequeteDBwheredate'
query(object, ...)

Arguments

object	an object of class RequeteDBwheredate
...	further arguments passed to the query method, base will be passed to ConnectionDB to set the connection parameters,

Value

An object of class RequeteDBwheredate

Author(s)

Cedric Briand [e-mail]

Examples

## Not run: 
object<-new("RequeteDBwheredate")
base=c("bd_contmig_nat","localhost","5432","user", "password")
object@select<- "select * from t_operation_ope"
object@datedebut=strptime("1996-01-01 00:00:00",format="%Y-%m-%d %H:%M:%S")
object@datefin=strptime("2000-01-01 00:00:00",format="%Y-%m-%d %H:%M:%S")
object@colonnedebut="ope_date_debut"
object@colonnefin="ope_date_fin"
object@and<-c("AND ope_dic_identifiant=1","AND ope_dic_identifiant=2")
object@order_by<-"ORDER BY ope_identifiant"
object@silent=FALSE
object<-connect(object, base)

## End(Not run)

stacomirtools documentation built on Sept. 9, 2022, 3:07 p.m.