About Ops Learning – past, present, future

[szabozoltan69]

The recent "Ops Learning" in Django data means one model in the PER section, with some many-to-many fields, beginning here:

• https://github.com/IFRCGo/go-api/blob/develop/per/models.py#L720

There is an API endpoint, for standard json and CSV data also:

• https://github.com/IFRCGo/go-api/blob/develop/per/drf_views.py#L717 and serializers in https://github.com/IFRCGo/go-api/blob/develop/per/serializers.py#L956 and below.

In CSV serialization we used a specific NarrowCSVRenderer, which means that the multiplied values of the many-to-many fields we show in a "narrow" way, i.e. repeating the rows with showing in the same column the different values of the many-to-many field. It's quite unique (and useful) in our GO api.

And we have a nice filter also:

• https://github.com/IFRCGo/go-api/blob/develop/per/drf_views.py#L653
  There is a planned cron job to read in the new OpsLearning entities. This task was done manually by Paola until now; if we decide to introduce that cron job, it could be fine.

The Django Admin page makes it possible to work with these OpsLearning records manually, validate or modify them. Recently there are 12663 records in the prod live database, which means a lots of data.

Here are some local testing options of using the ops-learning API endpoint. Normally the logged in users see more (e.g. about the appeal details) than the anonymous calls. That "-H ..." part below means a logged in usage:

curl 'http://localhost:8000/api/v2/ops-learning/' -H 'User-Agent: Mozilla/5.0 (X11...
curl 'http://localhost:8000/api/v2/ops-learning/'
curl 'http://localhost:8000/api/v2/ops-learning/52/?format=json' -H 'User-Agent: Mozilla/5.0 (X11...

curl 'http://localhost:8000/api/v2/ops-learning/?format=csv' -H 'User-Agent: Mozilla/5.0 (X11...
curl 'http://localhost:8000/api/v2/ops-learning/?format=csv'
curl 'http://localhost:8000/api/v2/ops-learning/52/?format=csv' -H 'User-Agent: Mozilla/5.0 (X11...

curl 'http://localhost:8000/api/v2/ops-learning/?search=MDRBF015'

[szabozoltan69]

An example API call output:

{
  "id": 13770,
  "learning": "Build teams' technical capacity in PGI issues.",
  "learning_validated": "Build teams' technical capacity in PGI issues.",
  "appeal_document_id": null,
  "type": 1,
  "type_validated": 1,
  "is_validated": true,
  "modified_at": "2024-01-19T14:29:39.489000Z",
  "created_at": "2024-01-19T14:29:39.489000Z",
  "organization": [
    2
  ],
  "organization_validated": [
    2
  ],
  "sector": [
    1
  ],
  "sector_validated": [
    1
  ],
  "per_component": [
    54
  ],
  "per_component_validated": [
    54
  ],
  "appeal": {
    "id": 3276,
    "aid": "15467",
    "name": "Argentina - Drought",
    "name_en": "Argentina - Drought",
    "name_es": null,
    "name_fr": null,
    "name_ar": null,
    "atype": 0,
    "status": 1,
    "code": "MDRAR017",
    "sector": "Southern Cone country cluster",
    "num_beneficiaries": 4000,
    "amount_requested": 291491.0,
    "amount_funded": 291491.0,
    "start_date": "2020-02-21T00:00:00Z",
    "end_date": "2020-07-31T00:00:00Z",
    "created_at": "2020-02-21T10:45:10.192209Z",
    "modified_at": "2023-10-02T14:50:14.700578Z",
    "previous_update": "2020-11-03T15:36:05Z",
    "real_data_update": "2023-01-03T10:43:01Z",
    "needs_confirmation": false,
    "triggering_amount": "0.00",
    "translation_module_original_language": "en",
    "translation_module_skip_auto_translation": false,
    "dtype": 20,
    "event": 3985,
    "country": 20,
    "region": 1
  }
}

And the same in CSV:

id,appeal_code,appeal_name,learning,finding,sector,component,organization,country_id,country_name,region_id,region_name,dtype_name,appeal_year,appeal_num_beneficiaries,modified_at
13770,MDRAR017,Argentina - Drought,Build teams' technical capacity in PGI issues.,Lesson learned,PGI,Staff and volunteer management,National Society,20,Argentina,1,Americas,Drought,2020,4000,2024-01-19

Some filtering options, and the given records count:

11  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?search=MDRBF015'                                                                                  
1   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?search=nationwide'                                                                                
1   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/13977/' #  or similar:                                                                             
1   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?id=13977' # (a 1-element list)                                                                    
3   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?id__in=13977,13976,13975'                                                                         
3   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?id__in=13977,13976,13975&is_validated=true'                                                       
0   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?is_validated=false'                                                                               
176 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?type_validated=1'                                                                                 
194 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?type_validated=2'                                                                                 
2   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_document_id=8992'                                                                          
12  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?sector_validated=3'                                                                               
32  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?sector_validated=4'                                                                               
44  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?sector_validated__in=3,4'                                                                         
21  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?per_component_validated=10'                                                                       
5   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?per_component_validated=44'                                                                       
25  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?per_component_validated__in=10,44'                                                                
11  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?organization_validated=1'                                                                         
362 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?organization_validated=2'                                                                         
370 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?organization_validated__in=1,2'                                                                   
13  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?modified_at__gte=2024-02-01T00:00:00'                                                             
11  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__code=MDRBF015'                                                                       
11  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code=MDRBF015&'                                                                            
24  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__in=MDRBF015,MDRBF014&'                                                               
16  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__num_beneficiaries=5000&'                                                             
172 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__num_beneficiaries__gte=5000&'                                                        
170 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__num_beneficiaries__gte=5000&appeal_code__num_beneficiaries__lte=50000'               
26  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__start_date__gte=2022-12-23T00:00:00&'                                                
26  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__start_date__gte=2022-12-23T00:00:00&appeal_code__start_date__lte=2023-12-23T00:00:00'
344 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__start_date__lte=2022-12-23T00:00:00&'                                                
112 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__dtype=12&'                                                                           
122 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__dtype__in=12,2&'                                                                     
6   'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__country=1'                                                                           
49  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__country__in=1,21'                                                                    
123 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__country__iso=AR'                                                                     
129 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__country__iso__in=AR,UA'                                                              
43  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__country__iso3=ARM'                                                                   
49  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__country__iso3__in=ARM,UKR'                                                           
43  'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__country__name=Armenia'                                                               
103 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__region=3'                                                                            
226 'https://goadmin-stage.ifrc.org/api/v2/ops-learning/?appeal_code__region__in=1,3'