SELECT & UPDATE agreement.assistance_addition values

Update Vehicle agreement rates for Lahden Aluetaksi (https://app.clickup.com/t/2496230/TMS-5613)

SELECT agreement.index AS agreement_index,
    vehicle.index AS vehicle_index,
    vehicle.vehicle->'uuid' AS vehicle_uuid,
    vehicle.vehicle->'org_uuid' AS vehicle_org_uuid,
    vehicle.vehicle->'car_model' AS vehicle_car_model,
    vehicle.vehicle->'reg_number' AS vehicle_reg_number,
    vehicle.vehicle->'company_uuid' AS vehicle_company_uuid,
    vehicle.vehicle->'vehicle_type' AS vehicle_vehicle_type,
    agreement.org_uuid,
    agreement.assistance_addition,
    agreement.stair_climber_addition,
    agreement.stretcher_addition
FROM vehicle INNER JOIN agreement ON vehicle.index = agreement.vehicle_index
WHERE vehicle->'org_uuid' = '"6b1de742-525b-4945-8d0a-136d5574583f"'
AND vehicle->'vehicle_type' = '1'
ORDER BY agreement.index

UPDATE agreement
SET assistance_addition = '{"serialized": "0.00", "currency_code": "EUR", "serialized_currency": "0.00 €"}',
    stair_climber_addition = '{"serialized": "0.00", "currency_code": "EUR", "serialized_currency": "0.00 €"}',
    stretcher_addition = '{"serialized": "0.00", "currency_code": "EUR", "serialized_currency": "0.00 €"}'
FROM vehicle
WHERE vehicle.index = agreement.vehicle_index
AND vehicle->'org_uuid' = '"6b1de742-525b-4945-8d0a-136d5574583f"'
AND vehicle->'vehicle_type' = '1'
RETURNING agreement.index AS agreement_index,
    vehicle.index AS vehicle_index,
    vehicle.vehicle->'uuid' AS vehicle_uuid,
    vehicle.vehicle->'org_uuid' AS vehicle_org_uuid,
    vehicle.vehicle->'car_model' AS vehicle_car_model,
    vehicle.vehicle->'reg_number' AS vehicle_reg_number,
    vehicle.vehicle->'company_uuid' AS vehicle_company_uuid,
    vehicle.vehicle->'vehicle_type' AS vehicle_vehicle_type,
    agreement.org_uuid,
    agreement.assistance_addition,
    agreement.stair_climber_addition,
    agreement.stretcher_addition;

Another way to update: Update Makupa Fleet agreement prices (https://app.clickup.com/t/2496230/TMS-5825)

UPDATE agreement
SET assistance_addition = assistance_addition || jsonb_build_object(
    'units', 22, 
    'serialized', '22.00',  
    'display_float', 22, 
    'serialized_currency', '22.00 €',
    'nanos', 0
)
WHERE org_uuid = '0a4f0f4b-24b6-448f-907e-38237bb87698'
RETURNING
index, uuid, org_uuid, assistance_addition;