Missing tables and procedures for Shell - 1.0

Compatibility: v2 v3 Cloud
What's new? Release Notes
ID: com.castsoftware.shell.missingtable

Description

This extension is designed to analyze SQL queries embedded in Shell code and create “missing” SQL and Shell table / procedure objects to represent SQL objects that have not been delivered for analysis. Links to these objects are also created. The primary goal of the extension is to ensure that a full transaction is identified by CAST, resulting from the SQL queries embedded in the Shell code, even if none or only part of the referenced SQL objects are delivered for analysis.

Supported client languages

Language Supported?
SHELL ✅

Function Point, Quality and Sizing support

  • Function Points (transactions): a green tick indicates that OMG Function Point counting and Transaction Risk Index are supported
  • Quality and Sizing: a green tick indicates that CAST can measure size and that a minimum set of Quality Rules exist
Function Points (transactions) Quality and Sizing
✅ ❌

Prerequisites

Item Description
✅ An installation of any compatible release of CAST Core (see table above)
✅ An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.7.14-funcrel)

Download and installation instructions

The extension will be automatically downloaded and installed in CAST Console when SHELL source code is delivered for analysis. You can manage it using the Application - Extensions interface.

What results can you expect?

Objects

Icon Object Type Description Metamodel Type
Missing Schema Parent of the missing tables and procedures, attached to the Shell Project. CAST_Shell_MissingTable_Schema
Missing Table A table or a view selected/updated/deleted/inserted in a Shell SQL Query missing from the DDL file. CAST_Shell_MissingTable_Table
Missing Procedure A procedure or a function called in a Shell SQL Query missing from the DDL file. CAST_Shell_MissingTable_Procedure
SQL Missing Table A table or a view selected/updated/deleted/inserted in a Shell SQL Query missing from the DDL file, but we have a SQL Schema, and only one. SQLScript_Missing_Table
SQL Missing Procedure A procedure or a function called in a Shell SQL Query missing from the DDL file but we have a SQL Schema, and only one. SQLScript_Missing_Procedure

Links are created for transaction and function point needs. You can expect the following links on the SHELL Embedded SQL queries:

  • useSelect/useUpdate/useDelete/useInsert from Shell SQL Query to Missing Table/SQL Missing Table
  • call from Shell SQL Query to Missing Procedure/SQL Missing Procedure