Open.ControlTier > ModuleForge
 

RdbStrategy

Abstract RDB strategy

Overview

Open in Workbench RdbStrategy: Abstract RDB strategy

This is a abstract implementation defining various basic rdb management operations.

Design

Super Type
Deployment
Role Abstract. (Objects cannot be created.)
Instance Names Unique
Notification false
Template Directory
Data View Children, proximity: 1
Logger Name

Constraints

Allowed Child Dependencies

Allowed Parent Dependencies

Attributes

Commands

Note
Commandline options displayed in square brackets "[]" are optional. If an option expects arguments, then angle brackets are shown after the option "<>". Any default value is shown within the brackets.

assertSchemaIsDown

Confirm schema is unavailable in the database instance.

Usage
assertSchemaIsDown [-config <>] -installroot <> [-instance <>] [-password <>] -schema <> [-strategy <>] [-username <>]

Options

Option Description
config Database configuration file
installroot path to database install
instance Database server instance name
password Schema user's password
schema Database schema name
strategy Database strategy name
username Schema user name

assertSchemaIsUp

Confirm schema is available in the database instance.

Usage
assertSchemaIsUp [-config <>] -installroot <> [-instance <>] [-password <>] -schema <> [-strategy <>] [-username <>]

Options

Option Description
config Database configuration file
installroot path to database install
instance Database server instance name
password Schema user's password
schema Database schema name
strategy Database strategy name
username Schema user name

assertServiceIsDown

Confirm the rdb service is down.

Usage
assertServiceIsDown [-config <>] -installroot <> [-instance <>] [-password <>] [-strategy <>] [-username <>]

Options

Option Description
config Database configuration file
installroot path to database install
instance Database server instance name
password Schema user's password
strategy Database strategy name
username Schema user name

assertServiceIsUp

Confirm that rdb service is up.

Usage
assertServiceIsUp [-config <>] -installroot <> [-instance <>] [-password <>] [-strategy <>] [-username <>]

Options

Option Description
config Database configuration file
installroot path to database install
instance Database server instance name
password Schema user's password
strategy Database strategy name
username Schema user name

runSqlScript

Run the sql script.

Usage
runSqlScript [-buildstamp <>] [-config <>] [-failonwarnings <>] -installroot <> [-instance <>] [-password <>] -schema <> [-sqlscript <>] [-strategy <>] [-username <>]

Options

Option Description
buildstamp build stamp
config Database configuration file
failonwarnings if arg true, fail if there are import warnings
installroot path to database install
instance Database server instance name
password Schema user's password
schema Database schema name
sqlscript sql script to run
strategy Database strategy name
username Schema user name

Export

Export the schema to a file.

Usage
Export [-buildstamp <>] [-config <>] -exportfile <> -installroot <> [-instance <>] [-password <>] -schema <> [-strategy <>] [-username <>]

Options

Option Description
buildstamp build stamp
config Database configuration file
exportfile Output file
installroot path to database install
instance Rdb server instance name
password Schema user's password
schema Rdb schema name
strategy Database strategy name
username Schema user name

runImport

Load the exportfile into the schema.

Usage
runImport [-buildstamp <>] [-config <>] [-export_user <>] -exportfile <> [-failonwarnings <>] -installroot <> [-instance <>] [-params <>] [-password <>] -schema <> [-strategy <>] [-username <>]

Options

Option Description
buildstamp build stamp
config Database configuration file
export_user from user
exportfile dump file to import
failonwarnings if arg true, fail if there are import warnings
installroot path to database install
instance Database server instance name
params import parameters
password Schema user's password
schema Database schema name
strategy Database strategy name
username Schema user name

Related Types

The following types are defined for use with RdbStrategy.

RdbStrategySetting

Overview

Open in Workbench RdbStrategySetting: an RdbStrategySetting setting

Design

Super Type
Setting
Role Abstract. (Objects cannot be created.)
Instance Names Unique

Constraints

Allowed Parent Dependencies

RdbStrategyModule

Overview

Open in Workbench RdbStrategyModule: Specifies the unique key value identifying which type database type is in use (e.g. "RdbMysqlStrategy" or "RdbOracleStrategy", etc)

Design

Super Type
RdbStrategySetting
Role Concrete. (Objects can be created.)
Instance Names Unique

Constraints

Allowed Parent Dependencies
Allowed Property Values
Property Allowed Values Default Enforced Description
settingValue
  • MssqlRdbStrategy
  • RdbMysqlStrategy
  • RdbOracleStrategy
  • RdbStrategy
  • RdbMysqlStrategy
  • RdbStrategy
false

Rdb specific strategy implementation

Attributes

Exported Attributes
Name Property
rdbStrategy settingValue