Fully functional querying examples

Question

Fully functional querying examples

Closed this issue 3 years ago · 9 comments

There needs to be support for all the requirements of cross-level ViEWS work : i.e. merging data from LOA cm to LOA pgm outputing pgm, as well as aggregating data from LOA pgm to LOA cm. Support for, e.g. countries having no PGM attached should be there.

Answer 1 · 2021-11-10T09:49:23.000Z

This is currently supported. Do you have a reprex / queryset where this doesn't work?

Answer 2 · 2021-11-10T13:31:21.000Z

Mihai, please provide a query that explores this, as basis for discussion.

Answer 3 · 2021-11-10T18:28:07.000Z

A set of queries and outputs are located here:
https://github.com/UppsalaConflictDataProgram/ingester3_loaders/blob/main/QueryExamples.ipynb

Answer 4 · 2021-11-15T09:12:19.000Z

Thanks! I'll make sure that these work.

Answer 5 · 2021-11-30T11:38:26.000Z

@mihaicroicu, I keep testing with these queries, and the previously missing LOA stuff works now. The assertions that assume global data do not, though, perhaps we could write some new ones?

Answer 6 · 2021-11-30T11:40:04.000Z

Will do. On 30 Nov 2021, at 12:38, Peder G. Landsverk ***@***.******@***.***>> wrote: @mihaicroicu<https://github.com/mihaicroicu>, I keep testing with these queries, and the previously missing LOA stuff works now. The assertions that assume global data do not, though, perhaps we could write some new ones? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#31 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AAY7UXAWWGCMIHXVUP7ZFVLUOSZTZANCNFSM5HV54TLA>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. När du har kontakt med oss på Uppsala universitet med e-post så innebär det att vi behandlar dina personuppgifter. För att läsa mer om hur vi gör det kan du läsa här: http://www.uu.se/om-uu/dataskydd-personuppgifter/ E-mailing Uppsala University means that we will process your personal data. For more information on how this is performed, please read here: http://www.uu.se/en/about-uu/data-protection-policy

Answer 7 · 2021-11-30T15:07:29.000Z

Mihai helpfully pointed out that queries should predictably return all rows @ the requested LOA. This is implemented in prio-data/views_query_planning#2. I'll enable the service with this new update tomorrow.

Answer 8 · 2021-12-01T15:32:26.000Z

Hey! I've pushed the change to Hermes now, confirm if data returned is as expected?

Answer 9 · 2021-12-08T10:30:34.000Z

The latest iteration of this set of example queries returns data as expected with all assertions passing, so I'm closing this.