queryActigraph {PhysicalActivity}

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.

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)