Function getRefreshedSession

server/src/db/session-refresh-db.ts:44–61

(
  oldCookieHash: string,
)

 * Returns the new sealed session if found and not expired, undefined otherwise.
 */
export async function getRefreshedSession(
  oldCookieHash: string,
): Promise<string | undefined> {
  if (!isDatabaseInitialized()) return undefined;
  try {
    const result = await query(
      `SELECT new_sealed_session FROM session_refreshes
       WHERE old_cookie_hash = $1 AND expires_at > NOW()`,
      [oldCookieHash],
    );
    if (result.rows.length > 0) {
      return result.rows[0].new_sealed_session;
    }
  } catch (err) {
    logger.warn({ err }, 'Failed to look up refreshed session');
  }
  return undefined;
}

/**
 * Clean up expired entries. Called periodically.