Skip to content

Désactive la maille commune pour l’indicateur `arcep_techno`

Ronan Amicel requested to merge fix-fthd-arcep-maille-commune into main

La vue sur laquelle on s’appuie est à la maille département, donc on a une erreur :

INFO:insitu:Generating fiche 01 from numérique/département to /srv/insit
u/outbox/fiches/numérique/département/01 - Ain.docx
...
ERROR:insitu:Requête SQL: SELECT
  CAST(SUM("total") AS INT) AS "total",
  CAST(SUM("nbr_elig_8") AS INT) AS "nbr_elig_8",
  CAST(SUM("elig_ftth") AS INT) AS "elig_ftth",
  CAST(SUM("elig_coax") AS INT) AS "elig_coax",
  CAST(SUM("elig_cu_30") AS INT) AS "elig_cu_30",
  CAST(SUM("elig_thdr") AS INT) AS "elig_thdr",
  CAST(SUM("elig_cu_8") AS INT) AS "elig_cu_8",
  CAST(SUM("elig_4gf") AS INT) AS "elig_4gf",
  CAST(SUM("elig_hdr") AS INT) AS "elig_hdr",
  CAST(SUM("elig_sat") AS INT) AS "elig_sat",
  MIN("date") AS "date",
  CAST(SUM("total" - "nbr_elig_8") AS INT) AS "nbr_non_elig",
  ROUND(
    CAST((
      CAST((
        SUM("total") - SUM("nbr_elig_8") + SUM("elig_sat")
      ) AS DECIMAL) / CAST(SUM("total") AS DECIMAL)
    ) AS DECIMAL) * 100,
    2
  ) AS "pourcent_non_elig"
FROM "arcep_techno_view"
FULL JOIN "commune" AS "__insitu_geo_table"
  ON "arcep_techno_view"."insee_com" = "__insitu_geo_table"."insee_com"
WHERE
  "__insitu_geo_table"."insee_dep" = :code
...
asyncpg.exceptions.UndefinedColumnError: column arcep_techno_view.insee_com does not exist

Au passage on le marque comme déprécié car il est utilisé seulement dans les fiches Word.

Merge request reports