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;