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

View source: R/sqlite.R

querySQLiteR Documentation

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.