Last active
July 28, 2022 04:31
-
-
Save andy4thehuynh/a4ab9d08dc9fd39857d8c6a3ffed16ae to your computer and use it in GitHub Desktop.
finds mismatched external user ids with users for university site
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| university = Site.find(ENV["UNIVERSITY_SITE_ID"]) | |
| members = university.members | |
| count = 0 | |
| member_emails = [] | |
| emails_as_eui_count = 0 | |
| # find emails as external user ids | |
| members.find_each do |member| | |
| eui = member.external_user_id | |
| if eui && eui.include?("@") | |
| emails_as_eui_count += 1 | |
| end | |
| end | |
| # finds mismatched university member external_user_ids | |
| # from their KJB user account id | |
| members.find_each do |member| | |
| email = member.email | |
| eui = member.external_user_id | |
| if eui && !eui.include?("@") | |
| id = eui.split(":")[-1] | |
| if u = User.find_by(id: id) | |
| unless u.email == email | |
| puts "Mismatch! member_id: #{member.id}, email: #{email}, eui: #{eui}" | |
| member_emails << email | |
| count +=1 | |
| end | |
| end | |
| end | |
| end | |
| puts "count: #{count}" | |
| university_users_count = User.where(email: member_emails).count | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment