History

Commits on master to Source/Libraries/GSF.TimeSeries/Data/SQLite/GSFSchema-InitialDataSet.db29

Added Recommended Action to AlarmStateChristoph Lackner committed 5 years agoc32da58
GSF.TimeSeries: Updated SQLite schemasJ. Ritchie Carroll committed 5 years agobdf4108
GSF.TimeSeries: Updated the schema version of the databases to reflect the change to the device update trigger.StephenCWills committed 8 years agoc60166a
GSF.TimeSeries: Fixed NULL comparisons in SQL trigger for tracking changes to Device records.StephenCWills committed 8 years ago2fdb5db
GSF.TimeSeries: Fixed protocol ID of the test device in the sample data set.StephenCWills committed 8 years ago8174649
GSF.TimeSeries: Fixed casing on protocol definition for DNP3.StephenCWills committed 8 years agoddd0293
GSF.TimeSeries: Fixed up protocols in initial data set scripts.StephenCWills committed 8 years agoef20c06
GSF.TimeSeries: Added Modbus Protocol to SQL scripts.StephenCWills committed 8 years agoa953eb3
GSF.TimeSeries: Added unique constraint to the Phasor table to catch user input errors that caused crashes in the WPF Manager.StephenCWills committed 8 years ago606f059
GSF.TimeSeries: Updated SQLite database files to match the latest schema version.StephenCWills committed 8 years agod8c3592
GSF.TimeSeries: Modified Measurement, ImportedMeasurement, and OutputStreamMeasurement to use a 64-bit integer for the point ID in GSFSchema.sql.StephenCWills committed 9 years agobe6500f
GSF.TimeSeries: 1) Fixed adder/multiplier on throttled subscriptions. 2) Added PowerCalculations table to SQL scripts.StephenCWills committed 10 years ago76ae436
Converted TFS repository to Git.StephenCWills committed 11 years agodd143d7
GSF.TimeSeries: Modified db-update.bat to use PRAGMA user_version in order to force modification of the db files when db-update.bat detects changes in the SQL script files.gsfbuildbot committed 11 years ago745ca38
Updated db-update.bat to check for updates to .sql scripts before attempting to update .db files.StephenCWills committed 11 years ago0792b29
GSF.TimeSeries: Fixed Alarm_InsertDefault trigger in SQLite database script.StephenCWills committed 12 years agoe93da99
GSF.TimeSeries: Fixed an issue with device statistic records when inserted by the InitialDataSet database scripts.StephenCWills committed 12 years ago5953471
GSF.Core: 1) Improved AdoDataConnection to handle null parameters by converting them to DBNull.Value automatically. 2) Added MixedSynchronizedOperation to GSF.Threading.StephenCWills committed 12 years agoaafd44b
(1) GSF.Core.Parsing: Added TemplatedExpressionParser class: a template based token substitution parser that supports binary expressions. (2) PhasorProtocolAdapters / GSF.PhasorProtocols.UI.*: Added support for custom tag naming expressions so that end user can control format of tag names. (3) PIAdapters: Updated meta-data synchronization to take into account last update time so that meta-data will only be refreshed if needed. (4) GSF.TimeSeries.Data: Updated database schema to version 3 to include last update times in various measurement views and add a LongAcronym field to the SignalType table for better flexibility in custom tag naming. (5) GSF.TimeSeries.Adapters::IaonSession: Updated temporal configuration extraction to cache current temporal configuration so long as primary real-time configuration hasn't changed as an optimization. (6) GSF.TimeSeries.Transport: (a) modified to publisher to include updated times in default meta-data, (b) modified subscriber to track last update time and check publisher meta-data update times to only update local database records if meta-data was changed, (c) modified subscriber with SQL Server configuration to default to not using transactions to help avoid dead-lock victims (7) Various consistency and spelling corrections.ritchiecarroll committed 12 years agoe328c95
Added missing triggers in SQLite and MySQL database scripts.StephenCWills committed 12 years agoeabc751
(1) Added time-quality flags measurement, for phasor protocols that support this, that is associated with a connection (e.g., directly connected device or concentrator). Quality flags can then archived and/or applied to an output stream. Output stream time-quality can be a measurement dervied from a hardware clock. (2) Updated initial data set schemas to include new "Quality Flags" signal type. (3) Updated EpriExporter to use a long synchronized operation for exports to eliminate a possible race condition. (4) Added unit tests for CRC CCITT that compare the tableless calculation method described in the C37 standard with a faster table version.ritchiecarroll committed 12 years ago756f0f9
Grid Solution Framework Time-series Schema: Updated SQLite databases.ritchiecarroll committed 12 years agod4a66a9
1) Added StatHistorianReportGenerator to the solution. 2) GSF.TimeSeries: Added device statistics to the DataSubscriber. 3) GSF.TimeSeries: Added new device statistics (!PMU-ST4 and !PMU-ST5) for measurements received and measurements expected - required for generating reports.StephenCWills committed 12 years agoeaad2ac
GSF.TimeSeries: Fixed an issue with NULL values when building connection strings in views in the SQLite database script.StephenCWills committed 12 years agoc04ed0d
GSF.TimeSeries: Fixed MeasurementGroup.FilterExpression in GSFSchema.sql for SQLite.StephenCWills committed 12 years ago94698f4
GSF.TimeSeries: Added unique index to ApplicationRole in SQL scripts.StephenCWills committed 12 years agodf2dfa2
GSF.TimeSeries: Added unique index to the Name field of the SecurityGroup table.StephenCWills committed 12 years ago3e89de9
In SQL scripts, updated historian in SampleDataSet.sql to default to TestingAdapters.VirtualOutputAdapter.StephenCWills committed 13 years ago3bf995f
GSF.TimeSeries: Added time-series database schemas (as GSFSchema.*) to Grid Solutions Framework such that same schema can be rolled down to specific time-series implementations.ritchiecarroll committed 13 years ago8868f24