[Enhancement]: For testers, when no testing server is available, return the production server

[InternalLoss]

Checked Existing

• I have checked the repository for duplicate issues.

What enhancement would you like to see?

Currently, if a server set to testing environment is not available, users set to test servers will receive an error, causing us to need to duplicate servers across prod and test. However, it would be preferable if we didn't have to do this - if a test server is set this should override the production server for testing users, otherwise send them to the same production servers.

Any other details to share? (OPTIONAL)

No response

[binaryoverload]

Currently, the servers are retrieved by access level here:

account/src/database.js

Lines 204 to 209 in 8c259c9

	function getServerByTitleId(titleId, accessMode) {
	return Server.findOne({
	title_ids: titleId,
	access_mode: accessMode,
	});
	}

We could change this to get all servers regardless of access level, and then use fallback like so depending on the user's access level:

flowchart TD
    Development--When no dev env-->Tester
    Tester--When no tester env-->Prod
    UserDev{{"User (Developer)"}} --> Development
    UserTest{{"User (Tester)"}} --> Tester
    User{{"User (Normal)"}} --> Prod

Loading

[AToska21]

Currently, the servers are retrieved by access level here:

account/src/database.js

Lines 204 to 209 in 8c259c9

function getServerByTitleId(titleId, accessMode) {
return Server.findOne({
title_ids: titleId,
access_mode: accessMode,
});
}
We could change this to get all servers regardless of access level, and then use fallback like so depending on the user's access level:

could probably be done by if no server is found by the requested access level fall back to the lower access level (e.g. dev --> test --> prod)

sidenote: how'd you do that flowchart thing?

[binaryoverload]

sidenote: how'd you do that flowchart thing?

Using a Mermaid diagram - docs here: https://mermaid.js.org/intro/

[AToska21]

Made a PR for this, #158