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
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="content-type">
<title>News</title>
<link href="layout.css" type="text/css" rel="stylesheet">
</head>
<body>
<div id="page">
<h1 class="doc-title"><a></a></h1>
<div id="navcontainer">
<ul id="navlist">
<li class="pagenav">
<ul>
<li class="page_item">
<a href="index.html" title="Project Home / Index">SQLObject</a>
</li>
<li class="page_item">
<a href="module-index.html" title="sqlobject package and module reference">Modules</a>
</li>
<li>
<a href="community.html" title="Mailing List">Discuss</a>
</li>
<li>
<a href="SQLObject.html">Documentation</a>
</li>
</ul>
</li>
</ul>
</div>
<hr>
<div id="content"><div class="rst-doc">
<h1 class="pudge-member-page-heading">News</h1>
<div class="contents topic" id="contents">
<p class="topic-title first">Contents:</p>
<ul class="simple">
<li><a href="#sqlobject-0-15-1" class="reference internal" id="id7">SQLObject 0.15.1</a></li>
<li><a href="#sqlobject-0-15-0" class="reference internal" id="id8">SQLObject 0.15.0</a><ul>
<li><a href="#features-interface" class="reference internal" id="id9">Features & Interface</a></li>
</ul>
</li>
<li><a href="#sqlobject-0-14-2" class="reference internal" id="id10">SQLObject 0.14.2</a></li>
<li><a href="#sqlobject-0-14-1" class="reference internal" id="id11">SQLObject 0.14.1</a></li>
<li><a href="#sqlobject-0-14-0" class="reference internal" id="id12">SQLObject 0.14.0</a><ul>
<li><a href="#id1" class="reference internal" id="id13">Features & Interface</a></li>
</ul>
</li>
<li><a href="#sqlobject-0-13-1" class="reference internal" id="id14">SQLObject 0.13.1</a></li>
<li><a href="#sqlobject-0-13-0" class="reference internal" id="id15">SQLObject 0.13.0</a><ul>
<li><a href="#id2" class="reference internal" id="id16">Features & Interface</a></li>
<li><a href="#small-features" class="reference internal" id="id17">Small Features</a></li>
</ul>
</li>
<li><a href="#sqlobject-0-12-5" class="reference internal" id="id18">SQLObject 0.12.5</a></li>
<li><a href="#sqlobject-0-12-4" class="reference internal" id="id19">SQLObject 0.12.4</a></li>
<li><a href="#sqlobject-0-12-3" class="reference internal" id="id20">SQLObject 0.12.3</a></li>
<li><a href="#sqlobject-0-12-2" class="reference internal" id="id21">SQLObject 0.12.2</a></li>
<li><a href="#sqlobject-0-12-1" class="reference internal" id="id22">SQLObject 0.12.1</a></li>
<li><a href="#sqlobject-0-12" class="reference internal" id="id23">SQLObject 0.12</a><ul>
<li><a href="#id3" class="reference internal" id="id24">Features & Interface</a></li>
<li><a href="#id4" class="reference internal" id="id25">Small Features</a></li>
</ul>
</li>
<li><a href="#sqlobject-0-11-6" class="reference internal" id="id26">SQLObject 0.11.6</a></li>
<li><a href="#sqlobject-0-11-5" class="reference internal" id="id27">SQLObject 0.11.5</a></li>
<li><a href="#sqlobject-0-11-4" class="reference internal" id="id28">SQLObject 0.11.4</a></li>
<li><a href="#sqlobject-0-11-3" class="reference internal" id="id29">SQLObject 0.11.3</a></li>
<li><a href="#sqlobject-0-11-2" class="reference internal" id="id30">SQLObject 0.11.2</a></li>
<li><a href="#sqlobject-0-11-1" class="reference internal" id="id31">SQLObject 0.11.1</a></li>
<li><a href="#sqlobject-0-11-0" class="reference internal" id="id32">SQLObject 0.11.0</a><ul>
<li><a href="#id5" class="reference internal" id="id33">Features & Interface</a></li>
<li><a href="#minor-features" class="reference internal" id="id34">Minor features</a></li>
</ul>
</li>
</ul>
</div>
<div class="section" id="sqlobject-0-15-1">
<span id="start"></span><h1>SQLObject 0.15.1</h1>
<p>Released 22 Mar 2011.</p>
<ul class="simple">
<li>A bug was fixed in MSSQLConnection.</li>
<li>A minor bug was fixed in sqlbuilder.Union.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-15-0">
<h1>SQLObject 0.15.0</h1>
<p>Released 6 Dec 2010.</p>
<div class="section" id="features-interface">
<h2>Features & Interface</h2>
<ul class="simple">
<li>Major API change: all signals are sent with the instance (or the class)
as the first parameter. The following signals were changed:
RowCreateSignal, RowCreatedSignal, DeleteColumnSignal.</li>
<li>Major API change: post-processing functions for all signals are called
with the instance as the first parameter. The following signals were
changed: RowUpdatedSignal, RowDestroySignal, RowDestroyedSignal.</li>
</ul>
</div>
</div>
<div class="section" id="sqlobject-0-14-2">
<h1>SQLObject 0.14.2</h1>
<ul class="simple">
<li>A minor bug was fixed in sqlbuilder.Union.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-14-1">
<h1>SQLObject 0.14.1</h1>
<p>Released 15 Oct 2010.</p>
<ul class="simple">
<li>A bugfix was ported from <a href="#sqlobject-0-13-1" class="reference internal">SQLObject 0.13.1</a>.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-14-0">
<h1>SQLObject 0.14.0</h1>
<p>Released 10 Oct 2010.</p>
<div class="section" id="id1">
<h2>Features & Interface</h2>
<ul class="simple">
<li>The lists of columns/indices/joins are now sorted according to the order
of declaration.</li>
<li><tt class="docutils literal">validator2</tt> was added to all columns; it is inserted at the beginning
of the list of validators, i.e. its <tt class="docutils literal">from_python()</tt> method is called
first, <tt class="docutils literal">to_python()</tt> is called last, after all validators in the list.</li>
<li>SQLiteConnection's parameter <tt class="docutils literal">use_table_info</tt> became boolean with default
value True; this means the default schema parser is now based on <tt class="docutils literal">PRAGMA
table_info()</tt>.</li>
<li>Major API change: attribute <tt class="docutils literal">dirty</tt> was moved to sqlmeta.</li>
</ul>
</div>
</div>
<div class="section" id="sqlobject-0-13-1">
<h1>SQLObject 0.13.1</h1>
<p>Released 15 Oct 2010.</p>
<ul class="simple">
<li>A bug was fixed in a subtle case when a per-instance connection is not
passed to validators.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-13-0">
<h1>SQLObject 0.13.0</h1>
<p>Released 11 Aug 2010.</p>
<div class="section" id="id2">
<h2>Features & Interface</h2>
<ul class="simple">
<li>SQLObject instances that don't have a per-instance connection can be
pickled and unpickled.</li>
<li>Validators became stricter: StringCol and UnicodeCol now accept only str,
unicode or an instance of a class that implements __unicode__ (but not
__str__ because every object has a __str__ method); BoolCol accepts only
bool or int or an instance of a class that implements __nonzero__; IntCol
accepts int, long or an instance of a class that implements __int__ or
__long__; FloatCol accepts float, int, long or an instance of a class
that implements __float__, __int__ or __long__.</li>
<li>Added a connection class for rdbhost.com (commercial Postgres-over-Web
service).</li>
</ul>
</div>
<div class="section" id="small-features">
<h2>Small Features</h2>
<ul class="simple">
<li>Added TimedeltaCol; currently it's only implemented on PostgreSQL as an
INTERVAL type.</li>
<li>Do not pollute the base sqlmeta class to allow Style to set idName. In
the case of inherited idName inherited value takes precedence; to allow
Style to set idName reset inherited idName to None.</li>
<li>Better handling of circular dependencies in sqlobject-admin -
do not include the class in the list of other classes.</li>
<li>Renamed db_encoding to dbEncoding in UnicodeStringValidator.</li>
<li>A new parameter <tt class="docutils literal">sslmode</tt> was added to PostgresConnection.</li>
<li>Removed SQLValidator - its attemptConvert was never called because in
FormEncode it's named attempt_convert.</li>
</ul>
</div>
</div>
<div class="section" id="sqlobject-0-12-5">
<h1>SQLObject 0.12.5</h1>
<ul class="simple">
<li><tt class="docutils literal">backend</tt> parameter was renamed to <tt class="docutils literal">driver</tt>. To preserve backward
compatibility <tt class="docutils literal">backend</tt> is still recognized and will be recognized
for some time.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-12-4">
<h1>SQLObject 0.12.4</h1>
<p>Released 5 May 2010.</p>
<ul class="simple">
<li>Bugs were fixed in calling from_python().</li>
<li>A bugfix was ported from <a href="#sqlobject-0-11-6" class="reference internal">SQLObject 0.11.6</a>.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-12-3">
<h1>SQLObject 0.12.3</h1>
<p>Released 11 Apr 2010.</p>
<ul class="simple">
<li>A bugfix ported from <a href="#sqlobject-0-11-5" class="reference internal">SQLObject 0.11.5</a>.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-12-2">
<h1>SQLObject 0.12.2</h1>
<p>Released 4 Mar 2010.</p>
<ul class="simple">
<li>Bugfixes ported from <a href="#sqlobject-0-11-4" class="reference internal">SQLObject 0.11.4</a>.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-12-1">
<h1>SQLObject 0.12.1</h1>
<p>Released 8 Jan 2010.</p>
<ul class="simple">
<li>Fixed three bugs in PostgresConnection.</li>
<li>A number of changes ported from <a href="#sqlobject-0-11-3" class="reference internal">SQLObject 0.11.3</a>.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-12">
<h1>SQLObject 0.12</h1>
<p>Released 20 Oct 2009.</p>
<div class="section" id="id3">
<h2>Features & Interface</h2>
<ul class="simple">
<li>.selectBy(), .deleteBy() and .by*() methods pass all values through
.from_python(), not only unicode.</li>
<li>The user can choose a DB API driver for SQLite by using a <tt class="docutils literal">backend</tt>
parameter in DB URI or SQLiteConnection that can be a comma-separated
list of backend names. Possible backends are: <tt class="docutils literal">pysqlite2</tt> (alias
<tt class="docutils literal">sqlite2</tt>), <tt class="docutils literal">sqlite3</tt>, <tt class="docutils literal">sqlite</tt> (alias <tt class="docutils literal">sqlite1</tt>). Default is
to test pysqlite2, sqlite3 and sqlite in that order.</li>
<li>The user can choose a DB API driver for PostgreSQL by using a <tt class="docutils literal">backend</tt>
parameter in DB URI or PostgresConnection that can be a comma-separated
list of backend names. Possible backends are: <tt class="docutils literal">psycopg2</tt>, <tt class="docutils literal">psycopg1</tt>,
<tt class="docutils literal">psycopg</tt> (tries psycopg2 and psycopg1), <tt class="docutils literal">pygresql</tt>. Default is
<tt class="docutils literal">psycopg</tt>.
WARNING: API change! PostgresConnection's parameter
<tt class="docutils literal">usePygresql</tt> is now replaced with <tt class="docutils literal">backend=pygresql</tt>.</li>
<li>The user can choose a DB API driver for MSSQL by using a <tt class="docutils literal">backend</tt>
parameter in DB URI or MSSQLConnection that can be a comma-separated
list of backend names. Possible backends are: <tt class="docutils literal">adodb</tt> (alias
<tt class="docutils literal">adodbapi</tt>) and <tt class="docutils literal">pymssql</tt>. Default is to test adodbapi and pymssql
in that order.</li>
<li>alternateMethodName is defined for all unique fields, not only alternateID;
this makes SQLObject create .by*() methods for all unique fields.</li>
<li>SET client_encoding for PostgreSQL to the value of <tt class="docutils literal">charset</tt> parameter
in DB URI or PostgresConnection.</li>
<li>TimestampCol() can be instantiated without any defaults, in this case
default will be None (good default for TIMESTAMP columns in MySQL).</li>
</ul>
</div>
<div class="section" id="id4">
<h2>Small Features</h2>
<ul class="simple">
<li>Imported DB API drivers are stored as connection instance variables, not
in global variables; this allows to use different DB API drivers at the
same time; for example, PySQLite2 and sqlite3.</li>
<li>Removed all deprecated attributes and functions.</li>
<li>Removed the last remained string exceptions.</li>
</ul>
</div>
</div>
<div class="section" id="sqlobject-0-11-6">
<h1>SQLObject 0.11.6</h1>
<p>Released 5 May 2010.</p>
<ul class="simple">
<li>A bug was fixed in SQLiteConnection.columnsFromSchema(): pass None as
size/precision to DecimalCol; DecimalCol doesn't allow default values (to
force user to pass meaningful values); but columnsFromSchema() doesn't
implement proper parsing of column details.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-11-5">
<h1>SQLObject 0.11.5</h1>
<p>Released 11 Apr 2010.</p>
<ul class="simple">
<li>Fixed a bug in replacing _connection in a case when no previous
_connection has been set.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-11-4">
<h1>SQLObject 0.11.4</h1>
<p>Released 4 Mar 2010.</p>
<ul class="simple">
<li>Fixed a bug in inheritance - if creation of the row failed and if the
connection is not a transaction and is in autocommit mode - remove
parent row(s).</li>
<li>Do not set _perConnection flag if get() or _init() is passed the same
connection; this is often the case with select().</li>
</ul>
</div>
<div class="section" id="sqlobject-0-11-3">
<h1>SQLObject 0.11.3</h1>
<p>Released 8 Jan 2010.</p>
<ul class="simple">
<li>Fixed a bug in col.py and dbconnection.py - if dbEncoding is None suppose
it's 'ascii'.</li>
<li>Fixed a bug in FirebirdConnection.</li>
<li>The cache culling algorithm was enhanced to eliminate memory leaks by
removing references to dead objects; tested on a website that runs around
4 million requests a day.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-11-2">
<h1>SQLObject 0.11.2</h1>
<p>Released 30 Sep 2009.</p>
<ul class="simple">
<li>Fixed a bug in logging to console - convert unicode to str.</li>
<li>Fixed an obscure bug in ConnectionHub triggered by an SQLObject class
whose instances can be coerced to boolean False.</li>
</ul>
</div>
<div class="section" id="sqlobject-0-11-1">
<h1>SQLObject 0.11.1</h1>
<p>Released 20 Sep 2009.</p>
<ul class="simple">
<li>Fixed a bug: Sybase tables with identity column fire two identity_inserts.</li>
<li>Fixed a bug: q.startswith(), q.contains() and q.endswith() escape (with a
backslash) all special characters (backslashes, underscores and percent
signs).</li>
</ul>
</div>
<div class="section" id="sqlobject-0-11-0">
<h1>SQLObject 0.11.0</h1>
<p>Released 12 Aug 2009.</p>
<div class="section" id="id5">
<h2>Features & Interface</h2>
<ul class="simple">
<li>Dropped support for Python 2.3. The minimal version of Python for
SQLObject is 2.4 now.</li>
<li>Dropped support for PostgreSQL 7.2. The minimal supported version of
PostgreSQL is 7.3 now.</li>
<li>New magic attribute <tt class="docutils literal">j</tt> similar to <tt class="docutils literal">q</tt> was added that
automagically does join with the other table in MultipleJoin or
RelatedJoin.</li>
<li>SQLObject can now create and drop a database in MySQL, PostgreSQL, SQLite
and Firebird/Interbase.</li>
<li>Added some support for schemas in PostgreSQL.</li>
<li>Added DecimalStringCol - similar to DecimalCol but stores data as strings
to work around problems in some drivers and type affinity problem in
SQLite.</li>
<li>Added sqlobject.include.hashcol.HashCol - a column type that automatically
hashes anything going into it, and returns out an object that hashes
anything being compared to itself. Basically, it's good for really simple
one-way password fields, and it even supports the assignment of None to
indicate no password set. By default, it uses the md5 library for
hashing, but this can be changed in a HashCol definition.</li>
<li>RowDestroyedSignal and RowUpdatedSignal were added.</li>
</ul>
</div>
<div class="section" id="minor-features">
<h2>Minor features</h2>
<ul class="simple">
<li>Use reversed() in manager/command.py instead of .__reversed__().</li>
<li>Minor change in logging to console - logger no longer stores the output
file, it gets the file from module sys every time by name; this means
logging will use new sys.stdout (or stderr) in case the user changed
them.</li>
<li>Changed the order of testing of SQLite modules - look for external
PySQLite2 before sqlite3.</li>
</ul>
<p><a href="News3.html" class="reference external">Older news</a></p>
<a href="https://sourceforge.net/projects/sqlobject" class="reference external image-reference"><img src="https://sourceforge.net/sflogo.php?group_id=74338&type=10" alt="Get SQLObject at SourceForge.net. Fast, secure and Free Open Source software downloads" style="width: 80px; height: 15px;" class="noborder align-center"></a>
</div>
</div>
</div></div>
<div id="footer">
<p style="float: left;">
built with
<a href="http://lesscode.org/projects/pudge/">pudge/0.1.3</a> |
original design by
<a href="http://blog.ratterobert.com/">ratter / robert</a>
</p>
<div>
<br> <!--
<a name="search">
<form method="get" id="searchform"
action="http://lesscode.org/blog/index.php">
<div>
<input type="text" value="" name="s" id="s" />
<input type="submit" id="searchsubmit" value="Search" />
</div>
</form>
</a> -->
<br>
</div>
</div>
</div>
</body>
</html>
|
