reload: Internal functions: helping to do things

In RObsDat: Store your observations: R-Package to the Observations Data Model from CUAHSI

Description

The following methods are used internally:

Reload is used to recompile and reload the package during development.

Todo is used to indicate unfinished implementations. options(verbose.todos = TRUE) can be used to determine if the corresponding text is printed.

run.query is used to run queries. In addition, the query string is printed if options(verbose.queries=TRUE) is set.

run.sql.script reads an SQL script from a text file and executes all the commands.

sqlnow returns a database engine specific term to obtain the current time and date.

sv and svk are used to return the correct element from a vector to be entered in a database query. The commands take care to give useful result also for vectors that are NULL and NA-entries in a vector. svk must be used if the database column has to meet a foreign key relation ship. In this case, the appropriate key is returned.

Usage

reload()
run.query(object, query)
run.sql.script(con, script.file)
sqlstatements(object, term)
sv(the.vect, rownum)
svk(the.vect, tablename, rownum, object)
todo(text)

Arguments

con	Connection returned by dbConnect
query	Query string to be executed
script.file	Location (path) of the SQL script to be run.
object	ODM handler object returned by new("ODM1_1") or new("ODM1_1Ver").
term	Internal function. SQL statement to be translated in the appropriate SQL-dialect.
tablename	Name of the table defining the foreign key.
the.vect	Vector from which to return the correct element.
rownum	Element to be returned from vector.
text	String describing what is missing in the implementation.

Details

See code for details.

Value

See code for return values.

Author(s)

Dominik Reusser

Examples

# see code for examples

RObsDat documentation built on May 2, 2019, 5:55 p.m.