Learn R Programming

ctrdata (version 1.5.2)

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

Description

Show the history of queries that were loaded into a database

Usage

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

Run this code
# NOT RUN {
# }
# NOT RUN {
db <- nodbi::src_sqlite(
  collection = "my_collection"
)
dbQueryHistory(
  con = db
)
# }
# NOT RUN {
# }

Run the code above in your browser using DataLab