db

type SQLClient interface {
	// Begin starts a new transaction.
	Begin(ctx context.Context) (Transaction, error)
	// Exec executes a standard query without returning any rows.
	Exec(ctx context.Context, stmt string, args ...any) (sql.Result, error)
	// Query executes a standard query, returning resulting rows.
	Query(ctx context.Context, stmt string, args ...any) (*sql.Rows, error)
}

type Transaction interface {
	// Exec executes a standard query without returning any rows.
	Exec(ctx context.Context, stmt string, args ...any) (sql.Result, error)
	// Query executes a standard query, returning resulting rows.
	Query(ctx context.Context, stmt string, args ...any) (*sql.Rows, error)
	// Commit commits the transaction.
	Commit() error
	// Rollback rolls the transaction back.
	Rollback() error
}