Returns the results of mapping a function across a SQL query statement.
sql
map-query output-type-spec function query-exp &key database not-inside-transaction get-all => result
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. |
result |
A sequence of type output-type-spec containing the results of the map function. |
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.
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])
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