← Back to branch summary

~gary/python-openid/python-openid-2.2.1-patched

« back to all changes in this revision

Viewing changes to doc/openid.store.sqlstore.SQLiteStore-class.html

  • Committer: Launchpad Patch Queue Manager
  • Date: 2007-11-30 02:46:28 UTC
  • mfrom: (1.1.1 pyopenid-2.0)
  • Revision ID: launchpad@pqm.canonical.com-20071130024628-qktwsew3383iawmq
[rs=SteveA] upgrade to python-openid-2.0.1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/openid.store.sqlstore.SQLiteStore-class.html
1
 
<?xml version="1.0" encoding="ascii"?>
 
1
<?xml version="1.0" encoding="iso-8859-1"?>
2
2
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
3
3
          "DTD/xhtml1-transitional.dtd">
4
4
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
5
5
<head>
6
6
  <title>openid.store.sqlstore.SQLiteStore</title>
7
 
  <link rel="stylesheet" href="epydoc.css" type="text/css" />
8
 
  <script type="text/javascript" src="epydoc.js"></script>
 
7
  <link rel="stylesheet" href="epydoc.css" type="text/css"></link>
9
8
</head>
10
 
 
11
9
<body bgcolor="white" text="black" link="blue" vlink="#204080"
12
10
      alink="#204080">
13
 
<!-- ==================== NAVIGATION BAR ==================== -->
14
 
<table class="navbar" border="0" width="100%" cellpadding="0"
15
 
       bgcolor="#a0c0ff" cellspacing="0">
16
 
  <tr valign="middle">
17
 
  <!-- Home link -->
18
 
      <th>&nbsp;&nbsp;&nbsp;<a
19
 
        href="openid-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>
20
 
 
21
 
  <!-- Tree link -->
22
 
      <th>&nbsp;&nbsp;&nbsp;<a
23
 
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>
24
 
 
25
 
  <!-- Index link -->
26
 
      <th>&nbsp;&nbsp;&nbsp;<a
27
 
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>
28
 
 
29
 
  <!-- Help link -->
30
 
      <th>&nbsp;&nbsp;&nbsp;<a
31
 
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>
32
 
 
33
 
  <!-- Project homepage -->
34
 
      <th class="navbar" align="right" width="100%">
35
 
        <table border="0" cellpadding="0" cellspacing="0">
36
 
          <tr><th class="navbar" align="center"
37
 
            ><a class="navbar" target="_top" href="http://www.openidenabled.com/">Python-OpenID</a></th>
38
 
          </tr></table></th>
 
11
 
 
12
<!-- =========== START OF NAVBAR =========== -->
 
13
<table class="navbar" border="0" width="100%" cellpadding="0" bgcolor="#a0c0ff" cellspacing="0">
 
14
  <tr valign="center">
 
15
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="openid-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>
 
16
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="trees.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>
 
17
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="indices.html">Index</a>&nbsp;&nbsp;&nbsp;</th>
 
18
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>
 
19
    <th class="navbar" align="right" width="100%">
 
20
      <table border="0" cellpadding="0" cellspacing="0">
 
21
      <tr><th class="navbar" align="center">
 
22
        <p class="nomargin">
 
23
          <a class="navbar" target="_top" href="http://www.openidenabled.com/">Python-OpenID</a>
 
24
      </p></th></tr></table>
 
25
    </th>
39
26
  </tr>
40
27
</table>
41
28
<table width="100%" cellpadding="0" cellspacing="0">
42
29
  <tr valign="top">
43
30
    <td width="100%">
44
 
      <span class="breadcrumbs">
 
31
      <font size="-1"><b class="breadcrumbs">
45
32
        <a href="openid-module.html">Package&nbsp;openid</a> ::
46
33
        <a href="openid.store-module.html">Package&nbsp;store</a> ::
47
34
        <a href="openid.store.sqlstore-module.html">Module&nbsp;sqlstore</a> ::
48
35
        Class&nbsp;SQLiteStore
49
 
      </span>
50
 
    </td>
51
 
    <td>
52
 
      <table cellpadding="0" cellspacing="0">
53
 
        <!-- hide/show private -->
54
 
        <tr><td align="right"><span class="options"
55
 
            >[<a href="frames.html" target="_top">frames</a
56
 
            >]&nbsp;|&nbsp;<a href="openid.store.sqlstore.SQLiteStore-class.html"
57
 
            target="_top">no&nbsp;frames</a>]</span></td></tr>
58
 
      </table>
59
 
    </td>
60
 
  </tr>
61
 
</table>
62
 
<!-- ==================== CLASS DESCRIPTION ==================== -->
63
 
<h1 class="epydoc">Class SQLiteStore</h1><span class="codelink"><a href="openid.store.sqlstore-pysrc.html#SQLiteStore">source&nbsp;code</a></span><br /><br />
 
36
      </b></font></br>
 
37
    </td>
 
38
    <td><table cellpadding="0" cellspacing="0">
 
39
      <tr><td align="right"><font size="-2">[<a href="frames.html"target="_top">frames</a>&nbsp;|&nbsp;<a href="openid.store.sqlstore.SQLiteStore-class.html" target="_top">no&nbsp;frames</a>]</font></td></tr>
 
40
    </table></td>
 
41
</tr></table>
 
42
 
 
43
<!-- =========== START OF CLASS DESCRIPTION =========== -->
 
44
<h2 class="class">Type SQLiteStore</h2>
 
45
 
64
46
<pre class="base-tree">
65
 
           object --+        
66
 
                    |        
67
 
<a href="openid.store.interface.OpenIDStore-class.html">interface.OpenIDStore</a> --+    
68
 
                        |    
69
 
                 <a href="openid.store.sqlstore.SQLStore-class.html">SQLStore</a> --+
70
 
                            |
71
 
                           <strong class="uidshort">SQLiteStore</strong>
72
 
</pre>
73
 
 
74
 
<hr />
 
47
 <a href="__builtin__.object-class.html"><code>object</code></a> --+        
 
48
          |        
 
49
<a href="openid.store.interface.OpenIDStore-class.html"><code>OpenIDStore</code></a> --+    
 
50
              |    
 
51
       <a href="openid.store.sqlstore.SQLStore-class.html"><code>SQLStore</code></a> --+
 
52
                  |
 
53
                 <b>SQLiteStore</b>
 
54
</pre><br />
 
55
 
 
56
<hr/>
 
57
 
75
58
<p>This is an SQLite-based specialization of <code><a 
76
 
  href="openid.store.sqlstore.SQLStore-class.html" 
77
 
  class="link">SQLStore</a></code>.</p>
78
 
  <p>To create an instance, see <code><a 
79
 
  href="openid.store.sqlstore.SQLStore-class.html#__init__" 
80
 
  class="link">SQLStore.__init__</a></code>.  To create the tables it will 
81
 
  use, see <code><a 
82
 
  href="openid.store.sqlstore.SQLStore-class.html#createTables" 
83
 
  class="link">SQLStore.createTables</a></code>.</p>
84
 
  All other methods are implementation details.<br /><br />
85
 
 
86
 
<!-- ==================== INSTANCE METHODS ==================== -->
87
 
<a name="section-InstanceMethods"></a>
88
 
<table class="summary" border="1" cellpadding="3"
89
 
       cellspacing="0" width="100%" bgcolor="white">
90
 
<tr bgcolor="#70b0f0" class="table-header">
91
 
  <td colspan="2" class="table-header">
92
 
    <table border="0" cellpadding="0" cellspacing="0" width="100%">
93
 
      <tr valign="top">
94
 
        <td align="left"><span class="table-header">Instance Methods</span></td>
95
 
        <td align="right" valign="top"
96
 
         ><span class="options">[<a href="#section-InstanceMethods"
97
 
         class="privatelink" onclick="toggle_private();"
98
 
         >hide private</a>]</span></td>
99
 
      </tr>
100
 
    </table>
101
 
  </td>
102
 
</tr>
103
 
<tr>
104
 
  <td width="15%" align="right" valign="top" class="summary">
105
 
    <span class="summary-type">&nbsp;</span>
106
 
  </td><td class="summary">
107
 
    <span class="summary-sig"><a href="openid.store.sqlstore.SQLiteStore-class.html#blobDecode" class="summary-sig-name">blobDecode</a>(<span class="summary-sig-arg">self</span>,
108
 
        <span class="summary-sig-arg">buf</span>)</span><br />
109
 
      Convert a blob as returned by the SQL engine into a str 
110
 
      object.
111
 
  </td>
112
 
</tr>
113
 
<tr>
114
 
  <td width="15%" align="right" valign="top" class="summary">
115
 
    <span class="summary-type">&nbsp;</span>
116
 
  </td><td class="summary">
117
 
    <span class="summary-sig"><a href="openid.store.sqlstore.SQLiteStore-class.html#blobEncode" class="summary-sig-name">blobEncode</a>(<span class="summary-sig-arg">self</span>,
118
 
        <span class="summary-sig-arg">s</span>)</span><br />
119
 
      Convert a str object into the necessary object for storing in the 
120
 
      database as a blob.
121
 
  </td>
122
 
</tr>
123
 
  <tr>
124
 
    <td colspan="2" class="summary">
125
 
    <p class="indent-wrapped-lines"><b>Inherited from <code><a href="openid.store.sqlstore.SQLStore-class.html">SQLStore</a></code></b>:
126
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#__getattr__">__getattr__</a></code>,
127
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#__init__">__init__</a></code>,
128
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#createTables">createTables</a></code>,
129
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#getAssociation">getAssociation</a></code>,
130
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#getAuthKey">getAuthKey</a></code>,
131
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#removeAssociation">removeAssociation</a></code>,
132
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#storeAssociation">storeAssociation</a></code>,
133
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#storeNonce">storeNonce</a></code>,
134
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#txn_createTables">txn_createTables</a></code>,
135
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#txn_getAssociation">txn_getAssociation</a></code>,
136
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#txn_getAuthKey">txn_getAuthKey</a></code>,
137
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#txn_removeAssociation">txn_removeAssociation</a></code>,
138
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#txn_storeAssociation">txn_storeAssociation</a></code>,
139
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#txn_storeNonce">txn_storeNonce</a></code>,
140
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#txn_useNonce">txn_useNonce</a></code>,
141
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#useNonce">useNonce</a></code>
142
 
      </p>
143
 
    <p class="indent-wrapped-lines"><b>Inherited from <code><a href="openid.store.interface.OpenIDStore-class.html">interface.OpenIDStore</a></code></b>:
144
 
      <code><a href="openid.store.interface.OpenIDStore-class.html#isDumb">isDumb</a></code>
145
 
      </p>
146
 
    <p class="indent-wrapped-lines"><b>Inherited from <code>object</code></b>:
147
 
      <code>__delattr__</code>,
148
 
      <code>__getattribute__</code>,
149
 
      <code>__hash__</code>,
150
 
      <code>__new__</code>,
151
 
      <code>__reduce__</code>,
152
 
      <code>__reduce_ex__</code>,
153
 
      <code>__repr__</code>,
154
 
      <code>__setattr__</code>,
155
 
      <code>__str__</code>
156
 
      </p>
157
 
    </td>
158
 
  </tr>
159
 
</table>
160
 
 
161
 
<br />
162
 
<!-- ==================== CLASS VARIABLES ==================== -->
163
 
<a name="section-ClassVariables"></a>
164
 
<table class="summary" border="1" cellpadding="3"
165
 
       cellspacing="0" width="100%" bgcolor="white">
166
 
<tr bgcolor="#70b0f0" class="table-header">
167
 
  <td colspan="2" class="table-header">
168
 
    <table border="0" cellpadding="0" cellspacing="0" width="100%">
169
 
      <tr valign="top">
170
 
        <td align="left"><span class="table-header">Class Variables</span></td>
171
 
        <td align="right" valign="top"
172
 
         ><span class="options">[<a href="#section-ClassVariables"
173
 
         class="privatelink" onclick="toggle_private();"
174
 
         >hide private</a>]</span></td>
175
 
      </tr>
176
 
    </table>
177
 
  </td>
178
 
</tr>
179
 
<tr>
180
 
  <td width="15%" align="right" valign="top" class="summary">
181
 
    <span class="summary-type">&nbsp;</span>
182
 
  </td><td class="summary">
183
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#create_nonce_sql">create_nonce_sql</a> = <code title="'\n    CREATE TABLE %(nonces)s\n    (\n        nonce CHAR(8) UNIQUE PRIMARY KEY,\n        expires INTEGER\n    );\n    '">'\n CREATE TABLE %(nonces)s\n (\n nonce CHAR(8) UNIQ...</code>
184
 
  </td>
185
 
</tr>
186
 
<tr>
187
 
  <td width="15%" align="right" valign="top" class="summary">
188
 
    <span class="summary-type">&nbsp;</span>
189
 
  </td><td class="summary">
190
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#create_assoc_sql">create_assoc_sql</a> = <code title="'\n    CREATE TABLE %(associations)s\n    (\n        server_url VARCHAR(2047),\n        handle VARCHAR(255),\n        secret BLOB(128),\n        issued INTEGER,\n        lifetime INTEGER,\n        assoc_type VARCHAR(64),\n        PRIMARY KEY (server_url, handle)\n    );\n    '">'\n CREATE TABLE %(associations)s\n (\n server_url V...</code>
191
 
  </td>
192
 
</tr>
193
 
<tr>
194
 
  <td width="15%" align="right" valign="top" class="summary">
195
 
    <span class="summary-type">&nbsp;</span>
196
 
  </td><td class="summary">
197
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#create_settings_sql">create_settings_sql</a> = <code title="'\n    CREATE TABLE %(settings)s\n    (\n        setting VARCHAR(128) UNIQUE PRIMARY KEY,\n        value BLOB(20)\n    );\n    '">'\n CREATE TABLE %(settings)s\n (\n setting VARCHAR(...</code>
198
 
  </td>
199
 
</tr>
200
 
<tr>
201
 
  <td width="15%" align="right" valign="top" class="summary">
202
 
    <span class="summary-type">&nbsp;</span>
203
 
  </td><td class="summary">
204
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#create_auth_sql">create_auth_sql</a> = <code title="'INSERT INTO %(settings)s VALUES (&quot;auth_key&quot;, ?);'">'INSERT INTO %(settings)s VALUES (&quot;auth_key&quot;, ?);'</code>
205
 
  </td>
206
 
</tr>
207
 
<tr>
208
 
  <td width="15%" align="right" valign="top" class="summary">
209
 
    <span class="summary-type">&nbsp;</span>
210
 
  </td><td class="summary">
211
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#get_auth_sql">get_auth_sql</a> = <code title="'SELECT value FROM %(settings)s WHERE setting = &quot;auth_key&quot;;'">'SELECT value FROM %(settings)s WHERE setting = &quot;aut...</code>
212
 
  </td>
213
 
</tr>
214
 
<tr>
215
 
  <td width="15%" align="right" valign="top" class="summary">
216
 
    <span class="summary-type">&nbsp;</span>
217
 
  </td><td class="summary">
218
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#set_assoc_sql">set_assoc_sql</a> = <code title="'INSERT OR REPLACE INTO %(associations)s VALUES (?, ?, ?, ?, ?, ?);'">'INSERT OR REPLACE INTO %(associations)s VALUES (?, ...</code>
219
 
  </td>
220
 
</tr>
221
 
<tr>
222
 
  <td width="15%" align="right" valign="top" class="summary">
223
 
    <span class="summary-type">&nbsp;</span>
224
 
  </td><td class="summary">
225
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#get_assocs_sql">get_assocs_sql</a> = <code title="'SELECT handle, secret, issued, lifetime, assoc_type FROM %(associations)s WHERE server_url = ?;'">'SELECT handle, secret, issued, lifetime, assoc_type...</code>
226
 
  </td>
227
 
</tr>
228
 
<tr>
229
 
  <td width="15%" align="right" valign="top" class="summary">
230
 
    <span class="summary-type">&nbsp;</span>
231
 
  </td><td class="summary">
232
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#get_assoc_sql">get_assoc_sql</a> = <code title="'SELECT handle, secret, issued, lifetime, assoc_type FROM %(associations)s WHERE server_url = ? AND handle = ?;'">'SELECT handle, secret, issued, lifetime, assoc_type...</code>
233
 
  </td>
234
 
</tr>
235
 
<tr>
236
 
  <td width="15%" align="right" valign="top" class="summary">
237
 
    <span class="summary-type">&nbsp;</span>
238
 
  </td><td class="summary">
239
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#remove_assoc_sql">remove_assoc_sql</a> = <code title="'DELETE FROM %(associations)s WHERE server_url = ? AND handle = ?;'">'DELETE FROM %(associations)s WHERE server_url = ? A...</code>
240
 
  </td>
241
 
</tr>
242
 
<tr>
243
 
  <td width="15%" align="right" valign="top" class="summary">
244
 
    <span class="summary-type">&nbsp;</span>
245
 
  </td><td class="summary">
246
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#add_nonce_sql">add_nonce_sql</a> = <code title="'INSERT OR REPLACE INTO %(nonces)s VALUES (?, ?);'">'INSERT OR REPLACE INTO %(nonces)s VALUES (?, ?);'</code>
247
 
  </td>
248
 
</tr>
249
 
<tr>
250
 
  <td width="15%" align="right" valign="top" class="summary">
251
 
    <span class="summary-type">&nbsp;</span>
252
 
  </td><td class="summary">
253
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#get_nonce_sql">get_nonce_sql</a> = <code title="'SELECT * FROM %(nonces)s WHERE nonce = ?;'">'SELECT * FROM %(nonces)s WHERE nonce = ?;'</code>
254
 
  </td>
255
 
</tr>
256
 
<tr>
257
 
  <td width="15%" align="right" valign="top" class="summary">
258
 
    <span class="summary-type">&nbsp;</span>
259
 
  </td><td class="summary">
260
 
    <a href="openid.store.sqlstore.SQLiteStore-class.html#remove_nonce_sql">remove_nonce_sql</a> = <code title="'DELETE FROM %(nonces)s WHERE nonce = ?;'">'DELETE FROM %(nonces)s WHERE nonce = ?;'</code>
261
 
  </td>
262
 
</tr>
263
 
  <tr>
264
 
    <td colspan="2" class="summary">
265
 
    <p class="indent-wrapped-lines"><b>Inherited from <code><a href="openid.store.sqlstore.SQLStore-class.html">SQLStore</a></code></b>:
266
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#associations_table">associations_table</a></code>,
267
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#nonces_table">nonces_table</a></code>,
268
 
      <code><a href="openid.store.sqlstore.SQLStore-class.html#settings_table">settings_table</a></code>
269
 
      </p>
270
 
    <p class="indent-wrapped-lines"><b>Inherited from <code><a href="openid.store.interface.OpenIDStore-class.html">interface.OpenIDStore</a></code></b>:
271
 
      <code><a href="openid.store.interface.OpenIDStore-class.html#AUTH_KEY_LEN">AUTH_KEY_LEN</a></code>
272
 
      </p>
273
 
    </td>
274
 
  </tr>
275
 
</table>
276
 
 
277
 
<br />
278
 
<!-- ==================== PROPERTIES ==================== -->
279
 
<a name="section-Properties"></a>
280
 
<table class="summary" border="1" cellpadding="3"
281
 
       cellspacing="0" width="100%" bgcolor="white">
282
 
<tr bgcolor="#70b0f0" class="table-header">
283
 
  <td colspan="2" class="table-header">
284
 
    <table border="0" cellpadding="0" cellspacing="0" width="100%">
285
 
      <tr valign="top">
286
 
        <td align="left"><span class="table-header">Properties</span></td>
287
 
        <td align="right" valign="top"
288
 
         ><span class="options">[<a href="#section-Properties"
289
 
         class="privatelink" onclick="toggle_private();"
290
 
         >hide private</a>]</span></td>
291
 
      </tr>
292
 
    </table>
293
 
  </td>
294
 
</tr>
295
 
  <tr>
296
 
    <td colspan="2" class="summary">
297
 
    <p class="indent-wrapped-lines"><b>Inherited from <code>object</code></b>:
298
 
      <code>__class__</code>
299
 
      </p>
300
 
    </td>
301
 
  </tr>
302
 
</table>
303
 
 
304
 
<br />
305
 
<!-- ==================== METHOD DETAILS ==================== -->
306
 
<a name="section-MethodDetails"></a>
307
 
<table class="summary" border="1" cellpadding="3"
308
 
       cellspacing="0" width="100%" bgcolor="white">
309
 
<tr bgcolor="#70b0f0" class="table-header">
310
 
  <td colspan="2" class="table-header">
311
 
    <table border="0" cellpadding="0" cellspacing="0" width="100%">
312
 
      <tr valign="top">
313
 
        <td align="left"><span class="table-header">Method Details</span></td>
314
 
        <td align="right" valign="top"
315
 
         ><span class="options">[<a href="#section-MethodDetails"
316
 
         class="privatelink" onclick="toggle_private();"
317
 
         >hide private</a>]</span></td>
318
 
      </tr>
319
 
    </table>
320
 
  </td>
321
 
</tr>
322
 
</table>
323
 
<a name="blobDecode"></a>
324
 
<div>
325
 
<table class="details" border="1" cellpadding="3"
326
 
       cellspacing="0" width="100%" bgcolor="white">
327
 
<tr><td>
328
 
  <table width="100%" cellpadding="0" cellspacing="0" border="0">
329
 
  <tr valign="top"><td>
330
 
  <h3 class="epydoc"><span class="sig"><span class="sig-name">blobDecode</span>(<span class="sig-arg">self</span>,
331
 
        <span class="sig-arg">buf</span>)</span>
332
 
  </h3>
333
 
  </td><td align="right" valign="top"
334
 
    ><span class="codelink"><a href="openid.store.sqlstore-pysrc.html#SQLiteStore.blobDecode">source&nbsp;code</a></span>&nbsp;
335
 
    </td>
336
 
  </table>
337
 
  
338
 
  <br /><p>Convert a blob as returned by the SQL engine into a str object.</p>
339
 
  str -&gt; str
340
 
  <dl><dt></dt><dd>
341
 
    <dl><dt>Overrides:
342
 
      <a href="openid.store.sqlstore.SQLStore-class.html#blobDecode">SQLStore.blobDecode</a>
343
 
        <dd><em class="note">(inherited documentation)</em></dd>
344
 
    </dt></dl>
345
 
  </dd></dl>
346
 
</td></tr></table>
347
 
</div>
 
59
href="openid.store.sqlstore.SQLStore-class.html" 
 
60
class="link"><code>SQLStore</code></a></code>.</p>
 
61
<p>To create an instance, see <code><a 
 
62
href="openid.store.sqlstore.SQLStore-class.html#__init__" 
 
63
class="link"><code>SQLStore.__init__</code></a></code>. To create the 
 
64
tables it will use, see <code><a 
 
65
href="openid.store.sqlstore.SQLStore-class.html#createTables" 
 
66
class="link"><code>SQLStore.createTables</code></a></code>.</p>
 
67
All other methods are implementation details.
 
68
<hr/>
 
69
 
 
70
 
 
71
<!-- =========== START OF METHOD SUMMARY =========== -->
 
72
<table class="summary" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">
 
73
<tr bgcolor="#70b0f0" class="summary">
 
74
  <th colspan="2">Method Summary</th></tr>
 
75
<tr><td align="right" valign="top" width="15%"><font size="-1">&nbsp;</font></td>
 
76
  <td><code><a name="blobDecode"></a><span class="summary-sig"><span class="summary-sig-name">blobDecode</span>(<span class=summary-sig-arg>self</span>,
 
77
          <span class=summary-sig-arg>buf</span>)</span></code>
 
78
</td></tr>
 
79
<tr><td align="right" valign="top" width="15%"><font size="-1">&nbsp;</font></td>
 
80
  <td><code><span class="summary-sig"><a href="openid.store.sqlstore.SQLiteStore-class.html#blobEncode" class="summary-sig-name"><code>blobEncode</code></a>(<span class=summary-sig-arg>self</span>,
 
81
          <span class=summary-sig-arg>s</span>)</span></code>
 
82
<br />
 
83
Convert a str object into the necessary object for storing in the 
 
84
database as a blob.</td></tr>
 
85
<tr><td align="right" valign="top" width="15%"><font size="-1">&nbsp;</font></td>
 
86
  <td><code><span class="summary-sig"><a href="openid.store.sqlstore.SQLiteStore-class.html#useNonce" class="summary-sig-name"><code>useNonce</code></a>(<span class=summary-sig-arg>self</span>,
 
87
          <span class="summary-sig-vararg">*args</span>,
 
88
          <span class="summary-sig-kwarg">**kwargs</span>)</span></code>
 
89
<br />
 
90
Return whether this nonce is present, and if it is, then remove it 
 
91
from the set.</td></tr>
 
92
  <tr><td colspan="2">
 
93
    <b>Inherited from <a href="openid.store.sqlstore.SQLStore-class.html"><code>SQLStore</code></a>:</b>
 
94
      <a href="openid.store.sqlstore.SQLStore-class.html#__init__"><code>__init__</code></a>, 
 
95
      <a href="openid.store.sqlstore.SQLStore-class.html#__getattr__"><code>__getattr__</code></a>, 
 
96
      <a href="openid.store.sqlstore.SQLStore-class.html#cleanupAssociations"><code>cleanupAssociations</code></a>, 
 
97
      <a href="openid.store.sqlstore.SQLStore-class.html#cleanupNonces"><code>cleanupNonces</code></a>, 
 
98
      <a href="openid.store.sqlstore.SQLStore-class.html#createTables"><code>createTables</code></a>, 
 
99
      <a href="openid.store.sqlstore.SQLStore-class.html#getAssociation"><code>getAssociation</code></a>, 
 
100
      <a href="openid.store.sqlstore.SQLStore-class.html#removeAssociation"><code>removeAssociation</code></a>, 
 
101
      <a href="openid.store.sqlstore.SQLStore-class.html#storeAssociation"><code>storeAssociation</code></a>, 
 
102
      <a href="openid.store.sqlstore.SQLStore-class.html#txn_cleanupAssociations"><code>txn_cleanupAssociations</code></a>, 
 
103
      <a href="openid.store.sqlstore.SQLStore-class.html#txn_cleanupNonces"><code>txn_cleanupNonces</code></a>, 
 
104
      <a href="openid.store.sqlstore.SQLStore-class.html#txn_createTables"><code>txn_createTables</code></a>, 
 
105
      <a href="openid.store.sqlstore.SQLStore-class.html#txn_getAssociation"><code>txn_getAssociation</code></a>, 
 
106
      <a href="openid.store.sqlstore.SQLStore-class.html#txn_removeAssociation"><code>txn_removeAssociation</code></a>, 
 
107
      <a href="openid.store.sqlstore.SQLStore-class.html#txn_storeAssociation"><code>txn_storeAssociation</code></a>, 
 
108
      <a href="openid.store.sqlstore.SQLStore-class.html#txn_useNonce"><code>txn_useNonce</code></a>
 
109
      <br />
 
110
    <b>Inherited from <a href="openid.store.interface.OpenIDStore-class.html"><code>OpenIDStore</code></a>:</b>
 
111
      <a href="openid.store.interface.OpenIDStore-class.html#cleanup"><code>cleanup</code></a>
 
112
      <br />
 
113
    <b>Inherited from <a href="__builtin__.object-class.html"><code>object</code></a>:</b>
 
114
      <a href="__builtin__.object-class.html#__delattr__"><code>__delattr__</code></a>, 
 
115
      <a href="__builtin__.object-class.html#__getattribute__"><code>__getattribute__</code></a>, 
 
116
      <a href="__builtin__.object-class.html#__hash__"><code>__hash__</code></a>, 
 
117
      <a href="__builtin__.object-class.html#__new__"><code>__new__</code></a>, 
 
118
      <a href="__builtin__.object-class.html#__reduce__"><code>__reduce__</code></a>, 
 
119
      <a href="__builtin__.object-class.html#__reduce_ex__"><code>__reduce_ex__</code></a>, 
 
120
      <a href="__builtin__.object-class.html#__repr__"><code>__repr__</code></a>, 
 
121
      <a href="__builtin__.object-class.html#__setattr__"><code>__setattr__</code></a>, 
 
122
      <a href="__builtin__.object-class.html#__str__"><code>__str__</code></a>
 
123
    </td></tr>
 
124
</table><br />
 
125
 
 
126
 
 
127
<!-- =========== START OF CLASS VARIABLE SUMMARY =========== -->
 
128
<table class="summary" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">
 
129
<tr bgcolor="#70b0f0" class="summary">
 
130
  <th colspan="2">Class Variable Summary</th></tr>
 
131
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
132
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#add_nonce_sql"><code>add_nonce_sql</code></a></b> = <span title="'INSERT INTO %(nonces)s VALUES (?, ?, ?);'"><code><span class="variable-quote">'</span>INSERT&nbsp;INTO&nbsp;%(nonces)s&nbsp;VALUES&nbsp;(?,&nbsp;?,&nbsp;?)<span class="variable-ellipsis">...</span></code>
 
133
</span></td></tr>
 
134
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
135
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#clean_assoc_sql"><code>clean_assoc_sql</code></a></b> = <span title="'DELETE FROM %(associations)s WHERE issued + lifetime &lt; ?;'"><code><span class="variable-quote">'</span>DELETE&nbsp;FROM&nbsp;%(associations)s&nbsp;WHERE&nbsp;is<span class="variable-ellipsis">...</span></code>
 
136
</span></td></tr>
 
137
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
138
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#clean_nonce_sql"><code>clean_nonce_sql</code></a></b> = <span title="'DELETE FROM %(nonces)s WHERE timestamp &lt; ?;'"><code><span class="variable-quote">'</span>DELETE&nbsp;FROM&nbsp;%(nonces)s&nbsp;WHERE&nbsp;timestam<span class="variable-ellipsis">...</span></code>
 
139
</span></td></tr>
 
140
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
141
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#create_assoc_sql"><code>create_assoc_sql</code></a></b> = <span title="'\n    CREATE TABLE %(associations)s\n    (\n        server_url VARCHAR(2047),\n        handle VARCHAR(255),\n        secret BLOB(128),\n        issued INTEGER,\n        lifetime INTEGER,\n        assoc_type VARCHAR(64),\n        PRIMARY KEY (server_url, handle)\n    );\n    '"><code><span class="variable-quote">'</span>\n&nbsp;&nbsp;&nbsp;&nbsp;CREATE&nbsp;TABLE&nbsp;%(associations)s\<span class="variable-ellipsis">...</span></code>
 
142
</span></td></tr>
 
143
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
144
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#create_nonce_sql"><code>create_nonce_sql</code></a></b> = <span title="'\n    CREATE TABLE %(nonces)s (\n        server_url VARCHAR,\n        timestamp INTEGER,\n        salt CHAR(40),\n        UNIQUE(server_url, timestamp, salt)\n    );\n    '"><code><span class="variable-quote">'</span>\n&nbsp;&nbsp;&nbsp;&nbsp;CREATE&nbsp;TABLE&nbsp;%(nonces)s&nbsp;(\n&nbsp;&nbsp;&nbsp;<span class="variable-ellipsis">...</span></code>
 
145
</span></td></tr>
 
146
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
147
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#create_settings_sql"><code>create_settings_sql</code></a></b> = <span title="'\n    CREATE TABLE %(settings)s\n    (\n        setting VARCHAR(128) UNIQUE PRIMARY KEY,\n        value BLOB(20)\n    );\n    '"><code><span class="variable-quote">'</span>\n&nbsp;&nbsp;&nbsp;&nbsp;CREATE&nbsp;TABLE&nbsp;%(settings)s\n<span class="variable-ellipsis">...</span></code>
 
148
</span></td></tr>
 
149
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
150
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#get_assoc_sql"><code>get_assoc_sql</code></a></b> = <span title="'SELECT handle, secret, issued, lifetime, assoc_type FROM %(associations)s WHERE server_url = ? AND handle = ?;'"><code><span class="variable-quote">'</span>SELECT&nbsp;handle,&nbsp;secret,&nbsp;issued,&nbsp;lifetime<span class="variable-ellipsis">...</span></code>
 
151
</span></td></tr>
 
152
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
153
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#get_assocs_sql"><code>get_assocs_sql</code></a></b> = <span title="'SELECT handle, secret, issued, lifetime, assoc_type FROM %(associations)s WHERE server_url = ?;'"><code><span class="variable-quote">'</span>SELECT&nbsp;handle,&nbsp;secret,&nbsp;issued,&nbsp;lifetim<span class="variable-ellipsis">...</span></code>
 
154
</span></td></tr>
 
155
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
156
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#get_expired_sql"><code>get_expired_sql</code></a></b> = <span title="'SELECT server_url FROM %(associations)s WHERE issued + lifetime &lt; ?;'"><code><span class="variable-quote">'</span>SELECT&nbsp;server_url&nbsp;FROM&nbsp;%(associations<span class="variable-ellipsis">...</span></code>
 
157
</span></td></tr>
 
158
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
159
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#remove_assoc_sql"><code>remove_assoc_sql</code></a></b> = <span title="'DELETE FROM %(associations)s WHERE server_url = ? AND handle = ?;'"><code><span class="variable-quote">'</span>DELETE&nbsp;FROM&nbsp;%(associations)s&nbsp;WHERE&nbsp;s<span class="variable-ellipsis">...</span></code>
 
160
</span></td></tr>
 
161
<tr><td align="right" valign="top" width="15%"><font size="-1"><code>str</code></font></td>
 
162
<td><b><a href="openid.store.sqlstore.SQLiteStore-class.html#set_assoc_sql"><code>set_assoc_sql</code></a></b> = <span title="'INSERT OR REPLACE INTO %(associations)s VALUES (?, ?, ?, ?, ?, ?);'"><code><span class="variable-quote">'</span>INSERT&nbsp;OR&nbsp;REPLACE&nbsp;INTO&nbsp;%(associations)s<span class="variable-ellipsis">...</span></code>
 
163
</span></td></tr>
 
164
  <tr><td colspan="2">
 
165
    <b>Inherited from <a href="openid.store.sqlstore.SQLStore-class.html"><code>SQLStore</code></a>:</b>
 
166
      <a href="openid.store.sqlstore.SQLStore-class.html#associations_table"><code>associations_table</code></a>, 
 
167
      <a href="openid.store.sqlstore.SQLStore-class.html#nonces_table"><code>nonces_table</code></a>, 
 
168
      <a href="openid.store.sqlstore.SQLStore-class.html#settings_table"><code>settings_table</code></a>
 
169
    </td></tr>
 
170
</table><br />
 
171
 
 
172
 
 
173
<!-- =========== START OF METHOD DETAILS =========== -->
 
174
<table class="details" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">
 
175
<tr bgcolor="#70b0f0" class="details">
 
176
  <th colspan="2">Method Details</th></tr>
 
177
</table>
 
178
 
348
179
<a name="blobEncode"></a>
349
 
<div>
350
 
<table class="details" border="1" cellpadding="3"
351
 
       cellspacing="0" width="100%" bgcolor="white">
352
 
<tr><td>
353
 
  <table width="100%" cellpadding="0" cellspacing="0" border="0">
354
 
  <tr valign="top"><td>
355
 
  <h3 class="epydoc"><span class="sig"><span class="sig-name">blobEncode</span>(<span class="sig-arg">self</span>,
356
 
        <span class="sig-arg">s</span>)</span>
 
180
<table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>
 
181
  <h3><span class="sig"><span class="sig-name">blobEncode</span>(<span class=sig-arg>self</span>,
 
182
          <span class=sig-arg>s</span>)</span>
357
183
  </h3>
358
 
  </td><td align="right" valign="top"
359
 
    ><span class="codelink"><a href="openid.store.sqlstore-pysrc.html#SQLiteStore.blobEncode">source&nbsp;code</a></span>&nbsp;
360
 
    </td>
361
 
  </table>
362
 
  
363
 
  <br />Convert a str object into the necessary object for storing in the 
 
184
  Convert a str object into the necessary object for storing in the 
364
185
  database as a blob.
365
186
  <dl><dt></dt><dd>
366
 
    <dl><dt>Overrides:
367
 
      <a href="openid.store.sqlstore.SQLStore-class.html#blobEncode">SQLStore.blobEncode</a>
368
 
        <dd><em class="note">(inherited documentation)</em></dd>
369
 
    </dt></dl>
370
 
  </dd></dl>
371
 
</td></tr></table>
372
 
</div>
 
187
    <dl><dt><b>Overrides:</b></dt>
 
188
      <dd><a href="openid.store.sqlstore.SQLStore-class.html#blobEncode"><code>openid.store.sqlstore.SQLStore.blobEncode</code></a> <i>(inherited documentation)</i>
 
189
</dd>
 
190
    </dl>
 
191
  </dd></dl>
 
192
</td></tr></table>
 
193
 
 
194
<a name="useNonce"></a>
 
195
<table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>
 
196
  <h3><span class="sig"><span class="sig-name">useNonce</span>(<span class=sig-arg>self</span>,
 
197
          <span class="sig-vararg">*args</span>,
 
198
          <span class="sig-kwarg">**kwargs</span>)</span>
 
199
  </h3>
 
200
  <p>Return whether this nonce is present, and if it is, then remove it 
 
201
  from the set.</p>
 
202
  str -&gt; bool
 
203
  <dl><dt></dt><dd>
 
204
    <dl><dt><b>Overrides:</b></dt>
 
205
      <dd><a href="openid.store.sqlstore.SQLStore-class.html#useNonce"><code>openid.store.sqlstore.SQLStore.useNonce</code></a> <i>(inherited documentation)</i>
 
206
</dd>
 
207
    </dl>
 
208
  </dd></dl>
 
209
</td></tr></table>
373
210
<br />
374
 
<!-- ==================== CLASS VARIABLE DETAILS ==================== -->
375
 
<a name="section-ClassVariableDetails"></a>
376
 
<table class="summary" border="1" cellpadding="3"
377
 
       cellspacing="0" width="100%" bgcolor="white">
378
 
<tr bgcolor="#70b0f0" class="table-header">
379
 
  <td colspan="2" class="table-header">
380
 
    <table border="0" cellpadding="0" cellspacing="0" width="100%">
381
 
      <tr valign="top">
382
 
        <td align="left"><span class="table-header">Class Variable Details</span></td>
383
 
        <td align="right" valign="top"
384
 
         ><span class="options">[<a href="#section-ClassVariableDetails"
385
 
         class="privatelink" onclick="toggle_private();"
386
 
         >hide private</a>]</span></td>
387
 
      </tr>
388
 
    </table>
389
 
  </td>
390
 
</tr>
 
211
 
 
212
 
 
213
<!-- =========== START OF CLASS VARIABLE DETAILS =========== -->
 
214
<table class="details" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">
 
215
<tr bgcolor="#70b0f0" class="details">
 
216
  <th colspan="2">Class Variable Details</th></tr>
391
217
</table>
392
 
<a name="create_nonce_sql"></a>
393
 
<div>
394
 
<table class="details" border="1" cellpadding="3"
395
 
       cellspacing="0" width="100%" bgcolor="white">
396
 
<tr><td>
397
 
  <h3 class="epydoc">create_nonce_sql</h3>
398
 
  
399
 
  <dl><dt></dt><dd>
400
 
    <dl><dt>Value:</dt>
401
 
      <dd><table><tr><td><pre class="variable">
402
 
<span class="variable-quote">'''</span>
403
 
    CREATE TABLE %(nonces)s
404
 
    (
405
 
        nonce CHAR(8) UNIQUE PRIMARY KEY,
406
 
        expires INTEGER
407
 
    );
408
 
    <span class="variable-quote">'''</span>                                                                
409
 
      </pre></td></tr></table></dd>
410
 
    </dl>
411
 
  </dd></dl>
412
 
</td></tr></table>
413
 
</div>
 
218
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
 
219
<a name="add_nonce_sql"></a>
 
220
<h3>add_nonce_sql</h3>
 
221
<dl>
 
222
  <dt></dt>
 
223
  <dd>
 
224
    <dl>
 
225
      <dt><b>Type:</b></dt>
 
226
      <dd>
 
227
          <code>str</code>
 
228
 
 
229
      </dd>
 
230
<span title="'INSERT INTO %(nonces)s VALUES (?, ?, ?);'">      <dt><b>Value:</b></dt>
 
231
      <dd><table><tr><td>
 
232
<pre class="variable">
 
233
<span class="variable-quote">'</span>INSERT INTO %(nonces)s VALUES (?, ?, ?);<span class="variable-quote">'</span>                             </pre>
 
234
        </td></tr></table></dd>
 
235
</span>    </dl>
 
236
  </dd>
 
237
</dl></td></tr></table>
 
238
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
 
239
<a name="clean_assoc_sql"></a>
 
240
<h3>clean_assoc_sql</h3>
 
241
<dl>
 
242
  <dt></dt>
 
243
  <dd>
 
244
    <dl>
 
245
      <dt><b>Type:</b></dt>
 
246
      <dd>
 
247
          <code>str</code>
 
248
 
 
249
      </dd>
 
250
<span title="'DELETE FROM %(associations)s WHERE issued + lifetime &lt; ?;'">      <dt><b>Value:</b></dt>
 
251
      <dd><table><tr><td>
 
252
<pre class="variable">
 
253
<span class="variable-quote">'</span>DELETE FROM %(associations)s WHERE issued + lifetime &lt; ?;<span class="variable-quote">'</span>            </pre>
 
254
        </td></tr></table></dd>
 
255
</span>    </dl>
 
256
  </dd>
 
257
</dl></td></tr></table>
 
258
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
 
259
<a name="clean_nonce_sql"></a>
 
260
<h3>clean_nonce_sql</h3>
 
261
<dl>
 
262
  <dt></dt>
 
263
  <dd>
 
264
    <dl>
 
265
      <dt><b>Type:</b></dt>
 
266
      <dd>
 
267
          <code>str</code>
 
268
 
 
269
      </dd>
 
270
<span title="'DELETE FROM %(nonces)s WHERE timestamp &lt; ?;'">      <dt><b>Value:</b></dt>
 
271
      <dd><table><tr><td>
 
272
<pre class="variable">
 
273
<span class="variable-quote">'</span>DELETE FROM %(nonces)s WHERE timestamp &lt; ?;<span class="variable-quote">'</span>                          </pre>
 
274
        </td></tr></table></dd>
 
275
</span>    </dl>
 
276
  </dd>
 
277
</dl></td></tr></table>
 
278
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
414
279
<a name="create_assoc_sql"></a>
415
 
<div>
416
 
<table class="details" border="1" cellpadding="3"
417
 
       cellspacing="0" width="100%" bgcolor="white">
418
 
<tr><td>
419
 
  <h3 class="epydoc">create_assoc_sql</h3>
420
 
  
421
 
  <dl><dt></dt><dd>
422
 
    <dl><dt>Value:</dt>
423
 
      <dd><table><tr><td><pre class="variable">
 
280
<h3>create_assoc_sql</h3>
 
281
<dl>
 
282
  <dt></dt>
 
283
  <dd>
 
284
    <dl>
 
285
      <dt><b>Type:</b></dt>
 
286
      <dd>
 
287
          <code>str</code>
 
288
 
 
289
      </dd>
 
290
<span title="'\n    CREATE TABLE %(associations)s\n    (\n        server_url VARCHAR(2047),\n        handle VARCHAR(255),\n        secret BLOB(128),\n        issued INTEGER,\n        lifetime INTEGER,\n        assoc_type VARCHAR(64),\n        PRIMARY KEY (server_url, handle)\n    );\n    '">      <dt><b>Value:</b></dt>
 
291
      <dd><table><tr><td>
 
292
<pre class="variable">
424
293
<span class="variable-quote">'''</span>
425
294
    CREATE TABLE %(associations)s
426
295
    (
429
298
        secret BLOB(128),
430
299
        issued INTEGER,
431
300
        lifetime INTEGER,
432
 
<span class="variable-ellipsis">...</span>                                                                    
433
 
      </pre></td></tr></table></dd>
434
 
    </dl>
435
 
  </dd></dl>
436
 
</td></tr></table>
437
 
</div>
 
301
<span class="variable-ellipsis">...</span>                                                                    </pre>
 
302
        </td></tr></table></dd>
 
303
</span>    </dl>
 
304
  </dd>
 
305
</dl></td></tr></table>
 
306
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
 
307
<a name="create_nonce_sql"></a>
 
308
<h3>create_nonce_sql</h3>
 
309
<dl>
 
310
  <dt></dt>
 
311
  <dd>
 
312
    <dl>
 
313
      <dt><b>Type:</b></dt>
 
314
      <dd>
 
315
          <code>str</code>
 
316
 
 
317
      </dd>
 
318
<span title="'\n    CREATE TABLE %(nonces)s (\n        server_url VARCHAR,\n        timestamp INTEGER,\n        salt CHAR(40),\n        UNIQUE(server_url, timestamp, salt)\n    );\n    '">      <dt><b>Value:</b></dt>
 
319
      <dd><table><tr><td>
 
320
<pre class="variable">
 
321
<span class="variable-quote">'''</span>
 
322
    CREATE TABLE %(nonces)s (
 
323
        server_url VARCHAR,
 
324
        timestamp INTEGER,
 
325
        salt CHAR(40),
 
326
        UNIQUE(server_url, timestamp, salt)
 
327
    );
 
328
    <span class="variable-quote">'''</span>                                                                </pre>
 
329
        </td></tr></table></dd>
 
330
</span>    </dl>
 
331
  </dd>
 
332
</dl></td></tr></table>
 
333
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
438
334
<a name="create_settings_sql"></a>
439
 
<div>
440
 
<table class="details" border="1" cellpadding="3"
441
 
       cellspacing="0" width="100%" bgcolor="white">
442
 
<tr><td>
443
 
  <h3 class="epydoc">create_settings_sql</h3>
444
 
  
445
 
  <dl><dt></dt><dd>
446
 
    <dl><dt>Value:</dt>
447
 
      <dd><table><tr><td><pre class="variable">
 
335
<h3>create_settings_sql</h3>
 
336
<dl>
 
337
  <dt></dt>
 
338
  <dd>
 
339
    <dl>
 
340
      <dt><b>Type:</b></dt>
 
341
      <dd>
 
342
          <code>str</code>
 
343
 
 
344
      </dd>
 
345
<span title="'\n    CREATE TABLE %(settings)s\n    (\n        setting VARCHAR(128) UNIQUE PRIMARY KEY,\n        value BLOB(20)\n    );\n    '">      <dt><b>Value:</b></dt>
 
346
      <dd><table><tr><td>
 
347
<pre class="variable">
448
348
<span class="variable-quote">'''</span>
449
349
    CREATE TABLE %(settings)s
450
350
    (
451
351
        setting VARCHAR(128) UNIQUE PRIMARY KEY,
452
352
        value BLOB(20)
453
353
    );
454
 
    <span class="variable-quote">'''</span>                                                                
455
 
      </pre></td></tr></table></dd>
456
 
    </dl>
457
 
  </dd></dl>
458
 
</td></tr></table>
459
 
</div>
460
 
<a name="create_auth_sql"></a>
461
 
<div>
462
 
<table class="details" border="1" cellpadding="3"
463
 
       cellspacing="0" width="100%" bgcolor="white">
464
 
<tr><td>
465
 
  <h3 class="epydoc">create_auth_sql</h3>
466
 
  
467
 
  <dl><dt></dt><dd>
468
 
    <dl><dt>Value:</dt>
469
 
      <dd><table><tr><td><pre class="variable">
470
 
<span class="variable-quote">'</span>INSERT INTO %(settings)s VALUES (&quot;auth_key&quot;, ?);<span class="variable-quote">'</span>                     
471
 
      </pre></td></tr></table></dd>
472
 
    </dl>
473
 
  </dd></dl>
474
 
</td></tr></table>
475
 
</div>
476
 
<a name="get_auth_sql"></a>
477
 
<div>
478
 
<table class="details" border="1" cellpadding="3"
479
 
       cellspacing="0" width="100%" bgcolor="white">
480
 
<tr><td>
481
 
  <h3 class="epydoc">get_auth_sql</h3>
482
 
  
483
 
  <dl><dt></dt><dd>
484
 
    <dl><dt>Value:</dt>
485
 
      <dd><table><tr><td><pre class="variable">
486
 
<span class="variable-quote">'</span>SELECT value FROM %(settings)s WHERE setting = &quot;auth_key&quot;;<span class="variable-quote">'</span>           
487
 
      </pre></td></tr></table></dd>
488
 
    </dl>
489
 
  </dd></dl>
490
 
</td></tr></table>
491
 
</div>
492
 
<a name="set_assoc_sql"></a>
493
 
<div>
494
 
<table class="details" border="1" cellpadding="3"
495
 
       cellspacing="0" width="100%" bgcolor="white">
496
 
<tr><td>
497
 
  <h3 class="epydoc">set_assoc_sql</h3>
498
 
  
499
 
  <dl><dt></dt><dd>
500
 
    <dl><dt>Value:</dt>
501
 
      <dd><table><tr><td><pre class="variable">
502
 
<span class="variable-quote">'</span>INSERT OR REPLACE INTO %(associations)s VALUES (?, ?, ?, ?, ?, ?);<span class="variable-quote">'</span>   
503
 
      </pre></td></tr></table></dd>
504
 
    </dl>
505
 
  </dd></dl>
506
 
</td></tr></table>
507
 
</div>
 
354
    <span class="variable-quote">'''</span>                                                                </pre>
 
355
        </td></tr></table></dd>
 
356
</span>    </dl>
 
357
  </dd>
 
358
</dl></td></tr></table>
 
359
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
 
360
<a name="get_assoc_sql"></a>
 
361
<h3>get_assoc_sql</h3>
 
362
<dl>
 
363
  <dt></dt>
 
364
  <dd>
 
365
    <dl>
 
366
      <dt><b>Type:</b></dt>
 
367
      <dd>
 
368
          <code>str</code>
 
369
 
 
370
      </dd>
 
371
<span title="'SELECT handle, secret, issued, lifetime, assoc_type FROM %(associations)s WHERE server_url = ? AND handle = ?;'">      <dt><b>Value:</b></dt>
 
372
      <dd><table><tr><td>
 
373
<pre class="variable">
 
374
<span class="variable-quote">'</span>SELECT handle, secret, issued, lifetime, assoc_type FROM %(associatio<span class="variable-linewrap">\</span>
 
375
ns)s WHERE server_url = ? AND handle = ?;<span class="variable-quote">'</span>                             </pre>
 
376
        </td></tr></table></dd>
 
377
</span>    </dl>
 
378
  </dd>
 
379
</dl></td></tr></table>
 
380
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
508
381
<a name="get_assocs_sql"></a>
509
 
<div>
510
 
<table class="details" border="1" cellpadding="3"
511
 
       cellspacing="0" width="100%" bgcolor="white">
512
 
<tr><td>
513
 
  <h3 class="epydoc">get_assocs_sql</h3>
514
 
  
515
 
  <dl><dt></dt><dd>
516
 
    <dl><dt>Value:</dt>
517
 
      <dd><table><tr><td><pre class="variable">
518
 
<span class="variable-quote">'</span>SELECT handle, secret, issued, lifetime, assoc_type FROM %(associatio<span class="variable-linewrap"><img src="crarr.png" alt="" /></span>
519
 
ns)s WHERE server_url = ?;<span class="variable-quote">'</span>                                            
520
 
      </pre></td></tr></table></dd>
521
 
    </dl>
522
 
  </dd></dl>
523
 
</td></tr></table>
524
 
</div>
525
 
<a name="get_assoc_sql"></a>
526
 
<div>
527
 
<table class="details" border="1" cellpadding="3"
528
 
       cellspacing="0" width="100%" bgcolor="white">
529
 
<tr><td>
530
 
  <h3 class="epydoc">get_assoc_sql</h3>
531
 
  
532
 
  <dl><dt></dt><dd>
533
 
    <dl><dt>Value:</dt>
534
 
      <dd><table><tr><td><pre class="variable">
535
 
<span class="variable-quote">'</span>SELECT handle, secret, issued, lifetime, assoc_type FROM %(associatio<span class="variable-linewrap"><img src="crarr.png" alt="" /></span>
536
 
ns)s WHERE server_url = ? AND handle = ?;<span class="variable-quote">'</span>                             
537
 
      </pre></td></tr></table></dd>
538
 
    </dl>
539
 
  </dd></dl>
540
 
</td></tr></table>
541
 
</div>
 
382
<h3>get_assocs_sql</h3>
 
383
<dl>
 
384
  <dt></dt>
 
385
  <dd>
 
386
    <dl>
 
387
      <dt><b>Type:</b></dt>
 
388
      <dd>
 
389
          <code>str</code>
 
390
 
 
391
      </dd>
 
392
<span title="'SELECT handle, secret, issued, lifetime, assoc_type FROM %(associations)s WHERE server_url = ?;'">      <dt><b>Value:</b></dt>
 
393
      <dd><table><tr><td>
 
394
<pre class="variable">
 
395
<span class="variable-quote">'</span>SELECT handle, secret, issued, lifetime, assoc_type FROM %(associatio<span class="variable-linewrap">\</span>
 
396
ns)s WHERE server_url = ?;<span class="variable-quote">'</span>                                            </pre>
 
397
        </td></tr></table></dd>
 
398
</span>    </dl>
 
399
  </dd>
 
400
</dl></td></tr></table>
 
401
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
 
402
<a name="get_expired_sql"></a>
 
403
<h3>get_expired_sql</h3>
 
404
<dl>
 
405
  <dt></dt>
 
406
  <dd>
 
407
    <dl>
 
408
      <dt><b>Type:</b></dt>
 
409
      <dd>
 
410
          <code>str</code>
 
411
 
 
412
      </dd>
 
413
<span title="'SELECT server_url FROM %(associations)s WHERE issued + lifetime &lt; ?;'">      <dt><b>Value:</b></dt>
 
414
      <dd><table><tr><td>
 
415
<pre class="variable">
 
416
<span class="variable-quote">'</span>SELECT server_url FROM %(associations)s WHERE issued + lifetime &lt; ?;<span class="variable-quote">'<span class="variable-linewrap">\</span>
 
417
</span>                                                                       </pre>
 
418
        </td></tr></table></dd>
 
419
</span>    </dl>
 
420
  </dd>
 
421
</dl></td></tr></table>
 
422
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
542
423
<a name="remove_assoc_sql"></a>
543
 
<div>
544
 
<table class="details" border="1" cellpadding="3"
545
 
       cellspacing="0" width="100%" bgcolor="white">
546
 
<tr><td>
547
 
  <h3 class="epydoc">remove_assoc_sql</h3>
548
 
  
549
 
  <dl><dt></dt><dd>
550
 
    <dl><dt>Value:</dt>
551
 
      <dd><table><tr><td><pre class="variable">
552
 
<span class="variable-quote">'</span>DELETE FROM %(associations)s WHERE server_url = ? AND handle = ?;<span class="variable-quote">'</span>    
553
 
      </pre></td></tr></table></dd>
554
 
    </dl>
555
 
  </dd></dl>
556
 
</td></tr></table>
557
 
</div>
558
 
<a name="add_nonce_sql"></a>
559
 
<div>
560
 
<table class="details" border="1" cellpadding="3"
561
 
       cellspacing="0" width="100%" bgcolor="white">
562
 
<tr><td>
563
 
  <h3 class="epydoc">add_nonce_sql</h3>
564
 
  
565
 
  <dl><dt></dt><dd>
566
 
    <dl><dt>Value:</dt>
567
 
      <dd><table><tr><td><pre class="variable">
568
 
<span class="variable-quote">'</span>INSERT OR REPLACE INTO %(nonces)s VALUES (?, ?);<span class="variable-quote">'</span>                     
569
 
      </pre></td></tr></table></dd>
570
 
    </dl>
571
 
  </dd></dl>
572
 
</td></tr></table>
573
 
</div>
574
 
<a name="get_nonce_sql"></a>
575
 
<div>
576
 
<table class="details" border="1" cellpadding="3"
577
 
       cellspacing="0" width="100%" bgcolor="white">
578
 
<tr><td>
579
 
  <h3 class="epydoc">get_nonce_sql</h3>
580
 
  
581
 
  <dl><dt></dt><dd>
582
 
    <dl><dt>Value:</dt>
583
 
      <dd><table><tr><td><pre class="variable">
584
 
<span class="variable-quote">'</span>SELECT * FROM %(nonces)s WHERE nonce = ?;<span class="variable-quote">'</span>                            
585
 
      </pre></td></tr></table></dd>
586
 
    </dl>
587
 
  </dd></dl>
588
 
</td></tr></table>
589
 
</div>
590
 
<a name="remove_nonce_sql"></a>
591
 
<div>
592
 
<table class="details" border="1" cellpadding="3"
593
 
       cellspacing="0" width="100%" bgcolor="white">
594
 
<tr><td>
595
 
  <h3 class="epydoc">remove_nonce_sql</h3>
596
 
  
597
 
  <dl><dt></dt><dd>
598
 
    <dl><dt>Value:</dt>
599
 
      <dd><table><tr><td><pre class="variable">
600
 
<span class="variable-quote">'</span>DELETE FROM %(nonces)s WHERE nonce = ?;<span class="variable-quote">'</span>                              
601
 
      </pre></td></tr></table></dd>
602
 
    </dl>
603
 
  </dd></dl>
604
 
</td></tr></table>
605
 
</div>
 
424
<h3>remove_assoc_sql</h3>
 
425
<dl>
 
426
  <dt></dt>
 
427
  <dd>
 
428
    <dl>
 
429
      <dt><b>Type:</b></dt>
 
430
      <dd>
 
431
          <code>str</code>
 
432
 
 
433
      </dd>
 
434
<span title="'DELETE FROM %(associations)s WHERE server_url = ? AND handle = ?;'">      <dt><b>Value:</b></dt>
 
435
      <dd><table><tr><td>
 
436
<pre class="variable">
 
437
<span class="variable-quote">'</span>DELETE FROM %(associations)s WHERE server_url = ? AND handle = ?;<span class="variable-quote">'</span>    </pre>
 
438
        </td></tr></table></dd>
 
439
</span>    </dl>
 
440
  </dd>
 
441
</dl></td></tr></table>
 
442
<table width="100%" class="var-details" bgcolor="#e0e0e0"><tr><td>
 
443
<a name="set_assoc_sql"></a>
 
444
<h3>set_assoc_sql</h3>
 
445
<dl>
 
446
  <dt></dt>
 
447
  <dd>
 
448
    <dl>
 
449
      <dt><b>Type:</b></dt>
 
450
      <dd>
 
451
          <code>str</code>
 
452
 
 
453
      </dd>
 
454
<span title="'INSERT OR REPLACE INTO %(associations)s VALUES (?, ?, ?, ?, ?, ?);'">      <dt><b>Value:</b></dt>
 
455
      <dd><table><tr><td>
 
456
<pre class="variable">
 
457
<span class="variable-quote">'</span>INSERT OR REPLACE INTO %(associations)s VALUES (?, ?, ?, ?, ?, ?);<span class="variable-quote">'</span>   </pre>
 
458
        </td></tr></table></dd>
 
459
</span>    </dl>
 
460
  </dd>
 
461
</dl></td></tr></table>
606
462
<br />
607
 
<!-- ==================== NAVIGATION BAR ==================== -->
608
 
<table class="navbar" border="0" width="100%" cellpadding="0"
609
 
       bgcolor="#a0c0ff" cellspacing="0">
610
 
  <tr valign="middle">
611
 
  <!-- Home link -->
612
 
      <th>&nbsp;&nbsp;&nbsp;<a
613
 
        href="openid-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>
614
 
 
615
 
  <!-- Tree link -->
616
 
      <th>&nbsp;&nbsp;&nbsp;<a
617
 
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>
618
 
 
619
 
  <!-- Index link -->
620
 
      <th>&nbsp;&nbsp;&nbsp;<a
621
 
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>
622
 
 
623
 
  <!-- Help link -->
624
 
      <th>&nbsp;&nbsp;&nbsp;<a
625
 
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>
626
 
 
627
 
  <!-- Project homepage -->
628
 
      <th class="navbar" align="right" width="100%">
629
 
        <table border="0" cellpadding="0" cellspacing="0">
630
 
          <tr><th class="navbar" align="center"
631
 
            ><a class="navbar" target="_top" href="http://www.openidenabled.com/">Python-OpenID</a></th>
632
 
          </tr></table></th>
 
463
 
 
464
 
 
465
<!-- =========== START OF NAVBAR =========== -->
 
466
<table class="navbar" border="0" width="100%" cellpadding="0" bgcolor="#a0c0ff" cellspacing="0">
 
467
  <tr valign="center">
 
468
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="openid-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>
 
469
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="trees.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>
 
470
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="indices.html">Index</a>&nbsp;&nbsp;&nbsp;</th>
 
471
    <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>
 
472
    <th class="navbar" align="right" width="100%">
 
473
      <table border="0" cellpadding="0" cellspacing="0">
 
474
      <tr><th class="navbar" align="center">
 
475
        <p class="nomargin">
 
476
          <a class="navbar" target="_top" href="http://www.openidenabled.com/">Python-OpenID</a>
 
477
      </p></th></tr></table>
 
478
    </th>
633
479
  </tr>
634
480
</table>
635
 
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
 
481
 
 
482
<table border="0" cellpadding="0" cellspacing="0" width="100%">
636
483
  <tr>
637
 
    <td align="left" class="footer">Generated by Epydoc
638
 
        3.0alpha3 on Fri Dec  8 13:26:20 2006</td>
639
 
    <td align="right" class="footer">
640
 
      <a href="http://epydoc.sourceforge.net">http://epydoc.sourceforge.net</a>
641
 
    </td>
 
484
    <td align="left"><font size="-2">Generated by Epydoc 2.1 on Mon Sep 10 13:00:12 2007</font></td>
 
485
    <td align="right"><a href="http://epydoc.sourceforge.net"
 
486
                      ><font size="-2">http://epydoc.sf.net</font></a></td>
642
487
  </tr>
643
488
</table>
644
 
 
645
 
<script type="text/javascript">
646
 
  <!--
647
 
  // Private objects are initially displayed (because if
648
 
  // javascript is turned off then we want them to be
649
 
  // visible); but by default, we want to hide them.  So hide
650
 
  // them unless we have a cookie that says to show them.
651
 
  checkCookie()
652
 
  // -->
653
 
</script>
654
 
  
655
489
</body>
656
490
</html>