15.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

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

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

sql-recording-p

Function

sql-recording-p &key type
 database

Returns t if SQL command or result traffic is being recorded, otherwise returns nil .

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

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

add-sql-stream

Function

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

delete-sql-stream

Function

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