This function executes a SELECT query on an ActiGraph AGD file.
queryActigraph(datfile, qry)
Arguments
datfile: An AGD file.
qry: An SQL SELECT statement.
Returns
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.
Examples
## Not run:dat <- queryActigraph("actfile.agd","SELECT * FROM data LIMIT 5")queryActigraph("actfile.agd","SELECT * FROM settings")## directly interface using DBI packagecon <- DBI::dbConnect(RSQLite::SQLite(),"actfile.agd")DBI::dbListTables(con)DBI::dbDisconnect(con)## End(Not run)