Missing tables and procedures for Node.js (JavaScript, TypeScript) - 1.0

Compatibility:

What's new? Release Notes

ID: com.castsoftware.nodejs.missingtable

Description

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

Supported client languages

Language	Supported?
JavaScript	✅
TypeScript	✅
HTML5	✅

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		Procedure Data Entity with Accurate FP Table Data Entities SQL Table - Unresolved

Data version: 1.0.7-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.7-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.6.10-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 Node.js / HTML5 source code is delivered for analysis. You can manage it using the Application - Extensions interface.

What results can you expect?

Objects

Type	Name	Description
	Embedded Procedure	Represents a procedure or function declared or created in a Node.js, JavaScript, TypeScript, or HTML5 query when it is missing from the analyzed DDL files.
	Missing Procedure	Represents a procedure or function called by a Node.js, JavaScript, TypeScript, or HTML5 query but missing from the analyzed DDL files.
	SQL Missing Procedure	Represents a missing procedure or function called by a Node.js, JavaScript, TypeScript, or HTML5 query when exactly one SQL schema is available.
	Embedded Schema	Parent of embedded tables and procedures, attached to the Node.js, JavaScript, TypeScript, or HTML5 project.
	Missing Schema	Parent of missing tables and procedures, attached to the Node.js, JavaScript, TypeScript, or HTML5 project.
	System Schema	Parent of system tables, attached to the Node.js, JavaScript, TypeScript, or HTML5 project.
	Embedded Table	Represents a table created, dropped, altered, replaced, renamed, or declared in a Node.js, JavaScript, TypeScript, or HTML5 query when it is missing from the analyzed DDL files.
	Missing Table	Represents a table or view referenced by a Node.js, JavaScript, TypeScript, or HTML5 query but missing from the analyzed DDL files.
	SQL Missing Table	Represents a missing table or view referenced by a Node.js, JavaScript, TypeScript, or HTML5 query when exactly one SQL schema is available.
	System Table	Represents a system table or view referenced by a Node.js, JavaScript, TypeScript, or HTML5 query but missing from the analyzed DDL files.
	SQL System Table	Represents a system table or view referenced by a Node.js, JavaScript, TypeScript, or HTML5 query when exactly one SQL schema is available.