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 InitializeReportVariableDataTables
! SUBROUTINE INFORMATION:
! AUTHOR Greg Stark
! DATE WRITTEN July 2008
! MODIFIED January 2010, Kyle Benne
! Naming cleanup and add reference to EnvironmentPeriod
! table
! RE-ENGINEERED na
! PURPOSE OF THIS SUBROUTINE:
! This subroutine initializes the .eso data SQL tables
! 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 TABLE ReportVariableData (' &
//'TimeIndex INTEGER, ' &
//'ReportVariableDataDictionaryIndex INTEGER, ' &
//'VariableValue REAL, ' &
//'ReportVariableExtendedDataIndex INTEGER);')
result = SQLitePrepareStatementMacro(ReportVariableDataInsertStmt, &
'INSERT INTO ReportVariableData (' &
//'TimeIndex, ' &
//'ReportVariableDataDictionaryIndex, ' &
//'VariableValue, ' &
//'ReportVariableExtendedDataIndex) ' &
//'VALUES(?,?,?,?);')
result = SQLiteExecuteCommandMacro( &
'CREATE TABLE ReportVariableExtendedData (' &
//'ReportVariableExtendedDataIndex INTEGER PRIMARY KEY, ' &
//'MaxValue REAL, ' &
//'MaxMonth INTEGER, ' &
//'MaxDay INTEGER, ' &
//'MaxHour INTEGER, ' &
//'MaxStartMinute INTEGER, ' &
//'MaxMinute INTEGER, ' &
//'MinValue REAL, ' &
//'MinMonth INTEGER, ' &
//'MinDay INTEGER, ' &
//'MinHour INTEGER, ' &
//'MinStartMinute INTEGER, ' &
//'MinMinute INTEGER);')
result = SQLitePrepareStatementMacro(ReportVariableExtendedDataInsertStmt, &
'INSERT INTO ReportVariableExtendedData (' &
//'ReportVariableExtendedDataIndex, ' &
//'MaxValue, ' &
//'MaxMonth, ' &
//'MaxDay, ' &
//'MaxHour, ' &
//'MaxStartMinute, ' &
//'MaxMinute, ' &
//'MinValue, ' &
//'MinMonth, ' &
//'MinDay, ' &
//'MinHour, ' &
//'MinStartMinute, ' &
//'MinMinute) ' &
//'VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);')
END SUBROUTINE InitializeReportVariableDataTables