Represents a database configuration block for connecting to a specific database. Encapsulates database connection parameters and naming conventions used during study execution.
Details
DbConfigBlock manages configuration for a single database connection within the Ulysses framework. This includes CDM schema specifications, cohort table references, and database labeling. Used to manage multiple database connections within a study.
Active Fields
configBlockName: Unique identifier for this config block (read/write)cdmDatabaseSchema: Schema name containing the CDM (read/write)cohortTable: Table name for study cohorts (read/write)databaseName: Database identifier (read/write, defaults to configBlockName)databaseLabel: Human-readable database label (read/write)
Active bindings
configBlockNameUnique identifier for this configuration block. Can be read or set with validation.
cdmDatabaseSchemaSchema name containing the CDM data. Can be read or set with validation.
cohortTableTable name for study cohorts. Can be read or set with validation.
databaseNameDatabase identifier. Can be read or set with validation. Defaults to configBlockName.
databaseLabelHuman-readable database label for display. Can be read or set with validation.
dbServerDatabase server name for secrets.yml lookup. Can be read or set with validation. Defaults to configBlockName.
workDatabaseSchemaWorking schema for writing temporary tables. Per-block setting (not study-level).
tempEmulationSchemaSchema for emulating temporary tables (Oracle/Snowflake). Per-block setting.
Methods
Method new()
Initialize a new DbConfigBlock instance with database configuration.
Usage
DbConfigBlock$new(
configBlockName,
cdmDatabaseSchema,
cohortTable,
databaseName = NULL,
databaseLabel = NULL,
dbServer = NULL,
workDatabaseSchema = NULL,
tempEmulationSchema = NULL
)Arguments
configBlockNameCharacter string. Unique identifier for this configuration block.
cdmDatabaseSchemaCharacter string. Schema containing CDM data.
cohortTableCharacter string. Table name for study cohorts.
databaseNameCharacter string. Optional database identifier (defaults to configBlockName).
databaseLabelCharacter string. Optional human-readable database label (defaults to databaseName).
dbServerCharacter string. Optional database server name for secrets.yml lookup (defaults to configBlockName).
workDatabaseSchemaCharacter string. Optional working schema for temp tables (per-block).
tempEmulationSchemaCharacter string. Optional temp table emulation schema (per-block).
Method writeBlockSection()
Generate a formatted configuration block section for the config file.