|
Database
|
The DatabaseNotifier is an action adapter which takes multiple input measurements and defines
a boolean expression such that when the expression is true a database operation is triggered.
Inheritance Hierarchy
SystemObject
GSF.TimeSeriesConcentratorBase
GSF.TimeSeries.AdaptersActionAdapterBase
DynamicCalculatorDynamicCalculator
DynamicCalculatorDatabaseNotifier
GSF.TimeSeriesConcentratorBase
GSF.TimeSeries.AdaptersActionAdapterBase
DynamicCalculatorDynamicCalculator
DynamicCalculatorDatabaseNotifier
Namespace: DynamicCalculator
Assembly: DynamicCalculator (in DynamicCalculator.dll) Version: 2.4.207-beta
Syntaxpublic class DatabaseNotifier : DynamicCalculator
The DatabaseNotifier type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | DatabaseNotifier | Initializes a new instance of the DatabaseNotifier class |
Properties| Name | Description | |
|---|---|---|
 | AllowPreemptivePublishing |
Gets or sets flag that allows system to preemptively publish frames assuming all ExpectedMeasurements have arrived.
(Inherited from ConcentratorBase) |
| AllowSortsByArrival |
Gets or sets flag that determines whether or not to allow incoming measurements with bad timestamps
to be sorted by arrival time.
(Inherited from ConcentratorBase) |
 | ArrayVariableLengths |
Gets array variables names mapped to their defined lengths.
(Inherited from DynamicCalculator) |
| AutoStart |
Gets or sets flag indicating if adapter should automatically start or otherwise connect on demand.
(Inherited from ActionAdapterBase) |
| AveragePublicationTimePerFrame |
Gets the average required frame publication time, in seconds.
(Inherited from ConcentratorBase) |
| CalculationInterval |
Gets or sets the interval at which the adapter should calculate values.
(Inherited from DynamicCalculator) |
| ConnectionInfo |
Gets connection info for adapter, if any.
(Inherited from ActionAdapterBase) |
| ConnectionString |
Gets or sets key/value pair connection information specific to action adapter.
(Inherited from ActionAdapterBase) |
| DatabaseCommand | Gets or sets the command used for database operation, e.g., a stored procedure name or SQL expression like "INSERT". |
| DatabaseCommandParameters | Gets or sets the parameters for the command that includes any desired value substitutions used for database operation. Available substitutions: {Acronym} and {Timestamp}. |
| DatabaseConnnectionString | Gets or sets the connection string used for database operation. Leave blank to use local configuration database defined in "systemSettings". |
| DatabaseMaximumWriteInterval | Gets or sets the maximum interval, in seconds, at which the adapter can execute database operations. Set to zero for no delay. |
| DatabaseProviderString | Gets or sets the provider string used for database operation. Defaults to a SQL Server provider string. |
| DataSource |
Gets or sets DataSet based data source available to this ActionAdapterBase.
(Inherited from ActionAdapterBase) |
| DiscardedMeasurements |
Gets the total number of measurements that have been discarded because of old timestamps
(i.e., measurements that were outside the time deviation tolerance from base time, past or future).
(Inherited from ConcentratorBase) |
| DownsampledMeasurements |
Gets the total number of down-sampled measurements processed by the concentrator.
(Inherited from ConcentratorBase) |
| DownsamplingMethod |
Gets or sets the DownsamplingMethod to be used by the concentrator.
(Inherited from ConcentratorBase) |
| Enabled |
Gets or sets the current enabled state of concentrator.
(Inherited from ConcentratorBase) |
| ExpectedMeasurements |
Gets or sets the expected number of measurements to be assigned to a single frame.
(Inherited from ConcentratorBase) |
| ExpectsOutputMeasurement |
Gets flag that determines if the implementation of the DynamicCalculator requires an output measurement.
(Overrides DynamicCalculatorExpectsOutputMeasurement) |
| ExpressionText | Gets or sets the boolean expression used to determine if the database operation should be executed. |
| FramesAheadOfSchedule |
Gets the total number of frames ahead of schedule processed by the concentrator.
(Inherited from ConcentratorBase) |
| FramesPerSecond | Gets or sets the number of frames per second. |
| ID |
Gets or sets numeric ID associated with this action adapter.
(Inherited from ActionAdapterBase) |
| IgnoreBadTimestamps |
Gets or sets flag that determines if bad timestamps (as determined by measurement's timestamp quality)
should be ignored when sorting measurements.
(Inherited from ConcentratorBase) |
| Imports |
Gets or sets the list of types which define
methods to be imported into the expression parser.
(Inherited from DynamicCalculator) |
| InitializationTimeout |
Gets or sets maximum time system will wait during Start for initialization.
(Inherited from ActionAdapterBase) |
| Initialized |
Gets or sets flag indicating if the action adapter has been initialized successfully.
(Inherited from ActionAdapterBase) |
| InputMeasurementKeys |
Gets or sets primary keys of input measurements the dynamic calculator expects.
(Inherited from DynamicCalculator) |
| InputSourceIDs |
Gets or sets Source values used to filter input measurement keys.
(Inherited from ActionAdapterBase) |
| IsDisposed |
Gets a flag that indicates whether the object has been disposed.
(Inherited from ActionAdapterBase) |
| LagTicks |
Gets defined past time deviation tolerance, in ticks.
(Inherited from ConcentratorBase) |
| LagTime | Gets or sets the allowed past time deviation tolerance, in seconds (can be sub-second). |
| LastDiscardedMeasurement |
Gets a reference the last IMeasurement that was discarded by the concentrator.
(Inherited from ConcentratorBase) |
| LastDiscardedMeasurementLatency |
Gets the calculated latency of the last IMeasurement that was discarded by the concentrator.
(Inherited from ConcentratorBase) |
| LastFrame |
Gets reference to the last published IFrame.
(Inherited from ConcentratorBase) |
| LatestMeasurements |
Gets reference to the collection of absolute latest received measurement values.
(Inherited from ConcentratorBase) |
| LeadTime | Gets or sets the allowed future time deviation tolerance, in seconds (can be sub-second). |
| Log |
Log messages generated by an adapter.
(Inherited from ConcentratorBase) |
| MaximumPublicationTimeout |
Gets or sets the maximum frame publication timeout in milliseconds, set to Infinite(-1) to wait indefinitely.
(Inherited from ConcentratorBase) |
| MeasurementsSortedByArrival |
Gets the total number of measurements that were sorted by arrival because the measurement reported a bad timestamp quality.
(Inherited from ConcentratorBase) |
| MinimumMeasurementsToUse |
Gets or sets minimum number of input measurements required for adapter. Set to -1 to require all.
(Inherited from ActionAdapterBase) |
| MissedSortsByTimeout |
Gets the total number of missed sorts by timeout processed by the concentrator.
(Inherited from ConcentratorBase) |
| Name |
Gets name of the action adapter.
(Inherited from ActionAdapterBase) |
| OutlierOperation |
Gets or sets the operation used to handle measurements which have timestamps that fall outside
the LagTime/LeadTime bounds.
(Inherited from DynamicCalculator) |
| OutputMeasurements |
Gets or sets output measurements that the action adapter will produce, if any.
(Overrides DynamicCalculatorOutputMeasurements) |
| OutputSourceIDs |
Gets or sets Source values used to filter output measurements.
(Inherited from ActionAdapterBase) |
| PerformTimestampReasonabilityCheck |
Gets or sets flag that determines if timestamp reasonability checks should be performed on incoming
measurements (i.e., measurement timestamps are compared to system clock for reasonability using
LeadTime tolerance).
(Inherited from ConcentratorBase) |
| ProcessByReceivedTimestamp |
Gets or sets flag that determines if concentrator should sort measurements by received time.
(Inherited from ConcentratorBase) |
| ProcessedMeasurements |
Gets the total number of measurements successfully sorted.
(Inherited from ConcentratorBase) |
| ProcessingInterval |
Gets or sets the desired processing interval, in milliseconds, for the adapter.
(Inherited from ConcentratorBase) |
| PublishedFrames |
Gets the total number of published frames.
(Inherited from ConcentratorBase) |
| PublishedMeasurements |
Gets the total number of published measurements.
(Inherited from ConcentratorBase) |
| QueueState |
Gets detailed state of concentrator frame queue.
(Inherited from ConcentratorBase) |
| RealTime |
Gets the most accurate time value that is available. If UseLocalClockAsRealTime = true, then
this function will return UtcNow. Otherwise, this function will return the timestamp of the
most recent measurement, or UtcNow if no measurement timestamps are within time deviation
tolerances as specified by the LeadTime value.
(Inherited from ConcentratorBase) |
| ReceivedMeasurements |
Gets the total number of measurements ever requested for sorting.
(Inherited from ConcentratorBase) |
| RequestedInputMeasurementKeys |
Gets or sets input measurement keys that are requested by other adapters based on what adapter says it can provide.
(Inherited from ActionAdapterBase) |
| RequestedOutputMeasurementKeys |
Gets or sets output measurement keys that are requested by other adapters based on what adapter says it can provide.
(Inherited from ActionAdapterBase) |
| ReservedVariableNames |
Gets the list of reserved variable names.
(Inherited from DynamicCalculator) |
| RespectInputDemands |
Gets or sets flag indicating if action adapter should respect auto-start requests based on input demands.
(Inherited from ActionAdapterBase) |
| RespectOutputDemands |
Gets or sets flag indicating if action adapter should respect auto-start requests based on output demands.
(Inherited from ActionAdapterBase) |
| RoundToNearestTimestamp |
Gets or sets a value to indicate whether the concentrator should round to the
nearest frame timestamp rather than rounding down to the nearest timestamps.
(Inherited from ConcentratorBase) |
| RunTime |
Gets the total amount of time, in seconds, that the concentrator has been active.
(Inherited from ConcentratorBase) |
| SentinelValue |
Gets or sets the value used when no other value can be determined for a variable.
(Inherited from DynamicCalculator) |
| Settings |
Gets settings DictionaryTKey, TValue parsed when ConnectionString was assigned.
(Inherited from ActionAdapterBase) |
| ShowConcentratorStatus |
Gets flags that determines if ConcentratorBase class status should be included in ActionAdapterBase status.
(Inherited from ActionAdapterBase) |
| SkipNaNOutput |
Gets or sets the flag indicating whether to skip processing of an output with a value of NaN.
(Inherited from DynamicCalculator) |
| StartTime |
Gets the UTC time the concentrator was started.
(Inherited from ConcentratorBase) |
| StartTimeConstraint |
Gets the start time temporal processing constraint defined by call to SetTemporalConstraint(String, String, String).
(Inherited from ActionAdapterBase) |
| Status |
Returns the detailed status of the data input source.
(Overrides DynamicCalculatorStatus) |
| StopTime |
Gets the UTC time the concentrator was stopped.
(Inherited from ConcentratorBase) |
| StopTimeConstraint |
Gets the stop time temporal processing constraint defined by call to SetTemporalConstraint(String, String, String).
(Inherited from ActionAdapterBase) |
| SupportsTemporalProcessing |
Gets the flag indicating if this adapter supports temporal processing.
(Inherited from DynamicCalculator) |
| TicksPerFrame |
Gets the number of ticks per frame.
(Inherited from ConcentratorBase) |
| TimeResolution |
Gets or sets the maximum time resolution, in ticks, to use when sorting measurements by timestamps into their proper destination frame.
(Inherited from ConcentratorBase) |
| TimestampSource | Gets or sets the source of the timestamps of the calculated values. |
| TotalPublicationTime |
Gets the total number of seconds frames have spent in the publication process since concentrator started.
(Inherited from ConcentratorBase) |
| TrackLatestMeasurements |
Gets or sets flag to start tracking the absolute latest received measurement values.
(Inherited from ConcentratorBase) |
| UseLatestValues |
Gets or sets the flag indicating whether to use the latest
received values to fill in values missing from the current frame.
(Inherited from DynamicCalculator) |
| UseLocalClockAsRealTime |
Gets or sets flag that determines whether or not to use the local clock time as real-time.
(Inherited from ConcentratorBase) |
| UsePrecisionTimer |
Gets or sets flag that determines if precision timer should be used for frame publication.
(Inherited from ConcentratorBase) |
| VariableKeys |
Gets variable names mapped to their MeasurementKey values.
(Inherited from DynamicCalculator) |
| VariableList |
Gets or sets the list of variables used in the expression.
(Inherited from DynamicCalculator) |
| VariableNames |
Gets the configured list of variables names.
(Inherited from DynamicCalculator) |
| Variables |
Gets defined expression variable collection with current values.
(Inherited from DynamicCalculator) |
| WaitHandleExpirations |
Gets the total number of wait handle expirations encountered due to delayed precision timer releases.
(Inherited from ConcentratorBase) |
Methods| Name | Description | |
|---|---|---|
 | AssignMeasurementToFrame |
Assigns IMeasurement to its associated IFrame.
(Inherited from ConcentratorBase) |
| Calculate |
Executes dynamic calculation for input measurements and any provided index restrictions.
(Inherited from DynamicCalculator) |
| CreateNewFrame |
Creates a new IFrame for the given timestamp.
(Inherited from ConcentratorBase) |
| Dispose |
Releases all the resources used by the ConcentratorBase object.
(Inherited from ConcentratorBase) |
| Dispose(Boolean) |
Releases the unmanaged resources used by the ActionAdapterBase object and optionally releases the managed resources.
(Inherited from ActionAdapterBase) |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| ExamineQueueState |
Examines the concentrator frame queue state of the ActionAdapterBase.
(Inherited from ActionAdapterBase) |
| Finalize |
Releases the unmanaged resources before the ConcentratorBase object is reclaimed by GC.
(Inherited from ConcentratorBase) |
| GetHashCode |
Serves as a hash function for the current ActionAdapterBase.
(Inherited from ActionAdapterBase) |
| GetShortStatus |
Gets a short one-line status of this ActionAdapterBase.
(Inherited from ActionAdapterBase) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| HandleCalculatedValue |
Handler for the values calculated by the DynamicCalculator.
(Overrides DynamicCalculatorHandleCalculatedValue(Object)) |
| HandleSpecialVariables |
Handler for assignment of special variables, e.g., constants, for the DynamicCalculator.
(Inherited from DynamicCalculator) |
| Initialize |
Initializes DatabaseNotifier.
(Overrides DynamicCalculatorInitialize) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| MillisecondsFromRealTime |
Returns the deviation, in milliseconds, that the given number of ticks is from real-time (i.e., RealTime).
(Inherited from ConcentratorBase) |
| OnConfigurationChanged |
Raises ConfigurationChanged event.
(Inherited from ActionAdapterBase) |
| OnDiscardingMeasurements |
Raises the DiscardingMeasurements event.
(Inherited from ConcentratorBase) |
| OnInputMeasurementKeysUpdated |
Raises InputMeasurementKeysUpdated event.
(Inherited from ActionAdapterBase) |
| OnNewMeasurements |
Raises the NewMeasurements event.
(Inherited from ActionAdapterBase) |
| OnOutputMeasurementsUpdated |
Raises OutputMeasurementsUpdated event.
(Inherited from ActionAdapterBase) |
| OnProcessException(Exception) | Obsolete. Raises the ProcessException event. (Inherited from ConcentratorBase) |
| OnProcessException(MessageLevel, Exception, String, MessageFlags) |
Raises the ProcessException event.
(Inherited from ConcentratorBase) |
| OnStatusMessage(String) | Obsolete. Raises the StatusMessage event. (Inherited from ActionAdapterBase) |
| OnStatusMessage(String, Object) | Obsolete. Raises the StatusMessage event with a formatted status message. (Inherited from ActionAdapterBase) |
| OnStatusMessage(MessageLevel, String, String, MessageFlags) |
Raises the StatusMessage event and sends this data to the Logger.
(Inherited from ActionAdapterBase) |
| OnUnpublishedSamples |
Raises the UnpublishedSamples event.
(Inherited from ConcentratorBase) |
| PublishFrame |
Publish IFrame of time-aligned collection of IMeasurement values that arrived within the
concentrator's defined LagTime.
(Inherited from DynamicCalculator) |
| QueueMeasurementsForProcessing |
Queues a collection of measurements for processing. Measurements are automatically filtered to the defined InputMeasurementKeys.
(Inherited from ActionAdapterBase) |
| QueueOperation | Queues database operation for execution. Operation will execute immediately if not already running. |
| ResetStatistics |
Resets the statistics of the ActionAdapterBase.
(Inherited from ActionAdapterBase) |
| SecondsFromRealTime |
Returns the deviation, in seconds, that the given number of ticks is from real-time (i.e., RealTime).
(Inherited from ConcentratorBase) |
| SetInitializedState |
Manually sets the initialized state of the ActionAdapterBase.
(Inherited from ActionAdapterBase) |
| SetTemporalConstraint |
Defines a temporal processing constraint for the adapter.
(Inherited from ActionAdapterBase) |
| SortMeasurement |
Sorts the IMeasurement placing the data point in its proper IFrame.
(Inherited from ConcentratorBase) |
| SortMeasurements |
Sorts each IMeasurement placing each data point in its proper IFrame.
(Inherited from ConcentratorBase) |
| Start |
Starts the DynamicCalculator or restarts it if it is already running.
(Inherited from DynamicCalculator) |
| Stop |
Stops the ActionAdapterBase.
(Inherited from ActionAdapterBase) |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| TryGetMinimumNeededMeasurements |
Attempts to retrieve the minimum needed number of measurements from the frame (as specified by MinimumMeasurementsToUse)
(Inherited from ActionAdapterBase) |
Events| Name | Description | |
|---|---|---|
 | ConfigurationChanged |
Event is raised when adapter is aware of a configuration change.
(Inherited from ActionAdapterBase) |
| DiscardingMeasurements |
This event is raised if there are any measurements being discarded during the sorting process.
(Inherited from ConcentratorBase) |
| Disposed |
This event is raised when ConcentratorBase is disposed.
(Inherited from ConcentratorBase) |
| InputMeasurementKeysUpdated |
Event is raised when InputMeasurementKeys are updated.
(Inherited from ActionAdapterBase) |
| NewMeasurements |
Provides new measurements from action adapter.
(Inherited from ActionAdapterBase) |
| OutputMeasurementsUpdated |
Event is raised when OutputMeasurements are updated.
(Inherited from ActionAdapterBase) |
| ProcessException |
This event is raised if there is an exception encountered while attempting to process a frame in the sample queue.
(Inherited from ConcentratorBase) |
| StatusMessage |
Provides status messages to consumer.
(Inherited from ActionAdapterBase) |
| UnpublishedSamples |
This event is raised every 5 seconds allowing consumer to track current number of unpublished seconds of data in the queue.
(Inherited from ConcentratorBase) |
See Also