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 InitializeTabularDataView
! SUBROUTINE INFORMATION:
! AUTHOR Kyle Benne
! DATE WRITTEN January 2010
! MODIFIED na
! RE-ENGINEERED na
! PURPOSE OF THIS SUBROUTINE:
! This subroutine initializes the TabularDataView in the database.
! This view is created in a separate subroutine because it is only
! created when SQLITE tabular reports are created.
! This 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 TabularDataWithStrings AS SELECT ' &
//'td.Value Value, ' &
//'reportn.Value ReportName, ' &
//'fs.Value ReportForString, ' &
//'tn.Value TableName, ' &
//'rn.Value RowName, ' &
//'cn.Value ColumnName, ' &
//'u.Value Units, ' &
//'RowId ' &
//'FROM TabularData td ' &
//'INNER JOIN Strings reportn ON reportn.StringIndex=td.ReportNameIndex ' &
//'INNER JOIN Strings fs ON fs.StringIndex=td.ReportForStringIndex ' &
//'INNER JOIN Strings tn ON tn.StringIndex=td.TableNameIndex ' &
//'INNER JOIN Strings rn ON rn.StringIndex=td.RowNameIndex ' &
//'INNER JOIN Strings cn ON cn.StringIndex=td.ColumnNameIndex ' &
//'INNER JOIN Strings u ON u.StringIndex=td.UnitsIndex ' &
//'WHERE ' &
//'reportn.StringTypeIndex=1 AND ' &
//'fs.StringTypeIndex=2 AND ' &
//'tn.StringTypeIndex=3 AND ' &
//'rn.StringTypeIndex=4 AND ' &
//'cn.StringTypeIndex=5 AND ' &
//'u.StringTypeIndex=6;')
END SUBROUTINE InitializeTabularDataView