stacomirtools (version 0.6.0.1)

query,RequeteDB-method: query method loads a quert to the data and returns either an error or a data.frame

Description

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

Usage

# S4 method for RequeteDB
query(object, ...)

Arguments

object

an object of class RequeteDB

...

further arguments passed to the query method, base will be passed to ConnectionDB to set the connection parameters, it should be a vector with dbname host port user and password (in this order)

Value

An object of class RequeteDB

Examples

# NOT RUN {
showClass("RequeteDB")
# }
# NOT RUN {
# this connection require user and password and a working data
 object=new("RequeteDB",dbname ="bd_contmig_nat",
			host ="localhost", port="5432", user ="postgres", password="secret")
)
object@open=TRUE
 ## this will leave the connection open, 
 ## by default it closes after the query is sent
 ## the following will work only if you have configured and ODBC link
object@sql= "select * from t_lot_lot limit 100"
object<-query(object)
  envir_stacomi=new.env()
  ## While testing if you want to see the output of sometimes
  ## complex queries generated by the program
  assign("showmerequest",1,envir_stacomi) 
  ## You can assign any values (here 1)
  ## just tests the existence of "showmerequest" in envir_stacomi
  object@sql= "select * from mytable limit 100"
  object<-connect(object)
 ## the connection is already closed, the query is printed
# }