Linear Road

Result queries

1. The following queries can be used to see the differences (if any) that the validator and your system generated:
   1. Accident alerts that the validator generated but yours did not
      SELECT * FROM accAlertNotInOriginal;
   2. Accident alerts that the your system generated but the validator did not
      SELECT * FROM accAlertNotInValidator;
   3. Toll alerts that the validator generated but yours did not
      SELECT * FROM tollAlertNotInOriginal;
   4. Toll alerts that the your system generated but the validator did not
      SELECT * FROM tollAlertNotInValidator;
   5. Account balance that differ from the validator and yours
      SELECT * FROM type2wronganswers;
   6. Daily expenditure that differ from the validator and yours
      SELECT * FROM type3wronganswers;
      
      If all queries return (0 rows), the two versions are 100% matched.
   
   
2. The following queries can be used to see data imported from your system:
   1. Number of car datapoints
      SELECT count (*) FROM input;
   2. Car datapoints
      SELECT * FROM input;
   3. Number of accident alerts
      SELECT count (*) FROM accidentAlerts;
   4. Accident alerts
      SELECT * FROM accidentAlerts;
   5. Number of toll alerts
      SELECT count (*) FROM tollAlerts;
   6. Toll alerts
      SELECT * FROM tollAlerts;
   7. Number of account balance requests
      SELECT count (*) FROM type2requests;
   8. Account balance requests
      SELECT * FROM type2requests;
   9. Number of daily expenditure requests
      SELECT count (*) FROM type3requests;
   10. Daily expenditure requests
       SELECT * FROM type3requests;
   11. Number of account balance answers
       SELECT count (*) FROM outputtype2;
   12. Account balance answers
       SELECT * FROM outputtype2;
   13. Number of daily expenditure answers
       SELECT count (*) FROM outputtype3;
   14. Daily expenditure answers
       SELECT * FROM outputtype3;
   
   
3. The following queries can be used to see data the validator generated:
   1. Number of accident alerts
      SELECT count (*)
      FROM tollAccAlerts
      WHERE accidentSeg <> -1;
      If the two versions are 100% matched, this number must be equal to the the number at (2.3)
   2. Accident alerts
      SELECT time, carid, accidentSeg
      FROM tollAccAlerts
      WHERE accidentSeg <> -1;
   3. Number of toll alerts
      SELECT count (*) FROM tollAccAlerts;
      If the two versions are 100% matched, this number must be equal to the the number at (2.5)
   4. Toll alerts
      SELECT time, carid, lav, toll
      FROM tollAccAlerts;
   5. Number of account balance answers
      SELECT count (*) FROM type2answer;
      If the two versions are 100% matched, this number must be equal to the the number at (2.11)
   6. Account balance answer
      SELECT * FROM type2answer;
   7. Number of daily expenditure answers
      SELECT count (*) FROM type3answer;
      If the two versions are 100% matched, this number must be equal to the the number at (2.13)
   8. Daily expenditure answers
      SELECT * FROM type3answer;
   
   
4. The following queries can be used to see other information that the validator extracted
   1. Accidents
      SELECT * FROM accident ORDER BY firstminute;
   2. Statistics
      SELECT * FROM statistics;