Function SetLimit

pkg/transform/limit.go:30–42

SetLimit returns a Rule that sets (or replaces) the LIMIT clause of a SELECT statement. Any existing LIMIT value is overwritten. Parameters: - n: Number of rows to return; must be >= 0. Returns an error for negative values. Returns ErrUnsupportedStatement for non-SELECT statements.

(n int)

//
// Returns ErrUnsupportedStatement for non-SELECT statements.
func SetLimit(n int) Rule {
	return RuleFunc(func(stmt ast.Statement) error {
		if n < 0 {
			return fmt.Errorf("SetLimit: value must be non-negative, got %d", n)
		}
		sel, err := getSelect(stmt, "SetLimit")
		if err != nil {
			return err
		}
		sel.Limit = &n
		return nil
	})
}

// SetOffset returns a Rule that sets (or replaces) the OFFSET clause of a SELECT
// statement. Use together with SetLimit to implement pagination.