API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 27th, 2017
156
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 65.71 KB | None | 0 0
raw download clone embed print report
  1. package com.jive.ua.provisioning;
  2.  
  3. import static com.google.common.collect.ObjectArrays.*;
  4. import static com.jive.ua.provisioning.internal.jooq.v4.Tables.*;
  5. import static java.util.Collections.*;
  6. import static java.util.function.Function.*;
  7. import static java.util.stream.Collectors.*;
  8.  
  9. import java.util.List;
  10. import java.util.Map;
  11. import java.util.Set;
  12. import java.util.UUID;
  13.  
  14. import lombok.Builder;
  15. import lombok.Cleanup;
  16. import lombok.NonNull;
  17. import lombok.Value;
  18. import lombok.extern.slf4j.Slf4j;
  19.  
  20. import org.jooq.DSLContext;
  21. import org.jooq.impl.DSL;
  22.  
  23. import com.google.common.collect.Lists;
  24. import com.jive.ua.provisioning.internal.jooq.v4.tables.records.UserAgentButtonRecord;
  25. import com.jive.ua.provisioning.internal.jooq.v4.tables.records.UserAgentConfigurationCustomAttributeRecord;
  26. import com.jive.ua.provisioning.internal.jooq.v4.tables.records.UserAgentConfigurationRecord;
  27.  
  28. /**
  29. * @author Brandon Pedersen
  30. */
  31. @Slf4j
  32. public class Fixerator
  33. {
  34.  
  35. private static final UUID JIVE_PBX_ID = UUID.fromString("0127d974-f9f3-0704-2dee-000100420001");
  36.  
  37. private static final List<UUID> EXISTING_UAC_IDS = Lists.newArrayList(
  38. "0159e14c-4169-969e-5c7f-000100620002", "0159e149-4ddb-039c-5c7f-000100620002",
  39. "0889f967-8d3b-4835-b785-c76606724c72", "948809c3-e24e-4c02-a8ec-7a059d3058a4",
  40. "8eb55d6e-caca-4458-b1d0-97c00a08273d", "39cb20fd-f396-4af7-86ed-b16e40686f3c",
  41. "66213e3c-9f22-42a6-8095-e5c3d15e65dd", "7511d92c-bc0f-4d5d-bfe0-57456425179c",
  42. "0159e141-053e-8bf6-5c7f-000100620002", "a16c68c1-329f-4659-97be-2e9f90a2725e",
  43. "12791245-ea4a-4ba9-b220-e5ed8f898102", "f0b57623-0a13-410f-acd0-f332e2cb9afb",
  44. "086a78d4-d297-4a31-8aa8-616626f8b95d", "0159e13c-51a7-a25e-5c7f-000100620002",
  45. "f8877ef4-b044-4b27-b21f-ec47f1318000", "0159e13b-397f-080c-5c7f-000100620002",
  46. "ca8ad27c-45d9-483d-81f4-6affbb432aff", "48dea32f-d8be-493e-90e1-bc113017e1dd",
  47. "0159e138-9d81-76d5-9113-000100610002", "2c1dc0dd-bcd6-4087-bf03-0c8cf2ba2ffc",
  48. "6c44f148-4181-4b2e-8a85-370ab873c797", "e5a1f9a6-7d1f-4268-b6ad-71228f4dc41e",
  49. "31b4c3b6-c444-4c4d-99cb-56489d66ee80", "537122cb-2090-4871-b5c5-f45057e54a75",
  50. "0159e130-7ffe-ca6f-9113-000100610002", "9e4c55c7-d6bb-4ed3-94f0-daf5538d26de",
  51. "0053743e-2d22-4a62-88ed-6c0c17e92c1b", "21fa9337-e4be-4afb-8af4-d8bc13957da8",
  52. "0159e12d-76a7-a3e6-5c7f-000100620002", "0159e12d-94a2-9f3e-9113-000100610002",
  53. "0a91a921-a692-4171-a694-c69ae4a4a0a7", "0159e12c-60cc-07fe-5c7f-000100620002",
  54. "94e5ec76-aed6-4149-b0d2-0030d8da56d3", "0159e12a-0621-a018-5c7f-000100620002",
  55. "cae984d1-931c-48fb-87c3-6e233f2eddcb", "040d1909-a79a-49fc-8250-a1eafe2f28c0",
  56. "3a99e59a-1834-4cae-817e-ae9eb248b026", "1e093040-03a3-43de-804d-a6d40a6b2d5c",
  57. "0159e127-54bf-19ef-5c7f-000100620002", "eeb97097-3fc1-42bc-9a12-a9de6780354e",
  58. "2dc0b034-fbca-4af8-801f-4a0b8ab211a1", "c8b8e8d9-4aab-4a55-b2e2-01e8cd872c77",
  59. "0159e125-332e-bdbb-5c7f-000100620002", "0159e124-7f8b-3cc8-5c7f-000100620002",
  60. "56e82f63-77fe-442b-9ce6-20bd7b30efcb", "824aaccb-6ff3-466a-abc6-2a16d27ebb04",
  61. "0159e120-5cab-66ef-9113-000100610002", "0159e11f-ab5b-10fc-5c7f-000100620002",
  62. "aeac5cb6-6c8f-44d9-ad01-7292955305f9", "2bed920f-aede-40ad-8453-7ae0c409badd",
  63. "0159e11e-760b-19b0-5c7f-000100620002", "e067a542-e552-483f-8931-5768d1f9910d",
  64. "0159e11d-4157-638f-5c7f-000100620002", "0159e11c-1dc6-bb49-5c7f-000100620002",
  65. "01431242-afbd-3707-5961-000100620002", "014a07d1-bfec-2673-83fe-000100620005",
  66. "ba10dae7-34db-4dc3-a5fb-c926f34ce735", "0026882b-a1fe-42d6-8d83-c3a81c427ab8",
  67. "0159e11a-6511-df91-5c7f-000100620002", "498ba628-6e00-47fb-bdb6-450d2e6a54dc",
  68. "a3cfb0c3-eabb-4783-ba93-a5506ea870ce", "0159e116-8efa-bdb9-5c7f-000100620002",
  69. "d711585e-9bff-410d-8a01-14e7b1e66d2d", "48215347-15ab-479d-b25f-6c7a652b748d",
  70. "d84d6909-0937-4e0c-8e12-6ce6c233f2ff", "0159e113-2794-dc82-5c7f-000100620002",
  71. "99da3269-d8dd-4e77-b72f-fe7dc8ab0e0b", "0159e112-2458-3b0d-5c7f-000100620002",
  72. "0159e111-8a71-d0ac-5c7f-000100620002", "4fb38ab8-1f9a-452a-ae53-278ce9c6f41f",
  73. "fd11df9c-bdd7-4d20-ab63-243804a62388", "0159e110-e5d8-0c60-9113-000100610002",
  74. "0159e110-73a1-1446-5c7f-000100620002", "0159e110-5c9a-05fd-5c7f-000100620002",
  75. "ad476bbf-8bee-4e94-852f-6a3e19ac4dc5", "0159e10f-8fe6-5f25-5c7f-000100620002",
  76. "0159e10f-0358-fb0c-5c7f-000100620002", "0159e10e-de2f-e102-5c7f-000100620002",
  77. "83687921-b214-44b5-a560-97651bffb8e9", "0159e10c-b0c1-90b4-5c7f-000100620002",
  78. "0159e10c-f4ac-b92f-5c7f-000100620002", "0159e10b-96a8-a6cc-5c7f-000100620002",
  79. "0159e10b-506e-7111-9113-000100610002", "85d82ffe-e8d7-4961-980b-fb2181ecfe94",
  80. "3392d0fa-37f3-44e0-8762-5dc0472ce89a", "0159e107-c3fe-5b6c-5c7f-000100620002",
  81. "01504823-646b-761d-ae26-000100620002", "0159513d-377b-5f17-3af9-000100610002",
  82. "014f6adf-516f-3210-42f2-000100620005", "0150d9af-9913-1fba-9dea-000100610001",
  83. "0150de75-14a7-5135-9dea-000100610001", "0153bf60-2585-0167-f0d6-000100610002",
  84. "015064be-6317-24fc-c57f-000100610004", "01506738-a2d8-9f39-87e7-000100610001",
  85. "015521a3-6c27-3438-da57-000100610001", "01506735-9efb-94d1-87e7-000100610001",
  86. "0142c532-a64d-e624-eea4-000100620005", "01531096-fd73-815f-0ff9-000100620007",
  87. "01540695-0e75-ae6b-f0d6-000100610002", "0154dee6-0933-4477-cef8-000100610002",
  88. "0153a4e7-b661-2df0-f0d6-000100610002", "01541ae7-0b63-6687-7ae6-000100610001",
  89. "0154dee6-07c1-4433-cef8-000100610002", "015085ff-d1f3-0763-6f99-000100620005",
  90. "578eadc2-103d-4523-9194-bc064f4fbbc4", "015043fb-be19-22fe-ae26-000100620002",
  91. "5396add2-baff-4fb5-bf42-1afad877a95f", "30c8e909-1481-48b2-83e3-3e4d3b3d5f59",
  92. "0151ad04-cb20-e4cc-35c7-000100610004", "0159dbc1-0ece-d9ad-9113-000100610002",
  93. "0159dbae-f2a0-a39c-9113-000100610002", "0159dba3-ecd8-5fa6-5c7f-000100620002",
  94. "0159dba1-cf9f-49d9-5c7f-000100620002", "0159db21-1303-2e28-9113-000100610002",
  95. "31632294-f168-402e-ad7e-bf89d1495167", "0159656c-b50f-0bc0-3af9-000100610002",
  96. "01568010-fb1e-a507-431a-000100620007", "0159d735-ea14-30fd-9113-000100610002",
  97. "0159d729-0482-09d2-9113-000100610002", "0159d6f8-0df8-8d0b-9113-000100610002",
  98. "0159d6d4-6bdf-1951-9113-000100610002", "0154bfba-9441-2aa9-cef8-000100610002",
  99. "01526588-72d7-1c07-97ba-000100620002", "01571041-ebcf-f909-db9a-000100610002",
  100. "0157b010-df48-1bfc-581d-000100610002", "015337d4-5b2d-c311-6dfb-000100620009",
  101. "0159d6ac-ffbd-989f-9113-000100610002", "01552428-31d7-dcdb-45a5-000100620009",
  102. "015579ab-de25-b537-47d8-000100610001", "0152f67f-4a8c-3082-cfa6-000100620009",
  103. "0159d293-de91-7aa5-8ed4-000100610002", "01548704-d140-f7d6-97f4-000100620009",
  104. "0159d1cc-1c2e-6774-8ed4-000100610002", "0159d196-8a01-779f-fa8b-000100620002",
  105. "01429655-253b-a4ba-2aa1-000100620002", "014dd402-b62b-daa6-6278-000100620005",
  106. "0158e533-2f9d-3a6b-54d0-000100610002", "01581a6a-9f13-6357-ee3e-000100620002",
  107. "0159bcac-e7d7-f294-8ed4-000100610002", "a75fa538-3e12-4512-9227-13a013a05089",
  108. "0159c963-3e92-8eba-8ed4-000100610002", "0159c8c9-5356-5737-fa8b-000100620002",
  109. "0159c73d-69af-e51d-fa8b-000100620002", "0159c707-679d-3dca-fa8b-000100620002",
  110. "0159c281-8067-1954-8ed4-000100610002", "0159be0d-6b94-986e-8ed4-000100610002",
  111. "0159bdd8-e756-105a-8ed4-000100610002", "0159bd57-19b7-bcca-8ed4-000100610002",
  112. "01389b4a-0e01-b449-4345-000100620001", "014ebc7f-ff4a-c925-a2a1-000100620005",
  113. "0157b9c9-34aa-c3a6-17a8-000100610002", "014f50a7-1e48-987d-2ff1-000100620002",
  114. "0159bd1d-da19-1f01-8ed4-000100610002", "0150ce3d-7bb2-fc70-07f7-000100620002",
  115. "0158d5c2-311b-51b4-54d0-000100610002", "0157289d-b9bf-dbfc-db9a-000100610002",
  116. "01539eb9-606e-ed5a-2c55-000100620007", "0159b7c9-f4aa-3cb4-8ed4-000100610002",
  117. "0159b7c9-5212-3ab2-8ed4-000100610002", "0159b3ed-a3cf-a00a-8ed4-000100610002",
  118. "015527e0-66bf-1f0c-da57-000100610001", "0155dfb6-738e-3cf4-ec6a-000100610002",
  119. "01492e3b-8804-969a-77ba-000100620002", "01591e31-1905-2d7c-3af9-000100610002",
  120. "0159b20a-1e87-ddc7-8ed4-000100610002", "0159af2b-866f-bcce-8ed4-000100610002",
  121. "015168e4-d68e-cf22-949f-000100620005", "0152e660-a671-025d-f918-000100610002",
  122. "0159aec4-bb08-3188-fa8b-000100620002", "0159a5c2-a6c1-0020-fa8b-000100620002",
  123. "0159adac-2f2a-cb94-8ed4-000100610002", "0159ada2-b69d-643e-fa8b-000100620002",
  124. "0159ada1-c1e5-ec1e-fa8b-000100620002", "0159a99b-135f-53ab-8ed4-000100610002",
  125. "0159a960-f254-ac51-8ed4-000100610002", "0159a878-479f-ab58-8ed4-000100610002",
  126. "4d7e4200-b71f-467c-bfc6-6a9ba4bfffaf", "0159ddf1-8a90-2b01-9113-000100610002",
  127. "0159dde5-e195-1db8-9113-000100610002", "836beb71-2838-4f6f-a45f-84585f0fa999",
  128. "d9f81eca-fbdb-416b-ad97-ed7e1ee8113f", "01572a87-ccda-e12d-db9a-000100610002",
  129. "0153aacd-4ff7-1adf-f0d6-000100610002", "0156c84e-8dc4-3084-9e44-000100610002",
  130. "0154cb06-11fe-16db-cef8-000100610002", "01545441-32d6-43e7-3594-000100610002",
  131. "01513a11-75ee-2b95-ad69-000100610001", "01507172-a9fb-888b-b23d-000100610004",
  132. "014bb7e3-6c3b-c061-bb21-000100620002", "0156a3a5-a6a3-a7a3-4a4e-000100610006",
  133. "01508b69-645c-1fc0-5d79-000100610004", "015028f5-95d8-b269-6828-000100610004",
  134. "01599905-9810-f48c-fa8b-000100620002", "015998f7-b0f4-7c00-8ed4-000100610002",
  135. "01569a61-88a5-23a5-8853-000100610002", "01539b08-5cdd-bd98-f0d6-000100610002",
  136. "01538a82-839b-3038-2c55-000100620007", "01569624-aec0-2a1f-8853-000100610002",
  137. "0157537e-917c-bb26-db9a-000100610002", "01572e8f-0525-f7f0-97c3-000100620007",
  138. "015998a2-80f4-99a7-8ed4-000100610002", "01599897-6b6d-7f69-8ed4-000100610002",
  139. "015996d7-9c9b-e7d4-8ed4-000100610002", "015554c4-0283-781a-da57-000100610001",
  140. "015994a7-6de8-16fa-3af9-000100610002", "0159949f-b3ba-fd47-3af9-000100610002",
  141. "0159949c-3381-f366-3af9-000100610002", "01593019-6e0f-ffad-3af9-000100610002",
  142. "01598eed-6d91-ad5c-3af9-000100610002", "01598eea-3615-a47b-3af9-000100610002",
  143. "0150bafc-e4ae-fd80-012a-000100610001", "01549b62-ed64-cd83-4700-000100610001",
  144. "01598ec9-3fc4-4559-3af9-000100610002", "01598ebe-0cf4-295a-3af9-000100610002",
  145. "01598e18-9982-6b87-3af9-000100610002", "014d78d0-665b-c623-a461-000100620002",
  146. "014c1359-efcd-895b-6df7-000100620002", "0159891d-6017-2508-3af9-000100610002",
  147. "01598484-912b-db4e-ef44-000100620002", "01598448-effc-1fe5-3af9-000100610002",
  148. "0159840d-b551-a7bb-3af9-000100610002", "01597f4e-e194-2e93-3af9-000100610002",
  149. "01597675-8a5b-c727-3af9-000100610002", "015975e5-239d-b58d-3af9-000100610002",
  150. "015975bd-04f0-443b-ef44-000100620002", "015975b6-e12c-fce0-ef44-000100620002",
  151. "015975b2-f2dc-c1f4-ef44-000100620002", "0159751a-8831-6f3f-ef44-000100620002",
  152. "01597518-256d-034c-ef44-000100620002", "01597514-8523-8e70-3af9-000100610002",
  153. "9945be2d-c4cf-411c-a00e-60ccf2b6b647", "01597483-6b7f-3a3e-3af9-000100610002",
  154. "0159706b-ae4b-6402-3af9-000100610002", "01596ffb-943c-7865-3af9-000100610002",
  155. "01596f3b-a19f-1d8d-ef44-000100620002", "01596c34-c8c3-5736-3af9-000100610002",
  156. "01596bae-2695-6747-3af9-000100610002", "01596a84-b8ed-d38c-3af9-000100610002",
  157. "01596a32-42a4-346b-3af9-000100610002", "015965bf-8bfe-cb15-3af9-000100610002",
  158. "01531b8b-7af4-3313-0ff9-000100620007", "0149e8eb-837b-b9e4-5167-000100620005",
  159. "01595185-933d-0392-3af9-000100610002", "01594d8b-c9fa-db2e-3af9-000100610002",
  160. "015947fe-5912-aead-3af9-000100610002", "01594774-ca20-b757-3af9-000100610002",
  161. "01594226-01dc-ca8a-3af9-000100610002", "01594157-2d84-1fe5-3af9-000100610002",
  162. "0154df14-f948-1436-712c-000100620007", "01530982-e7d9-d25a-d170-000100610002",
  163. "0156abf5-5c36-3bdf-4a4e-000100610006", "01570ff5-0d04-5942-db9a-000100610002",
  164. "01504848-f3c4-c1b5-ae26-000100620002", "0156d792-5fb8-f83f-9e44-000100610002",
  165. "01593618-8ea4-fd68-ef44-000100620002", "014f61cf-a025-0869-42f2-000100620005",
  166. "01588cba-b05d-acfd-afa1-000100620002", "015927cc-0763-7911-ef44-000100620002",
  167. "01592788-061a-baf1-3af9-000100610002", "01527afe-8387-b1e7-0cdf-000100610001",
  168. "015071bf-2c63-67e1-b23d-000100610004", "0154ca06-9387-5bf9-cef8-000100610002",
  169. "0151a77d-d46e-44cd-35c7-000100610004", "014ed561-13d5-eb57-c0f0-000100620002",
  170. "01591e6b-737b-644b-ef44-000100620002", "01591d99-dd13-8f91-3af9-000100610002",
  171. "01591856-b89b-a49a-3af9-000100610002", "01555c3e-c91b-5b01-b2eb-000100610002",
  172. "01571eed-26d9-4ee8-db9a-000100610002", "d29e42e1-f14f-4dc4-8a57-ecf203ac8cb3",
  173. "b5634e66-a737-4218-906a-6c6de7870efc", "01511ba7-4d9b-b36b-ad69-000100610001",
  174. "01549ca2-5f82-5c33-4700-000100610001", "0154c937-1e6e-60e8-cef8-000100610002",
  175. "01549ca2-6042-5c66-4700-000100610001", "01590838-8bc9-56ae-3af9-000100610002",
  176. "3b304927-fedc-4d78-a203-c4650bba58dc", "01590598-7152-9415-3af9-000100610002",
  177. "01539afe-6c4b-6476-2c55-000100620007", "0159030b-b2af-0928-9fe3-000100620002",
  178. "015902f8-305d-d7c9-54d0-000100610002", "0158ff46-7908-bf7d-216e-000100620002",
  179. "0147ff50-e989-b595-ff21-000100620005", "0158fe92-28cb-a076-216e-000100620002",
  180. "015561c0-e3c4-cf90-b2eb-000100610002", "015560d6-3a35-bc6b-b2eb-000100610002",
  181. "0152144f-8c3c-788a-fcdf-000100620002", "015716d4-ecff-9aa0-db9a-000100610002",
  182. "0158f8d9-d7ef-1a6c-54d0-000100610002", "0158f4ff-5bbf-bc17-736b-000100620002",
  183. "0154c4d7-78ba-6904-cef8-000100610002", "01554b3e-c7f2-b570-da57-000100610001",
  184. "015231db-75b7-db7e-1aae-000100610001", "0151a41f-c1d1-b0a4-35c7-000100610004",
  185. "0151a394-238b-faae-35c7-000100610004", "01582bc6-b9aa-420e-a5df-000100610002",
  186. "0150877a-0f91-cad5-5d79-000100610004", "01506cc0-e609-359f-b23d-000100610004",
  187. "0154a714-d279-d791-4700-000100610001", "0148b27e-d007-f3fc-b632-000100620005",
  188. "0148b27e-706c-cab6-b632-000100620005", "014fb403-17b8-8410-9706-000100620005",
  189. "01567189-84fa-d94c-8853-000100610002", "0138fe02-357b-b45a-7706-000100620002",
  190. "014f61d0-8836-6949-42f2-000100620005", "015522f1-b171-5822-da57-000100610001",
  191. "0158e47d-a796-7bd4-54d0-000100610002", "0158e43f-8e14-e464-54d0-000100610002",
  192. "015960e4-715d-32d9-3af9-000100610002", "0154c98a-64cb-636d-cef8-000100610002",
  193. "01549669-8fd3-a1ec-4700-000100610001", "01595026-1cf7-0827-ef44-000100620002",
  194. "01594dc4-7afd-d9da-ef44-000100620002", "01594bc8-61bc-60c1-3af9-000100610002",
  195. "0159495b-e3b1-2843-3af9-000100610002", "015948ab-6e38-961f-3af9-000100610002",
  196. "015942c5-6250-4671-ef44-000100620002", "0154ed8d-2772-33f7-cb38-000100610001",
  197. "01559d63-2cc1-137b-2ac4-000100610002", "01565190-b786-790f-5512-000100610006",
  198. "01565096-e98f-1c67-5512-000100610006", "0150727f-5535-c27e-b23d-000100610004",
  199. "0150727f-5464-c268-b23d-000100610004", "0150b0b7-c6cb-3c89-bbc5-000100610001",
  200. "0158732d-27ae-52e4-f326-000100610002", "0151f380-71fb-af77-5d88-000100620005",
  201. "0158d738-7033-3fab-54d0-000100610002", "0158d72f-3900-33d5-54d0-000100610002",
  202. "0158d5ef-46b9-ba04-54d0-000100610002", "015851b5-4041-a705-184c-000100610002",
  203. "0154c740-ea26-7db0-cef8-000100610002", "0153be5d-b8fa-0ba1-f0d6-000100610002",
  204. "0144406b-6084-0629-4969-000100620002", "0158d0e5-3ea1-eec3-54d0-000100610002",
  205. "0158c16a-895d-d2f4-736b-000100620002", "01541ae7-0ad1-6659-7ae6-000100610001",
  206. "0158c0ab-0f60-7661-54d0-000100610002", "0158c0a2-360f-5b55-54d0-000100610002",
  207. "0158c09c-7ff7-4a35-54d0-000100610002", "0158c084-7543-0d50-54d0-000100610002",
  208. "0150f8d5-dcb8-72a3-0de2-000100610004", "0152e7d4-7456-a84a-f918-000100610002",
  209. "01556ae6-c99e-9d72-b2eb-000100610002", "0158b748-a77b-f834-54d0-000100610002",
  210. "01580173-e8b4-8dc5-a5df-000100610002", "0157baea-dbac-fa2a-17a8-000100610002",
  211. "0156a3b5-1253-3d71-a73d-000100620009", "0158b636-c363-82e4-54d0-000100610002",
  212. "0157dd2f-839f-0585-a5df-000100610002", "015869bf-cd80-a256-ead6-000100620002",
  213. "0158b101-f173-a82c-736b-000100620002", "0158b0fe-c7c2-a7c1-54d0-000100610002",
  214. "0158b0c3-5d89-d736-54d0-000100610002", "0158b0ad-ea4a-a3ea-54d0-000100610002",
  215. "c4c32c26-835f-460b-a741-86e7891b5d51", "0158ace6-8fc0-6d21-aebb-000100610002",
  216. "014cd7e3-665b-d322-281e-000100620002", "0158ac1e-0747-d664-5e9e-000100620002",
  217. "0158abd5-42eb-89d6-5e9e-000100620002", "015047e2-764b-77a3-ae26-000100620002",
  218. "01427bd3-96c3-1136-e9d1-000100620005", "014097a3-ebaa-b76e-e7b1-000100620005",
  219. "01487998-f680-1094-7e7f-000100620005", "0146b9bf-7ace-70e8-6e39-000100620002",
  220. "01487994-711d-d8af-7e7f-000100620005", "014f604f-4758-facf-6377-000100620002",
  221. "fdd50343-43c2-4f31-b181-db12cb9fee40", "01573439-9e28-287b-db9a-000100610002",
  222. "0153100f-ecee-9f3c-d170-000100610002", "0152ccb1-9201-4f71-26dd-000100620009",
  223. "0150d9a6-d506-0b7f-9dea-000100610001", "0157954e-d7c3-b24f-db9a-000100610002",
  224. "014ffb51-f38a-dbde-e5ea-000100610001", "01572114-51e4-6536-db9a-000100610002",
  225. "0153100f-ec25-9eb3-d170-000100610002", "0150de76-0bba-53cc-9dea-000100610001",
  226. "0154bfc9-71f3-8bbd-cef8-000100610002", "014ffb4e-bfe0-3f15-ec60-000100620002",
  227. "01473b32-5056-8fd4-37a1-000100620005", "01586f62-668f-6793-f326-000100610002",
  228. "01586f2e-771d-90fc-7d32-000100620002", "0157e97a-a16b-acb7-a5df-000100610002",
  229. "0153527a-3e35-a4d1-07b0-000100610001", "0157ff27-edb2-ab36-a5df-000100610002",
  230. "0151d61f-5279-83dd-c3bd-000100610004", "01506d16-cc0d-3d26-b23d-000100610004",
  231. "0156b2cc-690e-2c45-4a4e-000100610006", "0154e411-e8d1-c913-cef8-000100610002",
  232. "0150aaed-825c-ba6d-bbc5-000100610001", "01476e5b-0218-df18-053e-000100610004",
  233. "0152842a-5bc0-33a6-e5e2-000100610001", "01362744-1400-b795-95e9-000100620001",
  234. "015260fd-d5d8-cf1c-4b0e-000100610004", "012c22ef-e1ae-2482-bef7-000100620001",
  235. "0148415f-834a-9352-74be-000100620002", "0158e52a-f497-0deb-54d0-000100610002",
  236. "01586ddc-4d37-ed6c-f326-000100610002", "0144c06e-f5ed-602b-b95c-000100610001",
  237. "0148992a-219c-6e88-e09a-000100610004", "0141eae7-4c2f-173f-d22d-000100610001",
  238. "01560818-9b8e-3179-8a3c-000100610006", "01477e6d-d130-9073-92b0-000100620005",
  239. "0155f5f4-63fa-74e3-8777-000100620007", "5f06f022-9aae-40fb-a21d-8d661b47045e",
  240. "0141eb02-bdc4-1b45-3dd8-000100620002", "0141e09b-04f0-a8d1-d22d-000100610001",
  241. "014e1765-2434-4205-a9a1-000100620002", "01537783-3f88-dc29-07b0-000100610001",
  242. "01506785-f07f-9594-87e7-000100610001", "01509492-d97c-9b53-99b5-000100610001",
  243. "0141eb6b-c52d-2fc2-d22d-000100610001", "0142b96b-ed2e-f273-2aa1-000100620002",
  244. "0141cc9d-cdfa-4577-d026-000100620002", "01427bd5-db05-391e-e9d1-000100620005",
  245. "01427bd2-48c2-6a05-e9d1-000100620005", "0141803a-0412-bead-c636-000100620002",
  246. "0136f625-a931-9ccf-06f0-000100620002", "014522dc-3bbe-09ae-5a24-000100620005",
  247. "0144080a-e937-de05-b5e8-000100620002", "014d1ee5-2127-ead2-8ea5-000100610004",
  248. "0142c423-0271-522d-eea4-000100620005", "014b927c-1eee-44ee-8e0b-000100610001",
  249. "014254b6-dba8-848e-3dd8-000100620002", "014254b7-1d13-86c4-3dd8-000100620002",
  250. "014254b7-62e8-8c84-3dd8-000100620002", "015613f8-25b1-ce3d-3650-000100610002",
  251. "0142de7e-9461-741b-eea4-000100620005", "01506686-9150-c456-c57f-000100610004",
  252. "01502ea7-97b4-caef-74c8-000100610001", "01529ca0-1e18-d3f6-6bfe-000100610001",
  253. "0150668b-2a4e-d0e4-c57f-000100610004", "0147164d-b446-c226-c322-000100620002",
  254. "013b85f7-99d6-1c2e-cabd-000100620002", "014828ac-579e-73a2-afb1-000100620002",
  255. "0153c793-756a-0f7f-f0d6-000100610002", "0153c793-74a0-0f61-f0d6-000100610002",
  256. "0148b27d-b615-874a-b632-000100620005", "0144b225-6ca0-e710-7f19-000100620002",
  257. "014828ab-9d6b-6c18-afb1-000100620002", "01550425-7c2e-98bf-a5c4-000100620007",
  258. "01575414-ecc8-9ded-97c3-000100620007", "015319e7-e0a6-4778-0ff9-000100620007",
  259. "0145f61d-f75f-9659-e5b9-000100610001", "015319ef-ee63-2726-0ff9-000100620007",
  260. "0145523a-a303-21dd-b5a3-000100610001", "0145dc7b-944f-441c-ac07-000100620002",
  261. "01531a19-04d9-de8d-0ff9-000100620007", "01442d0a-8575-7936-222a-000100610001",
  262. "01442d0b-d9b6-7ad1-222a-000100610001", "014403cf-2a34-f807-b5e8-000100620002",
  263. "0143db05-0d52-f66f-f856-000100620002", "0154def9-618b-8af0-cef8-000100610002",
  264. "01456b72-ace5-7428-28ef-000100620005", "014d6c17-3245-c687-50d2-000100610004",
  265. "01527e42-64f3-154a-2763-000100620007", "0146ce7b-2872-f323-b226-000100620002",
  266. "0146fd08-1e07-931b-bee5-000100620005", "0148841c-a387-8cc5-5c63-000100620002",
  267. "0149c8d1-c991-eca1-df3c-000100620005", "0155dfaa-a5af-3303-4b5e-000100620007",
  268. "014547fd-735e-6ffe-9a3d-000100620002", "01545d17-609e-54e7-97f4-000100620009",
  269. "014cb892-7c4e-8e02-52d7-000100610004", "014519cc-cf9f-3ed3-7db7-000100620002",
  270. "01424eab-229f-71b3-3dd8-000100620002", "01467255-30f4-b363-05ca-000100620002",
  271. "014600db-1f06-6935-41e2-000100620002", "01456c5c-f346-2516-ad28-000100610004",
  272. "0156f22b-3572-d840-97c3-000100620007", "0157b0ac-0d92-d365-581d-000100610002",
  273. "014ee4c5-9d97-f923-c0f0-000100620002", "015043a4-e626-fc52-6eeb-000100620005",
  274. "014f93f7-adcf-7191-9645-000100620002", "01487994-7eaf-ddda-7e7f-000100620005",
  275. "0158796e-5f73-cf6b-9a00-000100620002", "015459a1-be77-9177-97f4-000100620009",
  276. "015081b6-db94-4a79-b60a-000100610001", "015507c7-35c1-7df1-6969-000100610002",
  277. "0153be5c-b1f4-0790-f0d6-000100610002", "0151f3d4-15be-1bb8-c3bd-000100610004",
  278. "0154985a-3bd9-7d9b-4700-000100610001", "01541ad3-1873-228b-7ae6-000100610001",
  279. "01541ad3-17ed-2261-7ae6-000100610001", "0151f3d5-4564-1e81-c3bd-000100610004",
  280. "0148f09d-f626-59fd-07b7-000100620002", "0145435a-a4ac-e9f0-d82c-000100610001",
  281. "01495253-5ffc-c152-f3a6-000100610004", "0145fc20-a958-997d-41e2-000100620002",
  282. "0145fc21-741a-e539-41e2-000100620002", "014aa231-038a-b862-4359-000100620002",
  283. "0128d2fe-4268-4661-56f3-000100620001", "0128ef95-bd83-cb39-a730-000100620001",
  284. "0154c988-78c1-5a42-cef8-000100610002", "0135028d-9903-3bfb-a368-000100620001",
  285. "01359ae8-449a-8303-8b89-000100620001", "01361715-a09e-0ee7-95e9-000100620001",
  286. "01508aed-953f-cdf4-5d79-000100610004", "012f0888-0c77-3a98-b5a7-000100620001",
  287. "01464901-d5e6-3363-fc96-000100620002", "01306557-a95a-904a-6e53-000100620002",
  288. "0128841f-6268-ff10-272e-000100620001", "0146a593-72e8-1296-452d-000100620002",
  289. "0150cdd6-4af0-863a-07f7-000100620002", "01450947-818c-0cb8-7db7-000100620002",
  290. "01345788-57d4-0aef-9d2a-000100620002", "014bbd20-f197-8956-2f8c-000100610001",
  291. "01396986-5737-a173-a4d8-000100620002", "014aa185-65d1-da5d-4359-000100620002",
  292. "013ac336-aee9-f721-cb07-000100620002", "013abd9f-cd23-ad99-cb07-000100620002",
  293. "013ad179-cf3d-3544-cb07-000100620002", "01476507-0b68-98cc-6f70-000100620002",
  294. "015468fc-3ea5-29a9-4700-000100610001", "013d2185-4f77-8777-8efb-000100620005",
  295. "013e3cc0-d96c-bc29-bda1-000100620005", "013cbbc2-924f-3e1f-ffd5-000100620002",
  296. "013d6575-31f7-02b5-10c5-000100620005", "015047f2-571b-cad4-ae26-000100620002",
  297. "013dac85-6773-45b0-8f49-000100620002", "0138060d-28b1-3159-1757-000100620002",
  298. "0148d743-6359-4924-fe23-000100620005", "013baa40-43b9-491e-cabd-000100620002",
  299. "013db26b-4a13-d4cf-6157-000100620002", "013e335e-7fb0-f759-1fcd-000100620002",
  300. "013c4a96-defc-b702-1e82-000100620002", "013cd10e-203c-4de9-ffd5-000100620002",
  301. "0150e495-098c-b85b-9dea-000100610001", "01302e51-58ba-37a0-6e53-000100620002",
  302. "01481366-0820-e1e0-d5d9-000100620005", "014c0527-8900-c867-6df7-000100620002",
  303. "014b36bc-a61e-e04f-99b7-000100620002", "01498679-af6d-2a47-2f50-000100620002",
  304. "0155c097-3791-dfc3-ec6a-000100610002", "0154ed64-6616-f61e-cb38-000100610001",
  305. "0150afdd-16a5-f5a0-bbc5-000100610001", "014a4069-af50-4162-8d75-000100620005",
  306. "01488fe7-1624-7613-8b18-000100620002", "014b3ccd-7682-d040-6838-000100620005",
  307. "0148900e-a634-cc42-8b18-000100620002", "0150d348-f011-cd73-9dea-000100610001",
  308. "014b0404-02e6-99b1-b57e-000100620005", "014712ad-8cb4-77f4-7565-000100620005",
  309. "014712ad-b675-8c19-7565-000100620005", "014712ad-e18c-a9d7-7565-000100620005",
  310. "0154ed6f-cb07-eade-cb38-000100610001", "014712b9-a910-16cc-7565-000100620005",
  311. "014a54ee-2766-84ff-ab9a-000100620002", "015892e1-95f3-7839-aebb-000100610002",
  312. "014d7848-3063-2e8c-a461-000100620002", "01589288-29d1-95fe-aebb-000100610002",
  313. "01589283-fde4-857c-aebb-000100610002", "0157c4a8-f6f1-f691-17a8-000100610002",
  314. "01480dac-b936-6403-716b-000100620005", "015304fd-dc08-859f-d170-000100610002",
  315. "01489f3e-2516-2edb-e09a-000100610004", "015495ba-10c4-200e-97f4-000100620009",
  316. "0150ddb2-74d4-3ab3-9dea-000100610001", "015704b3-3019-eef3-97c3-000100620007",
  317. "014b1857-7a64-5444-1cb7-000100620005", "0147935e-4d5b-06e8-b6b0-000100620005",
  318. "014c37ad-58b1-a961-88f9-000100620002", "0150d8ad-c2ab-40da-9dea-000100610001",
  319. "01487c15-8f9d-faa5-5c63-000100620002", "01539635-aaa9-d85b-2c55-000100620007",
  320. "0148aa28-c1fa-77ee-3896-000100620002", "01543927-a4b3-2750-3594-000100610002",
  321. "014c9992-aee0-0806-8640-000100620005", "01538161-27fc-142c-2c55-000100620007",
  322. "0148c331-ff4e-7ba4-d37d-000100620002", "014d44b8-4d7c-d19e-22a1-000100620005",
  323. "0150a9fa-28f4-00a6-99b5-000100610001", "0150aa04-1dc8-1baf-99b5-000100610001",
  324. "0149630c-f0f1-1d97-dcdb-000100620005", "01496326-fb16-263b-dcdb-000100620005",
  325. "01496324-dfbd-b3a6-dcdb-000100620005", "014976e3-0f72-d390-2f01-000100620005",
  326. "014ba8f7-13a4-4f36-4188-000100620005", "014b5aec-8c57-22fd-2828-000100620005",
  327. "0153cd26-8f2f-54c1-f0d6-000100610002", "014aeb8a-5600-86ca-b57e-000100620005",
  328. "014c37ea-455b-e5a9-88f9-000100620002", "01456b8a-6d9f-ab66-ad28-000100610004",
  329. "0155a1e4-1c24-a7d7-2ac4-000100610002", "014efb14-d54b-aa7d-45a6-000100620005",
  330. "014b4c2b-036e-1a56-95ff-000100610004", "014c338a-089a-47e0-88f9-000100620002",
  331. "01511099-5977-0ead-fbc0-000100620002", "014beaf3-c5fa-a4e1-f9d8-000100620005",
  332. "014ba3c6-e7ee-95dc-4188-000100620005", "014bc6c8-3c5c-d2db-d096-000100620002",
  333. "014ba5ed-6ec6-7845-4188-000100620005", "014ba5ef-e34a-9839-4188-000100620005",
  334. "0154c450-94e7-c2bd-cef8-000100610002", "0154868d-75d3-1faf-4700-000100610001",
  335. "01379e8f-c120-d2f3-fd53-000100620002", "01484261-38a0-482d-74be-000100620002",
  336. "0150292c-c034-57a8-6828-000100610004", "0155c229-d4cc-8cf1-ec6a-000100610002",
  337. "01568cc4-036f-b133-431a-000100620007", "014c75f4-4e9b-1d8b-24a6-000100610001",
  338. "014c7b18-8c75-aec5-650c-000100620005", "0150eceb-4703-cd9c-b424-000100620005",
  339. "014f896e-ce9a-cb08-9645-000100620002", "015095dc-cde4-f7d6-99b5-000100610001",
  340. "01506cd7-9181-7bef-b23d-000100610004", "014c9f83-81e7-a2e3-bccb-000100620002",
  341. "0150cdd1-3409-db2d-07f7-000100620002", "0154966a-1f2c-a493-4700-000100610001",
  342. "0154e889-50ff-3ae3-cb38-000100610001", "01508b62-5717-0cf4-5d79-000100610004",
  343. "014bcd26-0f2f-d656-2c62-000100620005", "014c4d26-1512-463c-1890-000100610004",
  344. "014c4828-2618-7031-88f9-000100620002", "014c4828-2b97-72dc-88f9-000100620002",
  345. "0155c5d9-4645-bf1f-ec6a-000100610002", "015097db-5d55-e522-99b5-000100610001",
  346. "014dfcb6-b753-2a3e-4943-000100620002", "014fb87f-10a9-6700-4880-000100620002",
  347. "015337d2-fb55-3c90-6dfb-000100620009", "014c7bad-fde0-f072-650c-000100620005",
  348. "014f6acb-c33b-761f-42f2-000100620005", "0150a504-a8de-7ea3-1acb-000100620002",
  349. "014c52fc-bd5c-c3de-7d73-000100610001", "01506d1c-0748-4e85-b23d-000100610004",
  350. "0154aa93-3795-c0e3-cef8-000100610002", "0154aa93-396e-c120-cef8-000100610002",
  351. "014c2485-2062-2051-c904-000100620005", "0155a7d7-d8c2-db97-2ac4-000100610002",
  352. "01445584-bec7-9a7d-47b9-000100620002", "0155df6a-c372-3ce5-ec6a-000100610002",
  353. "014f604b-0ca3-a097-6377-000100620002", "015887b0-2c64-ebca-9a00-000100620002",
  354. "01588727-a766-5b2f-e558-000100610002", "014d775d-e8d4-3437-3443-000100610001",
  355. "01506305-789b-5a62-5ee8-000100620002", "0150d3ff-e7ad-550f-07f7-000100620002",
  356. "0150de7c-b343-64f6-9dea-000100610001", "01502980-275d-723d-74c8-000100610001",
  357. "0150de74-a4e2-4f72-9dea-000100610001", "014d262b-2336-e5c0-22a1-000100620005",
  358. "015067c5-1a9f-5b01-87e7-000100610001", "015067cf-5c07-7823-87e7-000100610001",
  359. "015067c5-1fd7-5b3e-87e7-000100610001", "015029a1-196f-5b2f-f40f-000100620002",
  360. "0146f7b1-e1bb-65af-af73-000100620002", "014ae597-d39c-97d4-43ea-000100610004",
  361. "015096c7-7004-ba6a-1acb-000100620002", "015029a0-e305-38c6-f40f-000100620002",
  362. "014d539e-fa89-5115-5f1d-000100620002", "014d0b65-854c-b596-3a04-000100620002",
  363. "014d014b-5a15-f2df-5084-000100620002", "015029a3-2d58-7b6f-f40f-000100620002",
  364. "015029a3-85be-b106-f40f-000100620002", "014d1fcc-f464-52d0-8ea5-000100610004",
  365. "0150aa8d-9eb5-97f7-99b5-000100610001", "0150ee54-0eb2-97d9-0de2-000100610004",
  366. "013ec951-1d04-d8aa-5cfb-000100610005", "014d2a8b-e9fa-846a-22a1-000100620005",
  367. "014f6a6f-00a5-260a-a456-000100610004", "01519ec4-188f-3e13-35c7-000100610004",
  368. "014f509f-6275-bf0e-2ff1-000100620002", "0154de2e-85f1-c1d2-cef8-000100610002",
  369. "01515862-df70-9c93-ad69-000100610001", "01544e6b-a2d8-a137-3594-000100610002",
  370. "0147178a-d682-66dd-c322-000100620002", "014ce2d0-1611-48a7-ca56-000100620005",
  371. "0155c13f-f7ff-5f92-ec6a-000100610002", "014ee4c7-4a0a-c034-c0f0-000100620002",
  372. "01500563-03f0-ce71-ec60-000100620002", "0150a575-906b-8031-99b5-000100610001",
  373. "01380c02-697a-b6de-1757-000100620002", "d8e3430a-f026-4c62-a27c-3b5507a423c0",
  374. "0153616d-fca6-2b7c-07b0-000100610001", "0150d5c7-c6f1-d732-9dea-000100610001",
  375. "015072ba-2fcc-6c33-b23d-000100610004", "01506899-2949-c2ea-87e7-000100610001",
  376. "0150689c-a310-cfb4-87e7-000100610001", "0150443b-0220-bf9c-ae26-000100620002",
  377. "01504e3f-d799-fa30-2738-000100610001", "015072ba-30f3-6c49-b23d-000100610004",
  378. "0154a08d-5830-5420-4700-000100610001", "0154a08d-5a30-5476-4700-000100610001",
  379. "0154a08d-5af6-54d3-4700-000100610001", "01488a59-776c-9fd1-0d10-000100610001",
  380. "014e07a6-9067-cd8e-60e9-000100610004", "01545dd6-bdb6-c061-97f4-000100620009",
  381. "01553b05-9409-4fe0-45a5-000100620009", "01555566-4f7b-4491-da57-000100610001",
  382. "014f75f7-489a-0123-9645-000100620002", "014dc547-8d89-b667-6278-000100620005",
  383. "015062cc-554a-2ead-2738-000100610001", "01506306-4a78-0ac0-5ee8-000100620002",
  384. "01511b85-9556-5cb3-ad69-000100610001", "014dfe1b-91f8-a0c4-4943-000100620002",
  385. "015827cb-b771-8e04-ee3e-000100620002", "0156e0dd-7eb7-1eec-d85c-000100610006",
  386. "014e93ab-e6b3-1ec6-0069-000100620002", "0150647c-bd02-cd55-c57f-000100610004",
  387. "0150649c-5e3e-f828-c57f-000100610004", "01528e30-58a1-b6aa-6c5f-000100620009",
  388. "0148577a-59f2-39f4-f9f3-000100620005", "01539ef4-8fc7-06b9-f0d6-000100610002",
  389. "0156132c-c149-14ff-b994-000100620007", "0155a24c-af0f-6316-2ac4-000100610002",
  390. "014e2b7d-df49-d52e-a9a1-000100620002", "01523165-05b1-84f7-1aae-000100610001",
  391. "0156a8b9-25db-d9ac-4a4e-000100610006", "01508337-bf01-8c10-6f99-000100620005",
  392. "014fb3c2-eed6-17fd-9706-000100620005", "014f3c0e-f97a-2a74-3996-000100620005",
  393. "0154966b-226a-a7b3-4700-000100610001", "0154966b-2284-a7d3-4700-000100610001",
  394. "0154966b-22dc-a80f-4700-000100610001", "0154966d-83f4-c250-4700-000100610001",
  395. "014e79af-d6e2-8c8f-b12f-000100620002", "0154966c-b6dc-be85-4700-000100610001",
  396. "0153cd9f-3959-d660-f0d6-000100610002", "01539f04-e9f1-2c3b-2c55-000100620007",
  397. "01561335-2d75-0ee8-b994-000100620007", "0154a5ed-a276-d0cc-97f4-000100620009",
  398. "01549671-3130-d2d8-4700-000100610001", "0150ba44-f499-2614-012a-000100610001",
  399. "0151ab7f-afe8-cc38-35c7-000100610004", "0154c9f5-de83-094c-cef8-000100610002",
  400. "0154c9f5-dfc8-0996-cef8-000100610002", "014f85d1-f00c-5f7c-9645-000100620002",
  401. "015486e8-6441-4cc1-4700-000100610001", "015486ef-9325-6c6f-4700-000100610001",
  402. "01549672-fe37-de8a-4700-000100610001", "01549673-582c-e092-4700-000100610001",
  403. "0154de4b-dbd4-17b8-cef8-000100610002", "01539f15-e625-a821-f0d6-000100610002",
  404. "01549673-a11f-e1af-4700-000100610001", "015747dc-5072-2550-db9a-000100610002",
  405. "0150398f-1c42-bd75-74c8-000100610001", "01533806-fd35-809e-6dfb-000100620009",
  406. "0144e2f6-a208-1851-43ca-000100620005", "014fcdd9-fa1e-6beb-88a7-000100610001",
  407. "0152316e-6b4b-a679-1aae-000100610001", "01506cd7-9083-7bd9-b23d-000100610004",
  408. "015405f2-5036-f0a7-f0d6-000100610002", "01525f36-3ae6-af0d-cc1a-000100610001",
  409. "a64db7f5-ffb0-48a2-b5c6-1cc743cceec4", "01531e59-7916-9c5a-0ff9-000100620007",
  410. "0154967e-7835-0c52-4700-000100610001", "0150c1b6-c5ae-22fd-012a-000100610001",
  411. "01523178-6291-c46e-1aae-000100610001", "0153cdc4-2489-d7ec-2c55-000100620007",
  412. "01427bd1-66c2-da1b-e9d1-000100620005", "01549681-ef25-1b4e-4700-000100610001",
  413. "015530eb-8102-1f09-da57-000100610001", "01588a66-d55d-5879-e558-000100610002",
  414. "015873cb-1c63-469f-7d32-000100620002", "01526a60-369e-84d5-0cdf-000100610001",
  415. "015511c9-10c6-d0e7-6969-000100610002", "01575978-0430-c660-29ad-000100620007",
  416. "015511c9-111c-d12e-6969-000100610002", "01552c09-1398-6fd1-da57-000100610001",
  417. "01518da0-87a8-f009-c1d5-000100620005", "0154968e-acf4-4bb1-4700-000100610001",
  418. "01549686-71f0-2ce3-4700-000100610001", "8e239dc8-af00-40c1-95e3-5e268606f19f",
  419. "01509096-a3de-e496-6f99-000100620005", "0150c575-5ec7-a77d-012a-000100610001",
  420. "0150c575-600c-a7b1-012a-000100610001", "0154aaf4-69ea-191f-cef8-000100610002",
  421. "01557939-a7a6-020d-47d8-000100610001", "01574298-93c5-032f-db9a-000100610002",
  422. "015049c4-58a4-4068-ae26-000100620002", "0150cc3b-c5b3-cd1a-9dea-000100610001",
  423. "0150fc78-27b7-4250-0de2-000100610004", "0153855d-96b3-6c40-f0d6-000100610002",
  424. "0153be26-4f3b-47c3-f0d6-000100610002", "0156b26a-3857-c92e-a73d-000100620009",
  425. "0151179f-db0e-a78e-ad69-000100610001", "01525acb-d4fa-a5c4-1aae-000100610001",
  426. "01525acb-e264-a73a-1aae-000100610001", "0150f288-48c2-6ce7-b424-000100620005",
  427. "0153be2f-b2c1-6b92-f0d6-000100610002", "0150f7cf-cf88-e84c-0de2-000100610004",
  428. "01543061-93cd-0d7c-98d5-000100620009", "0154e411-e729-c8b7-cef8-000100610002",
  429. "0154e411-ea08-c989-cef8-000100610002", "0154a61a-3f4d-6a5c-4700-000100610001",
  430. "0150fd4c-84f6-756d-0de2-000100610004", "01525acb-d541-a601-1aae-000100610001",
  431. "01525acb-e2d5-a77f-1aae-000100610001", "0153857e-008e-e07e-f0d6-000100610002",
  432. "01545876-f0cf-2481-97f4-000100620009", "014f85e4-8244-3a1e-9645-000100620002",
  433. "0154a0ea-8831-8f89-4700-000100610001", "f96b4125-01ad-494a-89e4-507b1a862d8e",
  434. "0153e770-16d7-1193-f0d6-000100610002", "01513f4a-0596-3856-fbc0-000100620002",
  435. "0153cdee-93f5-6750-2c55-000100620007", "01531e60-54e2-85f4-0ff9-000100620007",
  436. "0152b270-67d3-a629-9537-000100610001", "015496b4-fce3-ceb0-4700-000100610001",
  437. "0155a7c2-ad78-f9bf-5e30-000100620007", "01558390-91b9-959e-569c-000100620009",
  438. "0155c228-92d9-5d98-ec6a-000100610002", "0151abe8-45ff-ef9e-35c7-000100610004",
  439. "0154ab83-0114-efee-cef8-000100610002", "01513f94-feec-aca0-fbc0-000100620002",
  440. "0157be2f-c936-02a3-17a8-000100610002", "0154c000-e19a-5ffa-712c-000100620007",
  441. "01504829-a8fb-28b2-ae26-000100620002", "015507a2-c173-a0a7-6969-000100610002",
  442. "01528981-87c7-024e-1edb-000100620009", "01521322-6e58-b3a9-c0f1-000100610001",
  443. "01542a38-5010-70e1-7ae6-000100610001", "01579044-81c0-b7ec-29ad-000100620007",
  444. "0154ca75-5569-4024-cef8-000100610002", "01521878-a7d7-6a4f-c16b-000100620002",
  445. "0153c362-b745-123c-2c55-000100620007", "0150df1c-d1f0-10e1-07f7-000100620002",
  446. "01538134-9b95-5c96-2c55-000100620007", "0153e7a4-a724-986d-f0d6-000100610002",
  447. "0152843b-91b4-6c51-e5e2-000100610001", "0152843d-5a8a-7378-e5e2-000100610001",
  448. "0151d297-f1b0-a16f-c3bd-000100610004", "0154deb6-ba01-89fe-cef8-000100610002",
  449. "0152187d-66a8-d4c3-c0f1-000100610001", "01531eb3-c599-09c6-0ff9-000100620007",
  450. "0157edbb-6c52-a404-a5df-000100610002", "01531eb2-56ae-4777-0ff9-000100620007",
  451. "0153e7ba-cfa7-d36a-f0d6-000100610002", "01516e4f-334b-d6ef-35c7-000100610004",
  452. "015526f0-c877-28d9-45a5-000100620009", "01516e4f-328a-d6cc-35c7-000100610004",
  453. "014f8ea6-a6b3-52b4-9645-000100620002", "0153a01b-ce53-a946-f0d6-000100610002",
  454. "0154caba-d2be-6e7f-cef8-000100610002", "0151923e-fc31-4f98-35c7-000100610004",
  455. "01545374-024c-a73c-3594-000100610002", "0154ce74-a86e-68e6-cef8-000100610002",
  456. "0153ce77-f165-42b5-f0d6-000100610002", "01523253-e3c3-3974-1aae-000100610001",
  457. "01539b06-8293-b7cf-f0d6-000100610002", "015067d6-c41f-8c95-87e7-000100610001",
  458. "0154aba1-8d53-62b6-cef8-000100610002", "01526b51-68de-5084-0cdf-000100610001",
  459. "01526b5a-a937-6c47-0cdf-000100610001", "014cdde7-cdd9-d99e-ca56-000100620005",
  460. "01549382-b80e-decc-4700-000100610001", "015169f8-fd28-8623-949f-000100620005",
  461. "01516423-13a0-0a30-949f-000100620005", "014b040e-9150-7bab-b57e-000100620005",
  462. "01547d7f-dfdd-a449-4700-000100610001", "01516ee4-ae19-71b5-35c7-000100610004",
  463. "015192c8-ea11-0342-c1d5-000100620005", "0151b715-a3fc-59f0-c3bd-000100610004",
  464. "0155749a-ddd2-e7d4-b2eb-000100610002", "0153d34c-83d9-a3bb-f0d6-000100610002",
  465. "eac29ff5-f18e-4326-9ec5-d14a7a97703e", "0154a6d0-4859-eca1-4700-000100610001",
  466. "0152fb21-dab2-98c6-cfa6-000100620009", "014c0ebc-1483-64d2-6df7-000100620002",
  467. "01515a31-a625-1a26-ad69-000100610001", "0154cadf-1f59-1ffb-cef8-000100610002",
  468. "01549b92-56a2-56d3-4700-000100610001", "01488a51-30ee-9738-0d10-000100610001",
  469. "01549761-5596-091b-4700-000100610001", "01521e46-5106-0fbe-d1c8-000100610001",
  470. "01521e5f-237e-7115-d1c8-000100610001", "0148c862-8976-fb57-986f-000100610001",
  471. "01521e46-51b3-1019-d1c8-000100610001", "014d2c7f-128e-13f4-f93c-000100610001",
  472. "015260fd-d534-ceed-4b0e-000100610004", "01516f08-5d63-d6cd-35c7-000100610004",
  473. "01504408-001d-d768-ae26-000100620002", "0154df39-e8cb-98f7-cef8-000100610002",
  474. "0155dfb6-738b-3ce5-ec6a-000100610002", "0154caea-807b-6e93-cef8-000100610002",
  475. "0151a790-4f8f-77e1-35c7-000100610004", "0151a792-4776-7c8f-35c7-000100610004",
  476. "01519391-26b9-65ee-c1d5-000100620005", "0127d981-7bea-fc07-94bd-000100620001",
  477. "0153bf10-0ae9-2293-f0d6-000100610002", "01548865-be89-0930-97f4-000100620009",
  478. "01550876-e5ee-f8ce-6969-000100610002", "01521eef-0213-3c81-1b22-000100610004",
  479. "d8470059-8bba-4c0b-beef-f0f337c06122", "0155a892-5bd9-eabf-5e30-000100620007",
  480. "015574b4-ffe9-e655-b2eb-000100610002", "01557f0d-1f24-a591-47d8-000100610001",
  481. "0154a6e2-0755-2596-4700-000100610001", "01552799-8465-98cf-da57-000100610001",
  482. "012c3229-bd7e-6005-bef7-000100620001", "0152234b-57b1-1c8a-1aae-000100610001",
  483. "015082f0-de69-2b8f-5d79-000100610004", "015232cc-f81a-8184-1aae-000100610001",
  484. "01528afa-aea6-f9ee-1edb-000100620009", "0152424a-603d-3753-1aae-000100610001",
  485. "0152b33b-25e4-6513-9537-000100610001", "0152243d-a1a9-517b-1aae-000100610001",
  486. "0151b425-571e-aa17-c3bd-000100610004", "01525690-7edc-4c7d-1aae-000100610001",
  487. "0150439f-9a04-e04b-6eeb-000100620005", "0154a06b-22e1-e468-4700-000100610001",
  488. "01528e30-1fa1-962b-6c5f-000100620009", "01528b30-49e8-4a0e-aab0-000100610002",
  489. "d9731a20-7f83-494f-ae90-2c999b79175c", "0152383c-eafd-6016-1aae-000100610001",
  490. "0152384d-c6e8-91c6-1aae-000100610001", "0153c5f1-bfbb-2764-f0d6-000100610002",
  491. "015512f4-d10c-34c9-6969-000100610002", "015574ea-7828-01eb-b2eb-000100610002",
  492. "015574f2-33ee-3deb-b2eb-000100610002", "015574f2-3569-3e6b-b2eb-000100610002",
  493. "015574f2-3683-3ee9-b2eb-000100610002", "01529d61-bcf6-61a1-6bfe-000100610001",
  494. "01525701-be15-5ebe-1aae-000100610001", "015243f4-03e7-6d57-1aae-000100610001",
  495. "015574f2-34c5-3e30-b2eb-000100610002", "01539f72-c2b3-5fc3-f0d6-000100610002",
  496. "01540c31-82dd-6173-f0d6-000100610002", "0152661c-1c36-193a-4b0e-000100610004",
  497. "0154d046-8975-1a21-cef8-000100610002", "0155132c-9ff1-a5e1-6969-000100610002",
  498. "0155132c-a4e0-a6af-6969-000100610002", "0155132c-a22a-a63c-6969-000100610002",
  499. "0155bc5c-be0a-7435-2ac4-000100610002", "01550cab-e951-5f08-6969-000100610002",
  500. "01558476-cdd2-bc1e-569c-000100620009", "0152e7e8-24f8-d6e4-c6c9-000100620007",
  501. "762f2bf9-2ba1-4b92-9190-94272585eb75", "01577185-d7c5-c423-db9a-000100610002",
  502. "0152e846-2374-5438-f918-000100610002", "01529ec8-42a6-97d3-6c5f-000100620009",
  503. "015637f1-bbe1-fb20-5512-000100610006", "0153c847-5ed3-fe9d-f0d6-000100610002",
  504. "01512700-bdf3-80a7-ad69-000100610001", "0155b6a3-9c45-b9fb-2ac4-000100610002",
  505. "0153c43b-da5e-769d-f0d6-000100610002", "01549bc4-5b7a-15e0-4700-000100610001",
  506. "01515f13-7a49-6354-949f-000100620005", "0152d40a-688c-1fea-f918-000100610002",
  507. "0155fe22-46eb-c7f4-8777-000100620007", "0152c282-3848-a3ff-9537-000100610001",
  508. "0154bc62-d85d-e750-cef8-000100610002", "01408091-17db-cae1-e330-000100620002",
  509. "0142b547-24f8-64ff-270a-000100610001", "014b31d9-6d69-5f5e-7074-000100610001",
  510. "01559e45-9839-8198-2ac4-000100610002", "0152f896-4b88-6d2a-9b97-000100610001",
  511. "0152f896-20b2-6ccd-9b97-000100610001", "01545e96-b5ee-06d5-4700-000100610001",
  512. "0142b491-a7db-17c7-270a-000100610001", "014b31df-6ae0-67c6-7074-000100610001",
  513. "01563231-69df-6b1b-b477-000100620009", "0155c75e-0212-fd1d-ec6a-000100610002",
  514. "0156c244-3c8b-c625-4a4e-000100610006", "0157b4ee-0f9a-43f4-17a8-000100610002",
  515. "0154ee4a-579c-dcbc-cb38-000100610001", "0154cec0-2127-7e4d-cef8-000100610002",
  516. "015453ac-f3c9-647b-3594-000100610002", "01533e5a-d204-9fec-6dfb-000100620009",
  517. "0154ee67-16b0-7b12-31c0-000100620009", "0156eb67-c096-9412-db9a-000100610002",
  518. "0151a2bb-0dc2-5abc-35c7-000100610004", "0155caeb-16d5-10b5-ec6a-000100610002",
  519. "01541781-3fef-1254-7ae6-000100610001", "01536698-88b2-565a-07b0-000100610001",
  520. "0154ee80-ae33-da64-cb38-000100610001", "0153ce80-d11e-6e91-f0d6-000100610002",
  521. "01551758-b803-d508-da57-000100610001", "01550d0d-52d3-546c-6969-000100610002",
  522. "01543f2e-9ea9-8480-3594-000100610002", "0152c724-c3ab-bfca-9537-000100610001",
  523. "01533ea8-9bec-7ad0-07b0-000100610001", "0154eec4-feb1-e8c6-cb38-000100610001",
  524. "0153c337-28f5-6f99-f0d6-000100610002", "01549681-efb1-1bb2-4700-000100610001",
  525. "015047dd-622c-eb77-ae26-000100620002", "015187db-6ef3-06c1-c1d5-000100620005",
  526. "0152f622-61c6-5309-cfa6-000100620009", "0153d28b-d06d-35d5-f0d6-000100610002",
  527. "0153ec7f-9a29-6bd4-f0d6-000100610002", "0155cb75-999e-e95a-4b5e-000100620007",
  528. "0151c6fa-2bb0-5676-c3bd-000100610004", "01511b5e-32ba-e2c8-ad69-000100610001",
  529. "4830a79d-05e5-43f8-9223-a21e3770dee8", "01518812-57b2-1b71-35c7-000100610004",
  530. "015403d9-ebc5-0f09-2c55-000100620007", "015493f1-68b2-bd81-97f4-000100620009",
  531. "0155cbb5-9822-9bea-ec6a-000100610002", "01562d59-1465-3354-3650-000100610002",
  532. "01562d59-13fb-32a6-3650-000100610002", "01562d59-15fd-3792-3650-000100610002",
  533. "0143b236-2111-7796-270a-000100610001", "0151ab80-3fd8-ce27-35c7-000100610004",
  534. "01550de8-3cac-bfb8-6969-000100610002", "01469217-d800-f088-5dbe-000100610001",
  535. "0154ce86-54fc-e134-cef8-000100610002", "01588cb5-f262-dddd-e558-000100610002",
  536. "01442ec1-8db1-fc5c-222a-000100610001", "0132e053-3efd-9065-f53e-000100620001",
  537. "01456b88-6770-a928-ad28-000100610004", "01550dea-880e-c949-6969-000100610002",
  538. "015759d7-2ded-a6cd-db9a-000100610002", "01565b75-ae8c-6cb8-8853-000100610002",
  539. "01550e0b-1cf2-8952-6969-000100610002", "014f75e3-26e8-4d9e-9645-000100620002",
  540. "0156275d-1b6e-da40-3650-000100610002", "9b78c53c-4503-43c3-9ad6-dce1c4538a62",
  541. "0155cbef-2687-ddbe-ec6a-000100610002", "01550f09-c9cc-a0cd-6969-000100610002",
  542. "0153c4d2-2c30-0cea-f0d6-000100610002", "01523291-08c3-dbb2-1aae-000100610001",
  543. "01508638-7809-14ba-5d79-000100610004", "01536843-f927-15a8-6aa0-000100620009",
  544. "0154f27e-b16f-db14-6969-000100610002", "01536b56-1852-8d94-6aa0-000100620009",
  545. "01536b66-394c-43d5-07b0-000100610001", "0157a7d9-66d6-684e-89d7-000100620002",
  546. "0155cb1f-f98a-9fb7-ec6a-000100610002", "0157339b-f363-438f-db9a-000100610002",
  547. "01554b8e-4722-1c18-da57-000100610001", "01538cea-73cc-9d3a-f0d6-000100610002",
  548. "01570006-581a-8bee-97c3-000100620007", "0153edef-1383-572a-2c55-000100620007",
  549. "0154062e-4568-b71c-2c55-000100620007", "014bdb7a-4992-385b-2c62-000100620005",
  550. "0144db8f-8e8b-aa7c-5867-000100620002", "0157908f-9bab-9fb2-db9a-000100610002",
  551. "0154f2fb-1ef6-79c1-6969-000100610002", "0154f2fb-20e2-7a41-6969-000100610002",
  552. "0155fe5f-caf4-6f16-1049-000100610002", "0154f2fb-1e94-7988-6969-000100610002",
  553. "014b3ccf-4712-9180-6838-000100620005", "015622ce-44a8-3736-3650-000100610002",
  554. "015622d1-8073-a751-3650-000100610002", "01564709-6c03-3c0f-5512-000100610006",
  555. "01530fe8-ffce-25c3-d170-000100610002", "01530fe8-ff4c-25ac-d170-000100610002",
  556. "01531b87-a742-d38d-0ff9-000100620007", "014f3c6f-5f32-c05d-3996-000100620005",
  557. "01565157-5e04-90e0-5512-000100610006", "01570a6b-600a-309a-db9a-000100610002",
  558. "01571eed-2762-4fb5-db9a-000100610002", "015622e7-0009-d142-3650-000100610002",
  559. "01565157-5e70-9119-5512-000100610006", "0150487e-71ed-faa0-ae26-000100620002",
  560. "0153102d-43d6-0ed0-d170-000100610002", "0155c2e9-fae5-0cea-ec6a-000100610002",
  561. "0153108b-93c2-8983-0ff9-000100620007", "01575783-a749-0f14-db9a-000100610002",
  562. "0157def7-4a3d-f397-a5df-000100610002", "015375ff-a560-1762-07b0-000100610001",
  563. "0151ca40-e510-5b42-5d88-000100620005", "01506bd8-c0e1-6e3d-b23d-000100610004",
  564. "014e9251-7513-2235-88af-000100620002", "014a0bc4-9ef3-2cbc-4564-000100620002",
  565. "015776df-85fa-8d65-9760-000100620002", "0154f47a-533a-e422-6969-000100610002",
  566. "0154f7c6-ae4c-fc28-6969-000100610002", "015817a5-d9fc-10e2-a5df-000100610002",
  567. "01531407-7df6-79a4-d170-000100610002", "cb65fd58-ded4-4a48-90b4-773f6680999a",
  568. "0153765f-e4c2-7f85-07b0-000100610001", "01557a29-d60e-f01f-47d8-000100610001",
  569. "0156b2cc-6435-28dc-4a4e-000100610006", "0156b2cc-6568-29bb-4a4e-000100610006",
  570. "0156b2cc-66db-2ad4-4a4e-000100610006", "0150966c-6523-5ffc-99b5-000100610001",
  571. "014f8904-04c0-2791-b3f3-000100610001", "014f9351-ee3e-2eb0-b3f3-000100610001",
  572. "015351d7-61f6-bf30-07b0-000100610001", "01560453-76ba-fd86-8777-000100620007",
  573. "01466d6d-a569-7e65-c753-000100620005", "0154a324-f157-13aa-4700-000100610001",
  574. "01570ffc-da8f-79b7-db9a-000100610002", "0155e420-96e2-2eed-4b5e-000100620007",
  575. "0156dc19-f12a-25b9-9e44-000100610002", "0155feb3-2a71-2e7c-8777-000100620007",
  576. "0153c3fc-d01f-8635-f0d6-000100610002", "0156dc17-7acd-b1f1-9e44-000100610002",
  577. "01577c31-1f0b-d0d4-9760-000100620002", "0155dbdd-3df7-1d96-ec6a-000100610002",
  578. "01562e44-bc79-ec84-3650-000100610002", "015550c8-c0d9-8a2a-da57-000100610001",
  579. "01496738-44e0-3748-dcdb-000100620005", "0155c0b9-c5e1-a28a-ec6a-000100610002",
  580. "0154b80f-c283-730e-712c-000100620007", "015314b5-3644-63f0-0ff9-000100620007",
  581. "015367a8-7477-0fa9-6aa0-000100620009", "015376f0-b66e-10aa-6aa0-000100620009",
  582. "0151f8df-0222-8306-c3bd-000100610004", "01535320-194c-bfce-6dfb-000100620009",
  583. "01574484-3a23-16de-97c3-000100620007", "014fb1ff-8d52-96f7-9706-000100620005",
  584. "014a7276-7adc-2ab2-2674-000100620002", "0156099e-0576-609f-8a3c-000100610006",
  585. "015333ad-cf95-f794-d170-000100610002", "014a544d-5d93-47da-ab9a-000100620002",
  586. "0152f52a-9d98-5d23-9b97-000100610001", "0152fb1c-3dc4-c95c-9b97-000100610001",
  587. "01535753-01d2-6d2a-07b0-000100610001", "0157c085-80dc-d1a7-4ef4-000100620002",
  588. "015319a5-ee3c-13dc-d170-000100610002", "0157d405-6ae9-8f36-17a8-000100610002",
  589. "01537c4e-f81c-09aa-07b0-000100610001", "015319c2-190b-2a1b-0ff9-000100620007",
  590. "0155a1c8-8851-1363-5e30-000100620007", "01531a0d-349d-d76a-0ff9-000100620007",
  591. "01531a14-3d65-63c0-0ff9-000100620007", "015090aa-f703-38be-5d79-000100610004",
  592. "01535807-63c7-91c6-07b0-000100610001", "0152f081-9611-e86f-9b97-000100610001",
  593. "0155eaf3-8687-7bda-59e2-000100620009", "0156165f-1361-cae8-3650-000100610002",
  594. "0151ef36-b5a3-9572-c3bd-000100610004", "0157e9bb-6f11-2a3c-a5df-000100610002",
  595. "0157afae-3f59-298e-89d7-000100620002", "015638cf-39f6-083a-b477-000100620009",
  596. "01561693-a9bd-efa2-3650-000100610002", "01571f25-5842-ed98-db9a-000100610002",
  597. "01582559-0cfe-b523-a5df-000100610002", "0156a3d2-a0d5-f683-a73d-000100620009",
  598. "01560f5e-f608-8da9-8a3c-000100610006", "014f6acc-de9e-21b2-42f2-000100620005",
  599. "0156a3d1-e375-6e42-a73d-000100620009", "015600c8-8eec-a046-1049-000100610002",
  600. "015600c8-ed23-b106-1049-000100610002", "01560182-7a6c-8f3d-1049-000100610002",
  601. "0150cf45-ef5b-52e4-9dea-000100610001", "015535e8-10f6-e4fb-da57-000100610001",
  602. "0151aca1-9320-e688-35c7-000100610004", "01525fc3-96ca-54da-cc1a-000100610001",
  603. "0154abe1-aab6-b8fd-712c-000100620007", "01579bbd-52c5-0628-db9a-000100610002",
  604. "01564ccc-03bd-4ce1-5512-000100610006", "014e8eba-472c-7abb-88af-000100620002",
  605. "01520dca-6aea-c5bf-5d88-000100620005", "0157006e-f8ce-a3a4-97c3-000100620007",
  606. "01564d43-c927-8507-b477-000100620009", "0154de2e-84c3-c166-cef8-000100610002",
  607. "01508145-af6b-5375-b60a-000100610001", "01525812-34c5-62b3-1aae-000100610001",
  608. "01549825-9f35-1af2-4700-000100610001", "0154c025-2333-6b45-712c-000100620007",
  609. "0151ca42-edd2-0e88-c3bd-000100610004", "015733f6-cbda-dbbf-db9a-000100610002",
  610. "01571f39-ad3f-1a93-db9a-000100610002", "01570093-fffd-ac9a-db9a-000100610002",
  611. "01552427-0100-cc07-45a5-000100620009", "0157be8d-4113-60ad-4ef4-000100620002",
  612. "0154b9f5-054b-7813-712c-000100620007", "01504814-634d-34e9-ae26-000100620002",
  613. "0156c7f8-47ee-d076-9e44-000100610002", "01555491-af81-a4e1-45a5-000100620009",
  614. "01567f6d-ccf0-c279-8853-000100610002", "01577c81-18ee-2e27-9760-000100620002",
  615. "44aa2c9f-2b76-4099-a164-69b63fe203aa", "01578c11-3d08-8bbf-29ad-000100620007",
  616. "015618f2-c736-ea9f-b994-000100620007", "01568ffd-dc69-90d9-8853-000100610002",
  617. "01571f80-cd4a-eaf5-db9a-000100610002", "015694de-fde5-c438-8853-000100610002",
  618. "015694d1-5b8b-65b3-8853-000100610002", "46e9f93e-80b9-40ba-9443-de4c1bb70fd6",
  619. "01579cb9-01b5-7762-db9a-000100610002", "0156c855-babf-6279-9e44-000100610002",
  620. "01579d11-4628-d80a-df04-000100610002", "0153baf8-7bf3-5576-2c55-000100620007",
  621. "0153be5c-0a81-0519-f0d6-000100610002", "0153be5e-076b-0d1b-f0d6-000100610002",
  622. "219620ac-d8be-42c1-b677-c0a388a4e38d", "01567530-745a-0c7b-8853-000100610002",
  623. "015618f8-597f-57cf-3650-000100610002", "0157a0af-b2df-30e3-89d7-000100620002",
  624. "0157e93c-940c-d658-ee3e-000100620002", "0154caa0-76a2-f4ae-cef8-000100610002",
  625. "0153cdbf-262b-3c94-f0d6-000100610002", "01531987-6de2-a719-d170-000100610002",
  626. "0157e7ac-aa6c-a4a3-a5df-000100610002", "01569f8f-416f-6427-a73d-000100620009",
  627. "0156e757-7e95-939f-d85c-000100610006", "0156e757-8563-9526-d85c-000100610006",
  628. "0156e757-86dc-95dc-d85c-000100610006", "015535f2-db72-2a00-da57-000100610001",
  629. "0156b938-4b78-ed3b-4a4e-000100610006", "01576d87-71b2-ae5f-db9a-000100610002",
  630. "0156c3a2-e1ca-76c4-a73d-000100620009", "015700ee-d7a3-04c9-97c3-000100620007",
  631. "014841a3-871a-b2d0-dce3-000100610004", "0156b99e-18cd-509c-a73d-000100620009",
  632. "49359eda-e880-498a-b619-0cd5b78f0d3e", "01574eca-008f-2eb6-db9a-000100610002",
  633. "0157f8ea-5cf5-fb56-a5df-000100610002", "01567a92-4684-10cb-8853-000100610002",
  634. "0154595d-d236-4424-4700-000100610001", "01567b84-66bd-c0ae-8853-000100610002",
  635. "014bec1a-b889-b63d-f9d8-000100620005", "015068a6-0c1f-518a-b23d-000100610004",
  636. "015506a2-adb5-b060-6969-000100610002", "01547322-b258-029e-4700-000100610001",
  637. "015047ec-4e21-ae7e-ae26-000100620002", "0156767e-745a-77a5-8853-000100610002",
  638. "01570691-2efe-1045-db9a-000100610002", "01570692-2a7a-aaab-97c3-000100620007",
  639. "01579686-5ce8-8974-db9a-000100610002", "0156dd45-a7f0-4a68-9e44-000100610002",
  640. "0156b5bb-c1b5-71a0-4a4e-000100610006", "e077b021-6c02-42b3-b6d1-6fd607cbb843",
  641. "0156d87a-2b83-ee17-be06-000100620007", "01584172-621f-0cc1-5a6a-000100620002",
  642. "01508639-caf8-f1f0-6f99-000100620005", "0156809e-df0e-006b-8853-000100610002",
  643. "fa6714af-9d4e-4050-a1ae-3e123cda871b", "0151ab50-04e1-527e-35c7-000100610004",
  644. "0154922d-3d56-d262-4700-000100610001", "0156d92a-1ce4-ddc3-9e44-000100610002",
  645. "0156de1e-5bd7-38dd-d85c-000100610006", "0155c0b9-39ab-733a-4b5e-000100620007",
  646. "0145d2ca-e4c3-2635-866f-000100610004", "0145e2f6-1dfd-dd64-720a-000100610004",
  647. "0151686c-a61d-7e5a-35c7-000100610004", "0153ae59-5d4d-6e65-f0d6-000100610002",
  648. "014ead6b-cd95-572a-da2b-000100620005", "014eabfa-0bec-5348-da2b-000100620005",
  649. "015797fc-1eb2-ffbc-622d-000100610002", "0127d97a-38ca-fa56-94bd-000100620001",
  650. "01570be1-2ed1-64c6-db9a-000100610002", "01572fe1-ea6b-25d7-db9a-000100610002",
  651. "0153021e-3158-3048-cfa6-000100620009", "0154c95f-25c1-dcb0-cef8-000100610002",
  652. "015392fa-d899-d84d-f0d6-000100610002", "0153a40b-7de4-3f42-f0d6-000100610002",
  653. "01572ad0-74c8-e6a5-db9a-000100610002", "014cb8da-e708-4b4b-1bd7-000100620002",
  654. "01541b83-390b-b3bf-7ae6-000100610001", "0157536d-c030-25a2-db9a-000100610002",
  655. "015735ce-86b5-49b6-97c3-000100620007", "0152b268-a554-d2ee-26dd-000100620009",
  656. "b4ee5de8-ab00-4649-94ed-13610555c19e", "01575811-8554-79fc-db9a-000100610002",
  657. "01575816-f0b5-66b3-db9a-000100610002", "fbd26b8c-9f4a-4a76-b3b3-7e93075ac795",
  658. "4b446396-d47a-460f-8e83-3021377dfc1b", "0157b42c-a519-23f8-89d7-000100620002",
  659. "015453ac-f1c6-63f7-3594-000100610002", "0155134b-f5fd-cb56-6969-000100610002",
  660. "0154e87f-b77c-c65a-cb38-000100610001", "0157e2f0-f519-a260-a5df-000100610002",
  661. "0155b5b3-708f-e77d-5e30-000100620007", "015807c2-5b5e-016e-ee3e-000100620002",
  662. "0157e2f9-0a67-b8af-a5df-000100610002", "015231ea-f9b2-6a6b-1078-000100620002",
  663. "014ae515-56d4-29fc-26fe-000100620002", "01583f6e-6088-2ba9-5a6a-000100620002",
  664. "0154a0ca-1770-5f19-97f4-000100620009", "0158071b-11cc-3cd5-a5df-000100610002",
  665. "0153f6d2-6918-42f4-f0d6-000100610002", "0157b526-d3a3-0704-89d7-000100620002",
  666. "0157d377-8dd1-d447-17a8-000100610002", "0158020f-9aed-27f9-a5df-000100610002",
  667. "0157b05d-38c3-387d-581d-000100610002", "0157c427-ef59-c9d0-4ef4-000100620002",
  668. "01512607-d3b2-0248-fbc0-000100620002", "0157b630-d3e1-3488-17a8-000100610002",
  669. "01540c38-476f-7855-f0d6-000100610002", "01534f57-b14b-6208-6dfb-000100620009",
  670. "015047ff-527b-c973-ae26-000100620002", "0157fcf7-adc2-dc37-a5df-000100610002",
  671. "014c99ec-b70e-594e-8640-000100620005", "0150b91e-893e-d298-012a-000100610001",
  672. "0157ba04-ff63-b048-17a8-000100610002", "0157b427-1c8d-0d6b-89d7-000100620002",
  673. "0157fd04-ecd9-0cc0-ee3e-000100620002", "0157bab8-d46e-ec92-17a8-000100610002",
  674. "e29708e7-8b20-453d-9aa8-fa603fd7708b", "0152e72a-3120-3218-f918-000100610002",
  675. "015027cd-8b7b-8c3e-6828-000100610004", "01533367-0023-25d3-d170-000100610002",
  676. "01552608-329f-2389-da57-000100610001", "01560380-07e3-a73a-1049-000100610002",
  677. "0157d907-0a6d-cac4-17a8-000100610002", "0157de33-1a75-66b8-a5df-000100610002",
  678. "015863a6-c961-e9f0-184c-000100610002", "0155b0e6-ffa3-9b96-2ac4-000100610002",
  679. "015027e7-9eec-a5c4-6828-000100610004", "01508638-9a2b-1570-5d79-000100610004",
  680. "015027e8-972e-a6ef-6828-000100610004", "015029ff-4779-c738-74c8-000100610001",
  681. "0150cf15-c2fd-d169-9dea-000100610001", "01504282-4fcf-6687-8dd6-000100610001",
  682. "0140168e-5c35-50f2-0909-000100620005", "0157de96-791b-f4ca-ee3e-000100620002",
  683. "01582ae8-a0c1-f0b2-a5df-000100610002", "0155849a-113c-305b-47d8-000100610001",
  684. "dbe5a826-db99-479d-a660-dafc36ae9e79", "0157527f-14f1-3b28-db9a-000100610002",
  685. "015463a4-dc55-4f15-97f4-000100620009", "0158209c-2032-6e8b-a5df-000100610002",
  686. "0157fd6b-bae4-a595-ee3e-000100620002", "0157bff2-b4c4-29bd-4ef4-000100620002",
  687. "0157bfff-fa7c-eaa9-4ef4-000100620002", "0157f884-0a67-0560-a5df-000100610002",
  688. "015869a9-36a0-7dd6-15ca-000100610002", "015869aa-476c-8153-15ca-000100610002",
  689. "01581b6a-a354-9cfd-a5df-000100610002", "015802dd-abe0-1fb1-a5df-000100610002",
  690. "01580372-344e-9588-a5df-000100610002", "0157c512-9970-5265-17a8-000100610002",
  691. "01463a14-5e36-b3ca-f1af-000100620005", "01580796-dc27-ab6b-a5df-000100610002",
  692. "01584fb9-5094-4cad-45ab-000100620002", "015825fe-04cc-92df-a5df-000100610002",
  693. "015854b0-02e5-34d8-184c-000100610002", "01584550-c780-4191-45a0-000100610002",
  694. "0158454c-d998-34de-45a0-000100610002", "01491f79-7bec-ef92-7b00-000100620002",
  695. "0150ec6a-a5a3-5f67-0de2-000100610004", "0158509f-0baf-e3a8-45ab-000100620002",
  696. "0156ffd5-5799-09fb-97c3-000100620007", "014de458-72b6-3abf-853f-000100620002",
  697. "0149341c-a733-0dd8-b063-000100620005", "0156bd35-b689-40c5-4a4e-000100610006",
  698. "0152eb25-939e-a67b-f918-000100610002", "0153ce6b-ea84-1f89-f0d6-000100610002",
  699. "0152c2b0-7121-425f-9537-000100610001", "0152efc2-3554-9968-9b97-000100610001",
  700. "01541624-3159-a660-f0d6-000100610002", "01562e44-bac0-ea9f-3650-000100610002",
  701. "0152c2e9-1c60-e649-9537-000100610001", "0152c331-28b5-af5c-9537-000100610001",
  702. "0152d639-4145-bbb7-f918-000100610002", "0152c303-9bc0-3b27-9537-000100610001",
  703. "0152c2b8-b505-5c1d-9537-000100610001", "0152eb25-92dc-a5ff-f918-000100610002",
  704. "01562e44-bc70-ec63-3650-000100610002", "01530ae9-c504-1ece-d170-000100610002",
  705. "01582b6f-397d-c03e-23eb-000100620002", "01525644-2cf3-9047-1aae-000100610001",
  706. "01516899-63f4-f875-35c7-000100610004", "01503820-8db6-a662-74c8-000100610001",
  707. "01505e55-d10c-94ce-2738-000100610001", "01516a38-4255-d975-35c7-000100610004",
  708. "01511c96-1cbf-267e-ad69-000100610001", "015112c0-4dad-984c-ad69-000100610001",
  709. "015608ce-a760-bbd0-8a3c-000100610006", "0147b1e6-1b35-3dc0-a8bd-000100620005",
  710. "014b0d26-dc58-a123-cf20-000100620005", "01520ddb-9660-c43a-c0f1-000100610001",
  711. "01581ce6-0211-3478-a5df-000100610002", "015864c4-ecd1-07b8-184c-000100610002")
  712. .stream()
  713. .map(UUID::fromString)
  714. .collect(toList());
  715.  
  716. public static void main(final String[] args) throws Exception
  717. {
  718. // ssh -f -N -q -L 6543:10.104.0.47:5432 -o UserKnownHostsFile=/dev/null -o
  719. // StrictHostKeyChecking=no bastion
  720. @Cleanup
  721. final DSLContext backup = DSL.using("jdbc:postgresql://localhost:6543/pbxs", "postgres", "");
  722.  
  723. @Cleanup
  724. final DSLContext current = DSL.using("jdbc:postgresql://10.103.1.161/pbxs", "postgres", "");
  725.  
  726. final Map<UUID, RestorationData> restorationDatas = collectRestorationData(backup);
  727.  
  728. final Map<UUID, UserAgentConfigurationRecord> newUacs =
  729. collectNewUacs(current, restorationDatas.keySet());
  730.  
  731. final List<UserAgentConfigurationRecord> updatedUacRecords =
  732. getUpdatedUacRecords(restorationDatas, newUacs);
  733.  
  734. final List<UserAgentButtonRecord> updatedButtonRecords =
  735. getUpdatedButtons(restorationDatas, newUacs);
  736.  
  737. final List<UserAgentConfigurationCustomAttributeRecord> updatedAttributeRecords =
  738. getUpdatedAttributes(restorationDatas, newUacs);
  739.  
  740. final List<UUID> actualUpdatedUacIds = updatedUacRecords
  741. .stream()
  742. .map(UserAgentConfigurationRecord::getId)
  743. .collect(toList());
  744.  
  745. log.info("Updating UAC IDs: {}", actualUpdatedUacIds);
  746. log.info("Updating [{}] records", actualUpdatedUacIds.size());
  747.  
  748. // ssh -f -N -q -L 7654:10.117.252.27:5432 -o UserKnownHostsFile=/dev/null -o
  749. // StrictHostKeyChecking=no bastion
  750. @Cleanup
  751. final DSLContext rw = DSL.using("jdbc:postgresql://localhost:7654/pbxs", "postgres", "");
  752.  
  753. rw.transaction((config) ->
  754. {
  755. final DSLContext ctx = DSL.using(config);
  756.  
  757. ctx.deleteFrom(USER_AGENT_CONFIGURATION_CUSTOM_ATTRIBUTE)
  758. .where(USER_AGENT_CONFIGURATION_CUSTOM_ATTRIBUTE.USER_AGENT_CONFIGURATION_ID
  759. .in(actualUpdatedUacIds));
  760.  
  761. ctx.deleteFrom(USER_AGENT_BUTTON)
  762. .where(USER_AGENT_BUTTON.CONFIGURATION_ID.in(actualUpdatedUacIds));
  763.  
  764. ctx.batchInsert(updatedAttributeRecords);
  765.  
  766. ctx.batchInsert(updatedButtonRecords);
  767.  
  768. ctx.batchUpdate(updatedUacRecords);
  769.  
  770. });
  771.  
  772. }
  773.  
  774. private static List<UserAgentConfigurationCustomAttributeRecord> getUpdatedAttributes(
  775. final Map<UUID, RestorationData> restorationDatas,
  776. final Map<UUID, UserAgentConfigurationRecord> newUacs)
  777. {
  778. return newUacs.entrySet()
  779. .stream()
  780. .filter(entry -> restorationDatas.containsKey(entry.getKey()))
  781. .flatMap((entry) ->
  782. {
  783.  
  784. final RestorationData restorationData = restorationDatas.get(entry.getKey());
  785.  
  786. return restorationData.getOldUaccas()
  787. .stream()
  788. .map(uacca ->
  789. {
  790. uacca.setUserAgentConfigurationId(entry.getValue().getId());
  791. return uacca;
  792. });
  793. })
  794. .collect(toList());
  795. }
  796.  
  797. private static List<UserAgentButtonRecord> getUpdatedButtons(
  798. final Map<UUID, RestorationData> restorationDatas,
  799. final Map<UUID, UserAgentConfigurationRecord> newUacs)
  800. {
  801. return newUacs.entrySet()
  802. .stream()
  803. .filter(entry -> restorationDatas.containsKey(entry.getKey()))
  804. .flatMap((entry) ->
  805. {
  806.  
  807. final RestorationData restorationData = restorationDatas.get(entry.getKey());
  808.  
  809. return restorationData.getOldButtons()
  810. .stream()
  811. .map(uabr ->
  812. {
  813. uabr.setConfigurationId(entry.getValue().getId());
  814. return uabr;
  815. });
  816. })
  817. .collect(toList());
  818. }
  819.  
  820. private static List<UserAgentConfigurationRecord> getUpdatedUacRecords(
  821. final Map<UUID, RestorationData> restorationDatas,
  822. final Map<UUID, UserAgentConfigurationRecord> newUacs)
  823. {
  824. return newUacs.entrySet()
  825. .stream()
  826. .filter(entry -> restorationDatas.containsKey(entry.getKey()))
  827. .map((entry) ->
  828. {
  829.  
  830. final RestorationData restorationData = restorationDatas.get(entry.getKey());
  831.  
  832. final UserAgentConfigurationRecord newUac = entry.getValue();
  833. newUac.setPolycomContacts(restorationData.getOldPolycomContacts());
  834.  
  835. return newUac;
  836. })
  837. .collect(toList());
  838. }
  839.  
  840. private static Map<UUID, RestorationData> collectRestorationData(final DSLContext backup)
  841. {
  842. final Map<UUID, List<UserAgentConfigurationCustomAttributeRecord>> attrsByUacId = backup.select(
  843. concat(USER_AGENT_CONFIGURATION_CUSTOM_ATTRIBUTE.fields(), USER_AGENT.ID))
  844. .from(USER_AGENT_CONFIGURATION_CUSTOM_ATTRIBUTE)
  845. .join(USER_AGENT_CONFIGURATION)
  846. .on(USER_AGENT_CONFIGURATION_CUSTOM_ATTRIBUTE.USER_AGENT_CONFIGURATION_ID
  847. .eq(USER_AGENT_CONFIGURATION.ID))
  848. .join(USER_AGENT)
  849. .on(USER_AGENT.CONFIGURATION_ID.eq(USER_AGENT_CONFIGURATION.ID))
  850. .where(USER_AGENT_CONFIGURATION.RESOURCE_GROUP_ID.eq(JIVE_PBX_ID))
  851. .and(USER_AGENT_CONFIGURATION.ID.notIn(EXISTING_UAC_IDS))
  852. .fetchGroups(USER_AGENT.ID, UserAgentConfigurationCustomAttributeRecord.class);
  853.  
  854. final Map<UUID, List<UserAgentButtonRecord>> buttonsByUacId = backup.select(
  855. concat(USER_AGENT_BUTTON.fields(), USER_AGENT.ID))
  856. .from(USER_AGENT_BUTTON)
  857. .join(USER_AGENT_CONFIGURATION)
  858. .on(USER_AGENT_BUTTON.CONFIGURATION_ID.eq(USER_AGENT_CONFIGURATION.ID))
  859. .join(USER_AGENT)
  860. .on(USER_AGENT.CONFIGURATION_ID.eq(USER_AGENT_CONFIGURATION.ID))
  861. .where(USER_AGENT_CONFIGURATION.RESOURCE_GROUP_ID.eq(JIVE_PBX_ID))
  862. .and(USER_AGENT_CONFIGURATION.ID.notIn(EXISTING_UAC_IDS))
  863. .fetchGroups(USER_AGENT.ID, UserAgentButtonRecord.class);
  864.  
  865. final Map<UUID, UserAgentConfigurationRecord> uacByUacId = backup.select(
  866. concat(USER_AGENT_CONFIGURATION.fields(), USER_AGENT.ID))
  867. .from(USER_AGENT_CONFIGURATION)
  868. .join(USER_AGENT)
  869. .on(USER_AGENT.CONFIGURATION_ID.eq(USER_AGENT_CONFIGURATION.ID))
  870. .where(USER_AGENT_CONFIGURATION.RESOURCE_GROUP_ID.eq(JIVE_PBX_ID))
  871. .and(USER_AGENT_CONFIGURATION.ID.notIn(EXISTING_UAC_IDS))
  872. .fetchMap(USER_AGENT.ID, UserAgentConfigurationRecord.class);
  873.  
  874. return uacByUacId.entrySet()
  875. .stream()
  876. .map((entry) ->
  877. {
  878. final List<UserAgentConfigurationCustomAttributeRecord> uaccas =
  879. attrsByUacId.getOrDefault(entry.getKey(), emptyList());
  880.  
  881. final List<UserAgentButtonRecord> buttons =
  882. buttonsByUacId.getOrDefault(entry.getKey(), emptyList());
  883.  
  884. return RestorationData.builder()
  885. .uaId(entry.getKey())
  886. .oldUacId(entry.getValue().getId())
  887. .oldPolycomContacts(entry.getValue().getPolycomContacts())
  888. .oldUaccas(uaccas)
  889. .oldButtons(buttons)
  890. .build();
  891. })
  892. .collect(toMap(RestorationData::getUaId, identity()));
  893. }
  894.  
  895. private static Map<UUID, UserAgentConfigurationRecord> collectNewUacs(final DSLContext current,
  896. final Set<UUID> uaIds)
  897. {
  898. return current.select(concat(USER_AGENT_CONFIGURATION.fields(), USER_AGENT.ID))
  899. .from(USER_AGENT)
  900. .join(USER_AGENT_CONFIGURATION)
  901. .on(USER_AGENT.CONFIGURATION_ID.eq(USER_AGENT_CONFIGURATION.ID))
  902. .where(USER_AGENT.ID.in(uaIds))
  903. .fetchMap((record) -> record.getValue(USER_AGENT.ID),
  904. (record) -> record.into(UserAgentConfigurationRecord.class));
  905. }
  906.  
  907. @Value
  908. @Builder
  909. private static class RestorationData
  910. {
  911. @NonNull
  912. private final UUID uaId;
  913. @NonNull
  914. private final UUID oldUacId;
  915. @NonNull
  916. private final String oldPolycomContacts;
  917. @NonNull
  918. private final List<UserAgentButtonRecord> oldButtons;
  919. @NonNull
  920. private final List<UserAgentConfigurationCustomAttributeRecord> oldUaccas;
  921. }
  922.  
  923. @Value
  924. @Builder
  925. private static class FixedData
  926. {
  927. @NonNull
  928. private final UUID uaId;
  929. @NonNull
  930. private final UUID oldUacId;
  931. @NonNull
  932. private final String newPolycomContacts;
  933. @NonNull
  934. private final List<UserAgentButtonRecord> newButtons;
  935. @NonNull
  936. private final List<UserAgentConfigurationCustomAttributeRecord> newUaccas;
  937. }
  938.  
  939. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!