Skip to contents

Set up a dummy all_lkps_maps database

Usage

dummy_all_lkps_maps_db(db_path = tempfile(fileext = ".db"))

Arguments

db_path

Path to the database file. Defaults to a temporary file.

Value

Returns the db_path invisibly

Examples

dummy_all_lkps_maps_db()
#> Writing lookup and mapping tables to Duckdb database at /tmp/RtmpRK6Py7/file1bd33c3085bc.db
#> metadata_all_lkps_maps
#> bnf_lkp
#> dmd_lkp
#> icd9_lkp
#> icd10_lkp
#> icd9_icd10
#> read_v2_lkp
#> read_v2_drugs_lkp
#> read_v2_drugs_bnf
#> read_v2_icd9
#> read_v2_icd10
#> read_v2_opcs4
#> read_v2_read_ctv3
#> read_ctv3_lkp
#> read_ctv3_icd9
#> read_ctv3_icd10
#> read_ctv3_opcs4
#> read_ctv3_read_v2
#> opcs4_lkp
#> self_report_cancer
#> self_report_medication
#> self_report_operation
#> self_report_non_cancer
#> phecode_lkp
#> icd10_phecode
#> metadata_codeminer
#> Success! Connect to database with `con <- DBI::dbConnect(duckdb::duckdb(), '/tmp/RtmpRK6Py7/file1bd33c3085bc.db', read_only = TRUE)`, then access all tables with `all_lkps_maps <- ukbwranglr::db_tables_to_list(con)`