/usr/share/doc/python-apsw/html/blob.html is in python-apsw-doc 3.16.2-r1-2build2.
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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 | <!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>Blob Input/Output — APSW 3.16.2-r1 documentation</title>
<link rel="stylesheet" href="_static/classic.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: './',
VERSION: '3.16.2-r1',
COLLAPSE_INDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true
};
</script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/underscore.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<link rel="index" title="Index" href="genindex.html" />
<link rel="search" title="Search" href="search.html" />
<link rel="copyright" title="Copyright" href="copyright.html" />
<link rel="top" title="APSW 3.16.2-r1 documentation" href="index.html" />
<link rel="next" title="Backup" href="backup.html" />
<link rel="prev" title="Cursors (executing SQL)" href="cursor.html" />
<script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-26815066-1']);
_gaq.push(['_trackPageview']);
</script>
</head>
<body role="document">
<div class="related" role="navigation" aria-label="related navigation">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
accesskey="I">index</a></li>
<li class="right" >
<a href="py-modindex.html" title="Python Module Index"
>modules</a> |</li>
<li class="right" >
<a href="backup.html" title="Backup"
accesskey="N">next</a> |</li>
<li class="right" >
<a href="cursor.html" title="Cursors (executing SQL)"
accesskey="P">previous</a> |</li>
<li class="nav-item nav-item-0"><a href="index.html">APSW 3.16.2-r1 documentation</a> »</li>
</ul>
</div>
<div class="document">
<div class="documentwrapper">
<div class="bodywrapper">
<div class="body" role="main">
<div class="section" id="blob-input-output">
<span id="blobio"></span><h1>Blob Input/Output<a class="headerlink" href="#blob-input-output" title="Permalink to this headline">¶</a></h1>
<p>A <a class="reference external" href="http://en.wikipedia.org/wiki/Binary_large_object">blob</a> is a
SQLite <a class="reference external" href="https://sqlite.org/datatype3.html">datatype</a> representing
a sequence of bytes. It can be zero or more bytes in size.</p>
<p>SQLite blobs have an absolute maximum size of 2GB and a <a class="reference external" href="https://sqlite.org/c3ref/c_limit_attached.html">default
maximum size</a> of
1GB.</p>
<p>An alternate approach to using blobs is to store the data in files and
store the filename in the database. Doing so loses the <a class="reference external" href="https://sqlite.org/transactional.html">ACID</a> properties of SQLite.</p>
<div class="section" id="zeroblob-class">
<h2>zeroblob class<a class="headerlink" href="#zeroblob-class" title="Permalink to this headline">¶</a></h2>
<dl class="class">
<dt id="apsw.zeroblob">
<em class="property">class </em><code class="descname">zeroblob</code><span class="sig-paren">(</span><em>size</em><span class="sig-paren">)</span><a class="headerlink" href="#apsw.zeroblob" title="Permalink to this definition">¶</a></dt>
<dd><p>If you want to insert a blob into a row, you previously needed to
supply the entire blob in one go. To read just one byte also
required retrieving the blob in its entireity. For example to insert
a 100MB file you would have done:</p>
<div class="highlight-default"><div class="highlight"><pre><span class="n">largedata</span><span class="o">=</span><span class="nb">open</span><span class="p">(</span><span class="s">"largefile"</span><span class="p">,</span> <span class="s">"rb"</span><span class="p">)</span><span class="o">.</span><span class="n">read</span><span class="p">()</span>
<span class="n">cur</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s">"insert into foo values(?)"</span><span class="p">,</span> <span class="p">(</span><span class="n">buffer</span><span class="p">(</span><span class="n">largedata</span><span class="p">),))</span>
</pre></div>
</div>
<p>SQLite 3.5 allowed for incremental Blob I/O so you can read and
write blobs in small amounts. You cannot change the size of a blob
so you need to reserve space which you do through zeroblob which
creates a blob of the specified size but full of zero bytes. For
example you would reserve space for your 100MB one of these two
ways:</p>
<div class="highlight-default"><div class="highlight"><pre><span class="n">cur</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s">"insert into foo values(zeroblob(100000000))"</span><span class="p">)</span>
<span class="n">cur</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s">"insert into foo values(?),</span>
<span class="p">(</span><span class="n">apsw</span><span class="o">.</span><span class="n">zeroblob</span><span class="p">(</span><span class="mi">100000000</span><span class="p">),))</span>
</pre></div>
</div>
<p>This class is used for the second way. Once a blob exists in the
database, you then use the <a class="reference internal" href="#apsw.blob" title="apsw.blob"><code class="xref py py-class docutils literal"><span class="pre">blob</span></code></a> class to read and write its
contents.</p>
</dd></dl>
<dl class="method">
<dt id="apsw.zeroblob.length">
<code class="descclassname">zeroblob.</code><code class="descname">length</code><span class="sig-paren">(</span><span class="sig-paren">)</span> → int<a class="headerlink" href="#apsw.zeroblob.length" title="Permalink to this definition">¶</a></dt>
<dd><p>Size of zero blob in bytes.</p>
</dd></dl>
</div>
<div class="section" id="blob-class">
<h2>blob class<a class="headerlink" href="#blob-class" title="Permalink to this headline">¶</a></h2>
<dl class="class">
<dt id="apsw.blob">
<em class="property">class </em><code class="descname">blob</code><a class="headerlink" href="#apsw.blob" title="Permalink to this definition">¶</a></dt>
<dd><p>This object is created by <a class="reference internal" href="connection.html#apsw.Connection.blobopen" title="apsw.Connection.blobopen"><code class="xref py py-meth docutils literal"><span class="pre">Connection.blobopen()</span></code></a> and provides
access to a blob in the database. It behaves like a Python file.
At the C level it wraps a <a class="reference external" href="https://sqlite.org/c3ref/blob.html">sqlite3_blob</a>.</p>
<div class="admonition note">
<p class="first admonition-title">Note</p>
<p class="last">You cannot change the size of a blob using this object. You should
create it with the correct size in advance either by using
<a class="reference internal" href="#apsw.zeroblob" title="apsw.zeroblob"><code class="xref py py-class docutils literal"><span class="pre">zeroblob</span></code></a> or the <a class="reference external" href="https://sqlite.org/lang_corefunc.html">zeroblob()</a> function.</p>
</div>
<p>See the <a class="reference internal" href="example.html#example-blobio"><span class="std std-ref">example</span></a>.</p>
</dd></dl>
<dl class="method">
<dt id="apsw.blob.__enter__">
<code class="descclassname">blob.</code><code class="descname">__enter__</code><span class="sig-paren">(</span><span class="sig-paren">)</span> → context<a class="headerlink" href="#apsw.blob.__enter__" title="Permalink to this definition">¶</a></dt>
<dd><p>You can use a blob as a <a class="reference external" href="http://docs.python.org/reference/datamodel.html#with-statement-context-managers">context manager</a>
as defined in <span class="target" id="index-0"></span><a class="pep reference external" href="https://www.python.org/dev/peps/pep-0343"><strong>PEP 0343</strong></a>. When you use <em>with</em> statement,
the blob is always <code class="xref py py-meth docutils literal"><span class="pre">closed</span></code> on exit from the block, even if an
exception occurred in the block.</p>
<p>For example:</p>
<div class="highlight-default"><div class="highlight"><pre><span class="k">with</span> <span class="n">connection</span><span class="o">.</span><span class="n">blobopen</span><span class="p">()</span> <span class="k">as</span> <span class="n">blob</span><span class="p">:</span>
<span class="n">blob</span><span class="o">.</span><span class="n">write</span><span class="p">(</span><span class="s">"..."</span><span class="p">)</span>
<span class="n">res</span><span class="o">=</span><span class="n">blob</span><span class="o">.</span><span class="n">read</span><span class="p">(</span><span class="mi">1024</span><span class="p">)</span>
</pre></div>
</div>
</dd></dl>
<dl class="method">
<dt id="apsw.blob.__exit__">
<code class="descclassname">blob.</code><code class="descname">__exit__</code><span class="sig-paren">(</span><span class="sig-paren">)</span> → False<a class="headerlink" href="#apsw.blob.__exit__" title="Permalink to this definition">¶</a></dt>
<dd><p>Implements context manager in conjunction with
<a class="reference internal" href="#apsw.blob.__enter__" title="apsw.blob.__enter__"><code class="xref py py-meth docutils literal"><span class="pre">__enter__()</span></code></a>. Any exception that happened in the
<em>with</em> block is raised after closing the blob.</p>
</dd></dl>
<span class="target" id="index-1"></span><dl class="method">
<dt id="apsw.blob.close">
<code class="descclassname">blob.</code><code class="descname">close</code><span class="sig-paren">(</span><span class="optional">[</span><em>force=False</em><span class="optional">]</span><span class="sig-paren">)</span><a class="headerlink" href="#apsw.blob.close" title="Permalink to this definition">¶</a></dt>
<dd><p>Closes the blob. Note that even if an error occurs the blob is
still closed.</p>
<div class="admonition note">
<p class="first admonition-title">Note</p>
<p class="last">In some cases errors that technically occurred in the
<a class="reference internal" href="#apsw.blob.read" title="apsw.blob.read"><code class="xref py py-meth docutils literal"><span class="pre">read()</span></code></a> and <a class="reference internal" href="#apsw.blob.write" title="apsw.blob.write"><code class="xref py py-meth docutils literal"><span class="pre">write()</span></code></a> routines may not be
reported until close is called. Similarly errors that occurred
in those methods (eg calling <a class="reference internal" href="#apsw.blob.write" title="apsw.blob.write"><code class="xref py py-meth docutils literal"><span class="pre">write()</span></code></a> on a read-only
blob) may also be re-reported in <a class="reference internal" href="#apsw.blob.close" title="apsw.blob.close"><code class="xref py py-meth docutils literal"><span class="pre">close()</span></code></a>. (This
behaviour is what the underlying SQLite APIs do - it is not APSW
doing it.)</p>
</div>
<p>It is okay to call <a class="reference internal" href="#apsw.blob.close" title="apsw.blob.close"><code class="xref py py-meth docutils literal"><span class="pre">close()</span></code></a> multiple times.</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
<col class="field-body" />
<tbody valign="top">
<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><strong>force</strong> – Ignores any errors during close.</td>
</tr>
</tbody>
</table>
<p>Calls: <a class="reference external" href="https://sqlite.org/c3ref/blob_close.html">sqlite3_blob_close</a></p>
</dd></dl>
<span class="target" id="index-2"></span><dl class="method">
<dt id="apsw.blob.length">
<code class="descclassname">blob.</code><code class="descname">length</code><span class="sig-paren">(</span><span class="sig-paren">)</span> → int<a class="headerlink" href="#apsw.blob.length" title="Permalink to this definition">¶</a></dt>
<dd><p>Returns the size of the blob in bytes.</p>
<p>Calls: <a class="reference external" href="https://sqlite.org/c3ref/blob_bytes.html">sqlite3_blob_bytes</a></p>
</dd></dl>
<span class="target" id="index-3"></span><dl class="method">
<dt id="apsw.blob.read">
<code class="descclassname">blob.</code><code class="descname">read</code><span class="sig-paren">(</span><span class="optional">[</span><em>nbytes</em><span class="optional">]</span><span class="sig-paren">)</span> → bytes<a class="headerlink" href="#apsw.blob.read" title="Permalink to this definition">¶</a></dt>
<dd><p>Reads amount of data requested, or till end of file, whichever is
earlier. Attempting to read beyond the end of the blob returns the
empty string/bytes, in the same manner as end of file on normal file
objects.</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
<col class="field-body" />
<tbody valign="top">
<tr class="field-odd field"><th class="field-name">Return type:</th><td class="field-body">(Python 2) string (Python 3) bytes</td>
</tr>
</tbody>
</table>
<p>Calls: <a class="reference external" href="https://sqlite.org/c3ref/blob_read.html">sqlite3_blob_read</a></p>
</dd></dl>
<span class="target" id="index-4"></span><dl class="method">
<dt id="apsw.blob.readinto">
<code class="descclassname">blob.</code><code class="descname">readinto</code><span class="sig-paren">(</span><em>buffer</em><span class="optional">[</span>, <em>offset=0</em>, <em>length=remaining-buffer</em><span class="optional">]</span><span class="sig-paren">)</span> → None<a class="headerlink" href="#apsw.blob.readinto" title="Permalink to this definition">¶</a></dt>
<dd><p>Reads from the blob into a buffer you have supplied. This method is
useful if you already have a buffer like object that data is being
assembled in, and avoids allocating results in <a class="reference internal" href="#apsw.blob.read" title="apsw.blob.read"><code class="xref py py-meth docutils literal"><span class="pre">blob.read()</span></code></a> and
then copying into buffer.</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
<col class="field-body" />
<tbody valign="top">
<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first last simple">
<li><strong>buffer</strong> – A writable buffer like object. In Python 2.6 onwards
there is a bytearray type that is very useful.
<code class="xref py py-class docutils literal"><span class="pre">array.array</span></code> also works.</li>
<li><strong>offset</strong> – The position to start writing into the buffer
defaulting to the beginning.</li>
<li><strong>length</strong> – How much of the blob to read. The default is the
remaining space left in the buffer. Note that if
there is more space available than blob left then you
will get a <code class="xref py py-exc docutils literal"><span class="pre">ValueError</span></code> exception.</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>Calls: <a class="reference external" href="https://sqlite.org/c3ref/blob_read.html">sqlite3_blob_read</a></p>
</dd></dl>
<span class="target" id="index-5"></span><dl class="method">
<dt id="apsw.blob.reopen">
<code class="descclassname">blob.</code><code class="descname">reopen</code><span class="sig-paren">(</span><em>rowid</em><span class="sig-paren">)</span><a class="headerlink" href="#apsw.blob.reopen" title="Permalink to this definition">¶</a></dt>
<dd><p>Change this blob object to point to a different row. It can be
faster than closing an existing blob an opening a new one.</p>
<p>Calls: <a class="reference external" href="https://sqlite.org/c3ref/blob_reopen.html">sqlite3_blob_reopen</a></p>
</dd></dl>
<dl class="method">
<dt id="apsw.blob.seek">
<code class="descclassname">blob.</code><code class="descname">seek</code><span class="sig-paren">(</span><em>offset</em><span class="optional">[</span>, <em>whence=0</em><span class="optional">]</span><span class="sig-paren">)</span> → None<a class="headerlink" href="#apsw.blob.seek" title="Permalink to this definition">¶</a></dt>
<dd><p>Changes current position to <em>offset</em> biased by <em>whence</em>.</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
<col class="field-body" />
<tbody valign="top">
<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><ul class="first simple">
<li><strong>offset</strong> – New position to seek to. Can be positive or negative number.</li>
<li><strong>whence</strong> – Use 0 if <em>offset</em> is relative to the begining of the blob,
1 if <em>offset</em> is relative to the current position,
and 2 if <em>offset</em> is relative to the end of the blob.</li>
</ul>
</td>
</tr>
<tr class="field-even field"><th class="field-name">Raises:</th><td class="field-body"><p class="first last"><strong>ValueError</strong> – If the resulting offset is before the begining (less than zero) or beyond the end of the blob.</p>
</td>
</tr>
</tbody>
</table>
</dd></dl>
<dl class="method">
<dt id="apsw.blob.tell">
<code class="descclassname">blob.</code><code class="descname">tell</code><span class="sig-paren">(</span><span class="sig-paren">)</span> → int<a class="headerlink" href="#apsw.blob.tell" title="Permalink to this definition">¶</a></dt>
<dd><p>Returns the current offset.</p>
</dd></dl>
<span class="target" id="index-6"></span><dl class="method">
<dt id="apsw.blob.write">
<code class="descclassname">blob.</code><code class="descname">write</code><span class="sig-paren">(</span><em>data</em><span class="sig-paren">)</span> → None<a class="headerlink" href="#apsw.blob.write" title="Permalink to this definition">¶</a></dt>
<dd><p>Writes the data to the blob.</p>
<table class="docutils field-list" frame="void" rules="none">
<col class="field-name" />
<col class="field-body" />
<tbody valign="top">
<tr class="field-odd field"><th class="field-name">Parameters:</th><td class="field-body"><p class="first"><strong>data</strong> – (Python 2) buffer or string. (Python 3) buffer or bytes.</p>
</td>
</tr>
<tr class="field-even field"><th class="field-name">Raises:</th><td class="field-body"><ul class="first last simple">
<li><strong>TypeError</strong> – Wrong data type</li>
<li><strong>ValueError</strong> – If the data would go beyond the end of the blob.
You cannot increase the size of a blob by writing beyond the end.
You need to use <a class="reference internal" href="#apsw.zeroblob" title="apsw.zeroblob"><code class="xref py py-class docutils literal"><span class="pre">zeroblob</span></code></a> to set the desired size first when
inserting the blob.</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>Calls: <a class="reference external" href="https://sqlite.org/c3ref/blob_write.html">sqlite3_blob_write</a></p>
</dd></dl>
</div>
</div>
</div>
</div>
</div>
<div class="sphinxsidebar" role="navigation" aria-label="main navigation">
<div class="sphinxsidebarwrapper">
<h3><a href="index.html">Table Of Contents</a></h3>
<ul>
<li><a class="reference internal" href="#">Blob Input/Output</a><ul>
<li><a class="reference internal" href="#zeroblob-class">zeroblob class</a></li>
<li><a class="reference internal" href="#blob-class">blob class</a></li>
</ul>
</li>
</ul>
<h4>Previous topic</h4>
<p class="topless"><a href="cursor.html"
title="previous chapter">Cursors (executing SQL)</a></p>
<h4>Next topic</h4>
<p class="topless"><a href="backup.html"
title="next chapter">Backup</a></p>
<div role="note" aria-label="source link">
<h3>This Page</h3>
<ul class="this-page-menu">
<li><a href="_sources/blob.txt"
rel="nofollow">Show Source</a></li>
</ul>
</div>
<div id="searchbox" style="display: none" role="search">
<h3>Quick search</h3>
<form class="search" action="search.html" method="get">
<div><input type="text" name="q" /></div>
<div><input type="submit" value="Go" /></div>
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="related" role="navigation" aria-label="related navigation">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
>index</a></li>
<li class="right" >
<a href="py-modindex.html" title="Python Module Index"
>modules</a> |</li>
<li class="right" >
<a href="backup.html" title="Backup"
>next</a> |</li>
<li class="right" >
<a href="cursor.html" title="Cursors (executing SQL)"
>previous</a> |</li>
<li class="nav-item nav-item-0"><a href="index.html">APSW 3.16.2-r1 documentation</a> »</li>
</ul>
</div>
<div class="footer" role="contentinfo">
© <a href="copyright.html">Copyright</a> 2004-2016, Roger Binns <rogerb@rogerbinns.com>.
Last updated on Jan 14, 2017.
Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.4.8.
</div>
</body>
</html>
|