14 Common SQL

14.6 SQL I/O recording

It is sometimes convenient to simply monitor the flow of commands to, and results from, a database. A number of functions are provided for this purpose.

The functions operate on two stream collections (broadcast streams) -- one each for commands and results. They allow the recording to be started and stopped, checked, or recorded on further individual streams.

start-sql-recording

Function

start-sql-recording &key type database

: Starts recording SQL command or result traffic onto a broadcast stream. Initially the broadcast stream for commands or results is just*standard-output*. Returns no values.

stop-sql-recording

Function

stop-sql-recording &key type database

: Stops recording SQL command or result traffic. Returns no values.

sql-recording-p

Function

sql-recording-p &key type database

: Returnst if SQL command or result traffic is being recorded, otherwise returnsnil.

list-sql-streams

Function

list-sql-streams &key type database

: Returns the individual streams recording SQL command or result traffic, since there may be multiple streams wrapped up into a single broadcast stream.

sql-stream

Function

sql-stream &key type database

: Returns the broadcast stream used for recording SQL command or result traffic.

add-sql-stream

Function

add-sql-stream stream &key type database

: Adds a new stream to the broadcast stream for SQL command or result traffic. Returns the new stream.

delete-sql-stream

Function

delete-sql-stream stream &key type database

: Deletes a stream from the broadcast stream for SQL command or result traffic. Returns the deleted stream.