<refentrytitle>DATABASE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Class</emphasis> <emphasis role="bold">DATABASE</emphasis></refname>
+ <refname>DATABASE</refname>
<refpurpose>The super-type of all &clsql; databases</refpurpose>
<refclass>Class</refclass>
</refnamediv>
<refentrytitle>*CONNECT-IF-EXISTS*</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Variable</emphasis> <emphasis role="bold">*CONNECT-IF-EXISTS*</emphasis></refname>
+ <refname>*CONNECT-IF-EXISTS*</refname>
<refpurpose>Default value for the
<parameter>if-exists</parameter> parameter of <link
linkend="connect"><function>connect</function></link>.</refpurpose>
<refsect1>
<title>Value Type</title>
<para>A valid argument to the <parameter>if-exists</parameter>
- parameter of <function>connect</function>, i.e. one of
+ parameter of <function>connect</function>, that is, one of
<simplelist type="inline">
<member><symbol>:new</symbol></member>
<member><symbol>:warn-new</symbol></member>
<refentrytitle>*DEFAULT-DATABASE*</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Variable</emphasis> <emphasis role="bold">*DEFAULT-DATABASE*</emphasis></refname>
+ <refname>*DEFAULT-DATABASE*</refname>
<refpurpose>The default database object to use.</refpurpose>
<refclass>Variable</refclass>
</refnamediv>
<refsect1>
<title>Value Type</title>
- <para>Any object of type <type>database</type>, or nil to
+ <para>Any object of type <type>database</type>, or &nil; to
indicate no default database.</para>
</refsect1>
<refsect1>
<title>Initial Value</title>
- <para><symbol>nil</symbol></para>
+ <para>&nil;</para>
</refsect1>
<refsect1>
<title>Description</title>
<symbol>*default-database*</symbol> to the first database
that remains in the list of active databases as returned by
<function>connected-databases</function>, or
- <symbol>nil</symbol> if no further active databases
+ &nil; if no further active databases
exist.</para>
<para>The user may change <symbol>*default-database*</symbol>
at any time to a valid value of his choice.</para>
<caution>
<para>If the value of <symbol>*default-database*</symbol> is
- <symbol>nil</symbol>, then all calls to &clsql; functions on
+ &nil;, then all calls to &clsql; functions on
databases must provide a suitable
<parameter>database</parameter> parameter, or an error will be
signalled.</para>
<refentrytitle>*DEFAULT-DATABASE-TYPE*</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Variable</emphasis> <emphasis role="bold">*DEFAULT-DATABASE-TYPE*</emphasis></refname>
+ <refname>*DEFAULT-DATABASE-TYPE*</refname>
<refpurpose>The default database type to use</refpurpose>
<refclass>Variable</refclass>
</refnamediv>
<refsect1>
<title>Value Type</title>
<para>Any keyword representing a valid database back-end of
- &clsql;, or <symbol>nil</symbol>.</para>
+ &clsql;, or &nil;.</para>
</refsect1>
<refsect1>
<title>Initial Value</title>
- <para><symbol>nil</symbol></para>
+ <para>&nil;</para>
</refsect1>
<refsect1>
<title>Description</title>
<function>connect</function> as the default value of the
<parameter>database-type</parameter> parameter.</para>
<caution>
- <para>If the value of this variable is <symbol>nil</symbol>,
+ <para>If the value of this variable is &nil;,
then all calls to
<function>initialize-database-type</function> or
<function>connect</function> will have to specify the
<refentrytitle>*INITIALIZED-DATABASE-TYPES*</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Variable</emphasis> <emphasis role="bold">*INITIALIZED-DATABASE-TYPES*</emphasis></refname>
+ <refname>*INITIALIZED-DATABASE-TYPES*</refname>
<refpurpose>List of all initialized database types</refpurpose>
<refclass>Variable</refclass>
</refnamediv>
</refsect1>
<refsect1>
<title>Initial Value</title>
- <para><symbol>nil</symbol></para>
+ <para>&nil;</para>
</refsect1>
<refsect1>
<title>Description</title>
<refentrytitle>CONNECT</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">CONNECT</emphasis></refname>
+ <refname>CONNECT</refname>
<refpurpose>create a connection to a database.</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<refsect1>
<title>Syntax</title>
- <title>Syntax</title>
- <synopsis><function>connect</function> <replaceable>connection-spec</replaceable> &key <replaceable>if-exists</replaceable> <replaceable>database-type</replaceable> <replaceable>pool</replaceable> <replaceable>make-default</replaceable> => <returnvalue>database</returnvalue></synopsis>
+ <synopsis><function>connect</function> <replaceable>connection-spec</replaceable> &key <replaceable>if-exists</replaceable> <replaceable>database-type</replaceable> <replaceable>pool</replaceable> <replaceable>make-default</replaceable> => <returnvalue>database</returnvalue></synopsis>
</refsect1>
<refsect1>
<title>Arguments and Values</title>
<listitem>
<para>A boolean flag. If &t;, acquire connection from a
pool of open connections. If the pool is empty, a new
- connection is created. The default is &nil;. This is a
- &clsql; extension.
+ connection is created. The default is &nil;.
</para>
</listitem>
</varlistentry>
<para>A boolean flag. If &t;,
<symbol>*default-database*</symbol> is set to the new
connection, otherwise <symbol>*default-database*</symbol>
- is not changed. The default is &t;. This is a &clsql;
- extension.
+ is not changed. The default is &t;.
</para>
</listitem>
</varlistentry>
</refsect1>
<refsect1>
<title>Notes</title>
- <para>None.</para>
+ <para>The <parameter>pool</parameter> and
+ <parameter>make-default</parameter> keyword arguments to
+ <function>connect</function> are &clsql; extensions.</para>
</refsect1>
</refentry>
<refentrytitle>CONNECTED-DATABASES</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">CONNECTED-DATABASES</emphasis></refname>
+ <refname>CONNECTED-DATABASES</refname>
<refpurpose>Return the list of active database objects.</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<refentrytitle>DATABASE-NAME</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Generic Function</emphasis> <emphasis role="bold">DATABASE-NAME</emphasis></refname>
+ <refname>DATABASE-NAME</refname>
<refpurpose>Get the name of a database object</refpurpose>
<refclass>Generic Function</refclass>
</refnamediv>
<refentrytitle>DATABASE-NAME-FROM-SPEC</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Generic Function</emphasis> <emphasis role="bold">DATABASE-NAME-FROM-SPEC</emphasis></refname>
+ <refname>DATABASE-NAME-FROM-SPEC</refname>
<refpurpose>Return the database name string corresponding to
the given connection specification.</refpurpose>
<refclass>Generic Function</refclass>
<refentrytitle>DATABASE-TYPE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Generic Function</emphasis> <emphasis role="bold">DATABASE-TYPE</emphasis></refname>
+ <refname>DATABASE-TYPE</refname>
<refpurpose>Get the type of a database object.</refpurpose>
<refclass>Generic Function</refclass>
</refnamediv>
<refentrytitle>DISCONNECT</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">DISCONNECT</emphasis></refname>
+ <refname>DISCONNECT</refname>
<refpurpose>close a database connection</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<term><parameter>error</parameter></term>
<listitem>
<para>A boolean flag indicating whether to signal an error
- if <parameter>database</parameter> is non-nil but cannot
+ if <parameter>database</parameter> is non-&nil; but cannot
be found.
</para>
</listitem>
returned by <function>connect</function>, and closes the
connection. If no matching database is found and
<parameter>error</parameter> and
- <parameter>database</parameter> are both non-nil an error is
- signaled, otherwise nil is returned. If the database is from a
+ <parameter>database</parameter> are both non-&nil; an error is
+ signaled, otherwise &nil; is returned. If the database is from a
pool it will be released to this pool.
</para>
<symbol>*default-database*</symbol>, then
<symbol>*default-database*</symbol> is set to the first
remaining database from
- <function>connected-databases</function> or to nil if no
+ <function>connected-databases</function> or to &nil; if no
further active database exists.</para>
</refsect1>
<refsect1>
<refentrytitle>DISCONNECT-POOLED</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">DISCONNECT-POOLED</emphasis></refname>
+ <refname>DISCONNECT-POOLED</refname>
<refpurpose>closes all pooled database connections</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<refentrytitle>FIND-DATABASE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">FIND-DATABASE</emphasis></refname>
+ <refname>FIND-DATABASE</refname>
<refpurpose>>Locate a database object through it's
name.</refpurpose>
<refclass>Function</refclass>
<term><parameter>db-type</parameter></term>
<listitem>
<para>
- A keyword symbol denoting a known database back-end. This
- is a &clsql; extension.
+ A keyword symbol denoting a known database back-end.
</para>
</listitem>
</varlistentry>
<term><returnvalue>result</returnvalue></term>
<listitem>
<para>Either a database object, or, if
- <parameter>errorp</parameter> is <symbol>nil</symbol>,
- possibly <symbol>nil</symbol>.</para>
+ <parameter>errorp</parameter> is &nil;,
+ possibly &nil;.</para>
</listitem>
</varlistentry>
</variablelist>
<parameter>database</parameter>. If it succeeds, it returns
the first database found.</para>
<para>
- If <parameter>db-type</parameter> is nil all databases
+ If <parameter>db-type</parameter> is &nil; all databases
matching the string <parameter>database</parameter> are
considered. If no matching databases are found and
- <parameter>errorp</parameter> is nil then nil is
- returned. If <parameter>errorp</parameter> is nil and one or
+ <parameter>errorp</parameter> is &nil; then &nil; is
+ returned. If <parameter>errorp</parameter> is &nil; and one or
more matching databases are found, then the most recently
connected database is returned as a first value and the
number of matching databases is returned as a second
</refsect1>
<refsect1>
<title>Notes</title>
- <para>None.</para>
+ <para>The <parameter>db-type</parameter> keyword argument to
+ <function>find-database</function> is a &clsql;
+ extension. </para>
</refsect1>
</refentry>
<refentrytitle>INITIALIZE-DATABASE-TYPE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">INITIALIZE-DATABASE-TYPE</emphasis></refname>
+ <refname>INITIALIZE-DATABASE-TYPE</refname>
<refpurpose>Initializes a database type</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<varlistentry>
<term><returnvalue>result</returnvalue></term>
<listitem>
- <para>Either <symbol>nil</symbol> if the initialization
+ <para>Either &nil; if the initialization
attempt fails, or <symbol>t</symbol> otherwise.</para>
</listitem>
</varlistentry>
<symbol>*initialized-database-types*</symbol>, if not
already present.</para>
<para>If initialization fails, the function returns
- <symbol>nil</symbol>, and/or signals an error of type
+ &nil;, and/or signals an error of type
<errortype>clsql-error</errortype>. The kind of action
taken depends on the back-end and the cause of the
problem.</para>
<refentrytitle>RECONNECT</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">RECONNECT</emphasis></refname>
+ <refname>RECONNECT</refname>
<refpurpose>Re-establishes the connection between a database object and its RDBMS.</refpurpose>
<refclass>Function</refclass>
</refnamediv>
database whose name matches <parameter>database</parameter> is
sought in the list of connected databases. If no matching
database is found and <parameter>error</parameter> and
- <parameter>database</parameter> are both non-nil an error is
- signaled, otherwise nil is returned.</para>
+ <parameter>database</parameter> are both non-&nil; an error is
+ signaled, otherwise &nil; is returned.</para>
<para> When the current database connection has been lost, if
- <parameter>force</parameter> is non-nil as it is by default, the
+ <parameter>force</parameter> is non-&nil; as it is by default, the
connection is closed and errors are suppressed. If
- <parameter>force</parameter> is nil and the database connection
+ <parameter>force</parameter> is &nil; and the database connection
cannot be closed, an error is signalled.
</para>
</refsect1>
<refentrytitle>STATUS</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">STATUS</emphasis></refname>
+ <refname>STATUS</refname>
<refpurpose>Print information about connected databases.</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<title>Description</title>
<para>Prints information about the currently connected databases
to <symbol>*STANDARD-OUTPUT*</symbol>. The argument
- <parameter>full</parameter> is nil by default and a value of t
+ <parameter>full</parameter> is &nil; by default and a value of t
means that more detailed information about each database is
printed.
</para>
localhost/test/petrov mysql nil
localhost/test/petrov postgresql nil
localhost/test/petrov postgresql-socket nil
- mysql-test/petrov odbc nil
+ test/petrov odbc nil
* :memory: sqlite nil
--------------------------------------------------------
<refentrytitle>CREATE-DATABASE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">CREATE-DATABASE</emphasis></refname>
+ <refname>CREATE-DATABASE</refname>
<refpurpose>create a database</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<refentrytitle>DESTROY-DATABASE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">DESTROY-DATABASE</emphasis></refname>
+ <refname>DESTROY-DATABASE</refname>
<refpurpose>destroys a database</refpurpose>
<refclass>Function</refclass>
</refnamediv>
=>
Error: While trying to access database localhost/test2/root
using database-type POSTGRESQL:
- Error database-destory failed: dropdb: database removal failed: ERROR: database "test2" does not exist
+ Error database-destroy failed: dropdb: database removal failed: ERROR: database "test2" does not exist
has occurred.
[condition type: CLSQL-ACCESS-ERROR]
</screen>
<refentrytitle>PROBE-DATABASE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">PROBE-DATABASE</emphasis></refname>
+ <refname>PROBE-DATABASE</refname>
<refpurpose>tests for existence of a database</refpurpose>
<refclass>Function</refclass>
</refnamediv>
<refentrytitle>LIST-DATABASES</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Function</emphasis> <emphasis role="bold">LIST-DATABASES</emphasis></refname>
+ <refname>LIST-DATABASES</refname>
<refpurpose>List databases matching the supplied connection spec
and database type.</refpurpose>
<refclass>Function</refclass>
<refentrytitle>WITH-DATABASE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Macro</emphasis> <emphasis role="bold">WITH-DATABASE</emphasis></refname>
+ <refname>WITH-DATABASE</refname>
<refpurpose>Execute a body of code with a variable bound to a
specified database object.</refpurpose>
<refclass>Macro</refclass>
<varlistentry>
<term><parameter>db-var</parameter></term>
<listitem>
- <para>A variable to which the specified database is bound.
+ <para>A variable which is bound to the specified database.
</para>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>connect-args</parameter></term>
<listitem>
- <para>Other optional arguments to <function>connect</function>.
+ <para>Other optional arguments to
+ <function>connect</function>. This macro use a value of
+ &nil; for <function>connect</function>'s
+ <replaceable>make-default</replaceable> key, This is in
+ contrast to to the connect function which has a default
+ value of &t; for <replaceable>make-default</replaceable>.
</para>
</listitem>
</varlistentry>
<refentrytitle>WITH-DEFAULT-DATABASE</refentrytitle>
</refmeta>
<refnamediv>
- <refname><emphasis>Macro</emphasis> <emphasis role="bold">WITH-DEFAULT-DATABASE</emphasis></refname>
+ <refname>WITH-DEFAULT-DATABASE</refname>
<refpurpose>Execute a body of code with <symbol>*default-database*</symbol> bound to a specified database.</refpurpose>
<refclass>Macro</refclass>
</refnamediv>
</refsect1>
<refsect1>
<title>Description</title>
- <para>Perform BODY with DATABASE bound as
- *default-database*.
+ <para>Perform <parameter>body</parameter> with
+ <parameter>DATABASE</parameter> bound as
+ <symbol>*default-database*</symbol>.
</para>
</refsect1>
<refsect1>