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
|
<!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>TODO</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">TODO</h1>
<ul>
<li><p class="first">RelatedJoin.hasOther(otherObject[.id])</p>
</li>
<li><p class="first">createParamsPre/Post:</p>
<pre class="literal-block">
class MyTable(SQLObject):
class sqlmeta:
createParamsPre = 'TEMPORARY IF NOT EXISTS'
createParamsPre = {temporary: True, ifNotExists: True,
'postgres': 'LOCAL'}
createParamsPost = 'ENGINE InnoDB'
createParamsPost = {'mysql': 'ENGINE InnoDB',
'postgres': 'WITH OIDS'}
</pre>
</li>
<li><p class="first">SQLObject.fastInsert().</p>
</li>
<li><p class="first">IntervalCol</p>
</li>
<li><p class="first">TimedeltaCol</p>
</li>
<li><p class="first">Cached join results.</p>
</li>
<li><p class="first">Invert tests isinstance(obj, (tuple, list)) to not isinstance(obj, basestr)
to allow any iterable.</p>
</li>
<li><p class="first">Always use .lazyIter().</p>
</li>
<li><p class="first">Optimize Iteration.next() - use cursor.fetchmany().</p>
</li>
<li><p class="first">Generators instead of loops (fetchall => fetchone).</p>
</li>
<li><p class="first">Cache columns in sqlmeta.getColumns(); reset the cache on add/del Column/Join.</p>
</li>
<li><p class="first">Make ConnectionHub a context manager instead of .doInTransaction().</p>
</li>
<li><p class="first">Make version_info a namedtuple.</p>
</li>
<li><p class="first">Expression columns - in SELECT but not in INSERT/UPDATE. Something like this:</p>
<pre class="literal-block">
class MyClass(SQLObject):
function1 = ExpressionCol(func.my_function(MyClass.q.col1))
function2 = ExpressionCol('sum(col2)')
</pre>
</li>
<li><p class="first">A hierarchy of exceptions. SQLObject should translate exceptions from
low-level drivers to a consistent set of high-level exceptions.</p>
</li>
<li><p class="first">Memcache.</p>
</li>
<li><p class="first">Refactor <tt class="docutils literal">DBConnection</tt> to use parameterized queries instead of
generating query strings.</p>
</li>
<li><p class="first">PREPARE/EXECUTE.</p>
</li>
<li><p class="first">Protect all .encode(), catch UnicodeEncode exceptions and reraise Invalid.</p>
</li>
<li><p class="first">More kinds of joins, and more powerful join results (closer to how
<cite>select</cite> works).</p>
</li>
<li><p class="first">Better joins - automatic joins in .select()
based on ForeignKey/MultipleJoin/RelatedJoin.</p>
</li>
<li><p class="first">Deprecate, then remove connectionForOldURI.</p>
</li>
<li><p class="first">Switch from setuptools to distribute.</p>
</li>
<li><p class="first">oursql MySQL bindings: <a href="https://github.com/python-oursql/oursql" class="reference external">https://github.com/python-oursql/oursql</a></p>
</li>
<li><p class="first">MySQL Connector/Python: <a href="https://dev.mysql.com/doc/connector-python/en/" class="reference external">https://dev.mysql.com/doc/connector-python/en/</a></p>
</li>
<li><p class="first">Pure Python Mysql Interface: <a href="https://github.com/nasi/MyPy" class="reference external">https://github.com/nasi/MyPy</a></p>
</li>
<li><p class="first">pg8000 driver: <a href="http://code.google.com/p/pg8000/" class="reference external">http://code.google.com/p/pg8000/</a></p>
</li>
<li><p class="first">py-postgresql driver: <a href="http://python.projects.postgresql.org/" class="reference external">http://python.projects.postgresql.org/</a></p>
</li>
<li><p class="first">pyfirebirdsql: <a href="https://github.com/nakagami/pyfirebirdsql" class="reference external">https://github.com/nakagami/pyfirebirdsql</a></p>
</li>
<li><p class="first">dict API: use getitem interface for column access instead of getattr; reserve
getattr for internal attributes only; this helps to avoid collisions with
internal attributes.</p>
</li>
<li><p class="first">Or move column values access to a separate namespace, e.g. .c:
row.c.column.</p>
</li>
<li><p class="first">More documentation.</p>
</li>
<li><p class="first">RSS 2.0 and Atom news feeds.</p>
</li>
<li><p class="first">Use <a href="http://www.webwareforpython.org/DBUtils" class="reference external">DBUtils</a>, especially SolidConnection.</p>
</li>
</ul>
<ul class="simple">
<li><tt class="docutils literal">_fromDatabase</tt> currently doesn't support IDs that don't fit into
the normal naming scheme. It should do so. You can still use
<tt class="docutils literal">_idName</tt> with <tt class="docutils literal">_fromDatabase</tt>.</li>
<li>More databases supported. There has been interest and some work in
the progress for Oracle. IWBN to have Informix and DB2 drivers.</li>
<li>Better transaction support -- right now you can use transactions
for the database, but objects aren't transaction-aware, so
non-database persistence won't be able to be rolled back.</li>
<li>Optimistic locking and other techniques to handle concurrency.</li>
<li>Profile of SQLObject performance to identify bottlenecks.</li>
<li>Increase hooks with FormEncode validation and form generation package, so
SQLObject classes (read: schemas) can be published for editing more
directly and easily. (First step: get Schema-generating method into
sqlmeta class)</li>
<li>Merge SQLObject.create*, .create*SQL methods with DBPI.create* methods.</li>
<li>Made SQLObject unicode-based instead of just unicode-aware. All internal
processing should be done with unicode strings, conversion to/from ascii
strings should happen for non-unicode DB API drivers.</li>
<li>Allow to override ConsoleWriter/LogWriter classes and makeDebugWriter
function.</li>
</ul>
<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 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>
|
