Package com.saxonica.functions.sql

Class SQLPreparedQueryFn

java.lang.Object

net.sf.saxon.functions.AbstractFunction

net.sf.saxon.functions.SystemFunction

com.saxonica.functions.sql.SQLPreparedQueryFn

All Implemented Interfaces:

Callable, Function, GroundedValue, Item, Sequence

public class SQLPreparedQueryFn
extends SystemFunction

This class implements the sql:prepared-query() extension function. Arguments:

1. The connection
2. A SQL select statement, typically containing "?" placeholders

The result is a function, with arity equal to the number of placeholders. When calling this function, the supplied arguments substitute for the placeholders in the query, and the result is a sequence of maps containing the rows selected by the query.

Constructor Summary

Constructors

Constructor	Description
SQLPreparedQueryFn()

Method Summary

Modifier and Type	Method	Description
Function	call(XPathContext context, Sequence[] arguments)	Invoke the function
static Expression	makePreparedQueryFunction(java.lang.String tableName, Expression predicate)
static boolean	makeWhereClause(Expression predicate, java.lang.StringBuilder sb, java.util.List<Expression> params)

Methods inherited from class net.sf.saxon.functions.SystemFunction

dependsOnContextItem, dynamicCall, equals, export, exportAdditionalArguments, exportAttributes, fixArguments, getArity, getCardinality, getCompilerName, getContextNode, getDescription, getDetails, getErrorCodeForTypeErrors, getFunctionItemType, getFunctionName, getIntegerBounds, getNetCost, getOperandRoles, getRequiredType, getResultItemType, getResultItemType, getRetainedStaticContext, getSpecialProperties, getStaticBaseUriString, getStreamerName, importAttributes, isTrustedResultType, makeCall, makeFunction, makeFunctionCall, makeOptimizedFunctionCall, resultIfEmpty, setArity, setDetails, setRetainedStaticContext, supplyTypeInformation, toShortString, toString, typeCheckCaller

Methods inherited from class net.sf.saxon.functions.AbstractFunction

atomize, deepEquals, effectiveBooleanValue, getAnnotations, getStringValue, getStringValueCS, isArray, isMap, makeNewContext, simplify, typeCheck

Methods inherited from class java.lang.Object

clone, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface net.sf.saxon.om.Function

getGenre

Methods inherited from interface net.sf.saxon.om.GroundedValue

asIterable, concatenate, containsNode, materialize

Methods inherited from interface net.sf.saxon.om.Item

getLength, head, isStreamed, itemAt, iterate, reduce, subsequence

Methods inherited from interface net.sf.saxon.om.Sequence

makeRepeatable

Constructor Detail

SQLPreparedQueryFn

public SQLPreparedQueryFn()

Method Detail

call

public Function call(XPathContext context,
                     Sequence[] arguments)
              throws XPathException

Description copied from interface: Function

Invoke the function

Parameters:

context - the XPath dynamic evaluation context

arguments - the actual arguments to be supplied

Returns:

the result of invoking the function

Throws:

XPathException - if a dynamic error occurs within the function

makePreparedQueryFunction

public static Expression makePreparedQueryFunction(java.lang.String tableName,
                                                   Expression predicate)

makeWhereClause

public static boolean makeWhereClause(Expression predicate,
                                      java.lang.StringBuilder sb,
                                      java.util.List<Expression> params)