Deactivate INNM

Specification

Purpose

This WS is designed to deactivate medication by ID (post)

Input parameters 

• id

Authorize

1. Verify the validity of access token
2. Check user scope (scope = 'medication:deactivate') in order to perform this action
   1. In case error - generate 401 response

Validate PK Medication

Purpose validation: Check on existing Medication record 

1. Check exist Medication by $.id.

   1. if invalid - return 404 error (message: "Medication is not found!")

Validate status

Purpose validation:  Medication should be active (is_active == TRUE)

1. Validate `is_active` == TRUE

1. 1. if invalid  - return 409 eror (message: "Medication should be active !")

Validate status linked Medications

Purpose validation:  For INNM - all linked (child) Medications should be inactive (is_active == FALSE)

1. Get linked medications, check exist active medications

1. 1. if invalid  - return 409 eror (message: "All linked medication should be inactive !")

IF EXIST (
	SELECT * FROM medications M
		WHERE M.is_active == TRUE
			AND M.type == MEDICATIONS
			AND (M.ingridients.id = $.id AND M.ingridients.is_active_substance)
)

Update medication

Update medication record by $.id  set values: