pe.sql

CREATE OR REPLACE FUNCTION pes()
  RETURNS VOID AS $$
DECLARE something BIGINT;
BEGIN
  FOR i IN 1..10000 LOOP
    RAISE NOTICE 'Creating Row: %', i;
    INSERT INTO program_encounter (observations, earliest_visit_date_time, encounter_date_time, program_enrolment_id, uuid, version, created_by_id, last_modified_by_id, created_date_time, last_modified_date_time, encounter_type_id, name, max_visit_date_time, organisation_id, cancel_date_time, cancel_observations)
    VALUES ('{
      "0e620ea5-1a80-499f-9d07-b972a9130d60": [
        "3cf5e873-5b55-43ff-8fc2-15a0b78033f6",
        "d757c57b-c668-47ae-9d7e-4b61757e85b3",
        "714dffa2-7e24-4648-a977-eaf7ee63799d",
        "785d914e-5160-41c6-89c8-71ff5447fc1b"
      ],
      "0f87eac1-cf6a-4632-8af2-29a935451fe4": [
        "92ad8878-b476-4291-aa76-3377fa7cf19c",
        "4085f165-ccb8-409b-9d6e-ea7755cf123e",
        "761b7f7a-5db7-4115-aa84-32fcfce5ddfc",
        "1c478c50-4761-460c-b33c-a18d0c1500f7",
        "e27f4a35-c2ae-4d05-8930-e19e432221d1"
      ],
      "14598553-b87c-4c7c-b97a-27c83effae73": "e7b50c78-3d90-484d-a224-9887887780dc",
      "14bb22df-1348-4336-9e4a-66b0741a6c3b": "e7b50c78-3d90-484d-a224-9887887780dc",
      "15004f46-0720-417a-ab03-8805a3b549c4": "e7b50c78-3d90-484d-a224-9887887780dc",
      "1701b2f7-aaad-4808-9dcc-05437dd569f7": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "2973890d-0142-41a6-a6f5-988e7eb36d79": "e7b50c78-3d90-484d-a224-9887887780dc",
      "2eb87840-160d-4ee0-bb4c-55dc00c8998a": [
        "b5e3310a-7628-40d9-8bb3-961a6c302c84",
        "4f1c4d88-8d87-4a53-8e3a-1bb163e13b66"
      ],
      "2ebca9be-3be3-4d11-ada0-187563ff04f8": "c7f89d3c-2aa3-4570-a7a5-163e002fba66",
      "342a4172-131a-41fd-a9c7-ae16603b582f": "e7b50c78-3d90-484d-a224-9887887780dc",
      "34afa9e5-5a31-4f92-96c9-e13833bf023b": 11,
      "41b9cc54-8f06-4d9f-a70d-f9311b95c747": "e7b50c78-3d90-484d-a224-9887887780dc",
      "4c58ddb2-0ba9-490d-ba07-f1cd70e0905a": "e7b50c78-3d90-484d-a224-9887887780dc",
      "4cae960e-5e1e-4b23-9927-d95db35d83e3": "e7b50c78-3d90-484d-a224-9887887780dc",
      "4db4857f-7caa-4bd8-a528-09e8416e8f11": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "4f29a019-05f5-4d50-a255-81ab7e12b4a3": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "50d57508-77c3-4561-b8fc-402bd6d7a413": "e7b50c78-3d90-484d-a224-9887887780dc",
      "53ba2bf5-e8d8-4f88-86a3-0068465086ac": "e7b50c78-3d90-484d-a224-9887887780dc",
      "54a4c12f-7e67-471d-a668-eddc3b712c0d": "e7b50c78-3d90-484d-a224-9887887780dc",
      "5a300ad8-13f3-4d1c-aa2d-6bc36dcb5ff6": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "5af82adf-6be9-4792-9b3d-543b4b00f816": "e7b50c78-3d90-484d-a224-9887887780dc",
      "5e60baa0-c394-4140-80a6-424384a2f567": 0,
      "65fe703a-9756-4688-96d7-6854e783caa1": "e7b50c78-3d90-484d-a224-9887887780dc",
      "66dd68ee-6118-47df-95ee-a0d115a75a12": "e7b50c78-3d90-484d-a224-9887887780dc",
      "672815aa-4c3f-457b-ac87-fa0b3924c957": "e7b50c78-3d90-484d-a224-9887887780dc",
      "6c0ed446-b555-4bb7-90f8-6da6f9827ab9": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "719fc446-50b0-4212-9e91-47bfd1aa5559": [
        "48689220-7064-4a73-90c4-b8857445a0c8",
        "7b8829db-9a5a-4177-bab3-6f8e3bb3832c"
      ],
      "729d937f-204e-4409-8e0d-1cf9354cb980": "e7b50c78-3d90-484d-a224-9887887780dc",
      "75b1656e-2777-4753-9612-ce03a766a5e1": 44,
      "7ac0d759-c50d-4971-88e0-84274224c839": 17,
      "84e60852-0d0b-4e8e-a3b0-f22d079d42d9": "e7b50c78-3d90-484d-a224-9887887780dc",
      "9083aae8-0a78-4b5b-9177-dd993e6d088c": "64491e8e-cea5-4774-9cc8-d42442891e03",
      "9cb4c266-0511-48f6-a058-d4f1fa3eb17c": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "a3200784-2512-477b-9e78-f1c947d7dd75": "c7f89d3c-2aa3-4570-a7a5-163e002fba66",
      "a54fcfad-8656-46ae-9706-671a600eabca": [
        "6ebf2af2-38c6-4703-98c2-cba9f234b8f5"
      ],
      "b00a5ea2-e09c-43aa-b514-ac3c50474647": [
        "855fb739-19d8-418d-a8ae-c1da977b7fa9"
      ],
      "b249d6a2-fb5c-43aa-998e-fece3c37a6d4": [
        "cd637ed2-5a97-4f36-970a-3af1f27dfe78"
      ],
      "b573841e-83c4-4132-9a5d-92d227ce26a9": "e7b50c78-3d90-484d-a224-9887887780dc",
      "bd3d1ba3-0a85-4aa7-a62c-78254d8e0762": "905d4a48-7fe6-43ac-a64f-61b906596b34",
      "bd4bab3c-f0c5-4427-a2cb-325e538774e3": "e7b50c78-3d90-484d-a224-9887887780dc",
      "c874229a-47b4-4aab-9938-e88cf1cbadfc": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "cbcfdd44-dac8-435f-9cd9-35f20db1f367": "e7b50c78-3d90-484d-a224-9887887780dc",
      "cd637ed2-5a97-4f36-970a-3af1f27dfe78": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "d86fbdcd-cbd3-4c13-9067-3bbde010438f": "e7b50c78-3d90-484d-a224-9887887780dc",
      "d883d5fe-e17d-4136-b989-089fa0295e34": 157,
      "d9b98bba-885c-4f78-9bf6-ba251128a5c3": "e7b50c78-3d90-484d-a224-9887887780dc",
      "da15c64c-3a5b-4b0b-8cd4-f9636b9c4d3b": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "dc9882a4-ceff-4dc9-b6fc-3e2ba7e9b197": "3e7e80cc-1744-4292-a34f-1beff9dd2316",
      "e0340738-27fb-424d-8c8a-f783cd922659": "e7b50c78-3d90-484d-a224-9887887780dc",
      "e1687f36-b38d-4bf8-9dbf-59cdc6fa1b6d": 12,
      "e31481f1-c719-46dc-b1de-a0f282b33d12": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "e36ee991-51f2-4443-afbc-ab96a7ec4276": "e7b50c78-3d90-484d-a224-9887887780dc",
      "e90dee68-0a5f-4dd3-ae26-9b6229c4a02a": "246df73a-07d8-4924-8cf9-787dea8278fe",
      "eb47f6b7-1f64-4008-87f3-a781c7c342cd": "b14dc6d9-c724-4005-b407-77b365e8241d",
      "ed9ea061-2e35-41b8-a50f-aa2b30b7fc3c": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "f0e3c0db-0f01-4c3d-a468-b740849d0011": "e7b50c78-3d90-484d-a224-9887887780dc",
      "f161e8f8-7c20-4e5a-8ad7-80a09c60126e": [
        "1aff631c-e487-4202-a862-122b45168ac6",
        "7348b656-6d8e-4fb7-9ff8-5e667cd31151"
      ],
      "f3794468-8ff5-44a3-a279-2d8d2fb5aa78": "e7b50c78-3d90-484d-a224-9887887780dc",
      "f4ad3b83-8673-4040-9972-571ae93149ab": 2,
      "f621f0e0-f73f-4443-b02f-0b9d7cb5a5a6": "04bb1773-c353-44a1-a68c-9b448e07ff70",
      "f9ecabbc-2df2-4bfc-a6fa-aa417c50e11b": 9.6,
      "fb3214f4-d040-40bc-bd38-883ad5e0cae7": "4416a93c-38e8-4bc9-b440-00fa79d04914",
      "fda18675-59dc-4a69-82f7-4e137c274073": "29d29318-6b0c-4a2b-85e3-5392bd5a668f",
      "fdd74e4f-363b-4f74-a38c-d7e8ad1b00a1": "e7b50c78-3d90-484d-a224-9887887780dc"
    }', '2018-02-03 08:36:14.000000', '2018-02-03 08:36:34.000000', 1149, uuid_generate_v4(), 0, 1, 1,
        '2018-02-03 11:45:48.296000', '2018-02-03 11:45:48.296000', 7, 'Annual Visit', '2018-02-13 08:36:14.000000', 3,
            NULL, NULL)
    RETURNING id
      INTO something;
    RAISE NOTICE 'Created PE with id: %', something;
  END LOOP;
END
$$
LANGUAGE plpgsql;

SELECT count(*)
FROM program_encounter;
SELECT pes();