database

type Config struct {
	Driver             string        // Database driver name (e.g., "postgres", "mysql").
	ConnectionString   string        // Connection string for the database.
	MaxOpenConnections int           // Maximum number of open connections to the database.
	MaxIdleConnections int           // Maximum number of idle connections in the pool.
	ConnMaxLifetime    time.Duration // Maximum amount of time a connection may be reused.
	ConnMaxIdleTime    time.Duration // Maximum amount of time a connection may be idle.
}

type Querier interface {
	// ExecContext executes a query without returning any rows.
	ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)
	// QueryContext executes a query that returns rows, typically a SELECT.
	QueryContext(ctx context.Context, query string, args ...any) (*sql.Rows, error)
	// QueryRowContext executes a query that is expected to return at most one row.
	QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row
}

type TxManager interface {
	// WithTx executes the function within a database transaction.
	// If a transaction is already present in the context, it reuses it.
	WithTx(ctx context.Context, fn func(ctx context.Context) error) error
}