RdbSqlPackage

A package containing build and deploy database sql scripts

Overview
Design
Constraints
Attributes
- Exported Attributes
Commands

Overview

RdbSqlPackage: A package containing build and deploy database sql scripts

An RdbSqlPackage is a zip archive of SQL scripts executed during the RdbSchema Deploy process.

The RdbSqlPackage type is a trivial subtype of zip.

Content Structure

A standard file layout within the package archive is encouraged. This will enable a simple configuration in the RdbSchema object setup.

The diagram below describes the suggested file layout for the zip archive:

	  
package-archive-root
	  |
	  +-import // directory containing pre- and post-import SQL scripts
	     |
             |- pre-import.sql  // file executed by RdbSchema->runPreImportSqlScript
             `- post-import.sql // file executed by RdbSchema->runPostImportSqlScript

In the future, there may be a second directory to store export SQL scripts.

Building

Builds of the RdbSqlPackage are coordinated via the RdbDataBuilder object.

Deploying

Deployment of the RdbSqlPackage are coordinated via the RdbSchema object.

Design

Super Type: zip

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

Constraints

Allowed Child Dependencies

RdbSqlPackage

Allowed Parent Dependencies

RdbSchema

Allowed Property Values

Property	Allowed Values	Default	Enforced
package-arch	noarch	noarch
package-filetype	zip	zip	true
package-repo-url	${framework.pkgRepo.uri}/${context.depot}/RdbSqlPackage/zips/FILENAME	${framework.pkgRepo.uri}/${context.depot}/RdbSqlPackage/zips/FILENAME	false
package-install-root	$${entity.instance.dir}/RdbSqlPackage	$${entity.instance.dir}/RdbSqlPackage	false
package-vendor			false

Attributes

Exported Attributes

Name	Property	Description
rdbSqlPackageInstallroot	package-install-root	Directory where sql script code resides

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.