database

package

v0.1.3 Latest Latest Go to latest Published: Nov 14, 2024 License: MIT Imports: 6 Imported by: 0

Details

This section is empty.

This section is empty.

This section is empty.

type SQLiteDB struct {
	// contains filtered or unexported fields
}

func NewSQLiteDB(dbPath string) (*SQLiteDB, error)

func (s *SQLiteDB) CleanupExpiredTokens() error

func (s *SQLiteDB) CountActiveTokens(userID int64) (int, error)

func (s *SQLiteDB) CreateAuditLog(log *models.AuditLog) error

Audit methods

func (s *SQLiteDB) CreateToken(token *models.Token) error

Token methods

func (s *SQLiteDB) CreateUser(user *models.User) error

User methods

func (s *SQLiteDB) GetTokenByJTI(jti string) (*models.Token, error)

func (s *SQLiteDB) GetTokenByRefreshToken(refreshToken string, userID int64) (*models.Token, error)

func (s *SQLiteDB) GetUserByID(id int64) (*models.User, error)

func (s *SQLiteDB) GetUserByUsername(username string) (*models.User, error)

func (s *SQLiteDB) GetUserSessions(userID int64) ([]models.Session, error)

func (s *SQLiteDB) ListUsers() ([]models.User, error)

func (s *SQLiteDB) RevokeAllUserTokens(userID int64) error

func (s *SQLiteDB) UpdateToken(token *models.Token) error

func (s *SQLiteDB) UpdateUser(user *models.User) error

func (s *SQLiteDB) UpdateUserPassword(user *models.User) error