validate Session Connection Attempt

@Query(value = ""SELECT * FROM " + SESSIONS_KEY + _WHERE_ + JOIN_CODE_KEY + "=:" + JOIN_CODE_KEY + " AND " + PASSWORD_KEY + "=:" + PASSWORD_KEY", nativeQuery = true )
abstract fun validateSessionConnectionAttempt(@Param(value = "join_code") joinCode: String, @Param(value = "password") password: String): BrownieSession

Query used to validate the access attempt of session connection

Return

the related session if authorized as BrownieSession, null otherwise

Parameters

joinCode

The join code to connect to the session

password

The password used to protect the session accesses