Uses of Interface
com.ibm.fhir.database.utils.api.IDatabaseStatement

Packages that use IDatabaseStatement

Package	Description
com.ibm.fhir.bucket.persistence
com.ibm.fhir.database.utils.api
com.ibm.fhir.database.utils.common
com.ibm.fhir.database.utils.db2
com.ibm.fhir.database.utils.derby
com.ibm.fhir.database.utils.model
com.ibm.fhir.database.utils.postgres
com.ibm.fhir.database.utils.tenant
com.ibm.fhir.database.utils.version
com.ibm.fhir.persistence.jdbc.derby
com.ibm.fhir.schema.control

Uses of IDatabaseStatement in com.ibm.fhir.bucket.persistence

Classes in com.ibm.fhir.bucket.persistence that implement IDatabaseStatement

Modifier and Type	Class	Description
class	AddResourceBundleErrors	DAO to encapsulate all the SQL/DML used to retrieve and persist data in the schema
class	AllocateJobs	DAO to encapsulate all the SQL/DML used to retrieve and persist data in the schema
class	ClearStaleAllocations	DAO to encapsulate all the SQL/DML used to retrieve and persist data in the schema
class	GetLogicalIds	Fetch a batch of roughly random patientIds.
class	LoaderInstanceHeartbeat	Updates the last seen timestamp of the LOADER_INSTANCES record to indicate this particular instance is still alive
class	MarkBundleDone	Updates the LOAD_COMPLETED timestamp of the resource_bundles record
class	MergeResources	Command to merge a collection of resources
class	MergeResourceTypes	DAO to encapsulate all the SQL/DML used to retrieve and persist data in the schema.
class	MergeResourceTypesPostgres	DAO to encapsulate all the SQL/DML used to retrieve and persist data in the schema.
class	RecordLogicalId	DAO to encapsulate all the SQL/DML used to retrieve and persist data in the schema
class	RecordLogicalIdList	DAO to encapsulate all the SQL/DML used to retrieve and persist data in the schema

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.api

Methods in com.ibm.fhir.database.utils.api with parameters of type IDatabaseStatement

Modifier and Type	Method	Description
void	IDatabaseAdapter.runStatement(IDatabaseStatement statement)	Run the given statement against the database represented by this adapter
void	IDatabaseTarget.runStatement(IDatabaseTranslator translator, IDatabaseStatement statement)	Run the statement using the resources (e.g.

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.common

Classes in com.ibm.fhir.database.utils.common that implement IDatabaseStatement

Modifier and Type	Class	Description
class	AddColumn	Add column to the schema.table
class	AddForeignKeyConstraint	Add one or more foreign keys to the schema.table
class	CreateIndexStatement	Create an index
class	DropColumn	Drop columns from the schema.table
class	DropForeignKeyConstraint	Drop one or more foreign keys from the schema.table
class	DropIndex	Drop an index from a given schema by name
class	DropPrimaryKey	Drop the primary key constraint on a table
class	DropTable	Drops the table at the schema.table
class	ReorgTable	For databases which support it, execute the reorg table command.

Methods in com.ibm.fhir.database.utils.common with parameters of type IDatabaseStatement

Modifier and Type	Method	Description
void	CommonDatabaseAdapter.runStatement(IDatabaseStatement stmt)	Run the statement using the connectionProvider to obtain a new connection.
void	ConnectionProviderTarget.runStatement(IDatabaseTranslator translator, IDatabaseStatement statement)
void	JdbcTarget.runStatement(IDatabaseTranslator translator, IDatabaseStatement statement)
void	NopTarget.runStatement(IDatabaseTranslator translator, IDatabaseStatement statement)
void	PrintTarget.runStatement(IDatabaseTranslator translator, IDatabaseStatement statement)

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.db2

Classes in com.ibm.fhir.database.utils.db2 that implement IDatabaseStatement

Modifier and Type	Class	Description
class	Db2AddTablePartition	DB2 Add Table Partition
class	Db2AddTableToStaging	DB2 Adds table to staging
class	Db2AdminCommand	Reorg the schema.table
class	Db2CheckCompatibility	Checks Compatibility with the DB2 Implementation that is used.
class	Db2CreateTablespace	Creates the DB2 Table Space
class	Db2DetachTablePartition	DB2 DetatchTable Partition
class	Db2DropTablespace	Drops the DB2 Tablespace
class	Db2GetPartitionInfo	Functional wrapper to get the catalog information
class	Db2Reorg	Reorg the schema.table Be sure to complete all database operations and release all locks before you invoke REORG.
class	Db2SetTenantVariable	DAO command to call the set_tenant fhir admin procedure which will set the fhir_admin.sv_tenant_id variable but only if the correct tenantKey is provided.

Methods in com.ibm.fhir.database.utils.db2 with parameters of type IDatabaseStatement

Modifier and Type	Method	Description
void	Db2Adapter.runStatement(IDatabaseStatement stmt)

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.derby

Methods in com.ibm.fhir.database.utils.derby with parameters of type IDatabaseStatement

Modifier and Type	Method	Description
void	DerbyAdapter.runStatement(IDatabaseStatement stmt)

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.model

Methods in com.ibm.fhir.database.utils.model that return types with arguments of type IDatabaseStatement

Modifier and Type	Method	Description
List<IDatabaseStatement>	Migration.migrateFrom(int priorVersion)	Migrate from some previous version to the current version of this database object

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.postgres

Classes in com.ibm.fhir.database.utils.postgres that implement IDatabaseStatement

Modifier and Type	Class	Description
class	PostgresFillfactorSettingDAO	This DAO changes the fillfactor settings on the given PostgreSQL table.
class	PostgresVacuumSettingDAO	Per the Performance Guide, this DAO implements VACUUM setting changes.

Methods in com.ibm.fhir.database.utils.postgres with parameters of type IDatabaseStatement

Modifier and Type	Method	Description
void	PostgresAdapter.runStatement(IDatabaseStatement stmt)

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.tenant

Classes in com.ibm.fhir.database.utils.tenant that implement IDatabaseStatement

Modifier and Type	Class	Description
class	AddTenantDAO	DAO to create a free tenant slot (to align with a new partition)
class	AddTenantKeyDAO	DAO to add a new tenant key record
class	CreateOrReplaceViewDAO	Executes a CREATE OR REPLACE VIEW statement
class	DeleteTenantDAO	Delete the tenant meta-data after it has been dropped.
class	DeleteTenantKeyDAO	Db2-only DAO to delete a tenant key record
class	DropViewDAO	Executes a DROP VIEW statement
class	UpdateTenantStatusDAO	DAO to create a free tenant slot (to align with a new partition)

Uses of IDatabaseStatement in com.ibm.fhir.database.utils.version

Classes in com.ibm.fhir.database.utils.version that implement IDatabaseStatement

Modifier and Type	Class	Description
class	AddVersionDAO	Add the {type, name, version} record to the database.
class	ClearVersionHistoryDAO	Clear all version history records for a particular schema (used when dropping a schema).

Uses of IDatabaseStatement in com.ibm.fhir.persistence.jdbc.derby

Classes in com.ibm.fhir.persistence.jdbc.derby that implement IDatabaseStatement

Modifier and Type	Class	Description
class	CreateCanonicalValuesTmp	Create the CANONICAL_VALUES_TMP table
class	CreateCodeSystemsTmp	Create the CODE_SYSTEMS_TMP table
class	CreateCommonTokenValuesTmp	Create the COMMON_TOKEN_VALUES_TMP table

Uses of IDatabaseStatement in com.ibm.fhir.schema.control

Classes in com.ibm.fhir.schema.control that implement IDatabaseStatement

Modifier and Type	Class	Description
class	AddResourceType	DAO command to add a resource type.
class	BackfillResourceChangeLog	Backfill the RESOURCE_CHANGE_LOG table using all the existing _RESOURCES records for the given resourceType.
class	BackfillResourceChangeLogDb2	Backfill the RESOURCE_CHANGE_LOG table using all the existing _RESOURCE records for the given resourceType.
class	GetResourceTypes	Manages the DB2 Get Resource Types
class	InitializeLogicalResourceDenorms	Set the current value for xxx_LOGICAL_RESOURCES.IS_DELETED.
class	MigrateV0014LogicalResourceIsDeletedLastUpdated	Run a correlated update statement to update the new V0014 columns in LOGICAL_RESOURCES from the corresponding values in the xx_LOGICAL_RESOURCES table (for a specific resource type) Note that for this to work for the multi-tenant (Db2) schema, the SV_TENANT_ID needs to be set first.
class	MigrateV0021AbstractTypeRemoval	DOMAINRESOURCE_ and RESOURCE_ are abstract tables which are unused.
class	PopulateParameterNames	Populates the Parameters Names Table
class	PopulateResourceTypes	Populates the Resource Types Table
class	SetTenantIdDb2	Sets the FHIR_ADMIN.SV_TENANT_ID variable which is used for row-based permissions in the Db2 multi-tenant schema.
class	UpdateSchemaVersion	Update the schema version recorded in the WHOLE_SCHEMA_VERSION table
class	UpdateSchemaVersionPostgresql	Update the schema version recorded in the WHOLE_SCHEMA_VERSION table Postgresql-specific to handle ON CONFLICT DO NOTHING