Missing tables and procedures for Node.js (JavaScript, TypeScript) - 1.0
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 |
Data Entity with Accurate FP
|
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
| Icon | Object Type | Description | Metamodel Type |
|---|---|---|---|
 |
Missing Schema | Parent of the missing tables and procedures, attached to the Node.js (JavaScript, TypeScript)/ HTML5 Project. | CAST_NodeJS_MissingTable_Schema |
 |
Missing Table | A table or a view selected/updated/deleted/inserted in a Node.js (JavaScript, TypeScript)/ HTML5 Query missing from the DDL file. | CAST_NodeJS_MissingTable_Table |
 |
Missing Procedure | A procedure or a function called in a Node.js (JavaScript, TypeScript)/ HTML5 Query missing from the DDL file. | CAST_NodeJS_MissingTable_Procedure |
|
SQL Missing Table | A table or a view selected/updated/deleted/inserted in a Node.js (JavaScript, TypeScript)/ HTML5 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 Node.js (JavaScript, TypeScript)/ HTML5 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 Node.js (JavaScript, TypeScript)/ HTML5 Project. | CAST_NodeJS_EmbeddedTable_Schema |
|
Embedded Table | A table created/dropped/altered/replaced/renamed/declared in a Node.js (JavaScript, TypeScript)/ HTML5 Query missing from the DDL file. | CAST_NodeJS_EmbeddedTable_Table |
Links
Links are created for transaction and function point needs. You can expect the following links on the Node.js / HTML5 Embedded SQL queries:
- useSelect/useUpdate/useDelete/useInsert from Node.js (JavaScript, TypeScript) / HTML5 Query to Embedded Table/Missing Table/SQL Missing Table
- call from Node.js (JavaScript, TypeScript) / HTML5 Query to Missing Procedure/SQL Missing Procedure
- ddl/ddlCreate/ddlDrop/ddlAlter/ddlReplace from Node.js (JavaScript, TypeScript)/ HTML5 Query to Embedded Table