All Manuals > LispWorks® User Guide and Reference Manual > 45 The SQL Package

map-query Function

Summary

Returns the results of mapping a function across a SQL query statement.

Package

sql

Signature

map-query output-type-spec function query-exp &key database not-inside-transaction get-all => result

Arguments
output-type-spec
The output type specification.
function
A function.
query-exp
A SQL query or a prepared-statement containing a query.
database
A database.
not-inside-transaction
A generalized boolean.
get-all
A generalized boolean.
Values
result
A sequence of type output-type-spec containing the results of the map function.
Description

The function map-query returns the result of mapping function across the results of query-exp. output-type-spec specifies the type of the result sequence as per the Common Lisp map function.

The default value of database is *default-database*.

not-inside-transaction and get-all may be useful when fetching many records through a connection with database-type :mysql. Both of these arguments have default value nil. See the section 23.9.6 Special considerations for iteration functions and macros for details.

Examples

This example binds name to each name in the employee table and prints it.

(map-query
   nil
   #'(lambda (name) (print name))
   [select [ename] :from [emp] :flatp t])
See also

do-query
Loop Extensions in Common SQL
prepare-statement
print-query
query
select
simple-do-query


LispWorks® User Guide and Reference Manual - 01 Dec 2021 19:30:56