Projet

Général

Profil

0004-make-statistics-on-evolutions-fixes-14297.patch

Benjamin Dauvergne, 08 mars 2019 00:26

Télécharger (4,02 ko)

Voir les différences: 

Subject: [PATCH 4/4] make statistics on evolutions (fixes #14297)


 tests/olap.model   | 35 +++++++++++++++++++++++++++++++++++
 wcs_olap/feeder.py | 21 +++++++++++++++++++++
 2 files changed, 56 insertions(+)
tests/olap.model
133 133 
               "name" : "count",
134 134 
               "type" : "integer"
135 135 
            },
136 
            {
137 
               "expression" : "count(evolution.id)",
138 
               "join" : [
139 
                  "evolution"
140 
               ],
141 
               "label" : "nombre de demandes ayant changée de statut",
142 
               "name" : "count",
143 
               "type" : "integer"
144 
            },
136 145 
            {
137 146 
               "expression" : "avg(endpoint_delay)",
138 147 
               "label" : "délai de traitement moyen",
......
228 237 
               "value" : "status.id",
229 238 
               "value_label" : "status.label"
230 239 
            },
240 
            {
241 
               "join" : [
242 
                  "evolution",
243 
                  "evolution_status"
244 
               ],
245 
               "label" : "statut dans l'historique",
246 
               "name" : "evolution_status",
247 
               "type" : "integer",
248 
               "value" : "evolution_status.id",
249 
               "value_label" : "evolution_status.label"
250 
            },
231 251 
            {
232 252 
               "filter" : false,
233 253 
               "join" : [
......
329 349 
               "name" : "status",
330 350 
               "table" : "status_demande"
331 351 
            },
352 
            {
353 
               "detail" : "id",
354 
               "master" : "evolution.status_id",
355 
               "name" : "evolution_status",
356 
               "table" : "status_demande"
357 
            },
332 358 
            {
333 359 
               "detail" : "id",
334 360 
               "master" : "function__receiver",
......
363 389 
               "name" : "count",
364 390 
               "type" : "integer"
365 391 
            },
392 
            {
393 
               "expression" : "count(evolution.id)",
394 
               "join" : [
395 
                  "evolution"
396 
               ],
397 
               "label" : "nombre de demandes ayant changée de statut",
398 
               "name" : "count",
399 
               "type" : "integer"
400 
            },
366 401 
            {
367 402 
               "expression" : "avg(endpoint_delay)",
368 403 
               "label" : "délai de traitement moyen",
wcs_olap/feeder.py
217 217 
                    'type': 'integer',
218 218 
                    'expression': 'count({fact_table}.id)',
219 219 
                },
220 
                {
221 
                    'name': 'count',
222 
                    'label': u'nombre de demandes ayant changée de statut',
223 
                    'type': 'integer',
224 
                    'expression': 'count(evolution.id)',
225 
                    'join': ['evolution'],
226 
                },
220 227 
                {
221 228 
                    'name': 'avg_endpoint_delay',
222 229 
                    'label': 'délai de traitement moyen',
......
901 908 
            'value': 'status.id',
902 909 
            'value_label': 'status.label',
903 910 
        })
911 
        cube['joins'].append({
912 
            'name': 'evolution_status',
913 
            'table': self.status_table_name,
914 
            'master': 'evolution.status_id',
915 
            'detail': 'id',
916 
        })
917 
        cube['dimensions'].append({
918 
            'name': 'evolution_status',
919 
            'label': 'statut dans l\'historique',
920 
            'join': ['evolution', 'evolution_status'],
921 
            'type': 'integer',
922 
            'value': 'evolution_status.id',
923 
            'value_label': 'evolution_status.label',
924 
        })
904 925 

  		




  905
  926
  
    
        # add dimension for function

  		




  906
  927
  
    
        for function, name in self.formdef.schema.workflow.functions.iteritems():

  		




  907
  
  
    
-