DP44/Common/DTS.Common.Storage/TestSetups.cs

namespace DTS.Common.Storage
{
    public partial class DbOperations
    {
        public abstract class TestSetups
        {
            public const string HardwareTable = "tblTestSetupHardware";

            public enum HardwareFields
            {
                TestSetupName,
                HardwareId,
                AddOrRemove //0=remove,1=add
            }

            public const string DASSettingsTable = "tblTestSetupDASSettings";

            public const string ChannelSettingsTable = "tblTestChannelSettings";

            public enum ChannelSettingFields
            {
                TestName,
                TestObjectName,
                ChannelId,
                Setting,
                SensorSerial,
                Disabled
            }

            public enum ChannelFields
            {
                ISOChannelName,
                ISOCode,
                UserChannelName,
                UserCode,
                Disabled,
                Settings,
                SensorId,               //version 3
                DASId,                  //version 3
                DASChannelIdx,          //version 3
                TestSetupOrder,         //version 3
                GroupOrder,             //version 3
                Id                      //version 3
            }
            public enum SettingsFields
            {
                //Version 3 and earlier
                Range,
                CFC,
                Polarity,
                //Version 2 and earlier
                LimitDuration,
                Duration,
                Delay,
                OutputMode,
                SQMode,
                DIMode,
                DefaultValue,
                ActiveValue,
                //version 4 (DataPRO 2.1)
                SquibLimitDuration,
                SquibDuration,
                SquibDelay,
                DigitalOutLimitDuration,
                DigitalOutDuration,
                DigitalOutDelay,
                SquibCurrent,
                UserValue1,
                UserValue2,
                UserValue3,
                //Version 5?  (DataPRO 2.4) [noticed these issues during testing of 3.0]
                //15270 Sensor Import does not import most channel settings
                ZeroMethod,
                ZeroMethodStart,
                ZeroMethodEnd,
                //Version 6? (DataPRO 3.0)
                //15270 Sensor Import does not import most channel settings
                InitialOffset,
                FilterClass,
                //Version ?? (DataPRO 4.0)
                //18363 Uart Channels
                UartBaudRate,
                UartDataBits,
                UartStopBits,
                UartParity,
                UartFlowControl,
                UartDataFormat,
                //18364 Stream Out Channels
                StreamOutUDPProfile,
                StreamOutUDPAddress,
                StreamOutUDPTimeChannelId,
                StreamOutUDPDataChannelId,
                StreamOutUDPTmNSConfig,
                StreamOutIRIGTimeDataPacketIntervalMs,
                //http://manuscript.dts.local/f/cases/29760/Implement-ACCoupleEnable-for-TSR-AIR
                ACCouplingEnabled,
                StreamOutTMATSIntervalMs,
                //33415 Voltage insertion channel should be half bridge
                BridgeType
            }

            public const string TestSetupsTable = "tblTestSetups";

            public enum Fields
            {
                SetupName,
                SetupDescription,
                AutomaticTestProgression,
                AutomaticProgressionDelayMS,
                InvertTrigger,
                InvertStart,
                IgnoreShortedStart,
                IgnoreShortedTrigger,
                ViewDiagnostics,
                VerifyChannels,
                AutoVerifyChannels,
                VerifyChannelsDelayMS,
                RecordingMode,
                SamplesPerSecond,
                PreTriggerSeconds,
                PostTriggerSeconds,
                NumberOfEvents,
                WakeUpMotionTimeout,
                ScheduledStartDateTime,
                IntervalBetweenEventStartsMinutes,
                StartWithEvent,
                WakeUpWithMotion,
                StrictDiagnostics,
                RequireConfirmationOnErrors,
                ROIDownload,
                ViewROIDownload,
                DownloadAll,
                ViewRealtime,
                RealtimePlotCount,
                RegionsOfInterest,
                ROIStart,
                ROIEnd,
                ViewDownloadAll,
                Export,
                ExportFormat,
                LabDetails,
                UseLabDetails,
                CustomerDetails,
                UseCustomerDetails,
                AllowMissingSensors,
                AllowSensorIdToBlankChannel,
                LocalOnly,
                LastModified,
                LastModifiedBy,
                TurnOffExcitation,
                TriggerCheckRealtime,
                TriggerCheckStep,
                PostTestDiagnostics,
                ExportFolder,
                DownloadFolder,
                CommonStatusLine,
                SameAsDownloadFolder,
                UploadData,
                UploadDataFolder,
                UploadExportsOnly,
                Settings,
                WarnOnBatteryFail,
                Dirty,
                Complete,
                ErrorMessage,
                TestEngineerDetails,
                UseTestEngineerDetails,
                UserTags,
                DoAutoArm,
                DoEnableRepeat,
                DoStreaming,
                CheckoutMode,
                QuitTestWithoutWarning,
                SuppressMissingSensorsWarning,
                ISFFile,
                NotAllChannelsRealTime,
                NotAllChannelsViewer,
                CalibrationBehavior,
                ClockSyncProfileMaster,
                ClockSyncProfileSlave,
                ExtraProperties,
                MeasureSquibResistancesStep,
                TestSetupUniqueId,
                AlignUDPToPPS
            }

            public const string TestSetupObjectsTable = "tblTestSetupObjects";

            public enum TestSetupObjectFields
            {
                TestObjectSerialNumber,
                TestObjectName, //TestObjectSerialNumber was changed to TestObjectName in a later version
                TestSetupName,
                TargetSampleRate,
                ExcitationWarmupTimeMS,
                LocalOnly,
                TestObjectType,
                TestObjectPosition,
                DisplayOrder
            }

            public enum TestSetupDASHardwareFields
            {
                SerialNumber,
                SamplesPerSecond,
                AntiAliasFilterRate,
                IsClockMaster,
                PTPDomainID
            }
            public enum TestSetupGroupFields
            {
                SerialNumber,
                Name,
                DisplayName,
                Description,
                TestSetupName,
                DisplayOrder,
                Position,
                TestObjectType,
                Id,
                StaticGroupId
            }

            public const string TestObjectMetaDataTable = "tblTestSetupObjectMetaData";

            public enum TestObjectMetaDataFields
            {
                TestObject,
                ISOTestObject,
                SetupName,
                TestSetupName,
                PropName,
                PropValue,
                Optional,
                Version,
            }

            public const string TestObjectTemplatesTable = "tblTestObjectTemplates";

            public enum TestObjectTemplatesFields
            {
                TemplateName,
                Icon,
                Description,
                LocalOnly,
                Version,
                LastModifiedBy,
                CRC32,
                TestObject,
                LastModified,
                ParentTemplate,
                SysBuilt
            }

            public const string TestObjectsTable = "tblTestObjects";

            public enum TestObjectsFields
            {
                SerialNumber,
                LastModifiedBy,
                LastModified,
                Template,
                LocalOnly,
                ParentObject,
                SysBuilt,
                Embedded,
                OriginalTemplate,
                OriginalSerialNumber
            }

            public enum GroupsGroupFields
            {
                Name,
                LastModifiedBy,
                LastModified,
                Id,
                Tags
            }

            public enum GroupsGroupChannelFields
            {
                IsoCode,
                IsoChannelName,
                UserCode,
                UserChannelName,
                DASId,
                DASChannelIndex,
                GroupChannelOrder,
                Sensor,
                SensorId,
                Disabled,
                LastModified,
                LastModifiedBy
            }

            public enum GroupsGroupHardwareListFields
            {
                Hardware
            }

            public const string TestGraphsTable = "tblTestGraphs";

            public enum GraphFields
            {
                GraphName,
                GraphDescription,
                TemplateName,
                Channels,
                UseDomainMin,
                DomainMin,
                UseDomainMax,
                DomainMax,
                UseRangeMin,
                RangeMin,
                UseRangeMax,
                RangeMax,
                Thresholds,
                LocalOnly,
                TestSetupName
            }
        }
    }
}