Compute dechallenge rechallenge study

Compute dechallenge rechallenge study

Usage

computeDechallengeRechallengeAnalyses(
  connectionDetails = NULL,
  targetDatabaseSchema,
  targetTable,
  outcomeDatabaseSchema = targetDatabaseSchema,
  outcomeTable = targetTable,
  tempEmulationSchema = getOption("sqlRenderTempEmulationSchema"),
  settings,
  databaseId = "database 1",
  outputFolder,
  minCellCount = 0,
  ...
)

Arguments

connectionDetails

An object of type `connectionDetails` as created using the [DatabaseConnector::createConnectionDetails()] function.

targetDatabaseSchema

Schema name where your target cohort table resides. Note that for SQL Server, this should include both the database and schema name, for example 'scratch.dbo'.

targetTable

Name of the target cohort table.

outcomeDatabaseSchema

Schema name where your outcome cohort table resides. Note that for SQL Server, this should include both the database and schema name, for example 'scratch.dbo'.

outcomeTable

Name of the outcome cohort table.

tempEmulationSchema

Some database platforms like Oracle and Impala do not truly support temp tables. To emulate temp tables, provide a schema with write privileges where temp tables can be created

settings

The settings for the timeToEvent study

databaseId

An identifier for the database (string)

outputFolder

A directory to save the results as csv files

minCellCount

The minimum cell value to display, values less than this will be replaced by -1

...

extra inputs

Value

An Andromeda::andromeda() object containing the dechallenge rechallenge results

See also

Other DechallengeRechallenge: computeRechallengeFailCaseSeriesAnalyses(), createDechallengeRechallengeSettings()

Examples

conDet <- exampleOmopConnectionDetails()

drSet <- createDechallengeRechallengeSettings(
  targetIds = c(1,2),
  outcomeIds = 3
)

computeDechallengeRechallengeAnalyses(
  connectionDetails = conDet,
  targetDatabaseSchema = 'main',
  targetTable = 'cohort',
  settings = drSet,
  outputFolder = tempdir()
)
#> Inputs checked
#> Connecting using SQLite driver
#> Computing dechallenge rechallenge results
#>   |                                                                              |                                                                      |   0%  |                                                                              |========                                                              |  11%  |                                                                              |================                                                      |  22%  |                                                                              |=======================                                               |  33%  |                                                                              |===============================                                       |  44%  |                                                                              |=======================================                               |  56%  |                                                                              |===============================================                       |  67%  |                                                                              |======================================================                |  78%  |                                                                              |==============================================================        |  89%  |                                                                              |======================================================================| 100%
#> Executing SQL took 0.0261 secs
#> Computing dechallenge rechallenge for 2 target ids and 1 outcome ids took 0.375 secs
#> exporting to csv file
#> Writing 0 rows to csv