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. The output-type-spec argument 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 Special considerations for iteration functions and macros for details.

Example

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
prepare-statement
print-query
query
select
simple-do-query