Nodes of different colours represent the following:
Solid arrows point from a procedure to one which it calls. Dashed arrows point from an interface to procedures which implement that interface. This could include the module procedures in a generic interface or the implementation in a submodule of an interface in a parent module. Where possible, edges connecting nodes are given different colours to make them easier to distinguish in large graphs.
Nodes of different colours represent the following:
Solid arrows point from a procedure to one which it calls. Dashed arrows point from an interface to procedures which implement that interface. This could include the module procedures in a generic interface or the implementation in a submodule of an interface in a parent module. Where possible, edges connecting nodes are given different colours to make them easier to distinguish in large graphs.
SUBROUTINE InitializeViews
! SUBROUTINE INFORMATION:
! AUTHOR Greg Stark
! DATE WRITTEN May 2009
! MODIFIED na
! RE-ENGINEERED na
! PURPOSE OF THIS SUBROUTINE:
! This subroutine initializes views in the database
! Makes end use of the database easier for those unfamiliar
! with SQL queries.
! METHODOLOGY EMPLOYED:
! Standard SQL92 queries and commands via the Fortran SQLite3 API
! REFERENCES:
! na
! USE STATEMENTS:
! na
IMPLICIT NONE ! Enforce explicit typing of all variables in this routine
! SUBROUTINE ARGUMENT DEFINITIONS:
! na
! SUBROUTINE PARAMETER DEFINITIONS:
! na
! INTERFACE BLOCK SPECIFICATIONS:
! na
! DERIVED TYPE DEFINITIONS:
! na
! SUBROUTINE LOCAL VARIABLE DECLARATIONS:
INTEGER :: result
result = SQLiteExecuteCommandMacro ( &
'CREATE VIEW ReportVariableWithTime ' &
//'AS ' &
//'SELECT ReportVariableData.*, Time.*, ReportVariableDataDictionary.*, ReportVariableExtendedData.* ' &
//'FROM ' &
//'ReportVariableData LEFT OUTER JOIN ReportVariableExtendedData ' &
//'INNER JOIN Time ' &
//'INNER JOIN ReportVariableDataDictionary ' &
//'ON ' &
//'(ReportVariableData.ReportVariableExtendedDataIndex ' &
//'= ReportVariableExtendedData.ReportVariableExtendedDataIndex) ' &
//'AND ' &
//'(ReportVariableData.TimeIndex = Time.TimeIndex) ' &
//'AND ' &
//'(ReportVariableDataDictionary.ReportVariableDataDictionaryIndex ' &
//'= ReportVariableData.ReportVariableDataDictionaryIndex);')
END SUBROUTINE InitializeViews