How do I run SQL scripts pre and post RCU?

You can either specify a SQL file in your workspace (using Administration > Custom Actions), or have the SQL files bundled and published to your binary repository (recommended).

The four available phases you can use combined with RCU:

  • rcu-create-pre
  • rcu-create-post
  • rcu-drop-pre
  • rcu-drop-post

Prerequisites

Preparing the SQL Files

Workspace
  1. Go to Administration > Custom Actions
  2. Create a sql script in the workspace
  3. WebLogic Record
Binary Repository
  1. Create a ZIP file and publish to your binary repository
  2. Ensure that you have a MyST Studio Continuous Delivery Profile defined that is pointing to your binary repository

Configuring MyST Studio

Workspace

If you use the Workspace method:

  1. Define the SQL deployment definition in the global properties section
    core.deployment[Stock-rcu-create-post].param[data-source-username]=sys
    core.deployment[Stock-rcu-create-post].param[data-source-sys-role]=sysdba
    core.deployment[Stock-rcu-create-post].param[data-source-password]=${core.product[rcu].param[db-password]}
    core.deployment[Stock-rcu-create-post].param[data-source-url]=${core.product[rcu].param[db-url]}
    core.deployment[Stock-rcu-create-post].param[execute]=resources/custom/sql/myst-rcu-post.sql
    core.deployment[Stock-rcu-create-post].param[fail-on-error]=false
    core.deployment[Stock-rcu-create-post].param[phase]=rcu-create-post
    core.deployment[Stock-rcu-create-post].present=true
    core.deployment[Stock-rcu-create-post].type=sql
    

Binary Repository

If you use the Binary Repository method:

  1. Define the SQL deployment definition in the global properties section
core.deployment[Stock-rcu-create-post].artifact.repository.artifactId=myst-rcu-post
core.deployment[Stock-rcu-create-post].artifact.repository.groupId=com.rubiconred.myst
core.deployment[Stock-rcu-create-post].artifact.repository.type=zip
core.deployment[Stock-rcu-create-post].artifact.repository.version=1.0
core.deployment[Stock-rcu-create-post].param[data-source-username]=sys
core.deployment[Stock-rcu-create-post].param[data-source-sys-role]=sysdba
core.deployment[Stock-rcu-create-post].param[data-source-password]=${core.product[rcu].param[db-password]}
core.deployment[Stock-rcu-create-post].param[data-source-url]=${core.product[rcu].param[db-url]}
core.deployment[Stock-rcu-create-post].param[execute]=(EMBEDDED)/rcu_create_post.sql
core.deployment[Stock-rcu-create-post].param[fail-on-error]=false
core.deployment[Stock-rcu-create-post].param[phase]=rcu-create-post
core.deployment[Stock-rcu-create-pre].present=true
core.deployment[Stock-rcu-create-post].type=sql

Provisioning

When you run a provision (or RCU) action and depending on which phase you are using MyST will also execute the SQL.

results for ""

    No results matching ""