Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
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()
}