Create SQLite database from CDM database — helper_createSqliteDatabaseFromDatabase • ROMOPAPI

Creates a new SQLite database by extracting specific concept data from a CDM database. The function extracts concept information, concept ancestors, code counts, and stratified code counts for the specified concept IDs and creates a new SQLite database with this subset of data.

helper_createSqliteDatabaseFromDatabase(
  CDMdbHandler,
  conceptIds = c(317009, 21601855),
  pathToSqliteDatabase = tempfile(fileext = ".sqlite"),
  codeCountsTable = "code_counts"
)

Arguments

CDMdbHandler: A CDMdbHandler object containing database connection details
conceptIds: Vector of concept IDs to extract. Defaults to c(317009, 21601855)
pathToSqliteDatabase: Path where the new SQLite database should be created. Defaults to a temporary file with .sqlite extension
codeCountsTable: Name of the code counts table in the source database. Defaults to "code_counts"

Value

No return value. Creates a new SQLite database file at the specified path.