<?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: Sqlite3Store</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">Sqlite3Store</td>
</tr>
<tr class="top-aligned-row">
<td><strong>In:</strong></td>
<td>
<a href="../files/lib/storage/sqlite3store_rb.html">
lib/storage/sqlite3store.rb
</a>
<br />
</td>
</tr>
<tr class="top-aligned-row">
<td><strong>Parent:</strong></td>
<td>
<a href="Store.html">
Store
</a>
</td>
</tr>
</table>
</div>
<!-- banner header -->
<div id="bodyContent">
<div id="contextContent">
<div id="diagram">
<map id="map" name="map">
<area shape="rect" coords="5,101,99,149" href="Sqlite3Store.html" alt="Sqlite3Store
" />
<area shape="rect" coords="16,5,88,53" href="Store.html" alt="Store
" />
</map>
<img src="../dot/f_48.png" usemap="#map" border="0" alt="dot/f_48.png">
</div>
<div id="description">
<p>
The <a href="SqliteStore.html">SqliteStore</a> class manages access to all
object storage.
</p>
<dl>
<dt><tt>db</tt></dt><dd>is a handle to the database.
</dd>
<dt><tt>dbtop</tt></dt><dd>stores the highest id used in the database.
</dd>
<dt><tt>cache</tt></dt><dd>is a handle to the cache
</dd>
</dl>
</div>
</div>
<div id="method-list">
<h3 class="section-bar">Methods</h3>
<div class="name-list">
<a href="#M000120">check</a>
<a href="#M000115">close</a>
<a href="#M000118">delete</a>
<a href="#M000124">each</a>
<a href="#M000119">get</a>
<a href="#M000116">inspect</a>
<a href="#M000122">makenoswap</a>
<a href="#M000123">makeswap</a>
<a href="#M000121">mark</a>
<a href="#M000113">new</a>
<a href="#M000117">put</a>
<a href="#M000114">save</a>
<a href="#M000125">stats</a>
</div>
</div>
</div>
<!-- if includes -->
<div id="section">
<!-- if method_list -->
<div id="methods">
<h3 class="section-bar">Public Class methods</h3>
<div id="method-M000113" class="method-detail">
<a name="M000113"></a>
<div class="method-heading">
<a href="#M000113" class="method-signature">
<span class="method-name">new</span><span class="method-args">(dbfile)</span>
</a>
</div>
<div class="method-description">
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000113-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000113-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 31</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">initialize</span>(<span class="ruby-identifier">dbfile</span>)
<span class="ruby-keyword kw">super</span>()
<span class="ruby-ivar">@dbfile</span> = <span class="ruby-node">"#{dbfile}.sqlite3"</span>
<span class="ruby-comment cmt"># check if database exists and build it if not</span>
<span class="ruby-identifier">build_database</span>
<span class="ruby-identifier">log</span>.<span class="ruby-identifier">info</span> <span class="ruby-value str">"Loading world..."</span>
<span class="ruby-comment cmt"># open database and sets @dbtop to highest object id</span>
<span class="ruby-ivar">@db</span> = <span class="ruby-constant">SQLite3</span><span class="ruby-operator">::</span><span class="ruby-constant">Database</span>.<span class="ruby-identifier">open</span>(<span class="ruby-ivar">@dbfile</span>)
<span class="ruby-ivar">@db</span>.<span class="ruby-identifier">cache_size</span> = <span class="ruby-value">1000</span>; <span class="ruby-comment cmt"># default is 2000 1.5K pages</span>
<span class="ruby-ivar">@db</span>.<span class="ruby-identifier">synchronous</span> = <span class="ruby-value">0</span>; <span class="ruby-comment cmt"># dangerous if OS crash, but fast</span>
<span class="ruby-ivar">@db</span>.<span class="ruby-identifier">type_translation</span> = <span class="ruby-keyword kw">true</span>;
<span class="ruby-ivar">@db</span>.<span class="ruby-identifier">execute</span>(<span class="ruby-value str">"select id from tmud;"</span>) <span class="ruby-keyword kw">do</span> <span class="ruby-operator">|</span><span class="ruby-identifier">i</span><span class="ruby-operator">|</span>
<span class="ruby-ivar">@dbtop</span> = <span class="ruby-identifier">i</span>.<span class="ruby-identifier">first</span> <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">i</span>.<span class="ruby-identifier">first</span> <span class="ruby-operator">></span> <span class="ruby-ivar">@dbtop</span>
<span class="ruby-keyword kw">end</span>
<span class="ruby-ivar">@cache</span> = <span class="ruby-constant">CacheManager</span>.<span class="ruby-identifier">new</span>(<span class="ruby-ivar">@db</span>)
<span class="ruby-identifier">log</span>.<span class="ruby-identifier">info</span> <span class="ruby-node">"Database '#{@dbfile}' loaded...highest id = #{@dbtop}."</span>
<span class="ruby-comment cmt"># log.debug @db.inspect</span>
<span class="ruby-keyword kw">rescue</span>
<span class="ruby-identifier">log</span>.<span class="ruby-identifier">fatal</span> <span class="ruby-identifier">$!</span>
<span class="ruby-identifier">raise</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<h3 class="section-bar">Public Instance methods</h3>
<div id="method-M000120" class="method-detail">
<a name="M000120"></a>
<div class="method-heading">
<a href="#M000120" class="method-signature">
<span class="method-name">check</span><span class="method-args">(oid)</span>
</a>
</div>
<div class="method-description">
<p>
Check if an object is in the database by its id.
</p>
<dl>
<dt><tt>oid</tt></dt><dd>is the id to use in the search.
</dd>
<dt><tt>return</tt></dt><dd>true or false
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000120-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000120-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 99</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">check</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-ivar">@db</span>.<span class="ruby-identifier">has_key?</span> <span class="ruby-identifier">oid</span>.<span class="ruby-identifier">to_s</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000115" class="method-detail">
<a name="M000115"></a>
<div class="method-heading">
<a href="#M000115" class="method-signature">
<span class="method-name">close</span><span class="method-args">()</span>
</a>
</div>
<div class="method-description">
<p>
Close the database
</p>
<dl>
<dt><tt>return</tt></dt><dd>Undefined.
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000115-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000115-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 64</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">close</span>
<span class="ruby-ivar">@db</span>.<span class="ruby-identifier">close</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000118" class="method-detail">
<a name="M000118"></a>
<div class="method-heading">
<a href="#M000118" class="method-signature">
<span class="method-name">delete</span><span class="method-args">(oid)</span>
</a>
</div>
<div class="method-description">
<p>
Deletes an object from the database.
</p>
<dl>
<dt><tt>oid</tt></dt><dd>is the id to to be deleted.
</dd>
<dt><tt>return</tt></dt><dd>Undefined.
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000118-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000118-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 85</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">delete</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">delete</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000124" class="method-detail">
<a name="M000124"></a>
<div class="method-heading">
<a href="#M000124" class="method-signature">
<span class="method-name">each</span><span class="method-args">() {|@cache.get(k)}| ...}</span>
</a>
</div>
<div class="method-description">
<p>
Iterate through all objects This needs to have all the possible keys first.
So we need to fetch them from the cache and from the database and and
produce a list of unique keys.
</p>
<dl>
<dt><tt>yield</tt></dt><dd>Each object in database to block of caller.
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000124-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000124-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 129</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">each</span>
<span class="ruby-identifier">kys</span> = <span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">keys</span>
<span class="ruby-ivar">@db</span>.<span class="ruby-identifier">execute</span>(<span class="ruby-value str">"select id from tmud;"</span>) <span class="ruby-keyword kw">do</span> <span class="ruby-operator">|</span><span class="ruby-identifier">k</span><span class="ruby-operator">|</span>
<span class="ruby-identifier">kys</span> <span class="ruby-operator"><<</span> <span class="ruby-identifier">k</span>.<span class="ruby-identifier">to_i</span>
<span class="ruby-keyword kw">end</span>
<span class="ruby-identifier">kys</span>.<span class="ruby-identifier">uniq!</span>
<span class="ruby-identifier">kys</span>.<span class="ruby-identifier">each</span> {<span class="ruby-operator">|</span><span class="ruby-identifier">k</span><span class="ruby-operator">|</span> <span class="ruby-keyword kw">yield</span> <span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">get</span>(<span class="ruby-identifier">k</span>)}
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000119" class="method-detail">
<a name="M000119"></a>
<div class="method-heading">
<a href="#M000119" class="method-signature">
<span class="method-name">get</span><span class="method-args">(oid)</span>
</a>
</div>
<div class="method-description">
<p>
Finds an object in the database by its id.
</p>
<dl>
<dt><tt>oid</tt></dt><dd>is the id to use in the search.
</dd>
<dt><tt>return</tt></dt><dd>Handle to the object or nil.
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000119-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000119-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 92</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">get</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">get</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000116" class="method-detail">
<a name="M000116"></a>
<div class="method-heading">
<a href="#M000116" class="method-signature">
<span class="method-name">inspect</span><span class="method-args">()</span>
</a>
</div>
<div class="method-description">
<p>
<a href="Sqlite3Store.html#M000116">inspect</a> the store cache (only for
caches)
</p>
<dl>
<dt><tt>return</tt></dt><dd>string
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000116-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000116-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 70</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">inspect</span>
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">inspect</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000122" class="method-detail">
<a name="M000122"></a>
<div class="method-heading">
<a href="#M000122" class="method-signature">
<span class="method-name">makenoswap</span><span class="method-args">(oid)</span>
</a>
</div>
<div class="method-description">
<p>
Marks an object nonswappable
</p>
<dl>
<dt><tt>oid</tt></dt><dd>is the object id
</dd>
<dt><tt>return</tt></dt><dd>undefined
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000122-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000122-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 113</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">makenoswap</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">makenoswap</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000123" class="method-detail">
<a name="M000123"></a>
<div class="method-heading">
<a href="#M000123" class="method-signature">
<span class="method-name">makeswap</span><span class="method-args">(oid)</span>
</a>
</div>
<div class="method-description">
<p>
Marks an object swappable
</p>
<dl>
<dt><tt>oid</tt></dt><dd>is the object id
</dd>
<dt><tt>return</tt></dt><dd>undefined
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000123-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000123-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 120</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">makeswap</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">makeswap</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000121" class="method-detail">
<a name="M000121"></a>
<div class="method-heading">
<a href="#M000121" class="method-signature">
<span class="method-name">mark</span><span class="method-args">(oid)</span>
</a>
</div>
<div class="method-description">
<p>
Marks an object dirty
</p>
<dl>
<dt><tt>oid</tt></dt><dd>is the id to use in the search.
</dd>
<dt><tt>return</tt></dt><dd>undefined
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000121-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000121-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 106</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">mark</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">mark</span>(<span class="ruby-identifier">oid</span>)
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000117" class="method-detail">
<a name="M000117"></a>
<div class="method-heading">
<a href="#M000117" class="method-signature">
<span class="method-name">put</span><span class="method-args">(obj)</span>
</a>
</div>
<div class="method-description">
<p>
Adds a <a href="Sqlite3Store.html#M000113">new</a> object to the database.
</p>
<dl>
<dt><tt>obj</tt></dt><dd>is a reference to object to be added
</dd>
<dt><tt>return</tt></dt><dd>Undefined.
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000117-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000117-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 77</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">put</span>(<span class="ruby-identifier">obj</span>)
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">put</span>(<span class="ruby-identifier">obj</span>)
<span class="ruby-identifier">obj</span> <span class="ruby-comment cmt"># return really should not be checked</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000114" class="method-detail">
<a name="M000114"></a>
<div class="method-heading">
<a href="#M000114" class="method-signature">
<span class="method-name">save</span><span class="method-args">()</span>
</a>
</div>
<div class="method-description">
<p>
Save the world
</p>
<dl>
<dt><tt>return</tt></dt><dd>Undefined.
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000114-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000114-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 58</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">save</span>
<span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">sync</span>
<span class="ruby-keyword kw">end</span>
</pre>
</div>
</div>
</div>
<div id="method-M000125" class="method-detail">
<a name="M000125"></a>
<div class="method-heading">
<a href="#M000125" class="method-signature">
<span class="method-name">stats</span><span class="method-args">()</span>
</a>
</div>
<div class="method-description">
<p>
produces a statistical report of the database
</p>
<dl>
<dt><tt>return</tt></dt><dd>a string containing the report
</dd>
</dl>
<p><a class="source-toggle" href="#"
onclick="toggleCode('M000125-source');return false;">[Source]</a></p>
<div class="method-source-code" id="M000125-source">
<pre>
<span class="ruby-comment cmt"># File lib/storage/sqlite3store.rb, line 140</span>
<span class="ruby-keyword kw">def</span> <span class="ruby-identifier">stats</span>
<span class="ruby-identifier">stats</span> = <span class="ruby-keyword kw">super</span>
<span class="ruby-identifier">stats</span> <span class="ruby-operator"><<</span> <span class="ruby-ivar">@cache</span>.<span class="ruby-identifier">stats</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>
