Mike Bayer [Sat, 8 May 2010 20:25:30 +0000 (16:25 -0400)]
- expr.in_() now accepts a text() construct as the argument.
Grouping parenthesis are added automatically, i.e. usage
is like `col.in_(text("select id from table"))`.
[ticket:1793]
Mike Bayer [Sat, 8 May 2010 19:08:48 +0000 (15:08 -0400)]
- the SqlSoup constructor accepts a `base` argument which specifies
the base class to use for mapped classes, the default being
`object`. [ticket:1783]
Mike Bayer [Wed, 28 Apr 2010 17:30:25 +0000 (17:30 +0000)]
- oracle_xe 5 doesn't accept a Python unicode object in
its connect string in normal Python 2.x mode - so we coerce
to str() directly. non-ascii characters aren't supported
in connect strings here since we don't know what encoding
we could use. [ticket:1670]
Mike Bayer [Mon, 26 Apr 2010 22:31:05 +0000 (18:31 -0400)]
- Added a label to the query used within has_table() and
has_sequence() to work with older versions of Firebird
that don't provide labels for result columns. [ticket:1521]
Mike Bayer [Mon, 26 Apr 2010 20:55:11 +0000 (16:55 -0400)]
- Fixed regression introduced in 0.6.0 involving improper
history accounting on mutable attributes. Essentially
reversing r6b2b4fcd4799 and getting it covered.
[ticket:1782]
Mike Bayer [Mon, 19 Apr 2010 21:35:16 +0000 (17:35 -0400)]
- Added a check for cx_oracle versions lower than version 5,
in which case the incompatible "output type handler" won't
be used. This will impact decimal accuracy and some
unicode handling issues. [ticket:1775]
Mike Bayer [Fri, 16 Apr 2010 21:01:50 +0000 (17:01 -0400)]
when raising about columns not present, include the name of the property it's trying to configure,
to eliminate confusion over attributes not properly placed inside of a relationship().
Mike Bayer [Thu, 15 Apr 2010 23:05:41 +0000 (19:05 -0400)]
- Added get_pk_constraint() to reflection.Inspector, similar
to get_primary_keys() except returns a dict that includes the
name of the constraint, for supported backends (PG so far).
[ticket:1769]
- Postgresql reflects the name of primary key constraints,
if one exists. [ticket:1769]
Mike Bayer [Thu, 15 Apr 2010 04:13:48 +0000 (00:13 -0400)]
- beef up the --reversetop test option to embed RandomSet throughout the ORM
- with m2m we have to go back to the previous approach of having both sides of
the DP fire off, tracking each pair of objects. history may not be consistently present
in one side or the other
- this revealed a whole lot of issues with self-referential m2m, which are fixed
Mike Bayer [Tue, 13 Apr 2010 00:20:50 +0000 (20:20 -0400)]
further testing reveals that cursor.rowcount is only called with update/delete and DDL,
and also that FB's cursor.rowcount is a little expensive, but not dramatically.
added a test to ensure cursor.rowcount is only called on update/delete.
the current default for firebird enable_rowcount is now True, leaving all the
options to turn it off etc..
Mike Bayer [Sun, 11 Apr 2010 20:37:49 +0000 (16:37 -0400)]
- The functionality of result.rowcount is now disabled
by default, and can be re-enabled using the 'enable_rowcount'
flag with create_engine(), as well as the 'enable_rowcount'
execution context flag on a per-execute basis. This because
cursor.rowcount requires cursor access (can't be evaluated
lazily since the result auto-closes) and also incurs an
expensive round-trip.
Mike Bayer [Sun, 11 Apr 2010 19:37:20 +0000 (15:37 -0400)]
- added a test for the solution in [ticket:1757].
- this does imply that a lot of the "test the RowProxy" tests in sql/test_query might be better off in engine/test_execute or perhaps engine/test_resultproxy
Mike Bayer [Sun, 11 Apr 2010 16:03:41 +0000 (12:03 -0400)]
- somejoin.select(fold_equivalents=True) is no longer
deprecated, and will eventually be rolled into a more
comprehensive version of the feature for [ticket:1729].
Mike Bayer [Sat, 10 Apr 2010 23:21:54 +0000 (19:21 -0400)]
- starting to groom the branch for its inclusion
- one-to-many relationships now maintain a list of positive
parent-child associations within the flush, preventing
previous parents marked as deleted from cascading a
delete or NULL foreign key set on those child objects,
despite the end-user not removing the child from the old
association. [ticket:1764]
- re-established Preprocess as unique on their arguments,
as they were definitely duped in inheritance scenarios
- added a "memo" feature to UOWTransaction which represents the usual
pattern of using the .attributes collection
- added the test case from [ticket:1081] into perf/