| Title: | HSCI Data Access Provider |
|---|---|
| Description: | Provides data access helpers for HSCI datasets using DuckDB. |
| Authors: | Eetu Mäkelä [aut, cre] (ORCID: <https://orcid.org/0000-0002-8366-8414>) |
| Maintainer: | Eetu Mäkelä <[email protected]> |
| License: | file LICENSE |
| Version: | 0.6.0 |
| Built: | 2026-10-03 11:04:34 UTC |
| Source: | https://github.com/hsci-r/hscida |
Create a data access object backed by DuckDB.
data_access(config = config_from_env())data_access(config = config_from_env())
config |
A configuration list (by default from config_from_env()). |
A list with a DBI connection con, dataset accessor f, and
dataset discovery function list_datasets.
cfg <- list( path_query = "glob('{projroot}/{dataset}/*.csv')", list_datasets_query = "SELECT DISTINCT regexp_extract(file, '{projroot}/([^/]+)', 1) AS dataset FROM glob('{projroot}/*')", init_sql = "SELECT 1", duckdb_config = list(), projroot = tempdir() ) da <- data_access(cfg) DBI::dbDisconnect(da$con, shutdown = TRUE)cfg <- list( path_query = "glob('{projroot}/{dataset}/*.csv')", list_datasets_query = "SELECT DISTINCT regexp_extract(file, '{projroot}/([^/]+)', 1) AS dataset FROM glob('{projroot}/*')", init_sql = "SELECT 1", duckdb_config = list(), projroot = tempdir() ) da <- data_access(cfg) DBI::dbDisconnect(da$con, shutdown = TRUE)