hey. In your tests, you can call the login endpoint to create a new session and then take it from there.
In terms of the core, you can spin up a new docker container for each test suit with the in memory db and can restart the docker container during each test (to start from a fresh user table for each test), or can create new randomised users during each test.