querySQLite: Load data frame by querying an SQLite database. This function...

In D4TAlink.light: GDP - Workflow Management

Load data frame by querying an SQLite database. This function executes a SQL query on an SQLite database file created with saveSQLite.

Description

Load data frame by querying an SQLite database. This function executes a SQL query on an SQLite database file created with saveSQLite.

Usage

querySQLite(query, task, type, subdir = NULL, dirCreate = FALSE, conn = NULL)

Arguments

query	SQL query to execute.
task	Object of class D4TAlinkTask, as created by initTask.
type	Filename type. If the type is an array, the cocatenation of the elements is used with separator"-". Filenames have the form [task name]_[type].[ext]
subdir	(optional) Subdirectory.
dirCreate	Logical, if TRUE (by default) the directory is created.
conn	SQLite connection object (optional).

Value

Data frame with query results.

D4TAlink.light documentation built on Sept. 11, 2025, 1:07 a.m.