Class Sql-Query-Node

Creates a result-set from the records returned by an SQL query.

Part of:

package cl-perec, class plan-node

Direct Superclass

plan-node

Slot

binder
Function that creates a list of bindings when called with the name of the input record.
Initargs::binder; Accessors:binder-of; Type:function.
columns
The list of RDBMS columns which will be queried or updated to get and set the data of this slot.
Initform:(compute-as* nil (compute-columns -self-)), Initargs::columns; Accessors:columns-of; Type:list.
distinctInitargs::distinct; Accessors:distinct-of.
group-by
List of slot values.
Initargs::group-by; Accessors:group-by-of; Type:list.
havingInitargs::having; Accessors:having-of; Type:list.
order-by
Format: (:ascending :descending ...)
Initargs::order-by; Accessors:order-by-of; Type:list.
queryInitargs::query; Accessors:query-of.
result-typeInitform:'list, Initargs::result-type; Accessors:result-type-of; Type:(member 'list 'scroll).
tablesInitargs::tables; Accessors:tables-of.
whereInitargs::where; Accessors:where-of.

Direct Method

%compile-planCompiles a PLAN to executable lisp code.