Summary: this section explains how to manage specific tools that can be run before or after an analysis to enrich the content of the final snapshot or achieve a specific aim.

Introduction

To access to the panel, click Advanced within the Application - Config section. Available tools are explained below.

Click to enlarge

CAST AIP Console > Application - Config - Update Application schema > tools_config.jpg

Options

This sections lists all the tool "jobs" that will be run immediately after an analysis has completed, but before the snapshot is generated:

Click to enlarge

CAST AIP Console > Application - Config - Update Application schema > tools.jpg

	Click to add a new tool job, see below.
Name	Name of the tool.
Type	Indicates the type of tool that will be run.
Will be processed	This toggles the tool job: ENABLED > The tool will be run after the analysis - by default all newly created Tools will be set to ENABLED DISABLED > The tool will NOT be run. When a tool is set to DISABLED, this is usually a temporary action. You should delete the tool if you want to permanently remove it.
	Edit the existing tool.
	Delete the tool.

Adding a tool

Click the button - a new form will be displayed:

Click to enlarge

CAST AIP Console > Application - Config - Update Application schema > add_tool.jpg

Name

Enter a name for the tool.

Descripton

Enter a description.

Will be processed

This toggles the tool job:

ENABLED > The tool will be run after the analysis - by default all newly created Tools will be set to ENABLED
DISABLED > The tool will NOT be run.

When a tool is set to DISABLED, this is usually a temporary action. You should delete the tool if you want to permanently remove it.

Insertion Mode

Choose the job type:

KB Update SQL Tool

The KB Update SQL Tool provides (as its name suggests) a means to modify the content of the Analysis schema (also known as the Knowledge Base) after an analysis has been completed. There are many reasons for this requirement, but to give you some examples of how the assistant could be used:

Update links that have been omitted by analyzers when dynamic programming is in use
Update erroneous links identified by grep searches
Managing specific situations (e.g. Java frameworks)
Overcoming specific limitations inherent in a CAST analyzer (for example searching using the parent type and not just on the object name ("class.function()" calls in the Universal Analyzer), ability to handle virtual functions and the ability to ignore links)

The following processes are possible with the assistant:

Add a new object
Add a new parent link (Belongs To) to an object
Add/modify/delete the property of an existing object
Delete existing links
Delete existing objects

A set of entry tables in the Analysis schema must be injected with the relevant data that will modify the data. When the KB Update SQL Tool is then run, a specific stored procedure (also located in the Analysis schema) is called which will carry out the update using the data in the entry tables.

For more detailed information see Application - Config - Update Application schema - KB Update SQL Tool.

Parameters

Not currently used.

SQL Code editor

Enter the SQL code to be executed in this section. Only standard SQL is supported.

In Console ≤ 1.22, the section sign § (HTML code §) MUST be used as a variable in front of any table name. This character will be replaced by the name of the Analysis schema (attached to the current Application) with a dot separator. For example, this code is acceptable:

Insert into §CI_OBJECTS_SET(SET_NAME,OBJECT_ID,ERROR_ID) 
Select distinct '$(ModuleName)',o.OBJECT_ID,0
From §CDT_OBJECTS o 
where OBJECT_ID in ( select distinct cf.OBJECT_ID                   
                     from §CSV_FILE_OBJECTS cf                   
                     where upper(FILE_PATH) like '%\\JEE\\CLIENT\\%')

In Console ≥ 1.23, the section sign is no longer required in front of any table name. Any referenced tables will be assumed to belong to the current Application's Analysis schema.

Run Tool

This button is disabled until the form has been successfully saved. Once saved, you can use this button to execute the current tool.

Save and Run

This button will save the data in the tool and then execute it immediately. See SQL editor validation (below) for more information about the validation process in place.

Save

This button will save the data in the tool. See SQL editor validation (below) for more information about the validation process in place.

SQL editor validation

Behaviour in Console ≥ 1.27.1 and ≥ 2.1

In Console ≥ 1.27.1 and ≥ 2.1, SQL validation is not performed when the Save or Save and Run button is clicked. If the editor contains a syntax error:

When you click Save and Run and the editor contains a syntax error, then the content is saved regardless (when you try to run the job an error will occur).
If you click Save and the editor contains a syntax error, then the content is saved regardless (when you try to run the job an error will occur).

It is possible to enable SQL validation, if required see Configuring SQL validation.

Behaviour in Console ≤1.27.0 and ≤ 2.0

In Console ≤1.27.0 and ≤ 2.0, an SQL validation process is in place as follows. When the form is saved (Save or Save and Run button is clicked):

all the SQL queries are checked for syntax errors.
if any errors are detected, the errors are displayed underneath the editor and will need to be corrected before the form can be saved:

CAST AIP Console > Application - Config - Update Application schema > syntax.jpg

if no errors are found, the queries are checked against a list of allowed query rules, as follows:
- The changes are allowed only on specific tables in the Analysis schema (those with the "ci_" prefix) and temporary tables (with "maint_tmp_" prefix)
- SELECT - it is permitted to select from any table. If select is used with a function, then only the "droptemporarytable" function is allowed and only with a temporary table name parameter
- INSERT INTO - insertion is permitted only into Analysis schema tables or temporary tables
- UPDATE / DELETE - only temporary table records can be updated or deleted
- CREATE TABLE / DROP TABLE - only temporary tables can be created or deleted
- Only statements mentioned in this list are allowed
- Subqueries are also validated
finally, the data in the tool is saved.

Changes made

Any changes made in the Update Application schema page (e.g. adding a new tool job) will cause a banner to appear at the top:

This indicates that the changes you have made will impact your analysis results and therefore that the data that is used for the Architecture Studio, Transaction configuration and upload to CAST Imaging will not be up-to-date. Clicking the Update button in the banner will run a special step called Prepare analysis data that should complete relatively quickly (more quickly than a full analysis or snapshot) and ensures that the data used by the Architecture Studio, Transaction configuration and upload to CAST Imaging is up-to-date based on the changes you have made.

CAST AIP Console > Application - Config - Update Application schema > prepare_ana_data.jpg

This step is always actioned when you either run an analysis (without a snapshot) or generate a new snapshot. When the Prepare analysis data step is complete, the banner will no longer be displayed.