Name

LIST-SQL-STREAMS — List the components of the broadcast streams used for recording SQL commands or results.Function

Syntax

      list-sql-streams &key type database => result

Arguments and Values

type

One of the following keyword symbols: :commands, :results or :both, defaulting to :commands.

database

A database object. This will default to *default-database*.

result

A list.

Description

Returns the list of component streams for the broadcast stream recording SQL commands sent to and/or results returned from database which defaults to *default-database*. type must be one of :commands, :results, or :both, defaulting to :commands, and determines whether the listed streams contain those recording SQL commands, results or both.

Examples

(list-sql-streams :type :both)
=> NIL
(start-sql-recording :type :both)
=> 
(list-sql-streams :type :both)
=> (#<Stream for descriptor 7> #<Stream for descriptor 7>)
      

Side Effects

None.

Affected by

add-sql-stream
delete-sql-stream

Exceptional Situations

An error is signalled if type is passed a value other than :commands, :results or :both.

See Also

sql-stream
add-sql-stream
delete-sql-stream

Notes

None.