Page Comparison

Table of Contents

Specification

...

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

...

1. Check exist Medication by $.id.

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

...

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

Validate status linked 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 record by $.id  set values: