Missing tables and procedures for C and Cpp - 1.0

Extension ID

com.castsoftware.cpp.missingtable

What’s new?

Please see Missing tables and procedures for C and CPP - 1.0 - Release Notes for more information.

Description

This extension is designed to analyze SQL queries embedded in C/C++ code and create “missing” SQL and C/C++ 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 C/C++ code, even if none or only part of the referenced SQL objects are delivered for analysis.

AIP Core compatibility

This extension is compatible with:

AIP Core release Supported
8.3.x (tick)

Supported DBMS servers

DBMS Supported?
CAST Storage Service / PostgreSQL (tick)

Supported client languages

Language Supported?
C/C++ (tick)

Prerequisites

Item Description
(tick) An installation of any compatible release of AIP Core (see table above)
(tick) An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.6.9-funcrel)

Download and installation instructions

The extension will be automatically downloaded and installed in CAST Console when C/C++ 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 C/C++ Project. CAST_CPP_MissingTable_Schema

Missing Table A table or a view selected/updated/deleted/inserted in a C/C++ Query missing from the DDL file.

CAST_CPP_MissingTable_Table

Missing Procedure A procedure or a function called in a C/C++ Query missing from the DDL file. CAST_CPP_MissingTable_Procedure

SQL Missing Table A table or a view selected/updated/deleted/inserted in a C/C++ 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 C/C++ 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 C/C++ Embedded SQL queries:

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