Open.ControlTier > ModuleForge
 

RdbOracleStrategy

Oracle RDB strategy

Overview

Open in Workbench RdbOracleStrategy: Oracle RDB strategy

This is a implementation defining various basic rdb management operations for MySQL.

Design

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

Constraints

Allowed Child Dependencies

  • RdbStrategySetting

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

Checks schema is unavailable in the designated 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

Checks schema is available in the designated 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

Checks that rdb instance 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

Checks that rdb instance 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

Export

Exports 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

runImports the schema

Usage
runImport [-buildstamp <>] [-config <>] [-export_user <>] -exportfile <> [-failonwarnings <>] -installroot <> [-instance <>] [-password <>] -schema <> [-sqlscript <>] [-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
password Schema user's password
schema Database schema name
sqlscript sql script to run before import
strategy Database strategy name
username Schema user name

runSqlScript

Runs 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