Page tree
Skip to end of metadata
Go to start of metadata
Purpose

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.
Applicable in CAST Version


Release
Yes/No
8.3.x(tick) 
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (tick)
Microsoft SQL Server (tick)
CSS (tick)
Details

 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


Notes/comments




  • No labels