Missing tables and procedures for Shell - 1.0
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 | ✅ |
Transactions
Transaction support is derived from metamodel concepts used to build CAST Imaging Blueprint and structural transaction flows. Entry Points start transactions; Exit Points include both output/boundary concepts and Data Entities manipulated by transactions.
| Role | Support | Breakdown |
|---|---|---|
| Entry Point | No direct concept type details | |
| Exit Point |
Data Entity with Accurate FP
|
Data version: 1.0.4-funcrel
ISO 5055 Structural Rules
Quality support is based on ISO 5055 structural rules available for the selected extension version.
| Reliability | Maintainability | Security | Performance Efficiency |
|---|---|---|---|
Data version: 1.0.4-funcrel
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). Embedded tables were introduced in version 3.8.0-funcrel and system table in 3.8.1-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 |
|
Embedded Schema | Parent of the embedded tables, attached to the Shell Project. | CAST_Shell_EmbeddedTable_Schema |
|
Embedded Table | A table created/dropped/altered/replaced/renamed/declared in a Shell SQL Query missing from the DDL file. | CAST_Shell_EmbeddedTable_Table |
|
System Schema | Parent of the system tables, attached to the Shell Project. | CAST_Shell_SystemTable_Schema |
|
System Table | A system table or a system view selected/updated/deleted/inserted in a Shell SQL Query missing from the DDL file. | CAST_Shell_SystemTable_Table |
|
SQL System Table | A system table or a system 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_System_Table |
Links
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 Embedded Table / Missing Table / System Table / SQL Missing Table / SQL System Table
- call from Shell SQL Query to Missing Procedure/SQL Missing Procedure
- ddl/ddlCreate/ddlDrop/ddlAlter/ddlReplace from Shell SQL Query to Embedded Table