Bulk data improvement

[adunsulag]

CALL createClonedPatients(2);

15 records in prescriptions....

Diprospan, Suspensao injetavel (1un de 1mL)

SET @insertDate = NOW();
SELECT MAX(encounter) INTO @maxencounter FROM form_encounter;

INSERT INTO form_encounter2 (uuid, date, pid, encounter, pc_catid, class_code, referring_provider_id) SELECT UuidToBin(UUID()), @insertDate, pid, @maxencounter + pid, 19, 'AMB', 1 FROM patient_data2;
INSERT INTO uuid_registry(uuid, table_name, table_id, mapped, created) SELECT uuid, 'form_encounter', 'id', 0, NOW() FROM form_encounter2 WHERE encounter > @maxencounter;

INSERT INTO forms2 (date, encounter, form_name, form_id, groupname, pid, user, formdir)
SELECT @insertDate, fe.encounter, 'New Patient Encounter', fe.id, 'Default', pd.pid, 1, 'newpatient' FROM form_encounter2 fe JOIN patient_data2 pd ON fe.id = pd.pid WHERE fe.encounter > @maxencounter;

CREATE TEMPORARY TABLE enc_pop (encounter INT PRIMARY KEY, modulus INT) select form_encounter2.encounter, MOD(form_encounter2.encounter,15) AS modulus FROM form_encounter2 HAVING modulus = 0

CREATE TEMPORARY TABLE drug_pop (name VARCHAR(75));
INSERT INTO drug_pop VALUES ('Diprospan Suspenao injetval (1un de 1Ml)'), ('Cloridato de fluoxetina 20mg, Capsula dura'), ('Alginac Compromido revistido (30un)'), ('ATESTADO MEDICO'), ('Dorene 75mg Capsula gelatinosa dura (30un)'), ('Cloridato de tramadol 50mg, Capsula gelatinosa dura (10un)');

SET @insertCurrentDate = CURRENT_DATE();
INSERT INTO prescriptions (uuid, drug, active, end_date, date_added, patient_id, encounter, provider_id, drug_dosage_instructions,txDate,usage_category_title, request_intent_title) SELECT UuidToBin(UUID()), drug_pop.name, 1, NULL, @insertCurrentDate, fe2.pid, fe2.encounter, 1,'', @insertCurrentDate,'','' FROM drug_pop CROSS JOIN enc_pop JOIN form_encounter2 fe2 ON enc_pop.encounter = fe2.encounter