Skip to content

Instantly share code, notes, and snippets.

@hellais

hellais/ooni-api-queries.sql

Created December 14, 2015 21:35
Show Gist options
  • Save hellais/09d0b942721004c55ac8 to your computer and use it in GitHub Desktop.
Save hellais/09d0b942721004c55ac8 to your computer and use it in GitHub Desktop.
Download ZIP
interesting queries for ooni-api
Raw
ooni-api-queries.sql
# Interesting DNS Consistency tests
SELECT input, report_id FROM reports WHERE test_name='dns_consistency' AND (test_keys->>'tampering_detected')::bool=true;
# Interesting HTTP requests tests
SELECT input, report_id FROM reports WHERE test_name='http_requests' AND (test_keys->>'body_length_match')::bool=false;
# Interesting tests that indicate a generic failure
SELECT input, report_id FROM reports WHERE test_keys->>'failure' != 'null';
@hellais
Copy link
Author

hellais commented Dec 14, 2015

failure is one of the strings amongst the following: https://github.com/TheTorProject/ooni-spec/blob/master/data-formats/df-000-base.md#error-strings

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment