Skip to content

modify database to be consistent with manuals and qpeek, logpeek

Lan Dam requested to merge i245_convert_factor into develop

closes #245 (closed)

After checking with manual SOHViewer's database need to make the following changes

UPDATE Parameters SET plotType='linesDots', height=2 WHERE param='Barometric pressure';
INSERT INTO Parameters VALUES('System pressure', 'linesDots', 'Line:#00FF00', 'Line:#00CC00', 2);
INSERT INTO Channels VALUES('VDP', 'SysPress', 'System pressure', NULL, 1, 'pascal', NULL,  'Pegasus');
UPDATE Channels SET convertFactor=0.01 WHERE dataType='Pegasus' AND channel='VDT';
UPDATE Channels SET convertFactor=0.001 WHERE dataType='Pegasus' AND channel='VM?';
UPDATE Channels SET label='System Current' WHERE dataType='Pegasus' AND channel='VE1';
UPDATE Parameters SET valueColorsB='<=0.0:#FF0000|<=1.0:#FFFF00|1.0<:#00FF00', valueColorsW='<=0.0:#FF0000|<=1.0:#DDDD00|1.0<:#00CC00' WHERE param='GNSS status';
UPDATE Parameters SET plotType='dotForTime', valueColorsB='Color:#FF0000', valueColorsW='Color:#FF0000' WHERE param='Discrepancies';
UPDATE Parameters SET valueColorsB='<=0:#00FF00|<=1:#FFFF00|1<:#FF0000', valueColorsW='<=0:#00CC00|<=1:#DDDD00|1<:#FF0000' WHERE param="GNSS antenna status";
UPDATE Parameters SET valueColorsB='<=0:#00FF00|<=1:#00FFFF|<=2:#FFFF00|2<:#FF0000', valueColorsW='<=0:#00CC00|<=1:#0099DD|<=2:#DDDD00|2<:#FF0000' WHERE param="GNSS PPL status";

In which,

  • Pegasus' VDP is a new channel (param=System pressure) which wasn't in user's request list.
  • Centaur's LDO (param=Barometric pressure) was in user's request list but not in manual. I decide to keep it and also change in Parameters so it can be plotted.
  • Pegasus VDT's convertFactor change from microdegrees C to centidegrees C.
  • Pegasus mass position's convertFactor change from microVolts to milliVolts.
  • Pegasus VE1 change label from to SystemCurrent.
  • Change valueColor for GNSS status (Centaur GST) from "0:not plot, 1:red, 2: magenda" to "0:red, 1:yellow, 2:green"
  • Change valueColor for Discrepancies from plot type multiColorDotsEqualOnUpperBound to dotForTime with red color.
  • Change valueColor for GNSS antenna status (Centaur GAN) from '0: not plot, 1: red, 2: magenda' to '0: green, 1: yellow, 2: read'
  • Change valueColor for GNSS PPL status (Centaur GPL) from "0: Red, 1: Yellow, 2: Green, 3 Magenda" to "0: Green, 1: Cyan, 2: Yellow, 3: Red"

We should ask user to check the plotting for these channels to confirm this.

Edited by Kien Le

Merge request reports

Loading