| Title: | Database Backend for Quantitative Microbiological Risk Assessment (QMRA) within AquaNES project |
|---|---|
| Description: | This package contains a MS ACCESS database with data required for performing Quantitative Microbiological Risk Assessment (QMRA). In addition it provides also R functions for exporting these data into .csv files or a single ZIP file (together with the MS Access database). |
| Authors: | Michael Rustler [aut, cre, dtm] (ORCID: <https://orcid.org/0000-0001-9134-2871>), Patrick Smeets [aut, rev, dtc] (ORCID: <https://orcid.org/0000-0002-6442-9581>), Wolfgang Seis [ctb, rev] (ORCID: <https://orcid.org/0000-0002-7436-8575>), Kompetenzzentrum Wasser Berlin gGmbH (KWB) [cph], KWR Watercycle Research Institute (KWR) [cph], AquaNES [fnd] |
| Maintainer: | Michael Rustler <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.10.0 |
| Built: | 2026-04-23 05:45:04 UTC |
| Source: | https://github.com/KWB-R/qmra.db |
Create Zip File with MS ACCESS Database And Exported CSV files
create_zipfile(db_path, target_dir = dirname(db_path), dbg = TRUE)create_zipfile(db_path, target_dir = dirname(db_path), dbg = TRUE)
db_path |
path to MS Access DB (default: default_access_db()) |
target_dir |
directory. By default a new zip file is created in the same directory as mdb resides in. The new directory has the same name as the database file but with file extension ".zip" (default: dirname(db_path)) |
dbg |
debug information (default: TRUE) |
Default Path to MS ACCESS Database
default_access_db()default_access_db()
path to MS ACCESS DB
default_access_db()default_access_db()
Helper Function: Default Csv Directory
default_csv_dir(db_path)default_csv_dir(db_path)
db_path |
path to MS Access DB (default: deufault_access_db()) |
csv directory but with all "." replaced with with "_" (e.g. "qmra-db_accdb" instead of "qmra-db.accdb")
db_path <- default_access_db() default_csv_dir(db_path)db_path <- default_access_db() default_csv_dir(db_path)
Helper Function: Default Target Directory
default_target_dir(db_path, csv_dir = default_csv_dir(db_path))default_target_dir(db_path, csv_dir = default_csv_dir(db_path))
db_path |
path to MS Access DB (default: deufault_access_db()) |
csv_dir |
csv directory (default: default_csv_dir()) |
subdirectory in MS ACCESS DB directory but with all "." replaced with with "_" (e.g. "qmra-db_accdb" instead of "qmra-db.accdb")
db_path <- default_access_db() default_target_dir(db_path)db_path <- default_access_db() default_target_dir(db_path)
for exporting tables and queries from MS ACCESS DB into .csv files (one for each table/query) into subfolder "qmra-db_accdb"
dump_access_db(db_path = default_access_db(), target_dir = default_target_dir(db_path), dbg = TRUE, ...)dump_access_db(db_path = default_access_db(), target_dir = default_target_dir(db_path), dbg = TRUE, ...)
db_path |
path to MS Access DB (default: default_access_db()) |
target_dir |
directory. By default a new directory is created in the same directory as mdb resides in. The new directory has the same name as the database file with dots substituted with underscores (default: default_target_dir()) |
dbg |
debug information (default: TRUE) |
... |
additional arguments passed to kwb.db::dumpDatabase() |
Import Database Content From CSV Files
import_database_content(csv_dir = system.file("database/qmra-db_accdb", package = "qmra.db"), encoding = "WINDOWS-1252")import_database_content(csv_dir = system.file("database/qmra-db_accdb", package = "qmra.db"), encoding = "WINDOWS-1252")
csv_dir |
path to csv directory with database output (default: system.file("database/qmra-db_accdb", package = "qmra.db")) |
encoding |
encoding of csv files (default: "WINDOWS-1252") |
list with multiple data.frames with database content
## Not run: db_content <- import_database_content() str(db_content, 1) ## End(Not run)## Not run: db_content <- import_database_content() str(db_content, 1) ## End(Not run)