History

Commits on master to Source/Libraries/GSF.TimeSeries/Data/MySQL54

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
GSF.TimeSeries: 1) Fixed an issue in DatabaseConfigurationLoader where an empty TrackedChange table would cause the configuration data set version to revert to 0. 2) Fixed an issue in DatabaseConfigurationLoader where records that already existed in the configuration data set would be added anyway when augmenting configuration. 3) Fixed various issues in the Oracle database script.StephenCWills committed 12 years ago3dd3d74
GSF.TimeSeries: Changed version numbers for configuration augmentation to unsigned long.StephenCWills committed 12 years ago58fe059
GSF.TimeSeries: Implemented configuration augmentation and conditional data operations for database configurations to speed up ReloadConfig for large databases.StephenCWills committed 12 years ago429ebdf
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 primary key GUIDs in MySQL database script.StephenCWills committed 12 years ago508e629
GSF.TimeSeries: Fixed default value triggers in GSFSchema.sql for MySQL.StephenCWills committed 12 years ago1928561
GSF.TimeSeries: In GSFSchema.sql for MySQL, added a space after '--' in the comments at the bottom of the file.StephenCWills committed 12 years ago772987a
GSF.TimeSeries: Fixed UUID triggers in the MySQL version of GSFSchema.sql.StephenCWills committed 12 years ago233a066
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 MySQL and Oracle initial data scripts, fixed the data type used by the lifetime statistics for the data publisher.StephenCWills committed 13 years ago34e027d
In SQL scripts, updated historian in SampleDataSet.sql to default to TestingAdapters.VirtualOutputAdapter.StephenCWills committed 13 years ago3bf995f
GSF.TimeSeries: Commented OutputStream inserts in SampleDataSet.sql scripts.StephenCWills committed 13 years ago6a7f18a
GSF.TimeSeries: Updated sample data scripts to allow for comments (--) and commented commands (--*) such that only commented commands could be uncommented as part of the roll-down script if needed.ritchiecarroll committed 13 years agoae20ec0
GSF.TimeSeries: Rolled-up schema changes to support remote ADO database setups and applied consistency changes to scripts to support roll-down to all time-series implementations.ritchiecarroll committed 13 years ago2dc3ce9
GSF.TimeSeries: Updated database schema scripts to consistently use ANSI encoding.ritchiecarroll committed 13 years agob510581
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