SQLiteProcedures – EnergyPlusFortran

Uses:
DataInterfaces

Used By

Subroutines

Variables

Type	Visibility	Attributes		Name		Initial
integer,	public,	parameter	::	LocalReportEach	=	-1
integer,	public,	parameter	::	LocalReportTimeStep	=	0
integer,	public,	parameter	::	LocalReportHourly	=	1
integer,	public,	parameter	::	LocalReportDaily	=	2
integer,	public,	parameter	::	LocalReportMonthly	=	3
integer,	public,	parameter	::	LocalReportSim	=	4
integer,	public,	parameter	::	ReportVariableDataInsertStmt	=	1
integer,	public,	parameter	::	ReportVariableExtendedDataInsertStmt	=	2
integer,	public,	parameter	::	TimeIndexInsertStmt	=	3
integer,	public,	parameter	::	ReportVariableDictionaryInsertStmt	=	4
integer,	public,	parameter	::	ZoneInfoInsertStmt	=	7
integer,	public,	parameter	::	NominalLightingInsertStmt	=	8
integer,	public,	parameter	::	NominalElectricEquipmentInsertStmt	=	9
integer,	public,	parameter	::	NominalGasEquipmentInsertStmt	=	10
integer,	public,	parameter	::	NominalSteamEquipmentInsertStmt	=	11
integer,	public,	parameter	::	NominalHotWaterEquipmentInsertStmt	=	12
integer,	public,	parameter	::	NominalOtherEquipmentInsertStmt	=	13
integer,	public,	parameter	::	NominalBaseboardHeatInsertStmt	=	14
integer,	public,	parameter	::	SurfaceInsertStmt	=	15
integer,	public,	parameter	::	ConstructionInsertStmt	=	16
integer,	public,	parameter	::	ConstructionLayerInsertStmt	=	17
integer,	public,	parameter	::	MaterialInsertStmt	=	18
integer,	public,	parameter	::	ZoneListInsertStmt	=	19
integer,	public,	parameter	::	ZoneGroupInsertStmt	=	20
integer,	public,	parameter	::	InfiltrationInsertStmt	=	21
integer,	public,	parameter	::	VentilationInsertStmt	=	22
integer,	public,	parameter	::	NominalPeopleInsertStmt	=	23
integer,	public,	parameter	::	ZoneSizingInsertStmt	=	24
integer,	public,	parameter	::	SystemSizingInsertStmt	=	25
integer,	public,	parameter	::	ComponentSizingInsertStmt	=	26
integer,	public,	parameter	::	RoomAirModelInsertStmt	=	27
integer,	public,	parameter	::	GroundTemperatureInsertStmt	=	28
integer,	public,	parameter	::	WeatherFileInsertStmt	=	29
integer,	public,	parameter	::	MeterDictionaryInsertStmt	=	30
integer,	public,	parameter	::	ReportMeterDataInsertStmt	=	31
integer,	public,	parameter	::	MeterExtendedDataInsertStmt	=	32
integer,	public,	parameter	::	ScheduleInsertStmt	=	33
integer,	public,	parameter	::	DaylightMapTitleInsertStmt	=	34
integer,	public,	parameter	::	DaylightMapHorlyTitleInsertStmt	=	35
integer,	public,	parameter	::	DaylightMapHorlyDataInsertStmt	=	36
integer,	public,	parameter	::	EnvironmentPeriodInsertStmt	=	37
integer,	public,	parameter	::	SimulationsInsertStmt	=	38
integer,	public,	parameter	::	TabularDataInsertStmt	=	39
integer,	public,	parameter	::	StringsInsertStmt	=	40
integer,	public,	parameter	::	StringsLookUpStmt	=	41
integer,	public,	parameter	::	ErrorInsertStmt	=	42
integer,	public,	parameter	::	ErrorUpdateStmt	=	43
integer,	public,	parameter	::	SimulationUpdateStmt	=	44
integer,	public,	parameter	::	CommandBufferSize	=	4096
integer,	public,	parameter	::	MaxMessageSize	=	4096
character(len=1),	public,	parameter	::	ReportNameId	=	'1'
character(len=1),	public,	parameter	::	ReportForStringId	=	'2'
character(len=1),	public,	parameter	::	TableNameId	=	'3'
character(len=1),	public,	parameter	::	RowNameId	=	'4'
character(len=1),	public,	parameter	::	ColumnNameId	=	'5'
character(len=1),	public,	parameter	::	UnitsId	=	'6'
logical,	public,	SAVE	::	WriteOutputToSQLite	=	.FALSE.
logical,	public,	SAVE	::	WriteTabularDataToSQLite	=	.FALSE.
integer,	public		::	SQLdbTimeIndex	=	0
integer,	public,	parameter	::	SQLITE_ROW	=	100

Interfaces

interface

public function SQLiteOpenDatabase(dbNameBuffer) bind(C, NAME="SQLiteOpenDatabase")

Arguments

Type Intent Optional Attributes Name

type(C_PTR), VALUE :: dbNameBuffer

Return Value integer(kind=C_INT)

Type	Intent	Optional	Attributes		Name
type(C_PTR),			VALUE	::	dbNameBuffer

interface

public function SQLiteExecuteCommand(commandBuffer) bind(C, NAME="SQLiteExecuteCommand")

Arguments

Type Intent Optional Attributes Name

type(C_PTR), VALUE :: commandBuffer

Return Value integer(kind=C_INT)

Type	Intent	Optional	Attributes		Name
type(C_PTR),			VALUE	::	commandBuffer

interface

public function SQLiteCloseDatabase(commandBuffer, commandLength) bind(C, NAME="SQLiteCloseDatabase")

Arguments

Type Intent Optional Attributes Name

type(C_PTR), VALUE :: commandBuffer

integer(kind=C_INT), VALUE :: commandLength

Return Value integer(kind=C_INT)

Type	Intent	Optional	Attributes		Name
type(C_PTR),			VALUE	::	commandBuffer
integer(kind=C_INT),			VALUE	::	commandLength

interface

public function SQLitePrepareStatement(stmtType, stmtBuffer) bind(C, NAME="SQLitePrepareStatement")

Arguments

Type Intent Optional Attributes Name

integer(kind=C_INT), VALUE :: stmtType

type(C_PTR), VALUE :: stmtBuffer

Return Value integer(kind=C_INT)

interface

public function SQLiteColumnInt(stmtType, iCol) bind(C, NAME="SQLiteColumnInt")

Arguments

Type Intent Optional Attributes Name

integer(kind=C_INT), VALUE :: stmtType

integer(kind=C_INT), VALUE :: iCol

Return Value integer(kind=C_INT)

interface

public function SQLiteBindText(stmtType, stmtInsertLocationIndex, textBuffer) bind(C, NAME="SQLiteBindText")

Arguments

Type	Attributes		Name
integer(kind=C_INT),	VALUE	::	stmtType
integer(kind=C_INT),	VALUE	::	stmtInsertLocationIndex
type(C_PTR),	VALUE	::	textBuffer

Return Value integer(kind=C_INT)

interface

public function SQLiteBindInteger(stmtType, stmtInsertLocationIndex, intToInsert) bind(C, NAME="SQLiteBindInteger")

Arguments

Type	Attributes		Name
integer(kind=C_INT),	VALUE	::	stmtType
integer(kind=C_INT),	VALUE	::	stmtInsertLocationIndex
integer(kind=C_INT),	VALUE	::	intToInsert

Return Value integer(kind=C_INT)

interface

public function SQLiteBindDouble(stmtType, stmtInsertLocationIndex, doubleToInsert) bind(C, NAME="SQLiteBindDouble")

Arguments

Type	Attributes		Name
integer(kind=C_INT),	VALUE	::	stmtType
integer(kind=C_INT),	VALUE	::	stmtInsertLocationIndex
real(kind=C_DOUBLE),	VALUE	::	doubleToInsert

Return Value integer(kind=C_INT)

interface

public function SQLiteBindNULL(stmtType, stmtInsertLocationIndex) bind(C, NAME="SQLiteBindNULL")

Arguments

Type Intent Optional Attributes Name

integer(kind=C_INT), VALUE :: stmtType

integer(kind=C_INT), VALUE :: stmtInsertLocationIndex

Return Value integer(kind=C_INT)

interface

public function SQLiteStepCommand(stmtType) bind(C, NAME="SQLiteStepCommand")

Arguments

Type Intent Optional Attributes Name

integer(kind=C_INT), VALUE :: stmtType

Return Value integer(kind=C_INT)

interface

public function SQLiteResetCommand(stmtType) bind(C, NAME="SQLiteResetCommand")

Arguments

Type Intent Optional Attributes Name

integer(kind=C_INT), VALUE :: stmtType

Return Value integer(kind=C_INT)

interface

public function SQLiteClearBindings(stmtType) bind(C, NAME="SQLiteClearBindings")

Arguments

Type Intent Optional Attributes Name

integer(kind=C_INT), VALUE :: stmtType

Return Value integer(kind=C_INT)

interface

public function SQLiteFinalizeCommand(stmtType) bind(C, NAME="SQLiteFinalizeCommand")

Arguments

Type Intent Optional Attributes Name

integer(kind=C_INT), VALUE :: stmtType

Return Value integer(kind=C_INT)

interface

public function SQLiteWriteMessage(messageBuffer) bind(C, NAME="SQLiteWriteMessage")

Arguments

Type Intent Optional Attributes Name

type(C_PTR), VALUE :: messageBuffer

Return Value integer(kind=C_INT)

Type	Intent	Optional	Attributes		Name
type(C_PTR),			VALUE	::	messageBuffer

Functions

public function CreateSQLiteStringTableRecord(stringValue, stringType) result(iOut)

Arguments

Type	Intent	Optional	Attributes		Name
character(len=*),	intent(in)			::	stringValue
character,	intent(in)			::	stringType

Return Value integer

public function CreateSQLiteTimeIndexRecord(reportingInterval, recordIndex, CumlativeSimulationDays, Month, DayOfMonth, Hour, EndMinute, StartMinute, DST, DayType) result(iOut)

Arguments

Type	Intent	Optional		Name
integer,	intent(in)		::	reportingInterval
integer,	intent(in)		::	recordIndex
integer,	intent(in)		::	CumlativeSimulationDays
integer,	intent(in),	optional	::	Month
integer,	intent(in),	optional	::	DayOfMonth
integer,	intent(in),	optional	::	Hour
real(kind=r64),	intent(in),	optional	::	EndMinute
real(kind=r64),	intent(in),	optional	::	StartMinute
integer,	intent(in),	optional	::	DST
character(len=*),	intent(in),	optional	::	DayType

Return Value integer

private function SQLiteExecuteCommandMacro(sqlStmt) result(iOut)

Arguments

Type	Intent	Optional	Attributes		Name
character(len=*),	intent(in)			::	sqlStmt

Return Value integer

private function SQLitePrepareStatementMacro(stmtIndex, sqlStmt) result(iOut)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(in)			::	stmtIndex
character(len=*),	intent(in)			::	sqlStmt

Return Value integer

public function SQLiteColumnIntMacro(stmtType, iCol) result(iOut)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(in)			::	stmtType
integer,	intent(in)			::	iCol

Return Value integer

private function SQLiteBindTextMacro(stmtIndex, columnIndex, sqlStmt) result(iOut)

Arguments

Type	Intent		Name
integer,	intent(in)	::	stmtIndex
integer,	intent(in)	::	columnIndex
character(len=*),	intent(in)	::	sqlStmt

Return Value integer

private function SQLiteOpenDatabaseMacro(sqlStmt) result(iOut)

Arguments

Type	Intent	Optional	Attributes		Name
character(len=*),	intent(in)			::	sqlStmt

Return Value integer

private function SQLiteBindLogicalMacro(stmtIndex, columnIndex, valueToInsert) result(iOut)

Arguments

Type	Intent		Name
integer,	intent(in)	::	stmtIndex
integer,	intent(in)	::	columnIndex
logical,	intent(in)	::	valueToInsert

Return Value integer

private function LogicalToInteger(value) result(iOut)

Arguments

Type	Intent	Optional	Attributes		Name
logical,	intent(in)			::	value

Return Value integer

private function CreatExtBooundCondName(boundaryConditionType, currentName) result(cOut)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(in)			::	boundaryConditionType
character(len=*),	intent(in)			::	currentName

Return Value character(len=MaxNameLength)

private function GetUnitsString(VariableName) result(ThisUnitsString)

! Errors here are fatal because should only be encountered during development.

Arguments

Type	Intent	Optional	Attributes		Name
character(len=*),	intent(in)			::	VariableName

Return Value character(len=len(VariableName))

private function ReportingFreqName(reportingFreqIndex) result(freqName)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(in)			::	reportingFreqIndex

Return Value character(len=100)

private function TimestepTypeName(timestepType) result(name)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(in)			::	timestepType

Return Value character(len=100)

private function StorageType(storageTypeIndex) result(name)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(in)			::	storageTypeIndex

Return Value character(len=100)

Subroutines

public subroutine SQLiteBegin()

Arguments

None

public subroutine SQLiteCommit()

Arguments

None

public subroutine CreateSQLiteDatabase()

Arguments

None

private subroutine InitializeSQLiteTables()

Arguments

None

private subroutine InitializeViews()

Arguments

None

public subroutine InitializeTabularDataView()

Arguments

None

public subroutine InitializeIndexes()

Arguments

None

public subroutine InitializeSimulationsTable()

Arguments

None

public subroutine CreateSQLiteSimulationsRecord(ID)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(in)			::	ID

public subroutine UpdateSQLiteSimulationRecord(completed, completedSuccessfully)

Arguments

Type	Intent	Optional	Attributes		Name
logical,	intent(in)			::	completed
logical,	intent(in)			::	completedSuccessfully

public subroutine InitializeTabularDataTable()

Arguments

None

public subroutine CreateSQLiteTabularDataRecords(body, rowLabels, columnLabels, ReportName, ReportForString, TableName)

Arguments

Type	Intent	Attributes		Name
character(len=*),	intent(in),	DIMENSION(:,:)	::	body
character(len=*),	intent(in),	DIMENSION(:)	::	rowLabels
character(len=*),	intent(in),	DIMENSION(:)	::	columnLabels
character(len=*),	intent(in)		::	ReportName
character(len=*),	intent(in)		::	ReportForString
character(len=*),	intent(in)		::	TableName

private subroutine InitializeTimeIndicesTable()

Arguments

None

private subroutine InitializeReportVariableDataDictionaryTable()

Arguments

None

public subroutine CreateSQLiteReportVariableDictionaryRecord(reportVariableReportID, storeTypeIndex, indexGroup, keyedValueString, variableName, indexType, units, reportingFreq, scheduleName)

Arguments

Type	Intent	Optional		Name
integer,	intent(in)		::	reportVariableReportID
integer,	intent(in)		::	storeTypeIndex
character(len=*),	intent(in)		::	indexGroup
character(len=*),	intent(in)		::	keyedValueString
character(len=*),	intent(in)		::	variableName
integer,	intent(in)		::	indexType
character(len=*),	intent(in)		::	units
integer,	intent(in)		::	reportingFreq
character(len=*),	intent(in),	optional	::	scheduleName

public subroutine InitializeEnvironmentPeriodsTable()

Arguments

None

public subroutine CreateSQLiteEnvironmentPeriodRecord()

Arguments

None

private subroutine InitializeReportVariableDataTables()

Arguments

None

public subroutine CreateSQLiteReportVariableDataRecord(recordIndex, timeIndex, value, reportingInterval, minValue, minValueDate, maxValue, maxValueDate, minutesPerTimeStep)

Arguments

Type	Intent	Optional		Name
integer,	intent(in)		::	recordIndex
integer,	intent(in)		::	timeIndex
real(kind=r64),	intent(in)		::	value
integer,	intent(in),	optional	::	reportingInterval
real(kind=r64),	intent(in),	optional	::	minValue
integer,	intent(in),	optional	::	minValueDate
real(kind=r64),	intent(in),	optional	::	maxValue
integer,	intent(in),	optional	::	maxValueDate
integer,	intent(in),	optional	::	minutesPerTimeStep

public subroutine CreateZoneExtendedOutput()

Arguments

None

private subroutine InitializeZoneInfoTable()

Arguments

None

private subroutine CreateSQLiteZoneTable()

Arguments

None

private subroutine InitializeNominalLightingTable()

Arguments

None

private subroutine CreateSQLiteNominalLightingTable()

Arguments

None

private subroutine InitializeNominalPeopleTable()

Arguments

None

private subroutine CreateSQLiteNominalPeopleTable()

Arguments

None

private subroutine InitializeNominalElectricEquipmentTable()

Arguments

None

private subroutine CreateSQLiteNominalElectricEquipmentTable()

Arguments

None

private subroutine InitializeNominalGasEquipmentTable()

Arguments

None

private subroutine CreateSQLiteNominalGasEquipmentTable()

Arguments

None

private subroutine InitializeNominalSteamEquipmentTable()

Arguments

None

private subroutine CreateSQLiteNominalSteamEquipmentTable()

Arguments

None

private subroutine InitializeNominalHotWaterEquipmentTable()

Arguments

None

private subroutine CreateSQLiteNominalHotWaterEquipmentTable()

Arguments

None

private subroutine InitializeNominalOtherEquipmentTable()

Arguments

None

private subroutine CreateSQLiteNominalOtherEquipmentTable()

Arguments

None

private subroutine InitializeNominalBaseboardHeatTable()

Arguments

None

private subroutine CreateSQLiteNominalBaseboardHeatTable()

Arguments

None

private subroutine InitializeSurfacesTable()

Arguments

None

private subroutine CreateSQLiteSurfacesTable()

Arguments

None

private subroutine InitializeConstructionsTables()

Arguments

None

private subroutine CreateSQLiteConstructionsTable()

Arguments

None

private subroutine InitializeMaterialsTable()

Arguments

None

private subroutine CreateSQLiteMaterialsTable()

Arguments

None

private subroutine InitializeZoneListTable()

Arguments

None

private subroutine CreateSQLiteZoneListTable()

Arguments

None

private subroutine InitializeZoneGroupTable()

Arguments

None

private subroutine CreateSQLiteZoneGroupTable()

Arguments

None

private subroutine InitializeNominalInfiltrationTable()

Arguments

None

private subroutine CreateSQLiteInfiltrationTable()

Arguments

None

private subroutine InitializeNominalVentilationTable()

Arguments

None

private subroutine CreateSQLiteVentilationTable()

Arguments

None

private subroutine InitializeZoneSizingTable()

Arguments

None

public subroutine AddSQLiteZoneSizingRecord(ZoneName, LoadType, CalcDesLoad, UserDesLoad, CalcDesFlow, UserDesFlow, DesDayName, PeakHrMin, PeakTemp, PeakHumRat, MinOAVolFlow)

Arguments

Type	Intent		Name
character(len=*),	intent(in)	::	ZoneName
character(len=*),	intent(in)	::	LoadType
real(kind=r64),	intent(in)	::	CalcDesLoad
real(kind=r64),	intent(in)	::	UserDesLoad
real(kind=r64),	intent(in)	::	CalcDesFlow
real(kind=r64),	intent(in)	::	UserDesFlow
character(len=*),	intent(in)	::	DesDayName
character(len=*),	intent(in)	::	PeakHrMin
real(kind=r64),	intent(in)	::	PeakTemp
real(kind=r64),	intent(in)	::	PeakHumRat
real(kind=r64),	intent(in)	::	MinOAVolFlow

private subroutine InitializeSystemSizingTable()

Arguments

None

public subroutine AddSQLiteSystemSizingRecord(SysName, VarDesc, VarValue)

Arguments

Type	Intent		Name
character(len=*),	intent(in)	::	SysName
character(len=*),	intent(in)	::	VarDesc
real(kind=r64),	intent(in)	::	VarValue

private subroutine InitializeComponentSizingTable()

Arguments

None

public subroutine AddSQLiteComponentSizingRecord(CompType, CompName, VarDesc, VarValue)

Arguments

Type	Intent		Name
character(len=*),	intent(in)	::	CompType
character(len=*),	intent(in)	::	CompName
character(len=*),	intent(in)	::	VarDesc
real(kind=r64),	intent(in)	::	VarValue

private subroutine InitializeRoomAirModelTable()

Arguments

None

private subroutine CreateSQLiteRoomAirModelTable()

Arguments

None

public subroutine SQLiteWriteMessageMacro(message)

Arguments

Type	Intent	Optional	Attributes		Name
character(len=*),	intent(in)			::	message

private subroutine AdjustReportingHourAndMinutes(hour, minutes)

Arguments

Type	Intent	Optional	Attributes		Name
integer,	intent(inout)			::	hour
integer,	intent(inout)			::	minutes

private subroutine InitializeReportMeterDataDictionaryTable()

Arguments

None

public subroutine CreateSQLiteMeterDictionaryRecord(meterReportID, storeTypeIndex, indexGroup, keyedValueString, variableName, indexType, units, reportingFreq, scheduleName)

Arguments

Type	Intent	Optional		Name
integer,	intent(in)		::	meterReportID
integer,	intent(in)		::	storeTypeIndex
character(len=*),	intent(in)		::	indexGroup
character(len=*),	intent(in)		::	keyedValueString
character(len=*),	intent(in)		::	variableName
integer,	intent(in)		::	indexType
character(len=*),	intent(in)		::	units
integer,	intent(in)		::	reportingFreq
character(len=*),	intent(in),	optional	::	scheduleName

private subroutine InitializeReportMeterDataTables()

Arguments

None

public subroutine CreateSQLiteMeterRecord(recordIndex, timeIndex, value, reportingInterval, minValue, minValueDate, maxValue, maxValueDate, minutesPerTimeStep)

Arguments

Type	Intent	Optional		Name
integer,	intent(in)		::	recordIndex
integer,	intent(in)		::	timeIndex
real(kind=r64),	intent(in)		::	value
integer,	intent(in),	optional	::	reportingInterval
real(kind=r64),	intent(in),	optional	::	minValue
integer,	intent(in),	optional	::	minValueDate
real(kind=r64),	intent(in),	optional	::	maxValue
integer,	intent(in),	optional	::	maxValueDate
integer,	intent(in),	optional	::	minutesPerTimeStep

private subroutine InitializeSchedulesTable()

Arguments

None

private subroutine CreateSQLiteSchedulesTable()

Arguments

None

private subroutine InitializeDaylightMapTables()

Arguments

None

public subroutine InitializeErrorsTable()

Arguments

None

public subroutine CreateSQLiteErrorRecord(simulationIndex, errorType, errorMessage, cnt)

Arguments

Type	Intent		Name
integer,	intent(in)	::	simulationIndex
integer,	intent(in)	::	errorType
character(len=*),	intent(in)	::	errorMessage
integer,	intent(in)	::	cnt

public subroutine UpdateSQLiteErrorRecord(errorMessage)

Arguments

Type	Intent	Optional	Attributes		Name
character(len=*),	intent(in)			::	errorMessage

public subroutine CreateSQLiteDaylightMapTitle(mapNum, mapName, environmentName, zone, refPt1, refPt2, zCoord)

Arguments

Type	Intent		Name
integer,	intent(in)	::	mapNum
character(len=*),	intent(in)	::	mapName
character(len=*),	intent(in)	::	environmentName
integer,	intent(in)	::	zone
character(len=*),	intent(in)	::	refPt1
character(len=*),	intent(in)	::	refPt2
real(kind=r64),	intent(in)	::	zCoord

public subroutine CreateSQLiteDaylightMap(mapNum, month, dayOfMonth, hourOfDay, nX, x, nY, y, illuminance)

Arguments

Type	Intent	Attributes		Name
integer,	intent(in)		::	mapNum
integer,	intent(in)		::	month
integer,	intent(in)		::	dayOfMonth
integer,	intent(in)		::	hourOfDay
integer,	intent(in)		::	nX
real(kind=r64),	intent(in),	DIMENSION(:)	::	x
integer,	intent(in)		::	nY
real(kind=r64),	intent(in),	DIMENSION(:)	::	y
real(kind=r64),	intent(in),	DIMENSION(:,:)	::	illuminance

SQLiteProcedures Module

Uses:

Used By

Variables

Interfaces

interface

public function SQLiteOpenDatabase(dbNameBuffer) bind(C, NAME="SQLiteOpenDatabase")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteExecuteCommand(commandBuffer) bind(C, NAME="SQLiteExecuteCommand")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteCloseDatabase(commandBuffer, commandLength) bind(C, NAME="SQLiteCloseDatabase")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLitePrepareStatement(stmtType, stmtBuffer) bind(C, NAME="SQLitePrepareStatement")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteColumnInt(stmtType, iCol) bind(C, NAME="SQLiteColumnInt")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteBindText(stmtType, stmtInsertLocationIndex, textBuffer) bind(C, NAME="SQLiteBindText")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteBindInteger(stmtType, stmtInsertLocationIndex, intToInsert) bind(C, NAME="SQLiteBindInteger")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteBindDouble(stmtType, stmtInsertLocationIndex, doubleToInsert) bind(C, NAME="SQLiteBindDouble")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteBindNULL(stmtType, stmtInsertLocationIndex) bind(C, NAME="SQLiteBindNULL")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteStepCommand(stmtType) bind(C, NAME="SQLiteStepCommand")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteResetCommand(stmtType) bind(C, NAME="SQLiteResetCommand")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteClearBindings(stmtType) bind(C, NAME="SQLiteClearBindings")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteFinalizeCommand(stmtType) bind(C, NAME="SQLiteFinalizeCommand")

Arguments

Return Value integer(kind=C_INT)

interface

public function SQLiteWriteMessage(messageBuffer) bind(C, NAME="SQLiteWriteMessage")

Arguments

Return Value integer(kind=C_INT)

Functions

public function CreateSQLiteStringTableRecord(stringValue, stringType) result(iOut)

Arguments

Return Value integer

public function CreateSQLiteTimeIndexRecord(reportingInterval, recordIndex, CumlativeSimulationDays, Month, DayOfMonth, Hour, EndMinute, StartMinute, DST, DayType) result(iOut)

Arguments

Return Value integer

private function SQLiteExecuteCommandMacro(sqlStmt) result(iOut)

Arguments

Return Value integer

private function SQLitePrepareStatementMacro(stmtIndex, sqlStmt) result(iOut)

Arguments

Return Value integer

public function SQLiteColumnIntMacro(stmtType, iCol) result(iOut)

Arguments

Return Value integer

private function SQLiteBindTextMacro(stmtIndex, columnIndex, sqlStmt) result(iOut)

Arguments

Return Value integer