Nikolai Papin
827928178e
feat: implement change password service method with validation; fix: correct ErrorIsOneOf function logic to return true on match; refactor: rename 'log_out_accounts' to 'log_out_sessions' for clarity; refactor: update session termination to return GUIDs and cache in Redis; fix: ensure RollbackOnError only rolls back uncommitted transactions; fix: handle transaction commit errors properly in dbHelper; refactor: add helper methods for session termination and registration; refactor: pass client info to login and registration complete methods; fix: improve token validation error handling in refresh endpoint; refactor: update auth middleware to set session info correctly; chore: remove unused ClientInfo DTO; fix: correct password reset complete to use session termination helper; refactor: adjust database queries for session management; chore: update SQL schema and queries for sessions; docs: update swagger docs with new endpoint and model changes
105 lines
2.2 KiB
Go
105 lines
2.2 KiB
Go
// Copyright (c) 2025 Nikolai Papin
|
|
//
|
|
// This file is part of Easywish
|
|
//
|
|
// This program is free software: you can redistribute it and/or modify
|
|
// it under the terms of the GNU General Public License as published by
|
|
// the Free Software Foundation, either version 3 of the License, or
|
|
// (at your option) any later version.
|
|
//
|
|
// This program is distributed in the hope that it will be useful,
|
|
// but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See
|
|
// the GNU General Public License for more details.
|
|
//
|
|
// You should have received a copy of the GNU General Public License
|
|
// along with this program. If not, see <https://www.gnu.org/licenses/>.
|
|
|
|
package database
|
|
|
|
import (
|
|
"context"
|
|
|
|
"github.com/jackc/pgx/v5"
|
|
)
|
|
|
|
type DbHelperTransaction interface {
|
|
Commit() error
|
|
Rollback() error
|
|
RollbackOnError(err error) error
|
|
}
|
|
|
|
type DbHelper struct {
|
|
CTX context.Context
|
|
Queries Queries
|
|
}
|
|
|
|
type dbHelperTransactionImpl struct {
|
|
CTX context.Context
|
|
TXlessQueries Queries
|
|
TX pgx.Tx
|
|
TXQueries Queries
|
|
isCommited bool
|
|
}
|
|
|
|
func NewDbHelper(dbContext DbContext) DbHelper {
|
|
|
|
ctx := context.Background()
|
|
queries := New(dbContext)
|
|
|
|
return DbHelper{
|
|
CTX: ctx,
|
|
Queries: *queries,
|
|
}
|
|
}
|
|
|
|
func NewDbHelperTransaction(dbContext DbContext) (DbHelperTransaction, *dbHelperTransactionImpl, error) {
|
|
|
|
ctx := context.Background()
|
|
queries := New(dbContext)
|
|
tx, err := dbContext.BeginTx(ctx)
|
|
|
|
if err != nil {
|
|
return nil, nil, err
|
|
}
|
|
|
|
txQueries := queries.WithTx(tx)
|
|
|
|
obj := &dbHelperTransactionImpl{
|
|
CTX: ctx,
|
|
TXlessQueries: *queries,
|
|
TX: tx,
|
|
TXQueries: *txQueries,
|
|
}
|
|
|
|
return obj, obj, nil
|
|
}
|
|
|
|
// Commit implements DbHelperTransaction.
|
|
func (d *dbHelperTransactionImpl) Commit() error {
|
|
errCommit := d.TX.Commit(d.CTX)
|
|
|
|
if errCommit != nil {
|
|
d.isCommited = true
|
|
}
|
|
|
|
return errCommit
|
|
}
|
|
|
|
// Rollback implements DbHelperTransaction.
|
|
func (d *dbHelperTransactionImpl) Rollback() error {
|
|
if d.isCommited {
|
|
return nil
|
|
}
|
|
|
|
return d.TX.Rollback(d.CTX);
|
|
}
|
|
|
|
// RollbackOnError implements DbHelperTransaction.
|
|
func (d *dbHelperTransactionImpl) RollbackOnError(err error) error {
|
|
if d.isCommited || err == nil {
|
|
return d.Rollback()
|
|
}
|
|
return nil
|
|
}
|