ctrdata (version 1.1)

ctrLoadQueryIntoDb: Retrieve or update information on clinical trials from register and store in database

Description

This is the main function of package ctrdata for accessing registers. Note that re-rerunning this function adds or updates trial records in a database, even if from different queries or different registers.

Usage

ctrLoadQueryIntoDb(
  queryterm = "",
  register = "EUCTR",
  querytoupdate = 0L,
  forcetoupdate = FALSE,
  euctrresults = FALSE,
  euctrresultshistory = FALSE,
  annotation.text = "",
  annotation.mode = "append",
  parallelretrievals = 10L,
  only.count = FALSE,
  con = NULL,
  verbose = FALSE
)

Arguments

queryterm

Either a string with the full URL of a search in a register or the data frame returned by the ctrGetQueryUrlFromBrowser or the dbQueryHistory functions. The queryterm is recorded in the collection for later use to update records.

register

Vector of abbreviations of the register to query, defaults to "EUCTR".

querytoupdate

Either the word "last" or the number of the query (based on dbQueryHistory) that should be run to retrieve any trial records that are new or have been updated since this query was run the last time. This parameter takes precedence over queryterm. For EUCTR, updates are available only for the last seven days; the query is run again if more time has passed since it was run last.

forcetoupdate

If TRUE, run again the query given in querytoupdate, irrespective of when it was run last (default is FALSE).

euctrresults

If TRUE, also download available results when retrieving and loading trials from EUCTR. This slows down this function. (For CTGOV, all available results are always retrieved and loaded.)

euctrresultshistory

If TRUE, also download available history of results publication in EUCTR. This is quite time-consuming (default is FALSE).

annotation.text

Text to be including in the records retrieved with the current query, in the field "annotation".

annotation.mode

One of "append" (default), "prepend" or "replace" for new annotation.text with respect to any existing annotation for the records retreived with the current query.

parallelretrievals

Number of parallel downloads of information from the register, defaults to 10.

only.count

Set to TRUE to return only the number of trial records found in the register for the query. Does not load trial information into the database. Default is FALSE.

con

A src connection object, as obtained with nodbi::src_mongo() or nodbi::src_sqlite()

verbose

Printing additional information if set to TRUE; default is FALSE.

Value

A list with elements "n" (the number of trials that were newly imported or updated with this function call) and "ids" (a vector of the _id[s] of these trials), with attributes (database connection details and a data frame of the query history in this database).

Examples

# NOT RUN {
# Retrieve protocol-related information on a
# single trial identified by EudraCT number
# }
# NOT RUN {
ctrLoadQueryIntoDb (queryterm = "2013-001291-38")
# }
# NOT RUN {
# Retrieve protocol-related information on
# ongoing interventional cancer trials in children
# }
# NOT RUN {
ctrLoadQueryIntoDb (
     queryterm = "cancer&recr=Open&type=Intr&age=0",
     register = "CTGOV")
ctrLoadQueryIntoDb (
     queryterm = "NCT02239861",
     register = "CTGOV")
# }
# NOT RUN {
# }