History

Commits on 5c5b4069aec2d44d8180304bccefd780ba767115 to Source/Libraries/GSF.TimeSeries/Data/MySQL35+

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: Fixed editor role name in sample data scripts.J. Ritchie Carroll committed 8 years ago568e460
GSF.TimeSeries: Added filter adapters to modify measurement properties before routing.StephenCWills committed 8 years ago4ff56a0
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: Fixed all input stream and output stream statistic descriptions for the average number of measurements per second.J. Ritchie Carroll committed 9 years ago71b954e
GSF.TimeSeries: Added up-time statistics for system, subscriber, publisher, input streams and output streamsJ. Ritchie Carroll committed 9 years ago4ec2605
GSF.TimeSeries: Added device statistic for tracking the number of defined measurements per frame.StephenCWills committed 9 years agob4fcacd
GSF.TimeSeries: Updated acronyms for SDG&E to SDGE to match normal acronym validation.J. Ritchie Carroll committed 10 years ago8f42de3
Added SDG&E to company list in GSF schemaRyan McCoy committed 10 years ago5ead658
GSF.TimeSeries: Fixed GSFSchema.sql for versions of MySQL since 5.7.6 when VIRTUAL was introduced as a keyword.StephenCWills committed 10 years ago0a980ab
GSF.TimeSeries: Fixed names of tables referenced in foreign key constraints in the MySQL database script. MySQL servers on Linux platforms are case sensitive.StephenCWills committed 10 years ago6d14c61
Fixed and normalized the foreign key constraint names in the time-series schema implementations for the PowerCalculations table.J. Ritchie Carroll committed 10 years agofe5ced4
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: Migrated all file license references from Eclipse to MIT.ritchiecarroll committed 11 years ago6d94f5f
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
GSF.PerformanceMonitor: Updated performance counter to code and system statistics to be more platform portable.ritchiecarroll committed 12 years ago4ddc530
(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
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