Ajout parametre lazy sur relation et split dans une nouvelle materialized view

[alancolant]

DROP MATERIALIZED VIEW documentsview;
CREATE MATERIALIZED VIEW documentsview AS 
SELECT id as reference,annonce_id as annonce_id, JSON_BUILD_OBJECT('order',"documents"."order",'url',CASE WHEN documents.disk='media_images' THEN CONCAT('https://my-cdn.com/',documents.name) WHEN documents.disk='manual' THEN CONCAT('https://mymanual-cdn.com',documents.name) END)
FROM documents;
---Annonces---
CREATE MATERIALIZED VIEW annoncesview AS
SELECT annonces.id as reference, JSON_BUILD_OBJECT('documents',JSON_AGG(documentsview.*))
FROM annonces
LEFT OUTER JOIN documentsview ON documentsview.annonce_id = annonces.id
GROUP BY annonces.id;