kvalobs:kvoss:system:qc2:test:slv32

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
kvalobs:kvoss:system:qc2:test:slv32 [2010-09-26 22:38:35]
paule 		kvalobs:kvoss:system:qc2:test:slv32 [2022-05-31 09:29:32] (current)
Line 1: Line 1:
 +
 +====== Communication Tests ======
 +
 +Looking up object in CORBA nameservice: corbaname::corbans.met.no:2809#kvtest-dev-vm101/kvServiceDataReady
 +Data input by kvQc2:
 +
 +<code>
 +-- ProcessUnitT Writing Data -6.4 17850 2010-11-25 9:0:0
 +</code>
 +
 +Corresponding signal in kvServiced.log
 +
 +<code>
 +20101125201847: DEBUG (ServiceSubscriber)
 +--------------- Closing the database connection!
 +20101125202116: DEBUG (dataReady)
 +--------------- New data from <UNKNOWN>!
 +20101125202116: INFO (ServiceSubscriber)
 +--------------- New database connection (PostgreSQL) created!
 +20101125202116: DEBUG (ServiceSubscriber)
 +--------------- Created a new connection to the database!
 +20101125202116: DEBUG (ServiceSubscriber)
 +--------------- DataReady received from <> (Unknown)!
 +20101125202116: DEBUG (ServiceSubscriber)
 +--------------- CALL DataSubscribers: stationID: 17850 obstime: 2010-11-25 09:00:00 typeID: 330
 +20101125202116: DEBUG (service/getData)
 +--------------- called ...
 +20101125202116: DEBUG (service/getData)
 +--------------- isMaxClientReached: # : 0 max: 10000
 +20101125202116: INFO (service/getData)
 +--------------- New database connection (PostgreSQL) created!
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: called ...
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- stationid: 17850 currentEndTime: 0000-00-00 --:--:-- endTime: 0000-00-00 --:--:-- iData: 0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- select(17850, 2010-11-24 17:00:01, 2010-11-25 05:00:00
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- data: nElements=77
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- textData: nElements=0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- DataIteratorImpl::findData: return TRUE
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[0].dataList.length()=9
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[1].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[2].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[3].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[4].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[5].dataList.length()=8
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[6].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[7].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[8].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[9].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[10].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList->length()=12
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- text_data: 
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- No <textdata>!
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: called ...
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- stationid: 17850 currentEndTime: 2010-11-25 05:00:01 endTime: 2010-11-25 18:00:00 iData: 0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- select(17850, 2010-11-25 05:00:01, 2010-11-25 17:00:00
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- data: nElements=52
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- textData: nElements=0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- DataIteratorImpl::findData: return TRUE
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[0].dataList.length()=10
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[1].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[2].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[3].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[4].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[5].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList[6].dataList.length()=6
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList->length()=8
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- text_data: 
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- No <textdata>!
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: called ...
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- stationid: 17850 currentEndTime: 2010-11-25 17:00:01 endTime: 2010-11-25 18:00:00 iData: 0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- select(17850, 2010-11-25 17:00:01, 2010-11-25 18:00:00
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- data: nElements=0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- textData: nElements=0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- DataIteratorImpl::findData: return TRUE
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: End of data reached (return false)!
 +20101125202116: DEBUG 
 +--------------- DataIteratorImpl::destroy: called!
 +20101125202116: DEBUG 
 +--------------- DataIteratorImpl::destroy: leaving!
 +20101125202116: DEBUG (service/getData)
 +--------------- called ...
 +20101125202116: DEBUG (service/getData)
 +--------------- isMaxClientReached: # : 1 max: 10000
 +20101125202116: INFO (service/getData)
 +--------------- New database connection (PostgreSQL) created!
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: called ...
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- stationid: 17850 currentEndTime: 0000-00-00 --:--:-- endTime: 0000-00-00 --:--:-- iData: 0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- select(17850, 2010-11-25 09:00:00, 2010-11-25 09:00:00
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- data: nElements=6
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- textData: nElements=0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- DataIteratorImpl::findData: return TRUE
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: obsDataList->length()=1
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- text_data: 
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- No <textdata>!
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: called ...
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: End of data reached (return false)!
 +20101125202116: DEBUG 
 +--------------- DataIteratorImpl::destroy: called!
 +20101125202116: DEBUG 
 +--------------- DataIteratorImpl::destroy: leaving!
 +20101125202116: DEBUG (service/getData)
 +--------------- called ...
 +20101125202116: DEBUG (service/getData)
 +--------------- isMaxClientReached: # : 2 max: 10000
 +20101125202116: INFO (service/getData)
 +--------------- New database connection (PostgreSQL) created!
 +20101125202116: DEBUG (service/DataIterator)
 +--------------- next: called ...
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- stationid: 17850 currentEndTime: 0000-00-00 --:--:-- endTime: 0000-00-00 --:--:-- iData: 0
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- select(17850, 2010-11-25 09:00:00, 2010-11-25 09:00:00
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- data: nElements=6
 +20101125202116: DEBUG (service/DataIterator/findData)
 +--------------- textData: nElements=0
 +</code>
 +
 +
 +
 ====== Test Case for Qc2 Single Linear ====== ====== Test Case for Qc2 Single Linear ======
  
-This test case is in reponse to version 3.2 of the ftime {{:kvoss:system:qc2:test:algorithms:qc2-d2_flagg_08_2010_v32.pdf|flag specification}}.+This test case is in reponse to version 3.2 of the ftime {{kvalobs:kvoss:system:qc2:test:algorithms:qc2-d2_flagg_08_2010_v32.pdf|flag specification}}.
  
-The following steps are performed on **dev-vm101**. The test data source file and algorithm configuration have been pre-loaded. When necessary the test data may be restored from this {{:kvoss:system:qc2:test:qc2-211-singlepointtest.db.dat.gz|FILE}} and the configuration from the [[:kvoss:system:qc2:test:slv32#reference|Reference Section]] below.+The following steps are performed on **dev-vm101**. The test data source file and algorithm configuration have been pre-loaded. When necessary the test data may be restored from this {{kvalobs:kvoss:system:qc2:test:qc2-211-singlepointtest.db.dat.gz|FILE}} and the configuration from the [[kvalobs:kvoss:system:qc2:test:slv32#reference|Reference Section]] below.
  
 For shell commands the prefix "$" represents the Unix prompt. All the SQL commands are typed with no admonishments. For shell commands the prefix "$" represents the Unix prompt. All the SQL commands are typed with no admonishments.
Line 42: Line 215:
 SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime; SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
 </code> </code>
-  * Please see the [[:kvoss:system:qc2:test:slv32#reference|Reference Section]] below for a printout of the test data that is inserted.+  * Please see the [[kvalobs:kvoss:system:qc2:test:slv32#reference|Reference Section]] below for a printout of the test data that is inserted.
  
 ^Step 3^ ^Step 3^
Line 501: Line 674:
  
 </code> </code>
 +====== Data History ======
 +
 +**NB** The results from 2010-09-26 correspond to the test reported above (a similar test was also carried out earlier).
 +
 +<code>
 +kvalobs=# select * from data_history where obstime='2025-09-16 12:00:00' and stationid=87120 and paramid=211 order by modificationtime;
 + 
 +Cancel request sent
 +ERROR:  canceling statement due to user request
 +kvalobs=# select * from data_history where obstime='2025-09-16 12:00:00' and stationid=87120 and paramid=211 order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                           cfailed                            |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------------+----------------------------
 + 87813610 |     87120 | 2025-09-16 12:00:00 |    -19.1 |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |    -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1                         | 2010-09-24 10:52:27.021832
 + 88015727 |     87120 | 2025-09-16 12:00:00 |          |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |           |                  |                  |                                                              | 2010-09-25 10:58:55.972068
 + 88015728 |     87120 | 2025-09-16 12:00:00 |    -19.1 |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |       6.7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2                  | 2010-09-25 10:58:55.983701
 + 88310641 |     87120 | 2025-09-16 12:00:00 |          |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |           |                  |                  |                                                              | 2010-09-26 22:21:01.274446
 + 88310829 |     87120 | 2025-09-16 12:00:00 |    -19.1 |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |    -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1                         | 2010-09-26 22:24:30.465528
 + 88310864 |     87120 | 2025-09-16 12:00:00 |          |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |           |                  |                  |                                                              | 2010-09-26 22:24:35.941759
 + 88310899 |     87120 | 2025-09-16 12:00:00 |    -19.1 |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |    -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1                         | 2010-09-26 22:24:37.960795
 + 88310930 |     87120 | 2025-09-16 12:00:00 |          |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |           |                  |                  |                                                              | 2010-09-26 22:29:55.536605
 + 88310931 |     87120 | 2025-09-16 12:00:00 |    -19.1 |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |       6.7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2                  | 2010-09-26 22:29:55.545059
 + 88311611 |     87120 | 2025-09-16 12:00:00 |          |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |           |                  |                  |                                                              | 2010-09-26 22:32:52.957787
 + 88311612 |     87120 | 2025-09-16 12:00:00 |    -19.1 |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |         7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2  QC2d-2          | 2010-09-26 22:32:52.96432
 + 88311617 |     87120 | 2025-09-16 12:00:00 |          |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |           |                  |                  |                                                              | 2010-09-26 22:34:51.328849
 + 88311618 |     87120 | 2025-09-16 12:00:00 |    -19.1 |     211 | 2010-09-16 12:03:25 |    330 | 0      |     0 |    -32766 | 05120021000000A0 | 5038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2  QC2d-2  QC2d-2  | 2010-09-26 22:34:51.33704
 +(13 rows)
 +
 +
 +</code>
 +
 +
 +...
 +
 +
 +<code>
 +kvalobs=# select * from data_history where obstime='2025-09-17 10:00:00' and stationid=87120 and paramid=211 order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |         cfailed          |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------+----------------------------
 + 87813632 |     87120 | 2025-09-17 10:00:00 |   -32767 |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |    -32767 | 0100003000000000 | 7899900000000000 |                          | 2010-09-24 10:52:27.021832
 + 88015725 |     87120 | 2025-09-17 10:00:00 |          |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |           |                  |                  |                          | 2010-09-25 10:58:55.846379
 + 88015726 |     87120 | 2025-09-17 10:00:00 |   -32767 |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |       9.1 | 0100001100000000 | 5894900000000000 |  QC2d-2                  | 2010-09-25 10:58:55.915267
 + 88310663 |     87120 | 2025-09-17 10:00:00 |          |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |           |                  |                  |                          | 2010-09-26 22:21:01.274446
 + 88310851 |     87120 | 2025-09-17 10:00:00 |   -32767 |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |    -32767 | 0100003000000000 | 7899900000000000 |                          | 2010-09-26 22:24:30.465528
 + 88310886 |     87120 | 2025-09-17 10:00:00 |          |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |           |                  |                  |                          | 2010-09-26 22:24:35.941759
 + 88310921 |     87120 | 2025-09-17 10:00:00 |   -32767 |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |    -32767 | 0100003000000000 | 7899900000000000 |                          | 2010-09-26 22:24:37.960795
 + 88310928 |     87120 | 2025-09-17 10:00:00 |          |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |           |                  |                  |                          | 2010-09-26 22:29:55.509838
 + 88310929 |     87120 | 2025-09-17 10:00:00 |   -32767 |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |       9.1 | 0100001100000000 | 5894900000000000 |  QC2d-2                  | 2010-09-26 22:29:55.519257
 + 88311609 |     87120 | 2025-09-17 10:00:00 |          |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |           |                  |                  |                          | 2010-09-26 22:32:52.939681
 + 88311610 |     87120 | 2025-09-17 10:00:00 |   -32767 |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |       7.3 | 0100001100000000 | 5894900000000000 |  QC2d-2  QC2d-2          | 2010-09-26 22:32:52.940653
 + 88311615 |     87120 | 2025-09-17 10:00:00 |          |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |           |                  |                  |                          | 2010-09-26 22:34:51.312347
 + 88311616 |     87120 | 2025-09-17 10:00:00 |   -32767 |     211 | 2010-09-17 10:32:33 |    330 | 0      |     0 |    -32767 | 0100003100000000 | 5899900000000000 |  QC2d-2  QC2d-2  QC2d-2  | 2010-09-26 22:34:51.313104
 +(13 rows)
 +
 +kvalobs=# 
 +
 +</code>
 +
 +**Note** Data not deleted from the database in case it is required for inspection.
  
 ====== Reference ====== ====== Reference ======
Line 597: Line 828:
 (34 rows) (34 rows)
 </code> </code>
 +
 +====== Operations Testing ======
 +
 +Some results from the general inspection of the database on dev-vm101 after a few days testing:
 +
 +<code>
 +kvalobs=# SELECT count(*) FROM data WHERE obstime BETWEEN '2010-09-24 20:00:00' and 'today' and cfailed like '%QC2%';                                        
 + count 
 +-------
 +    16
 +(1 row)
 +
 +kvalobs=# SELECT * FROM data WHERE obstime BETWEEN '2010-09-24 20:00:00' and 'today' and cfailed like '%QC2%';
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |             cfailed              
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------
 +     99754 | 2010-09-25 00:00:00 |   -32767 |     213 | 2010-09-25 00:30:40 |    330 | 0      |     0 |       1.9 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 00:00:00 |   -32767 |     262 | 2010-09-25 00:30:40 |    330 | 0      |     0 |      85.3 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 00:00:00 |   -32767 |     215 | 2010-09-25 00:30:40 |    330 | 0      |     0 |       2.5 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 00:00:00 |   -32767 |     211 | 2010-09-25 00:30:40 |    330 | 0      |     0 |         2 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 00:00:00 |   -32767 |     178 | 2010-09-25 00:30:40 |    330 | 0      |     0 |    1011.4 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     49800 | 2010-09-25 15:00:00 |   -32767 |     178 | 2010-09-25 15:30:09 |    330 | 0      |     0 |    1012.5 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     49800 | 2010-09-25 15:00:00 |   -32767 |     211 | 2010-09-25 15:30:09 |    330 | 0      |     0 |       5.7 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     49800 | 2010-09-25 15:00:00 |   -32767 |     262 | 2010-09-25 15:30:09 |    330 | 0      |     0 |      64.5 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     49800 | 2010-09-25 15:00:00 |   -32767 |     213 | 2010-09-25 15:30:09 |    330 | 0      |     0 |       5.6 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     49800 | 2010-09-25 15:00:00 |   -32767 |     215 | 2010-09-25 15:30:09 |    330 | 0      |     0 |         6 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     60990 | 2010-09-25 17:00:00 |    -99.9 |     178 | 2010-09-25 16:53:18 |    311 | 0      |     0 |    1017.1 | 0700001100000000 | 5894900000000001 | QC1-1-178:1,QC1-1-178x:1 QC2d-2 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     262 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      96.3 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     178 | 2010-09-25 23:30:10 |    330 | 0      |     0 |    1015.3 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     211 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      -0.3 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     213 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      -0.2 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     215 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      -0.1 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +(16 rows)
 +
 +kvalobs=# select * from data_history where obstime='' and stationid=87120 and paramid=211 order by modificationtime;
 +kvalobs=# select * from data_history where obstime='2010-09-25 00:00:00' and stationid=99754 and paramid=213  order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
 + 87920142 |     99754 | 2010-09-25 00:00:00 |   -32767 |     213 | 2010-09-25 00:30:40 |    330 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 |          | 2010-09-25 00:30:40.458435
 + 87974667 |     99754 | 2010-09-25 00:00:00 |          |     213 | 2010-09-25 00:30:40 |    330 | 0      |     0 |           |                  |                  |          | 2010-09-25 06:34:00.580871
 + 87974668 |     99754 | 2010-09-25 00:00:00 |   -32767 |     213 | 2010-09-25 00:30:40 |    330 | 0      |     0 |       1.9 | 0000001100000000 | 6894900000000000 |  QC2d-2  | 2010-09-25 06:34:00.622777
 +(3 rows)
 +
 +kvalobs=# select * from data_history where obstime='2010-09-25 00:00:00' and stationid=99754 and paramid=211  order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
 + 87920141 |     99754 | 2010-09-25 00:00:00 |   -32767 |     211 | 2010-09-25 00:30:40 |    330 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 |          | 2010-09-25 00:30:40.453091
 + 87971303 |     99754 | 2010-09-25 00:00:00 |          |     211 | 2010-09-25 00:30:40 |    330 | 0      |     0 |           |                  |                  |          | 2010-09-25 06:08:27.567518
 + 87971304 |     99754 | 2010-09-25 00:00:00 |   -32767 |     211 | 2010-09-25 00:30:40 |    330 | 0      |     0 |         2 | 0000001100000000 | 6894900000000000 |  QC2d-2  | 2010-09-25 06:08:27.606269
 +(3 rows)
 +
 +kvalobs=# select * from data_history where obstime='2010-09-25 00:00:00' and stationid=99754 and paramid=178  order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
 + 87920140 |     99754 | 2010-09-25 00:00:00 |   -32767 |     178 | 2010-09-25 00:30:40 |    330 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 |          | 2010-09-25 00:30:40.452025
 + 87928769 |     99754 | 2010-09-25 00:00:00 |          |     178 | 2010-09-25 00:30:40 |    330 | 0      |     0 |           |                  |                  |          | 2010-09-25 01:42:02.857757
 + 87928770 |     99754 | 2010-09-25 00:00:00 |   -32767 |     178 | 2010-09-25 00:30:40 |    330 | 0      |     0 |    1011.4 | 0000001100000000 | 6894900000000000 |  QC2d-2  | 2010-09-25 01:42:02.871307
 +(3 rows)
 +
 +kvalobs=# select * from data_history where obstime='2010-09-25 15:00:00' and stationid=49800 and paramid=262  order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
 + 88053044 |     49800 | 2010-09-25 15:00:00 |   -32767 |     262 | 2010-09-25 15:30:09 |    330 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 |          | 2010-09-25 15:30:09.934391
 + 88119212 |     49800 | 2010-09-25 15:00:00 |          |     262 | 2010-09-25 15:30:09 |    330 | 0      |     0 |           |                  |                  |          | 2010-09-25 23:35:33.618095
 + 88119213 |     49800 | 2010-09-25 15:00:00 |   -32767 |     262 | 2010-09-25 15:30:09 |    330 | 0      |     0 |      64.5 | 0000001100000000 | 6894900000000000 |  QC2d-2  | 2010-09-25 23:35:33.664943
 +(3 rows)
 +
 +kvalobs=# select * from data where obstime between '2010-09-25 14:00:00' and '2010-09-25 16:00:00' and stationid=49800 and paramid=262; stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
 +     49800 | 2010-09-25 14:00:00 |       64 |     262 | 2010-09-25 13:59:09 |    330 | 0      |     0 |        64 | 0100000000000000 | 7000000000000000 | 
 +     49800 | 2010-09-25 15:00:00 |   -32767 |     262 | 2010-09-25 15:30:09 |    330 | 0      |     0 |      64.5 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     49800 | 2010-09-25 16:00:00 |       65 |     262 | 2010-09-25 17:00:23 |    330 | 0      |     0 |        65 | 0100000000000000 | 7100000400000000 | 
 +(3 rows)
 +
 +kvalobs=# 
 +kvalobs=# select * from data where obstime between '2010-09-25 16:00:00' and '2010-09-25 18:00:00' and stationid=60990 and paramid=178;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |             cfailed              
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------
 +     60990 | 2010-09-25 16:00:00 |   1016.6 |     178 | 2010-09-25 15:53:19 |    311 | 0      |     0 |    1016.6 | 0100000000000010 | 7000000000000000 | 
 +     60990 | 2010-09-25 17:00:00 |    -99.9 |     178 | 2010-09-25 16:53:18 |    311 | 0      |     0 |    1017.1 | 0700001100000000 | 5894900000000001 | QC1-1-178:1,QC1-1-178x:1 QC2d-2 
 +     60990 | 2010-09-25 18:00:00 |   1017.6 |     178 | 2010-09-25 17:53:18 |    311 | 0      |     0 |    1017.6 | 0100000000000010 | 7000000000000000 | 
 +(3 rows)
 +
 +kvalobs=# select * from data_history where obstime='2010-09-25 17:00:00' and stationid=60990 and paramid=178  order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |             cfailed              |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------+----------------------------
 + 88063331 |     60990 | 2010-09-25 17:00:00 |    -99.9 |     178 | 2010-09-25 16:53:18 |    311 | 0      |     0 |     -99.9 | 0000000000000000 | 9999900000000000 |                                  | 2010-09-25 16:53:19.026327
 + 88063466 |     60990 | 2010-09-25 17:00:00 |    -99.9 |     178 | 2010-09-25 16:53:18 |    311 | 0      |     0 |    -32767 | 0700003000000000 | 7899900000000001 | QC1-1-178:1,QC1-1-178x:1         | 2010-09-25 16:53:23.784335
 + 88135807 |     60990 | 2010-09-25 17:00:00 |          |     178 | 2010-09-25 16:53:18 |    311 | 0      |     0 |           |                  |                  |                                  | 2010-09-26 01:42:58.550019
 + 88135808 |     60990 | 2010-09-25 17:00:00 |    -99.9 |     178 | 2010-09-25 16:53:18 |    311 | 0      |     0 |    1017.1 | 0700001100000000 | 5894900000000001 | QC1-1-178:1,QC1-1-178x:1 QC2d-2  | 2010-09-26 01:42:58.597193
 +(4 rows)
 +
 +kvalobs=# select * from data_history where obstime='2010-09-25 23:00:00' and stationid=99754 and paramid=211  order by modificationtime;
 + version  | stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  |      modificationtime      
 +----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
 + 88118974 |     99754 | 2010-09-25 23:00:00 |   -32767 |     211 | 2010-09-25 23:30:10 |    330 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 |          | 2010-09-25 23:30:10.435031
 + 88126578 |     99754 | 2010-09-25 23:00:00 |          |     211 | 2010-09-25 23:30:10 |    330 | 0      |     0 |           |                  |                  |          | 2010-09-26 00:11:50.368793
 + 88126579 |     99754 | 2010-09-25 23:00:00 |   -32767 |     211 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      -0.3 | 0000001100000000 | 6894900000000000 |  QC2d-2  | 2010-09-26 00:11:50.382412
 +(3 rows)
 +
 +kvalobs=# select * from data where obstime between '2010-09-25 22:00:00' and '2010-09-26 00:00:00' and stationid=99754 and paramid=211;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
 +     99754 | 2010-09-25 22:00:00 |        0 |     211 | 2010-09-25 22:01:51 |    330 | 0      |     0 |         0 | 0111000000000010 | 7000000000000000 | 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     211 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      -0.3 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-26 00:00:00 |     -0.4 |     211 | 2010-09-26 00:01:55 |    330 | 0      |     0 |      -0.4 | 0110000000100010 | 7000000000000000 | 
 +(3 rows)
 +
 +kvalobs=# select * from data where obstime between '2010-09-25 22:00:00' and '2010-09-26 00:00:00' and stationid=99754 and paramid=213;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
 +     99754 | 2010-09-25 22:00:00 |        0 |     213 | 2010-09-25 22:01:51 |    330 | 0      |     0 |         0 | 0111000000000010 | 7000000000000000 | 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     213 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      -0.2 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-26 00:00:00 |     -0.4 |     213 | 2010-09-26 00:01:55 |    330 | 0      |     0 |      -0.4 | 0110000000000010 | 7000000000000000 | 
 +(3 rows)
 +
 +kvalobs=# select * from data where obstime between '2010-09-25 22:00:00' and '2010-09-26 00:00:00' and stationid=99754 and paramid=215;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
 +     99754 | 2010-09-25 22:00:00 |      0.1 |     215 | 2010-09-25 22:01:51 |    330 | 0      |     0 |       0.1 | 0111000000000010 | 7000000000000000 | 
 +     99754 | 2010-09-25 23:00:00 |   -32767 |     215 | 2010-09-25 23:30:10 |    330 | 0      |     0 |      -0.1 | 0000001100000000 | 6894900000000000 |  QC2d-2 
 +     99754 | 2010-09-26 00:00:00 |     -0.3 |     215 | 2010-09-26 00:01:55 |    330 | 0      |     0 |      -0.3 | 0110000000000010 | 7000000000000000 | 
 +(3 rows)
 +
 +kvalobs=# 
 +
 +</code>
 +
  • kvalobs/kvoss/system/qc2/test/slv32.1285540715.txt.gz
  • Last modified: 2022-05-31 09:23:18
  • (external edit)