queryActigraph: Query ActiGraph File

In PhysicalActivity: Process Accelerometer Data for Physical Activity Measurement

Description

This function executes a SELECT query on an ActiGraph AGD file.

Usage

queryActigraph(datfile, qry)

Arguments

datfile	An AGD file.
qry	An SQL SELECT statement.

Details

AGD files are actually SQLite databases. This function requires the RSQLite package. The user is encouraged to directly interface with the database by creating a connection with the DBI package. This has been tested with AGD files produced with ActiLife v6.11.

Value

A data frame with query results.

Author(s)

Cole Beck [e-mail]

See Also

readActigraph

Examples

## Not run: 
dat <- queryActigraph("actfile.agd", "SELECT * FROM data LIMIT 5")

queryActigraph("actfile.agd", "SELECT * FROM settings")

## directly interface using DBI package
con <- DBI::dbConnect(RSQLite::SQLite(), "actfile.agd")
DBI::dbListTables(con)
DBI::dbDisconnect(con)

## End(Not run)

PhysicalActivity documentation built on Jan. 23, 2021, 1:06 a.m.