Deactivate INNM Dosage

Specification

Purpose

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

Input parameters 

• id

Authorize

1. Verify the validity of access token
2. Check user scope (scope = 'innm_dosage: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_primary` == TRUE

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

Validate status linked Medications

Purpose validation:  For INNM Dosage - all linked (child) Medications should be inactive (is_primary == 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_primary == TRUE
			AND M.type == MEDICATIONS
			AND (M.ingridients.id = $.id AND M.ingridients.is_primary)
)

Update medication

Update medication record by $.id  set values: