sqlplus-formula

Formula to install Sqlplus on GNU/Linux and MacOS.

Table of Contents

• General notes
• Contributing to this repo
• Special notes
• Available states
• Testing

General notes

See the full SaltStack Formulas installation and usage instructions.

If you are interested in writing or contributing to formulas, please pay attention to the Writing Formula Section.

If you want to use this formula, please pay attention to the FORMULA file and/or git tag, which contains the currently released version. This formula is versioned according to Semantic Versioning.

See Formula Versioning Section for more details.

If you need (non-default) configuration, please pay attention to the pillar.example file and/or Special notes section.

Contributing to this repo

Commit message formatting is significant!!

Please see How to contribute for more details.

Special notes

None.

Available states

• sqlplus
• sqlplus.archive
• sqlplus.config
• sqlplus.linuxenv
• sqlplus.clean
• sqlplus.config.clean
• sqlplus.archive.clean
• sqlplus.linuxenv.clean

sqlplus

Meta-state (This is a state that includes other states).

This installs Sqlplus package, manages Sqlplus configuration file and then configures the development environment.

sqlplus.archive

This state will install Sqlplus from archive only.

sqlplus.config

This state will configure npmrc and/or environment and has a dependency on sqlplus.install via include list.

sqlplus.linuxenv

This state will install some Sqlplus linux-alternatives on GNU/Linux.

sqlplus.clean

Meta-state (This is a state that includes other states).

this state will undo everything performed in the sqlplus meta-state in reverse order, i.e. removes the configuration file and then uninstalls the package.

sqlplus.config.clean

This state will remove the configuration of Sqlplus and has a dependency on sqlplus.package.clean via include list.

sqlplus.archive.clean

This state will remove Sqlplus package and has a dependency on sqlplus.config.clean via include list.

sqlplus.linuxenv.clean

This state will remove Sqlplus linux-alternatives on GNU/Linux.

Testing

Linux testing is done with kitchen-salt.

Requirements

• Ruby
• Docker

$ gem install bundler
$ bundle install
$ bin/kitchen test [platform]

Where [platform] is the platform name defined in kitchen.yml, e.g. debian-9-2019-2-py3.

bin/kitchen converge

Creates the docker instance and runs the sqlplus main state, ready for testing.

bin/kitchen verify

Runs the inspec tests on the actual instance.

bin/kitchen destroy

Removes the docker instance.

bin/kitchen test

Runs all of the stages above in one go: i.e. destroy + converge + verify + destroy.

bin/kitchen login

Gives you SSH access to the instance for manual testing.