CustomCodeEditor Error when using the same email for both Google and GitHub sign-ins

When a user tries to sign in with both Google and GitHub using the same primary email address, it causes a database conflict and raises an error. This is likely because the email is already stored in the database when they first use Google sign-in, and attempting to log in via GitHub with the same email results in a duplicate entry.

Checkout this PR for reference https://github.com/DhanushNehru/CustomCodeEditor/pull/139

Steps to Reproduce:

Sign up with Google using an email. Try signing in with GitHub using the same primary email.

Expected Behavior:

The user should be able to sign in with either Google or GitHub using the same email without raising an error.

Actual Behavior:

An error occurs due to a conflict in the database for the same email being linked to different sign-in providers.

Oct 10 '24 06:10 DhanushNehru

Hey @DhanushNehru I can do this task. Please can you assign it to me. Thanks!

Oct 10 '24 06:10 swarupn17

@DhanushNehru this looks interesting, can you assign this to me also?

Oct 14 '24 02:10 tusharshah21

Hi @tusharshah21

Seems @swarupn17 is working on it. @swarupn17 any updates ?

Oct 16 '24 06:10 DhanushNehru

@DhanushNehru now can you check and assign it to me?

Oct 16 '24 09:10 tusharshah21

@DhanushNehru you expecting a Single User Identity or multi-user Identity?

Oct 19 '24 09:10 tusharshah21

SSO if possible @tusharshah21

Oct 19 '24 09:10 DhanushNehru

@DhanushNehru tried to resolved it, but couldn't resolve the conflict to be precise, could only add an alert that there exist an account already. Let me know if it is good to go

https://github.com/user-attachments/assets/366d3492-9de7-43aa-ba42-5c696b4c1d08

Oct 21 '24 09:10 tusharshah21

@DhanushNehru any update?

Oct 24 '24 06:10 tusharshah21

FIne for now , raise a new issue and new pr for alert alone, let this issue still be open @tusharshah21

Oct 25 '24 15:10 DhanushNehru

alright

Oct 26 '24 08:10 tusharshah21