SQL Queries - CAST Knowledge Base - Queries on metrics and diagnostics - How to get the Number of code lines at application or system level in the Knowledge Base

This page explains how to get the number of code lines at application/system level in the knowledge Base. The page is relevant for the following cases:

• One application with more than one module.
• One system with more than one application.
• One system with one application containing more than one module.

 If the Number of code line is calculated at the System level

PLEASE NOTE:  THE QUERIES BELOW ARE ONLY VALID IN CAST AIP 8.3.36 AND BELOW.  FOR CAST AIP 8.3.37 AND ABOVE YOU MUST MODIFY THE QUERIES AS FOLLOWS:

• change references:
  • properties = 0
• to
  • properties & 255 = 0

1. Get the list of APPLICATION_ID(s) belonging to the identified system:on Central base

   SELECT site_object_id
   FROM dss_translation_table
   WHERE object_id IN (SELECT module_id
   FROM dss_central_selection where application_id
   IN (SELECT next_object_id
   FROM dss_links
   WHERE
   previous_object_id IN (SELECT
   object_id
   FROM
   dss_objects
   WHERE
   object_name LIKE '<system_name>' )
   )
   )

   For example:

   SELECT site_object_id
   FROM dss_translation_table
   WHERE object_id IN (SELECT module_id
   FROM dss_central_selection where application_id
   IN (SELECT next_object_id
   FROM dss_links
   WHERE
   previous_object_id IN (SELECT
   object_id
   FROM
   dss_objects
   WHERE
   object_name LIKE '%My System%' )
   )
   )
   -- 95510
   --174003

2. Query for Number Of Code Lines on Knowledge base: 

   
   

   SELECT SUM(infval)
   FROM   objinf
   WHERE  idobj IN (SELECT DISTINCT ( object_id )
                    FROM   ctt_object_applications
                    WHERE  application_id IN (list of APPLICATION_ID)
                           AND properties = 0)
          AND inftyp = 1
          AND infsubtyp = 0

   For example:

   SELECT SUM(infval)
   FROM   objinf
   WHERE  idobj IN (SELECT DISTINCT ( object_id )
                    FROM   ctt_object_applications
                    WHERE  application_id IN (95510, 174003)
                           AND properties = 0)
          AND inftyp = 1
          AND infsubtyp = 0

If the Number of code lines is calculated at Application level

1. Get list of APPLICATION_ID(s) belonging to the identified Application on Central base:

   SELECT object_id
   FROM   dss_objects
   WHERE  object_id IN (SELECT module_id
                        FROM   dss_central_selection
                        WHERE  application_id IN (SELECT object_id
                                                  FROM   dss_objects where OBJECT_NAME like'<application_name>'))

   For example:

    SELECT object_id
   FROM   dss_objects
   WHERE  object_id IN (SELECT module_id
                        FROM   dss_central_selection
                        WHERE  application_id IN (SELECT object_id
                                                  FROM   dss_objects where OBJECT_NAME like'%cpp%'))
   --5652
   --5702

2. Query for Number of code Lines on Knowledge base:
   
   

   SELECT SUM(infval)
   FROM   objinf
   WHERE  idobj IN (SELECT DISTINCT ( object_id )
                    FROM   ctt_object_applications
                    WHERE  application_id IN (list of APPLICATION_ID)
                           AND properties = 0)
          AND inftyp = 1
          AND infsubtyp = 0

   For example:

   SELECT SUM(infval)
   FROM   objinf
   WHERE  idobj IN (SELECT DISTINCT ( object_id )
                    FROM   ctt_object_applications
                    WHERE  application_id IN (5652,5702)
                           AND properties = 0)
          AND inftyp = 1
          AND infsubtyp = 0

 CAST Engineering Dashboard - Metrics - Lines of code - Unexpected increase or decrease