github.com/ooni/api commits | Ecosyste.ms: OpenCollective

Improve query logging

5dc9f9b187471e8c178dd4225b7ed8f6a208ee63 authored about 5 years ago by Federico Ceratto <[email protected]>

More fine grained tests on fastpath vs traditional

afaa31374dc44f3e04807a2fd38e939388d5b3b8 authored about 5 years ago by Federico Ceratto <[email protected]>

Improve logging

8a2eec1513125a0658707e6ec4a391203a7bd000 authored about 5 years ago by Federico Ceratto <[email protected]>

Update fastpath measurement fetching

c80e158f647711d649abdc2b4ea4501c9da70e29 authored about 5 years ago by Federico Ceratto <[email protected]>

Improve pytest/Flask logging in integ tests

074ecfe86385f3a164dae9e3571b2a19de77f6c2 authored about 5 years ago by Federico Ceratto <[email protected]>

Update FASTPATH_MSM_ID_PREFIX

12f57d3696e8e729fdc79b9264e56d2f936b60e5 authored over 5 years ago by Federico Ceratto <[email protected]>

Cleanup unused imports

916e2904e67696ff1500219ab96f11aac0f63b79 authored over 5 years ago by Federico Ceratto <[email protected]>

Give access to scores column

Minor fixes

2ea82c56c2a0be9fbc4fa58f83c470431639b824 authored over 5 years ago by Federico Ceratto <[email protected]>

Add fastpath support and integration tests

Move the generation of measurement_id into the db query

27ec45d19b5b17bad614f201bbc867d9f4438276 authored over 5 years ago by Federico Ceratto <[email protected]>

Add fastpath db model

e8c252ac4ea8771073f96a1325a37cc8c6bd9ea8 authored over 5 years ago by Federico Ceratto <[email protected]>

Update country list

f1c3c79b0fb11ce08ae69d2b3d1b6904ad9e8900 authored over 5 years ago by Federico Ceratto <[email protected]>

Reflow file

08b6434f6af20165a6e41f11cd9f4be72d6fff40 authored over 5 years ago by Federico Ceratto <[email protected]>

Add tox.ini and update makefile

e512b0e137fd1e10d89528f3e2407f1f28ed8b34 authored over 5 years ago by Federico Ceratto <[email protected]>

Bump versions

a1817780202a6d56a4634bbe520050231fa01a2c authored over 5 years ago by Arturo Filastò <[email protected]>

Improvements to the SQL query

8a5cc9ee93b7cf90f577b0e9870284d51fe76f5d authored over 5 years ago by Arturo Filastò <[email protected]>

Revert "Work on optimizing the list_measurements API endpoints"

This reverts commit 4807a4f0aa4d0efd88bba00b349bbfdc649aab82.

bc21fd735ab2510315a78a4c04bbece3c52919b3 authored over 5 years ago by Arturo Filastò <[email protected]>

Bump version

f4fa57e68137e046760bb9235fcd21d6d3ac39d2 authored over 5 years ago by Arturo Filastò <[email protected]>

Add Changelog entry

bb1324aa99f4b14f8dc7c5fc9d925c3bd9993481 authored over 5 years ago by Arturo Filastò <[email protected]>

Upgrade Werkzeug

86a89460ef4c31449f122951e0b452410dfb491b authored over 5 years ago by Arturo Filastò <[email protected]>

Fix of by one with last bucket

35b44f422be4818579b7c9a00b48ce8508675971 authored over 5 years ago by Arturo Filastò <[email protected]>

Move the by_month queries into a separate call

c100cea4d13fd574b1620613cbd580c0679a39ec authored over 5 years ago by Arturo Filastò <[email protected]>

Restore private runs_by_month endpoint to how it was

fd47d5006db00627cfaea0c6de65e5e30b526939 authored over 5 years ago by Arturo Filastò <[email protected]>

Fix typo in jsonify

46f4461e13fa2d02505c05466598e1a7a7132a6d authored over 5 years ago by Arturo Filastò <[email protected]>

Add the by_month stats to the global_overview endpoint

c515cacebd9f8c643cc618e4d4c5729f46df779c authored over 5 years ago by Arturo Filastò <[email protected]>

Optimize the api_private_stats endpoints

e34108384fa1dec1d48f597b69aaf4795051443d authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #107 from ooni/bugfix-testday

Fix the query to avoid dupe dates

b98a117e49e4e85cd12267f0fbf5601ba35f871b authored over 5 years ago by Arturo Filastò <[email protected]>

Fix the query to avoid dupe dates

835eb4720fbed913bc7a4511eeafec0199bd4a28 authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #105 from ooni/faster-domain-filter

Faster domain filter

cbf7a3925812d01af798e70cb3f71de153dffe2f authored over 5 years ago by Arturo Filastò <[email protected]>

Add basic smoke test for input_cte

cfe9bf321385cc193dbb185fbbb3c260acf541b0 authored over 5 years ago by Arturo Filastò <[email protected]>

Drop unused imports

ae7f2b1f78f9d924d67535fd738265e1bae27cfe authored over 5 years ago by Arturo Filastò <[email protected]>

Work on optimizing the list_measurements API endpoints

Query time for an example query has gone from 537,136.721 ms
to 146.392 ms.

This improvement is...

4807a4f0aa4d0efd88bba00b349bbfdc649aab82 authored over 5 years ago by Arturo Filastò <[email protected]>

Don't send sentry exceptions while in developmnet mode

3d780929381d15afa0597679cbad53b1f984aa1d authored over 5 years ago by Arturo Filastò <[email protected]>

Add more debug to query time logging

abd4a142624373795290407acba4900e84e84b93 authored over 5 years ago by Arturo Filastò <[email protected]>

Bump version add changelog

c008868db22735aa3de076998342f2d3af864cf1 authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #103 from ooni/ooexpl_wc_input_counts

Use the materialized view ooexpl_wc_input_counts

8f1648f29f1ef7af9766cebb67679b1caf20b79f authored over 5 years ago by Arturo Filastò <[email protected]>

Add missing column to select

6a60d0ed5d4bdd11dc13258876b4e095f1ce6a44 authored over 5 years ago by Arturo Filastò <[email protected]>

Fix typo

83aece04bd2ed868fd3833036d658203ca05ff0c authored over 5 years ago by Arturo Filastò <[email protected]>

Fix passing Makefile variable

b6bcea7a3dcdd2404c126c0af6592549bd2e5277 authored over 5 years ago by Arturo Filastò <[email protected]>

Run the travis tests with production mode on

c2a4a10807f04ccca7889901e6c596ac3e6e5ce9 authored over 5 years ago by Arturo Filastò <[email protected]>

Use the pipeline master for fixtures

d7764a2d08e0f16dd6487207b27e95d6c606285d authored over 5 years ago by Arturo Filastò <[email protected]>

Add a fastpath for blockpages

2f1aa8c1bc045179f8bed3e7e3732713e2e7e8f4 authored over 5 years ago by Arturo Filastò <[email protected]>

Sort by total_count before anomaly count

9a340a2045690cd62281c796c280d65ea6703251 authored over 5 years ago by Arturo Filastò <[email protected]>

Add failure_count

9d15ac78e5636ea890f245010e214a7f1052a0f6 authored over 5 years ago by Arturo Filastò <[email protected]>

Use the materialized view ooexpl_wc_input_counts

This is related to: https://github.com/ooni/pipeline/pull/222

296158392a4042459e9d0af4c9d0ad5411df850c authored over 5 years ago by Arturo Filastò <[email protected]>

Bump version add changelog

311239460b4a18774c94371a670ebf177369095a authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #102 from ooni/fix-website-urls

Only consider the web_connectivity measurements when calculating webs…

1db5a00f9ed011bb5e779d001a81ee37697a080a authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #100 from ooni/feature/domain-search

Add support for searching by domain

1f7789bf427f5e39fd5bde861aac3940902b03fe authored over 5 years ago by Arturo Filastò <[email protected]>

Only consider the web_connectivity measurements when calculating website stats

3a31206afc234d7f1302dd722b86803ff6a4e179 authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #101 from ooni/better-exceptions

Better exceptions

eec4a0ddf08aab9bb781cb9263f3c473356942c7 authored over 5 years ago by Arturo Filastò <[email protected]>

Throw BadRequest instead of Exception to avoid polluting sentry

25bd5ef9d053899c49549ca52b1bff7fa1573e44 authored over 5 years ago by Arturo Filastò <[email protected]>

Add support for searching by domain

This implements: https://github.com/ooni/api/issues/52

7efb334a68c610aaf75d215dedeeac5621e426ad authored over 5 years ago by Arturo Filastò <[email protected]>

Add comments about the sections of the private endpoints

dca660539979b776591ef3dcca9cdcf7f9a44cd6 authored over 5 years ago by Arturo Filastò <[email protected]>

Drop the 1 day lag from the API queries for Explorer

Even if the pipeline ticks at 24h it's still bad to always put a lag of
24h because if the pipel...

36840fa8e365431d5268e64ba256bcb124df0220 authored over 5 years ago by Arturo Filastò <[email protected]>

Bump version add changelog entry

7ba9d53cd9bf12b3bf8b42d6a59116db893e7c59 authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #96 from ooni/legacy-explr-fix

Legacy explr fix

19f4929eaf1deedf1800a6b6be3d25db0c46943a authored over 5 years ago by Arturo Filastò <[email protected]>

Apply a limit of 100

1d8967fa2aa3ac4461643d247a4c0369e7622745 authored over 5 years ago by Arturo Filastò <[email protected]>

Restrict legacy explorer related queries to a 2 month window

47461e91eef18f0e2594bb469e99ecd7a2b2056f authored over 5 years ago by Arturo Filastò <[email protected]>

Bump version

592859b4ae70f313198763d96aa40112cd0f1b2c authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #94 from ooni/fix-blockpage

Fix blockpage

02f22d0a973d13b005e9e92988d103619c71d0b1 authored over 5 years ago by Arturo Filastò <[email protected]>

Apply ordering on test_day and GROUP BY

c66ce09adcda760f67976f590b4f65978e13eedf authored over 5 years ago by Arturo Filastò <[email protected]>

Create man dirs

9b1be55035e595dad7308d76a8d3d87dfb3ff2b1 authored over 5 years ago by Arturo Filastò <[email protected]>

Use 3.5-slim for python

9107dc4691c864383245aebb7747bc20929d6bf9 authored over 5 years ago by Arturo Filastò <[email protected]>

Bump changelog date

b6a048d7adcfe5982c70480777ff1e2ce06f9066 authored over 5 years ago by Arturo Filastò <[email protected]>

Bump API version and add Changelog

0d71dc64345f00c884b3980637146df87b7dcf34 authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #92 from ooni/performance

Compute the blockpage counts from the mat view

0438e3a8a1e856f90dadc90ad2dcf98ce31c273d authored over 5 years ago by Federico Ceratto <[email protected]>

Compute the blockpage counts from the mat view

xref: https://github.com/ooni/pipeline/pull/198

8a3300698b7718a07758becb2a9498045d86f1ef authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #88 from ooni/performance

Performance

81cf7b7f7cbbcf046497c35bb76350d8c9bbd283 authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #89 from pellaeon/master

Readme: add building assets

7ba9160eb48264e9f120724a9e064469230a0b94 authored over 5 years ago by Arturo Filastò <[email protected]>

Readme: add building assets

9a70f54b452b9970317f64103430d368c9eb076f authored over 5 years ago by Pellaeon Lin <[email protected]>

Add link to the config source

79c0f54a5a9cc7e8ec6f8cfb9a3217c01baa3db9 authored over 5 years ago by Arturo Filastò <[email protected]>

Group endpoints by function

a0a0acf053558ee43b5e9d831b966aaee8a2b61e authored over 5 years ago by Arturo Filastò <[email protected]>

app needs to be called application

8bc6876cd449737a5ae2f8e5793e3782e58226af authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #87 from ooni/update-deps

Update versions of jquery, urllib3, sqlalchemy, jinja2

2653428514340d8374e09beeeb98745de79828af authored over 5 years ago by Arturo Filastò <[email protected]>

Add support for exposing API metrics via prometheus

e2cedc16ee6ee6a707e278d496088ef772cc35b5 authored over 5 years ago by Arturo Filastò <[email protected]>

Only consider web_connectivity when doing blockpage calcs

8607287fe8ae1cacb2de7cd07e2d873db28dcb9a authored over 5 years ago by Arturo Filastò <[email protected]>

Downgrade sqlalchemy

ff6b4b1f9c5d81929f50686ba23c895fc1f0cd3c authored over 5 years ago by Arturo Filastò <[email protected]>

Explicitly use text for order_by

c6715ec986b82552f1f2158f108bcfc481c7b5d7 authored over 5 years ago by Arturo Filastò <[email protected]>

Update versions of jquery, urllib3, sqlalchemy, jinja2

492c8a75e030db40bbd30b5f96e4f1527bde1593 authored over 5 years ago by Arturo Filastò <[email protected]>

Add changelog entry and bump version

e1836a31cee47b68a8621cb5ad83fc6bd43deab1 authored over 5 years ago by Arturo Filastò <[email protected]>

Merge pull request #77 from ooni/feature/explorer-metrics

Implement views for OONI Explorer beta

79317fd7e0959d35dd0de04713b0688d678c159d authored over 5 years ago by Arturo Filastò <[email protected]>

Use the metadb for legacy explorer requests as well

77d44c95b895aed2955abeeed627951f27e84195 authored over 5 years ago by Arturo Filastò <[email protected]>

Add API endpoint for vanilla_tor measurements

f6c5f0685fa8b06b04f25c3519d828f25986abf1 authored over 5 years ago by Arturo Filastò <[email protected]>

Disable network_stats test

5458f0c71030c281af1c6e4bbd0c28bfa52b3697 authored over 5 years ago by Arturo Filastò <[email protected]>

Fix im e2e test

a47752380e04060921c24537ff175310092f33a7 authored over 5 years ago by Arturo Filastò <[email protected]>

Fix typo in test

d5d5f157f43b635e1ea3807b2945c1a7c39fd812 authored over 5 years ago by Arturo Filastò <[email protected]>

Add constraint to website_networks endpoint

ce8e8ed3d236f5eb43b216bf9630bb891d0c3939 authored over 5 years ago by Arturo Filastò <[email protected]>

Adjust test_start_time in website_stats as well

dea5f1ad0bb49026d6da17552f35ba1747727faf authored over 5 years ago by Arturo Filastò <[email protected]>

Use test_start_time instead of measurement_start_time

397beff3a5dea8edfea7ba77939e8a42fdba1df2 authored over 5 years ago by Arturo Filastò <[email protected]>

failure column is called msm_failure in the measurements table

4b8083b4b8012598ffd4a855c9b814fa41223e8e authored over 5 years ago by Arturo Filastò <[email protected]>

Fix check

f3a1be64b672630a7df577d82f8e9c02bf9387fd authored over 5 years ago by Arturo Filastò <[email protected]>

Check row length for the query of the first_bucket_date

30f621cf5b29733daa1d939cdf3c322e5deb8d87 authored over 5 years ago by Arturo Filastò <[email protected]>

Remove unneeded Makefile targets

6f1c987225a1f320c85ad766526c137d3b685364 authored over 5 years ago by Arturo Filastò <[email protected]>

Use same version of pg in sysadmin

fb04931b410b911ac05b5cbf60e2560c10772e7f authored over 5 years ago by Arturo Filastò <[email protected]>

Bump travis pg version

8908f31aafa48238b14fea82f70db2ffa3fabbd4 authored over 5 years ago by Arturo Filastò <[email protected]>

Fix path

9b56e56284d0709c550fa78ce36b89bb499291a8 authored over 5 years ago by Arturo Filastò <[email protected]>

Fix create directory line

3e084e037461aca5d32b5fca9354952e937f4e6f authored over 5 years ago by Arturo Filastò <[email protected]>

Fix npm

07bc3f5d5141678c85e68cf36c956ce0a971f3be authored over 5 years ago by Arturo Filastò <[email protected]>

Maybe fix travis

47c6f1e57213c4b3903fdbc7b1fb13aa20b5d2bb authored over 5 years ago by Arturo Filastò <[email protected]>

Refactor the ooexpl_websites table queries to use the measurements table instead

54e40c6a00fc4c8d7efda8ec234c56bdb36d6586 authored over 5 years ago by Arturo Filastò <[email protected]>

Fix bug in test_coverage API endpoint

7c408790774204b9de67f1478bf101973c45c00c authored over 5 years ago by Arturo Filastò <[email protected]>