RelatedJoin.hasOther(otherObject[.id])
createParamsPre/Post:
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'}
SQLObject.fastInsert().
IntervalCol
TimedeltaCol
Cached join results.
Invert tests isinstance(obj, (tuple, list)) to not isinstance(obj, basestr) to allow any iterable.
Always use .lazyIter().
Optimize Iteration.next() - use cursor.fetchmany().
Generators instead of loops (fetchall => fetchone).
Cache columns in sqlmeta.getColumns(); reset the cache on add/del Column/Join.
Make ConnectionHub a context manager instead of .doInTransaction().
Make version_info a namedtuple.
Expression columns - in SELECT but not in INSERT/UPDATE. Something like this:
class MyClass(SQLObject): function1 = ExpressionCol(func.my_function(MyClass.q.col1)) function2 = ExpressionCol('sum(col2)')
A hierarchy of exceptions. SQLObject should translate exceptions from low-level drivers to a consistent set of high-level exceptions.
Memcache.
Refactor DBConnection to use parameterized queries instead of generating query strings.
PREPARE/EXECUTE.
Protect all .encode(), catch UnicodeEncode exceptions and reraise Invalid.
More kinds of joins, and more powerful join results (closer to how select works).
Better joins - automatic joins in .select() based on ForeignKey/MultipleJoin/RelatedJoin.
Deprecate, then remove connectionForOldURI.
Switch from setuptools to distribute.
oursql MySQL bindings: https://github.com/python-oursql/oursql
MySQL Connector/Python: https://dev.mysql.com/doc/connector-python/en/
Pure Python Mysql Interface: https://github.com/nasi/MyPy
pg8000 driver: http://code.google.com/p/pg8000/
py-postgresql driver: http://python.projects.postgresql.org/
pyfirebirdsql: https://github.com/nakagami/pyfirebirdsql
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.
Or move column values access to a separate namespace, e.g. .c: row.c.column.
More documentation.
RSS 2.0 and Atom news feeds.
Use DBUtils, especially SolidConnection.