/usr/share/doc/cl-sql/html/with-database.html is in cl-sql 6.5.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>WITH-DATABASE</title><meta name="generator" content="DocBook XSL Stylesheets V1.78.1" /><link rel="home" href="index.html" title="CLSQL Users' Guide" /><link rel="up" href="ref-connect.html" title="Connection and Initialisation" /><link rel="prev" href="list-databases.html" title="LIST-DATABASES" /><link rel="next" href="with-default-database.html" title="WITH-DEFAULT-DATABASE" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">WITH-DATABASE</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="list-databases.html">Prev</a> </td><th width="60%" align="center">Connection and Initialisation</th><td width="20%" align="right"> <a accesskey="n" href="with-default-database.html">Next</a></td></tr></table><hr /></div><div class="refentry"><a id="with-database"></a><div class="titlepage"></div><div class="refnamediv"><h2>Name</h2><p>WITH-DATABASE — Execute a body of code with a variable bound to a
specified database object.<strong>Macro</strong></p></div><div class="refsect1"><a id="idp61899408"></a><h2>Syntax</h2><pre class="synopsis">
<code class="function">with-database</code> <em class="replaceable"><code>db-var</code></em> <em class="replaceable"><code>connection-spec</code></em> &rest <em class="replaceable"><code>connect-args</code></em> &body <em class="replaceable"><code>body</code></em> => <span class="returnvalue">result</span></pre></div><div class="refsect1"><a id="idp61903216"></a><h2>Arguments and Values</h2><div class="variablelist"><dl class="variablelist"><dt><span class="term"><em class="parameter"><code>db-var</code></em></span></dt><dd><p>A variable which is bound to the specified database.
</p></dd><dt><span class="term"><em class="parameter"><code>connection-spec</code></em></span></dt><dd><p>A vendor specific connection specification supplied
as a list or as a string.</p></dd><dt><span class="term"><em class="parameter"><code>connect-args</code></em></span></dt><dd><p>Other optional arguments to
<code class="function">connect</code>. This macro use a value of
<code class="constant">NIL</code> for <code class="function">connect</code>'s
<em class="replaceable"><code>make-default</code></em> key, This is in
contrast to to the connect function which has a default
value of <code class="constant">T</code> for <em class="replaceable"><code>make-default</code></em>.
</p></dd><dt><span class="term"><em class="parameter"><code>body</code></em></span></dt><dd><p>A Lisp code body.
</p></dd><dt><span class="term"><em class="parameter"><code>result</code></em></span></dt><dd><p>Determined by the result of executing the last
expression in <em class="parameter"><code>body</code></em>.
</p></dd></dl></div></div><div class="refsect1"><a id="idp61917712"></a><h2>Description</h2><p>Evaluate <em class="parameter"><code>body</code></em> in an environment,
where <em class="parameter"><code>db-var</code></em> is bound to the database
connection given by <em class="parameter"><code>connection-spec</code></em> and
<em class="parameter"><code>connect-args</code></em>. The connection is
automatically closed or released to the pool on exit from the
body.
</p></div><div class="refsect1"><a id="idp61921488"></a><h2>Examples</h2><pre class="screen">
(connected-databases)
=> NIL
(with-database (db '(":memory:") :database-type :sqlite
:make-default nil)
(database-name db))
=> ":memory:"
(connected-databases)
=> NIL
</pre></div><div class="refsect1"><a id="idp61923088"></a><h2>Side Effects</h2><p>
See <code class="function">connect</code> and <code class="function">disconnect</code>.
</p></div><div class="refsect1"><a id="idp61925488"></a><h2>Affected by</h2><p>
See <code class="function">connect</code> and <code class="function">disconnect</code>.
</p></div><div class="refsect1"><a id="idp61927888"></a><h2>Exceptional Situations</h2><p>
See <code class="function">connect</code> and <code class="function">disconnect</code>.
</p></div><div class="refsect1"><a id="idp61930288"></a><h2>See Also</h2><p>
</p><table border="0" summary="Simple list" class="simplelist"><tr><td><a class="link" href="connect.html" title="CONNECT"><code class="function">connect</code></a></td></tr><tr><td><a class="link" href="disconnect.html" title="DISCONNECT"><code class="function">disconnect</code></a></td></tr><tr><td><a class="link" href="disconnect-pooled.html" title="DISCONNECT-POOLED"><code class="function">disconnect-pooled</code></a></td></tr><tr><td><a class="link" href="with-default-database.html" title="WITH-DEFAULT-DATABASE"><code class="function">with-default-database</code></a></td></tr></table><p>
</p></div><div class="refsect1"><a id="idp61936544"></a><h2>Notes</h2><p>
<code class="function">with-database</code> is a <span class="application"><span class="emphasis"><em>CLSQL</em></span></span> extension.
</p></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="list-databases.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="ref-connect.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="with-default-database.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">LIST-DATABASES </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> WITH-DEFAULT-DATABASE</td></tr></table></div></body></html>
|