This is an old revision of the document!
ALG001
Working … 
Acceptance Test for Redistribution of 24 hour accumulated precipitation
| Step | Direction | Expected Result | Pass/Fail Criteria or Comment |
|---|---|---|---|
| 001 | – | – | – |
| 002 | – | – | – |
| 003 | – | – | – |
| 004 | – | – | – |
| 005 | – | – | – |
| 006 | – | – | – |
| 007 | – | – | – |
| 008 | – | – | – |
| 009 | – | – | – |
| 010 | – | – | – |
Prerequisites
Set up the test data (these are prepatory notes for now for set up on pak}
- $ psql kvalobs
- psql⇒ DELETE FROM data WHERE obstime>'2027-01-01' and obstime<'2028-01-01';
- psql⇒ COPY data FROM '/metno/kvalobs/TESTDATA/2027.dat' USING DELIMTERS ';';
- Run generator.pl commands (current set in /metno/kvalobs/TESTDATA/gencom2027.sh)
kvalobs@pak:~/TESTDATA$ psql kvalobs
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
kvalobs=# DELETE FROM data WHERE obstime>'2027-01-01' and obstime<'2028-01-01';
DELETE 124515
kvalobs=# COPY data FROM '/metno/kvalobs/TESTDATA/2027.dat' USING DELIMITERS ';';
COPY 124515
kvalobs=# \q
kvalobs@pak:~/TESTDATA$ ls
2027.dat gencom2027.sh generator.pl RA24-RESULTS-20091230.dat results20091230.dat
2047_paramid_110.dat gencom.sh plotXY.R RA_RA24_ScriptFile.sql Rplots.ps
kvalobs@pak:~/TESTDATA$ ./gencom2027.sh
Saved the results of the TEST data into a file and made ready for reinsert
kvalobs=# select * from data where obstime>'2027-01-01' and obstime<'2028-01-01' \g | cat >> ./TEST-DATA-2027-SIMULATED.dat;
$ ./MakeDataForInsert.sh TEST-DATA-2027-SIMULATED.dat
(NB afterwards replace "NULL" with "")
$ mv TEST-DATA-2027-SIMULATED.dat.temp 2027ProcessedTestData.dat
Run Qc2 RA_RR24 with triangle interpolation...
kvalobs=# select * from data where obstime>'2027-01-01' and obstime<'2028-01-01' and cfailed like '%TEST%Qc2%' \g | cat >> ./RA24-RESULTS-20100101-triangle.dat;
