github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/migration/v2_to_v3/options_dev.sql (about)

     1  -- UPDATE camps SET date_fin = date_fin + interval '1 year';
     2  UPDATE
     3      camps
     4  SET
     5      option_prix = jsonb_set(jsonb_set(option_prix, '{semaine}', '{"prix_1": 45, "prix_2": 55, "plage_1": {"to": "2020-10-05", "from": "2020-10-01"}, "plage_2": {"to": "2020-10-10", "from": "2020-10-06"}}'), '{active}', '"semaine"')
     6  WHERE
     7      id = 56;
     8  
     9  UPDATE
    10      camps
    11  SET
    12      option_prix = jsonb_set(jsonb_set(option_prix, '{quotient_familial}', '[25,35,45,55]'), '{active}', '"quotient_familial"')
    13  WHERE
    14      id = 57;
    15  
    16  UPDATE
    17      camps
    18  SET
    19      option_prix = jsonb_set(jsonb_set(option_prix, '{statut}', '[{"id": 1, "prix": 54, "statut": "test1", "description": "desc test"}, {"id":2, "prix": 54, "statut": "test2", "description": "desc test"}, {"id": 4, "prix": 54, "statut": "test3", "description": "desc test"}, {"id": 3, "prix": 54, "statut": "test4", "description": "desc test"}]'), '{active}', '"statut"')
    20  WHERE
    21      id = 58;
    22