dbQueryHistory: Show the history of queries that were loaded into a database

Description Usage Arguments Value Examples

View source: R/utils.R

Description

Show the history of queries that were loaded into a database

Usage

1
dbQueryHistory(con, verbose = FALSE)

Arguments

con

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

verbose

If TRUE, prints additional information (default FALSE).

Value

A data frame 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, and with one row for each ctrLoadQueryIntoDb loading trial records in this collection.

Examples

1
2
3
4
5
6
7
8
9
## Not run: 
db <- nodbi::src_sqlite(
  collection = "my_collection"
)
dbQueryHistory(
  con = db
)

## End(Not run)

ctrdata documentation built on Nov. 22, 2021, 1:06 a.m.