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.

result-type

The result sequence type.

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