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

Values

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