[tor-bugs] #13565 [Ooni]: Work on script that generates the data formats for visualisation team

[Tor Bug Tracker & Wiki]

#13565: Work on script that generates the data formats for visualisation team
--------------------------------------+-------------------------
 Reporter:  hellais                   |          Owner:  hellais
     Type:  task                      |         Status:  new
 Priority:  normal                    |      Milestone:
Component:  Ooni                      |        Version:
 Keywords:  ooni_data_analytics_team  |  Actual Points:
Parent ID:                            |         Points:
--------------------------------------+-------------------------
 This involves querying the database tables reports and measurements and
 adding data to a new table called "bridge_reachability" or
 "bridge_reachability_timeline" where all the data that is needed to
 visualise the data is placed.

 The data format that is needed by them is the following:
 https://transparencytoolkit.org/pretty_data.json with the addition of the
 key "status" that can have 4 values:

 * working (the bridge works, control == true, test == true)
 * blocked (the bridge is offline, control == true, test == false)
 * offline (the bridge is offline, control == false, test == false)
 * inconsistency  (there is probably a bug in ooni or tor or obfsproxy,
 control == false, test == true)

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/13565>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online