<?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>