Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sqlstore

package

Go to main page

Versions in this module

v0

v0.0.4

Jan 19, 2026

Changes in this version

type SQLStore

+ func (s *SQLStore) GetUserDirectPermissions(ctx context.Context, userID string) ([]*models.Permission, error)

+ func (s *SQLStore) GrantUserPermission(ctx context.Context, userID, permissionID string) error

+ func (s *SQLStore) RevokeUserPermission(ctx context.Context, userID, permissionID string) error

v0.0.3

Jan 18, 2026

Changes in this version

type SQLStore

+ func (s *SQLStore) GetPermissionByResourceAction(ctx context.Context, resource, action string) (*models.Permission, error)

+ func (s *SQLStore) HasPermissionByName(ctx context.Context, userID, permissionName string) (bool, error)

+ func (s *SQLStore) HasRolePermission(ctx context.Context, roleID, permissionID string) (bool, error)

v0.0.2

Nov 29, 2025

v0.0.1

Nov 27, 2025

Changes in this version

+ func New(cfg config.DatabaseConfig) (store.Store, error)

+ type SQLStore struct

+ func (s *SQLStore) AssignRole(ctx context.Context, userID, roleID string) error

+ func (s *SQLStore) BeginTx(ctx context.Context) (store.Store, error)

+ func (s *SQLStore) Close() error

+ func (s *SQLStore) Commit() error

+ func (s *SQLStore) CreateEmailVerification(ctx context.Context, verification *models.EmailVerification) error

+ func (s *SQLStore) CreateOAuthAccount(ctx context.Context, account *models.OAuthAccount) error

+ func (s *SQLStore) CreatePasswordReset(ctx context.Context, reset *models.PasswordReset) error

+ func (s *SQLStore) CreatePermission(ctx context.Context, permission *models.Permission) error

+ func (s *SQLStore) CreateRefreshToken(ctx context.Context, token *models.RefreshToken) error

+ func (s *SQLStore) CreateRole(ctx context.Context, role *models.Role) error

+ func (s *SQLStore) CreateUser(ctx context.Context, user *models.User) error

+ func (s *SQLStore) DB() *sql.DB

+ func (s *SQLStore) DeleteExpiredEmailVerifications(ctx context.Context) error

+ func (s *SQLStore) DeleteExpiredPasswordResets(ctx context.Context) error

+ func (s *SQLStore) DeleteExpiredRefreshTokens(ctx context.Context) error

+ func (s *SQLStore) DeleteOAuthAccount(ctx context.Context, id string) error

+ func (s *SQLStore) DeletePermission(ctx context.Context, id string) error

+ func (s *SQLStore) DeleteRole(ctx context.Context, id string) error

+ func (s *SQLStore) DeleteUser(ctx context.Context, id string) error

+ func (s *SQLStore) GetEmailVerificationByToken(ctx context.Context, token string) (*models.EmailVerification, error)

+ func (s *SQLStore) GetOAuthAccountByProviderID(ctx context.Context, provider models.OAuthProvider, providerID string) (*models.OAuthAccount, error)

+ func (s *SQLStore) GetOAuthAccountsByUserID(ctx context.Context, userID string) ([]*models.OAuthAccount, error)

+ func (s *SQLStore) GetPasswordResetByToken(ctx context.Context, token string) (*models.PasswordReset, error)

+ func (s *SQLStore) GetPermissionByID(ctx context.Context, id string) (*models.Permission, error)

+ func (s *SQLStore) GetPermissionByName(ctx context.Context, name string) (*models.Permission, error)

+ func (s *SQLStore) GetPermissionRoles(ctx context.Context, permissionID string) ([]*models.Role, error)

+ func (s *SQLStore) GetRefreshTokenByToken(ctx context.Context, token string) (*models.RefreshToken, error)

+ func (s *SQLStore) GetRefreshTokensByUserID(ctx context.Context, userID string) ([]*models.RefreshToken, error)

+ func (s *SQLStore) GetRoleByID(ctx context.Context, id string) (*models.Role, error)

+ func (s *SQLStore) GetRoleByName(ctx context.Context, name string) (*models.Role, error)

+ func (s *SQLStore) GetRolePermissions(ctx context.Context, roleID string) ([]*models.Permission, error)

+ func (s *SQLStore) GetRoleUsers(ctx context.Context, roleID string) ([]*models.User, error)

+ func (s *SQLStore) GetUserByEmail(ctx context.Context, email string) (*models.User, error)

+ func (s *SQLStore) GetUserByID(ctx context.Context, id string) (*models.User, error)

+ func (s *SQLStore) GetUserRoles(ctx context.Context, userID string) ([]*models.Role, error)

+ func (s *SQLStore) GrantPermission(ctx context.Context, roleID, permissionID string) error

+ func (s *SQLStore) HasRole(ctx context.Context, userID, roleName string) (bool, error)

+ func (s *SQLStore) ListPermissions(ctx context.Context) ([]*models.Permission, error)

+ func (s *SQLStore) ListRoles(ctx context.Context) ([]*models.Role, error)

+ func (s *SQLStore) ListUsers(ctx context.Context, limit, offset int) ([]*models.User, error)

+ func (s *SQLStore) MarkEmailVerificationUsed(ctx context.Context, id string) error

+ func (s *SQLStore) MarkPasswordResetUsed(ctx context.Context, id string) error

+ func (s *SQLStore) RemoveRole(ctx context.Context, userID, roleID string) error

+ func (s *SQLStore) RevokeAllRefreshTokensForUser(ctx context.Context, userID string) error

+ func (s *SQLStore) RevokePermission(ctx context.Context, roleID, permissionID string) error

+ func (s *SQLStore) RevokeRefreshToken(ctx context.Context, token string) error

+ func (s *SQLStore) Rollback() error

+ func (s *SQLStore) UpdateOAuthAccount(ctx context.Context, account *models.OAuthAccount) error

+ func (s *SQLStore) UpdatePermission(ctx context.Context, permission *models.Permission) error

+ func (s *SQLStore) UpdateRole(ctx context.Context, role *models.Role) error

+ func (s *SQLStore) UpdateUser(ctx context.Context, user *models.User) error