Hey!!! There is a table named `userid_mapping `in the supertokens core's database (when we are using self-hosted service). Could this table be used to map the user ids from supertokens database with some external NoSQL database, say MongoDB, which our application uses? Also, is there any table that can store additional session information that our application fetches?

hey @himanshukukreja_ yea, this table can be used to map user IDs. Im not sure which SDK you are using, but in node, there is a function called

createUserIdMapping

which you can use: https://supertokens.com/docs/nodejs/modules/index.html#createUserIdMapping

Hey @rp_st after using the

userid_mapping

table (to store the supertokens_user_id and external_database_id), at the time of first-time signup (both third party and email password ) the user id that I get from` session.get_user_id()` or

session.user_id

is my supertokens id after the signup when we get logged out and again sign In we get the external database id. Why is this so?? Or Is there any method to override this change?

are you doing the mapping in the api override or in the recipe function override?

I was directly accessing the database

*userid_mapping

and making a SQL query call to it

thats fine.. but are you doing that in api override or function override? I mean, override.apis or in override.functions?

Oh yes. I am doing it in api override

right. You want to do this in the functions override

just to confirm I was doing it in

override_thirdpartyemailpassword_apis(original_implementation: APIInterface)

function but now I have to implement the mapping logic in

override_thirdpartyemailpassword_functions(original_implementation: RecipeInterface)

function

correct.

Ok right, Can you tell me which function I have to override by adding it into my mapping logic example

thirdparty_sign_in_up_post

or

thirdparty_sign_in_up

???

thirdparty_sign_in_up one

I have implemented the mapping in

thirdparty_sign_in_up

and

emailpassword_sign_up

of

override_thirdpartyemailpassword_functions(original_implementation: RecipeInterface)

function but still the same problem persists thatis the at the time of first sign_up session.user_id givessupertokens_id while after logging out and then at the time of signIn session.user_id gives external_id. I am attaching my code snipped where I have implemented

override_thirdpartyemailpassword_functions

do you modify the response object's user_id to point to your custom user in these overrides?

No we didn't changed response object's user_id because we are unsure that if it might have some affect in supertokens' internal code

you should modify that

Yup you are right!!! the issue id fixed

great

Hey @rp_st , I have an issue with mapping function provided by supertokens. I have imported this function as

from supertokens_python.asyncio import create_user_id_mapping

. I have used this function inside the function overrides of

emailpassword_signup and thirdparty_signin_up

After the mapping I have used the api overrides in order to store the additional session information in my custom table. There is a problem of synchronizarion of this function (

create_user_id_mapping

) as in some cases mapping is done successfully before the calling of functions which I have written inside the api overrides while sometimes there is no mapping at the time of calling api override function. Thus it causes inconsistency. I am attaching the snippet of my code. Also If I uses the custom function for mapping, all things are running smoothly with no problem of synchronization

you need to add

await

when calling the

create_user_id_mapping

function

I have added the await but the issue still persists

you may also need to add await for the mongo_db query that you are doing.

thnks issue resolved

cool