Skip to content

Instantly share code, notes, and snippets.

@kelmerp
Created August 15, 2024 15:50
Show Gist options
  • Save kelmerp/f4d72ee501db588ac21ef1c3ff758a40 to your computer and use it in GitHub Desktop.
Save kelmerp/f4d72ee501db588ac21ef1c3ff758a40 to your computer and use it in GitHub Desktop.
bh db wipe; reset tables on our end
irb(main):005:0> Corp::BhReservationRequest.distinct(:bh_user_info_id).pluck(:bh_user_info_id)
=> ["08aa7047-da53-447f-9873-3c2155c2fb9e", "08afc806-ff07-46ec-b90e-fb0fd75806c0", "0a42b13b-6374-42d6-9720-747e6234fe04", "0a70fee5-362c-4f29-b750-3914e6f1a9ed", "0beb079e-1fda-48ea-b659-b6fae092071d", "10681110", "109487b5-191f-4869-82eb-0151d134d63d", "14153983", "16431310", "1689bbfb-f072-4e81-88d4-4223351171e4", "17652199", "19945996", "1af107b5-a718-4fbe-aa37-6c05c14ce080", "1c5472ce-8276-ed11-a866-005056993f98", "1d7766ca-f405-ec11-a858-005056993f98", "1f36d445-ba66-48c5-bec3-244a745062d5", "20214407", "205bb208-21ed-4fe5-9697-669895e38510", "214fa430-a852-4424-ad70-f0b6342ef2bf", "269f1e3f-d51c-4a23-a5f3-eb6197d56c87", "27964329", "28289464", "2b6dec2e-362b-4305-8d72-d0372c4c4b63", "2bf2843a-eaf8-4ee4-9050-13ddb437b280", "2c262371-faea-e911-a842-005056993f98", "2f5e762a-bc5a-4aff-a30c-4aa76313c374", "2f8da8b7-0da0-4b5a-85de-65372453ce15", "30041851", "3128cfcb-e4f1-4ec6-a685-cd6d18aaba58", "31c0ed20-3b5d-46f6-81db-9c31918fcfd3", "32fe3242-b88c-4723-bfc6-7a7fad433949", "3406087", "36020403-92c7-4631-ac26-d00f5b5ce814", "36246155", "366c4bf6-4305-4791-8e87-b458c017031d", "373406ce-efc4-4a70-893d-0957b40159db", "3cf939bb-42b9-418d-8e89-156efd875935", "43ea9bae-ee7f-ed11-a867-005056993f98", "44cad50d-494b-ed11-a866-005056993f98", "46b5b111-2479-4bc1-ad27-a69ff95469f8", "4a86ce55-e9bb-ea11-a850-005056993f98", "4aea2d45-dc61-4767-a7af-a14e748c8c7f", "4cdb34b4-c76f-4b6a-8c79-49c94518be50", "4dcd4be6-df81-4277-891d-84800decc613", "4dd9be34-5d17-4470-99a2-977d65d66105", "516bd948-2691-498d-8e7e-308057556550", "51c99bd3-bcf8-482f-b16d-69be6dece36b", "53ef8c54-9da0-4886-a59f-793af80c381a", "550eab08-855c-4362-be8a-e9b07630d036", "55c2d60a-83c0-4bf3-a1bd-93852ab978ae", "56f0c1d4-8a9e-42cf-b5cb-3403dac88923", "580a425b-678f-4bdf-80a9-688cb7eac8bf", "5882f18a-0caa-4885-8815-f494605beb31", "58be58b2-08a9-4c4b-aa7b-4d3731f594fd", "5b5a3c81-d059-ea11-a84a-005056993f98", "5b5e9cfa-40a5-42ca-b39f-3b01cafdb827", "5cf515af-c538-447a-a993-011e90f9d769", "5dea9bae-ee7f-ed11-a867-005056993f98", "5e34bfe6-71f7-424f-a9b9-6209362d6cf7", "5f3372ec-1393-43dd-ad07-86ff7198c133", "6150e4b6-e388-4a93-b201-6e6fc5263961", "6249cab1-fbed-ec11-a862-005056993f98", "634a18bd-5114-420a-9837-e2f804179c93", "634fc8d8-11c5-4724-bdfb-eeb651c09729", "6459442", "6464808", "671221", "67ea9bae-ee7f-ed11-a867-005056993f98", "6ad03ed9-60ac-414a-bb98-17f8097e1e71", "6c1c498a-8dfd-4ebe-857e-72afae704710", "6c5812e9-d961-4768-a8ba-9668291d7c65", "6db671f3-f624-e911-8629-005056997abe", "7021692", "7023267", "7023383", "70868ed1-f67a-441a-ba22-2c9daeb586bd", "71a8cf51-bad3-4903-b987-069ecbbc4bc2", "744fac3f-32e7-ea11-a851-005056993f98", "7546156d-51e0-489b-bb13-e8d59c19d4af", "75c0715d-c5d8-4d63-8363-19548deceac9", "79335ec7-0bb5-eb11-a856-005056993f98", "7994f2bf-bc37-4f30-a28e-8f17a31238b2", "7a6ba4b5-eee3-4e2b-bdcd-a09250cc97aa", "7b2032a4-3db6-48dd-8f0f-9cc19b980117", "7b335ec7-0bb5-eb11-a856-005056993f98", "7c51531d-7d35-4435-9b79-04f8804cac9b", "831ebc5b-8ab9-4c1d-a276-17fc91bbf51d", "83823b05-c3e8-ea11-a851-005056993f98", "847250d5-1be0-456e-8e64-80f49b25c4db", "85c4d813-9d53-ea11-a848-005056993f98", "876ee5b2-2733-4658-bacc-dc218eeb212e", "886dfe3e-4fc6-410b-b0cb-b7b785448c06", "89a8c5d9-7577-46f2-9a03-7ecec3188ae8", "8ba83b92-8884-49ab-8b49-981605467c7c", "8df82318-db9b-4ff4-9bd8-096d395429db", "90787c13-c943-4909-a1e4-7a746c0d19f3", "9099ad5f-6769-ea11-a84b-005056993f98", "91522168-7ade-4c96-bbfb-0c5ddbaa045a", "9234822", "92eab506-c2a9-47a8-a8ea-341023dc9cf6", "9300365", "9305788", "94366049-30cb-4280-aed0-9be103c3a733", "9535e6f5-3382-48c5-ac46-46e51bab3743", "96a7b8e8-3155-ea11-a84a-005056993f98", "9b63337c-d059-ea11-a84a-005056993f98", "9b8e325e-fdf4-430e-83aa-9bdb96d33259", "9bc67fdf-9f32-4b58-aa41-055b4b8b88d7", "9f0514e0-decd-4023-aced-3d48c40043a4", "9fcbe6df-d2c1-4fc2-a3e2-9a73b4bdf1da", "a2114aa8-be2e-405c-9dbb-3ec5ff30cfc1", "a561ba9a-a2d4-4567-98cd-ee47c8b453d2", "a7e90ba9-af9c-eb11-a856-005056993f98", "a9e90ba9-af9c-eb11-a856-005056993f98", "aadd77c4-8c24-44cb-8f0d-7f9c497a732f", "abb01676-2942-4467-968c-629f592ff8a2", "ac0e9def-a73c-4fc8-95c7-57aaf8b566a7", "ac9c665a-5c7a-4073-8b29-1cf17be29ad9", "acbc32c9-9f63-42e9-a79e-40584243ce03", "ae3b7b10-a938-41c8-9376-9aa4949876dc", "b189395b-b26b-4861-8a54-72b4a2f21986", "b35b3160-16e1-4683-8f93-be49546c10f8", "b8bd3042-6fbf-4c20-b568-9619322d3c71", "b9bccb79-b476-4263-a9ab-530432e54b52", "be4eb36d-3c52-43be-9ed6-426230999813", "c4f9a204-ec58-4d7b-b8c3-e13c71f6e4ee", "c58742d9-aab9-4c59-9155-0703b22b250c", "c5d8bf82-807a-e511-b173-005056991898", "c88f16ec-f2a9-e711-9f93-005056991898", "c8b3e3e2-2f0a-4d68-846a-dba9ef8e4c6e", "d141b523-71c0-486b-b201-5387460729c3", "d1c2a6c6-a02f-ee11-a886-00505684cdbc", "d373ec29-ce42-4587-aa2f-d2c6f2f01682", "ddaa41af-65aa-48e9-b4fe-71e385d000b2", "de3baba2-7e12-43a8-8187-39ac8764854e", "e001a0d8-0190-ea11-a84e-005056993f98", "e1b8360b-ead8-42b4-b10a-a79fd485668e", "e2ca9fbf-99d6-4d4a-bef6-037c3a247e1a", "e54e3671-c10f-e911-8629-005056997abe", "e5fccd62-415f-499a-849f-510526dfed41", "e6cefeac-5401-ef11-a885-005056b2c8fe", "e79992bd-1643-48e5-bf4b-19a385afaec1", "e80beaef-4edd-4493-8bea-2cd7ce388ed4", "e87d26f3-df8e-4f61-83a3-26ae3de9d1c9", "e8bb8adc-0543-49c7-b035-e5bb04dbd4b7", "e997b37f-14f0-4869-b57a-3f5fc97bb032", "e9fcc772-9367-e911-826d-0050569902e1", "ed086057-a460-ed11-a866-005056993f98", "ee879fa1-97a4-4faa-b3d5-9d52775a537e", "ef7b3b5b-fc94-45a3-baca-686c5045900e", "efb34602-9e9e-4fff-a267-fa1f389ce6d5", "efb88d18-2bcd-4dbd-afb3-815336eaaeed", "f4045f90-903e-4441-a775-1febdbf10aa5", "f58cbfcb-ec42-4759-8f6e-4bbc7834c146", "f62363b0-fedb-4a48-b60e-9586f063b243", "f6b3b6a8-0105-4e90-bb99-ed588ac58190", "f76c337c-d059-ea11-a84a-005056993f98", "f8db9f0c-d598-4197-ad85-4db90b64059f", "fcd27873-0166-ed11-a866-005056993f98", "fd345ec7-0bb5-eb11-a856-005056993f98", "ffe01447-ad93-4bc6-bdf8-131de0a879c1"]
irb(main):016:0> ActiveRecord::Base.connection.execute("SET FOREIGN_KEY_CHECKS = 0;")
=> nil
irb(main):017:0> ActiveRecord::Base.connection.execute("TRUNCATE sc_care_sessions")
=> nil
irb(main):018:0> ActiveRecord::Base.connection.execute("TRUNCATE bh_reservation_requests")
=> nil
irb(main):019:0> ActiveRecord::Base.connection.execute("TRUNCATE bh_care_sessions")
=> nil
irb(main):020:0> ActiveRecord::Base.connection.execute("TRUNCATE bh_care_recipients")
=> nil
irb(main):021:0> ActiveRecord::Base.connection.execute("TRUNCATE bh_reservation_request_events")
=> nil
irb(main):022:0> ActiveRecord::Base.connection.execute("SET FOREIGN_KEY_CHECKS = 1;")
=> nil
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment