Work on script that generates the data formats for visualisation team
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)