dbQueryHistory {ctrdata}R Documentation

Show history of queries loaded into a database collection

Description

Show history of queries loaded into a database collection

Usage

dbQueryHistory(con, verbose = FALSE)

Arguments

con

A connection object, see section 'Databases' in ctrdata-package

verbose

If TRUE, prints additional information (default FALSE).

Value

A data frame (or tibble, if dplyr is loaded) with columns: 'query-timestamp', 'query-register', 'query-records' (note: this is the number of records loaded when last executing ctrLoadQueryIntoDb, not the total record number) and 'query-term', with one row for each time ctrLoadQueryIntoDb loaded trial records into this collection.

Examples


dbc <- nodbi::src_sqlite(
   dbname = system.file("extdata", "demo.sqlite", package = "ctrdata"),
   collection = "my_trials")

dbQueryHistory(con = dbc)


[Package ctrdata version 1.11.1 Index]