<?xml version="1.0" encoding="iso-8859-1"?>
<!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" xml:lang="en" lang="en">
<head>
<title>Class: SQLite3::Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />
<link rel="stylesheet" href="../.././rdoc-style.css" type="text/css" media="screen" />
<script type="text/javascript">
// <![CDATA[
function popupCode( url ) {
window.open(url, "Code", "resizable=yes,scrollbars=yes,toolbar=no,status=no,height=150,width=400")
}
function toggleCode( id ) {
if ( document.getElementById )
elem = document.getElementById( id );
else if ( document.all )
elem = eval( "document.all." + id );
else
return false;
elemStyle = elem.style;
if ( elemStyle.display != "block" ) {
elemStyle.display = "block"
} else {
elemStyle.display = "none"
}
return true;
}
// Make codeblocks hidden by default
document.writeln( "<style type=\"text/css\">div.method-source-code { display: none }</style>" )
// ]]>
</script>
</head>
<body>
<div id="classHeader">
<table class="header-table">
<tr class="top-aligned-row">
<td><strong>Class</strong></td>
<td class="class-name-in-header">SQLite3::Database</td>
</tr>
<tr class="top-aligned-row">
<td><strong>In:</strong></td>
<td>
<a href="../../files/lib/storage/sqlite3hash_rb.html">
lib/storage/sqlite3hash.rb
</a>
<br />
</td>
</tr>
<tr class="top-aligned-row">
<td><strong>Parent:</strong></td>
<td>
Object
</td>
</tr>
</table>
</div>
<!-- banner header -->
<div id="bodyContent">
<div id="contextContent">
<div id="diagram">
<map id="map" name="map">
<area shape="rect" coords="27,52,107,100" href="Database.html" alt="Database
" />
<area shape="rect" coords="16,16,141,111" href="../SQLite3.html" alt="SQLite3
" />
</map>
<img src="../../dot/f_47.png" usemap="#map" border="0" alt="dot/f_47.png">
</div>
</div>
<div id="method-list">
<h3 class="section-bar">Methods</h3>
<div class="name-list">
<a href="#M000317">[]</a>
<a href="#M000318">[]=</a>
<a href="#M000320">delete</a>
<a href="#M000319">has_key?</a>
</div>
</div>
</div>
<!-- if includes -->
<div id="section">
<!-- if method_list -->
<div id="methods">
<h3 class="section-bar">Public Instance methods</h3>
<div id="method-M000317" class="method-detail">
<a name="M000317"></a>
<div class="method-heading">
<a href="#M000317" class="method-signature">
<span class="method-name">[]</span><span class="method-args">(idx)</span>
</a>
</div>
<div class="method-description">
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000317-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000317-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3hash.rb, line 17</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-operator">[]</span>(<span class="ruby-identifier">idx</span>)
<span class="ruby-identifier">result</span> = <span class="ruby-identifier">execute</span>(<span class="ruby-value str">"select data from tmud where id = ?;"</span>, <span class="ruby-identifier">idx</span>.<span class="ruby-identifier">to_i</span>)
<span class="ruby-identifier">result</span>.<span class="ruby-identifier">first</span>.<span class="ruby-identifier">first</span> <span class="ruby-value">? </span><span class="ruby-identifier">result</span>.<span class="ruby-identifier">first</span>.<span class="ruby-identifier">first</span> <span class="ruby-operator">:</span> <span class="ruby-keyword kw">nil</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000318" class="method-detail">
<a name="M000318"></a>
<div class="method-heading">
<a href="#M000318" class="method-signature">
<span class="method-name">[]=</span><span class="method-args">(idx, data)</span>
</a>
</div>
<div class="method-description">
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000318-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000318-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3hash.rb, line 21</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-operator">[]=</span>(<span class="ruby-identifier">idx</span>, <span class="ruby-identifier">data</span>)
<span class="ruby-identifier">result</span> = <span class="ruby-identifier">execute</span>(<span class="ruby-value str">"insert into tmud values (?, ?);"</span>, <span class="ruby-identifier">idx</span>.<span class="ruby-identifier">to_i</span>, <span class="ruby-identifier">data</span>)
<span class="ruby-keyword kw">rescue</span> <span class="ruby-constant">Exception</span>
<span class="ruby-identifier">result</span> = <span class="ruby-identifier">execute</span>(<span class="ruby-value str">"update tmud set data = ? where id = ?;"</span>, <span class="ruby-identifier">data</span>, <span class="ruby-identifier">idx</span>.<span class="ruby-identifier">to_i</span>)
<span class="ruby-keyword kw">ensure</span>
<span class="ruby-identifier">data</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000320" class="method-detail">
<a name="M000320"></a>
<div class="method-heading">
<a href="#M000320" class="method-signature">
<span class="method-name">delete</span><span class="method-args">(idx)</span>
</a>
</div>
<div class="method-description">
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000320-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000320-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3hash.rb, line 32</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">delete</span>(<span class="ruby-identifier">idx</span>)
<span class="ruby-identifier">result</span> = <span class="ruby-identifier">execute</span>(<span class="ruby-value str">"delete from tmud where id = ?;"</span>, <span class="ruby-identifier">idx</span>.<span class="ruby-identifier">to_i</span>)
<span class="ruby-keyword kw">rescue</span> <span class="ruby-constant">Exception</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000319" class="method-detail">
<a name="M000319"></a>
<div class="method-heading">
<a href="#M000319" class="method-signature">
<span class="method-name">has_key?</span><span class="method-args">(idx)</span>
</a>
</div>
<div class="method-description">
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000319-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000319-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3hash.rb, line 28</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">has_key?</span>(<span class="ruby-identifier">idx</span>)
<span class="ruby-identifier">result</span> = <span class="ruby-identifier">execute</span>(<span class="ruby-value str">"select data from tmud where id = ?;"</span>, <span class="ruby-identifier">idx</span>.<span class="ruby-identifier">to_i</span>)
<span class="ruby-identifier">result</span>.<span class="ruby-identifier">first</span>.<span class="ruby-identifier">first</span> <span class="ruby-value">? </span><span class="ruby-keyword kw">true</span> <span class="ruby-operator">:</span> <span class="ruby-keyword kw">false</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
</div>
</div>
<div id="validator-badges">
<p><small><a href="http://validator.w3.org/check/referer">[Validate]</a></small></p>
</div>
</body>
</html>
