Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

3.5 KB
Raw Blame
package store

import (
	"context"
	"database/sql"
	"time"

	"github.com/pkg/errors"

	"github.com/bytebase/bytebase/backend/store/qb"
)

type WebRefreshTokenMessage struct {
	TokenHash string
	UserEmail string
	ExpiresAt time.Time
	// CreatedAt is when the session was issued, filled in by the database.
	// Ignored on create.
	CreatedAt time.Time
}

func (s *Store) CreateWebRefreshToken(ctx context.Context, create *WebRefreshTokenMessage) error {
	q := qb.Q().Space(`
		INSERT INTO web_refresh_token (token_hash, user_email, expires_at)
		VALUES (?, ?, ?)
	`, create.TokenHash, create.UserEmail, create.ExpiresAt)

	query, args, err := q.ToSQL()
	if err != nil {
		return err
	}

	if _, err := s.GetDB().ExecContext(ctx, query, args...); err != nil {
		return errors.Wrap(err, "failed to create web refresh token")
	}
	return nil
}

func (s *Store) GetWebRefreshToken(ctx context.Context, tokenHash string) (*WebRefreshTokenMessage, error) {
	q := qb.Q().Space(`
		SELECT token_hash, user_email, expires_at, created_at
		FROM web_refresh_token
		WHERE token_hash = ?
	`, tokenHash)

	query, args, err := q.ToSQL()
	if err != nil {
		return nil, err
	}

	msg := &WebRefreshTokenMessage{}
	if err := s.GetDB().QueryRowContext(ctx, query, args...).Scan(
		&msg.TokenHash, &msg.UserEmail, &msg.ExpiresAt, &msg.CreatedAt,
	); err != nil {
		if errors.Is(err, sql.ErrNoRows) {
			return nil, nil
		}
		return nil, errors.Wrap(err, "failed to get web refresh token")
	}
	return msg, nil
}

// GetAndDeleteWebRefreshToken atomically retrieves and deletes a refresh token.
// Returns the token if found and deleted, nil if not found.
func (s *Store) GetAndDeleteWebRefreshToken(ctx context.Context, tokenHash string) (*WebRefreshTokenMessage, error) {
	q := qb.Q().Space(`
		DELETE FROM web_refresh_token
		WHERE token_hash = ?
		RETURNING token_hash, user_email, expires_at, created_at
	`, tokenHash)

	query, args, err := q.ToSQL()
	if err != nil {
		return nil, err
	}

	msg := &WebRefreshTokenMessage{}
	if err := s.GetDB().QueryRowContext(ctx, query, args...).Scan(
		&msg.TokenHash, &msg.UserEmail, &msg.ExpiresAt, &msg.CreatedAt,
	); err != nil {
		if errors.Is(err, sql.ErrNoRows) {
			return nil, nil
		}
		return nil, errors.Wrap(err, "failed to get and delete web refresh token")
	}
	return msg, nil
}

func (s *Store) DeleteWebRefreshToken(ctx context.Context, tokenHash string) error {
	q := qb.Q().Space(`
		DELETE FROM web_refresh_token
		WHERE token_hash = ?
	`, tokenHash)

	query, args, err := q.ToSQL()
	if err != nil {
		return err
	}

	if _, err := s.GetDB().ExecContext(ctx, query, args...); err != nil {
		return errors.Wrap(err, "failed to delete web refresh token")
	}
	return nil
}

func (s *Store) DeleteWebRefreshTokensByUser(ctx context.Context, userEmail string) error {
	q := qb.Q().Space(`
		DELETE FROM web_refresh_token
		WHERE user_email = ?
	`, userEmail)

	query, args, err := q.ToSQL()
	if err != nil {
		return err
	}

	if _, err := s.GetDB().ExecContext(ctx, query, args...); err != nil {
		return errors.Wrap(err, "failed to delete web refresh tokens for user")
	}
	return nil
}

func (s *Store) DeleteExpiredWebRefreshTokens(ctx context.Context) (int64, error) {
	q := qb.Q().Space(`
		DELETE FROM web_refresh_token
		WHERE expires_at < NOW()
	`)

	query, args, err := q.ToSQL()
	if err != nil {
		return 0, err
	}

	result, err := s.GetDB().ExecContext(ctx, query, args...)
	if err != nil {
		return 0, errors.Wrap(err, "failed to delete expired web refresh tokens")
	}
	return result.RowsAffected()
}