PhysicalActivity (version 0.2-4)

queryActigraph: Query ActiGraph File

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.

Value

A data frame with query results.

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.

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)
# }