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 InitializeTabularDataTable
! SUBROUTINE INFORMATION:
! AUTHOR Kyle Benne
! DATE WRITTEN January 2010
! MODIFIED na
! RE-ENGINEERED na
! PURPOSE OF THIS SUBROUTINE:
! This subroutine initializes the TabularData SQL table
! 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 TabularData " &
//"(ReportNameIndex INTEGER, " &
//"ReportForStringIndex INTEGER, " &
//"TableNameIndex INTEGER, " &
//"SimulationIndex INTEGER, " &
//"RowNameIndex INTEGER, " &
//"ColumnNameIndex INTEGER, " &
//"RowId INTEGER, " &
//"ColumnId INTEGER, " &
//"Value TEXT, " &
//"UnitsIndex INTEGER);")
result = SQLitePrepareStatementMacro(TabularDataInsertStmt, "INSERT INTO TabularData VALUES(?,?,?,?,?,?,?,?,?,?);")
result = SQLiteExecuteCommandMacro("CREATE TABLE Strings " &
//"(StringIndex INTEGER PRIMARY KEY, " &
//"StringTypeIndex INTEGER, " &
//"Value TEXT);")
result = SQLitePrepareStatementMacro(StringsInsertStmt, "INSERT INTO Strings (StringTypeIndex,Value) VALUES(?,?);")
result = SQLitePrepareStatementMacro(StringsLookUpStmt, "SELECT StringIndex FROM Strings " &
//"WHERE StringTypeIndex=? AND Value=?;")
result = SQLiteExecuteCommandMacro("CREATE TABLE StringTypes " &
//"(StringTypeIndex INTEGER PRIMARY KEY, " &
//"Value TEXT);")
result = SQLiteExecuteCommandMacro("INSERT INTO StringTypes VALUES("// ReportNameId //",'ReportName');")
result = SQLiteExecuteCommandMacro("INSERT INTO StringTypes VALUES("// ReportForStringId //",'ReportForString');")
result = SQLiteExecuteCommandMacro("INSERT INTO StringTypes VALUES("// TableNameId //",'TableName');")
result = SQLiteExecuteCommandMacro("INSERT INTO StringTypes VALUES("// RowNameId //",'RowName');")
result = SQLiteExecuteCommandMacro("INSERT INTO StringTypes VALUES("// ColumnNameId //",'ColumnName');")
result = SQLiteExecuteCommandMacro("INSERT INTO StringTypes VALUES("// UnitsId //",'Units');")
END SUBROUTINE InitializeTabularDataTable