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 &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 &key
type
database
Stops recording SQL command or result traffic. Returns no values.
sql-recording-p &key type database
Returns
t
if SQL command or result traffic is being recorded, otherwise returns
nil
.
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 &key
type
database
Returns the broadcast stream used for recording SQL command or result traffic.
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
stream
&key
type
database
Deletes a stream from the broadcast stream for SQL command or result traffic. Returns the deleted stream.