SQLiteProcedures Module

module~~sqliteprocedures~~UsesGraph module~sqliteprocedures SQLiteProcedures module~dataprecisionglobals DataPrecisionGlobals module~dataprecisionglobals->module~sqliteprocedures
Help

Variables

TypeVisibility AttributesNameInitial
integer, public, parameter:: MaxMessageSize =4096
logical, public, SAVE:: WriteOutputToSQLite =.FALSE.
logical, public, SAVE:: WriteTabularDataToSQLite =.FALSE.
integer, public :: SQLdbTimeIndex =0

Functions

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

Arguments

Type IntentOptional AttributesName
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


Subroutines

public subroutine SQLiteBegin()

Arguments

None

public subroutine SQLiteCommit()

Arguments

None

public subroutine CreateSQLiteDatabase()

Arguments

None

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

Arguments

Type IntentOptional AttributesName
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 CreateSQLiteReportVariableDataRecord(recordIndex, timeIndex, value, reportingInterval, minValue, minValueDate, maxValue, maxValueDate, minutesPerTimeStep)

Arguments

Type IntentOptional AttributesName
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 CreateSQLiteZoneTable()

Arguments

None

public subroutine CreateSQLiteNominalLightingTable()

Arguments

None

public subroutine CreateSQLiteNominalPeopleTable()

Arguments

None

Arguments

None

Arguments

None

Arguments

None

Arguments

None

Arguments

None

Arguments

None

public subroutine CreateSQLiteSurfacesTable()

Arguments

None

public subroutine CreateSQLiteConstructionsTable()

Arguments

None

public subroutine CreateSQLiteMaterialsTable()

Arguments

None

public subroutine CreateSQLiteZoneListTable()

Arguments

None

public subroutine CreateSQLiteZoneGroupTable()

Arguments

None

public subroutine CreateSQLiteInfiltrationTable()

Arguments

None

public subroutine CreateSQLiteVentilationTable()

Arguments

None

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

Arguments

Type IntentOptional AttributesName
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

public subroutine AddSQLiteSystemSizingRecord(SysName, VarDesc, VarValue)

Arguments

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

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

Arguments

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

public subroutine CreateSQLiteRoomAirModelTable()

Arguments

None

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

Arguments

Type IntentOptional AttributesName
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

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

Arguments

Type IntentOptional AttributesName
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 SQLiteWriteMessageMacro(message)

Arguments

Type IntentOptional AttributesName
character(len=*), intent(in) :: message

public subroutine CreateZoneExtendedOutput()

Arguments

None

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

Arguments

Type IntentOptional AttributesName
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 IntentOptional AttributesName
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

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

Arguments

Type IntentOptional AttributesName
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

public subroutine InitializeIndexes()

Arguments

None

public subroutine InitializeTabularDataTable()

Arguments

None

public subroutine InitializeTabularDataView()

Arguments

None

public subroutine CreateSQLiteSimulationsRecord(ID)

Arguments

Type IntentOptional AttributesName
integer, intent(in) :: ID

Arguments

None

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

Arguments

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

public subroutine UpdateSQLiteErrorRecord(errorMessage)

Arguments

Type IntentOptional AttributesName
character(len=*), intent(in) :: errorMessage

public subroutine UpdateSQLiteSimulationRecord(completed, completedSuccessfully)

Arguments

Type IntentOptional AttributesName
logical, intent(in) :: completed
logical, intent(in) :: completedSuccessfully


AirflowNetworkBalanceManager AirflowNetworkSolver BaseboardElectric BaseboardRadiator Boilers BoilerSteam BranchInputManager BranchNodeConnections ChillerAbsorption ChillerElectricEIR ChillerExhaustAbsorption ChillerGasAbsorption ChillerIndirectAbsorption ChillerReformulatedEIR CondenserLoopTowers ConductionTransferFunctionCalc ConvectionCoefficients CoolTower CostEstimateManager CrossVentMgr CTElectricGenerator CurveManager DataAirflowNetwork DataAirLoop DataAirSystems DataBranchAirLoopPlant DataBranchNodeConnections DataBSDFWindow DataComplexFenestration DataContaminantBalance DataConvergParams DataConversions DataCostEstimate DataDaylighting DataDaylightingDevices DataDefineEquip DataDElight DataEnvironment DataErrorTracking DataGenerators DataGlobalConstants DataGlobals DataHeatBalance DataHeatBalFanSys DataHeatBalSurface DataHVACControllers DataHVACGlobals DataInterfaces DataIPShortCuts DataLoopNode DataMoistureBalance DataMoistureBalanceEMPD DataOutputs DataPhotovoltaics DataPlant DataPlantPipingSystems DataPrecisionGlobals DataReportingFlags DataRoomAirModel DataRootFinder DataRuntimeLanguage DataShadowingCombinations DataSizing DataStringGlobals DataSurfaceColors DataSurfaceLists DataSurfaces DataSystemVariables DataTimings DataUCSDSharedData DataVectorTypes DataViewFactorInformation DataWater DataWindowEquivalentLayer DataZoneControls DataZoneEnergyDemands DataZoneEquipment DaylightingDevices DaylightingManager DELIGHTMANAGERF DELIGHTMANAGERF DemandManager DesiccantDehumidifiers DirectAirManager DisplacementVentMgr DualDuct DXCoils DXFEarClipping EarthTube EconomicLifeCycleCost EconomicTariff EcoRoofManager ElectricBaseboardRadiator EMSManager EvaporativeCoolers EvaporativeFluidCoolers ExteriorEnergyUse ExternalInterface FanCoilUnits Fans FaultsManager FluidCoolers FluidProperties FuelCellElectricGenerator Furnaces General GeneratorDynamicsManager GeneratorFuelSupply GlobalNames GroundHeatExchangers HeatBalanceAirManager HeatBalanceHAMTManager HeatBalanceIntRadExchange HeatBalanceManager HeatBalanceMovableInsulation HeatBalanceSurfaceManager HeatBalFiniteDiffManager HeatingCoils HeatPumpWaterToWaterCOOLING HeatPumpWaterToWaterHEATING HeatPumpWaterToWaterSimple HeatRecovery HighTempRadiantSystem Humidifiers HVACControllers HVACCooledBeam HVACDuct HVACDXHeatPumpSystem HVACDXSystem HVACHXAssistedCoolingCoil HVACInterfaceManager HVACManager HVACMultiSpeedHeatPump HVACSingleDuctInduc HVACStandAloneERV HVACUnitaryBypassVAV HVACUnitarySystem HVACVariableRefrigerantFlow HWBaseboardRadiator ICEngineElectricGenerator IceThermalStorage InputProcessor InternalHeatGains ISO_C_FUNCTION_BINDING ISO_C_FUNCTION_BINDING LowTempRadiantSystem ManageElectricPower MatrixDataManager MicroCHPElectricGenerator MicroturbineElectricGenerator MixedAir MixerComponent MoistureBalanceEMPDManager MundtSimMgr NodeInputManager NonZoneEquipmentManager OutAirNodeManager OutdoorAirUnit OutputProcessor OutputReportPredefined OutputReportTabular OutsideEnergySources PackagedTerminalHeatPump PackagedThermalStorageCoil Photovoltaics PhotovoltaicThermalCollectors PipeHeatTransfer Pipes PlantCentralGSHP PlantChillers PlantComponentTemperatureSources PlantCondLoopOperation PlantHeatExchangerFluidToFluid PlantLoadProfile PlantLoopEquip PlantLoopSolver PlantManager PlantPipingSystemsManager PlantPressureSystem PlantUtilities PlantValves PollutionModule PondGroundHeatExchanger PoweredInductionUnits Psychrometrics Pumps PurchasedAirManager RefrigeratedCase ReportSizingManager ReturnAirPathManager RoomAirModelManager RoomAirModelUserTempPattern RootFinder RuntimeLanguageProcessor ScheduleManager SetPointManager SimAirServingZones SimulationManager SingleDuct SizingManager SolarCollectors SolarReflectionManager SolarShading SortAndStringUtilities SplitterComponent SQLiteProcedures SQLiteProcedures StandardRatings SteamBaseboardRadiator SteamCoils SurfaceGeometry SurfaceGroundHeatExchanger SystemAvailabilityManager SystemReports TARCOGArgs TARCOGCommon TARCOGDeflection TARCOGGasses90 TARCOGGassesParams TARCOGMain TARCOGOutput TARCOGParams TarcogShading ThermalChimney ThermalComfort ThermalEN673Calc ThermalISO15099Calc TranspiredCollector UFADManager UnitHeater UnitVentilator UserDefinedComponents VariableSpeedCoils vectors VentilatedSlab WaterCoils WaterManager WaterThermalTanks WatertoAirHeatPump WatertoAirHeatPumpSimple WaterUse WeatherManager WindowAC WindowComplexManager WindowEquivalentLayer WindowManager WindTurbine ZoneAirLoopEquipmentManager ZoneContaminantPredictorCorrector ZoneDehumidifier ZoneEquipmentManager ZonePlenum ZoneTempPredictorCorrector