Implement Refresh Token Validation Function #62

New issue

Closed

opened 2026-03-12 00:14:46 +00:00 by charlie · 0 comments

charlie commented

2026-03-12 00:14:46 +00:00

Owner

Description

We need a function to validate a refresh token

Requirements

Function name: check_refresh
Input parameters:
- userid (integer) the ID of the user asking to verify his token
- token (varchar(255)) the refresh token to verify
Return:
- Boolean

Proposed logic

Check if the token exist, haven't expired have not been rotated, for that user in the token table.
If the token exist mark it as rotated
return true is the token exist and false if it does not.

## Description We need a function to validate a refresh token ## Requirements 1. Function name: `check_refresh` 2. Input parameters: - `userid` (integer) the ID of the user asking to verify his token - `token` (varchar(255)) the refresh token to verify 3. Return: - Boolean ## Proposed logic 1. Check if the token exist, haven't expired have not been rotated, for that user in the token table. 2. If the token exist mark it as rotated 3. return true is the token exist and false if it does not.

charlie added the

enhancement

label

2026-03-12 00:14:46 +00:00