delta/python-packages/sqlalchemy.git/test/sql/select.py, branch pullreq55

- unit tests have been migrated from unittest to nose.

2009-06-10T21:18:24+00:00

See README.unittests for information on how to run
the tests.  [ticket:970]

- sql

2009-05-29T18:56:50+00:00

    - Removed an obscure feature of execute() (including connection,
      engine, Session) whereby a bindparam() construct can be sent as
      a key to the params dictionary.  This usage is undocumented
      and is at the core of an issue whereby the bindparam() object
      created implicitly by a text() construct may have the same
      hash value as a string placed in the params dictionary and
      may result in an inappropriate match when computing the final
      bind parameters.   Internal checks for this condition would
      add significant latency to the critical task of parameter
      rendering, so the behavior is removed.  This is a backwards
      incompatible change for any application that may have been
      using this feature, however the feature has never been
      documented.

extract() is now dialect-sensitive and supports SQLite and others.

2009-03-30T20:41:48+00:00

- Lazy loader will not use get() if the "lazy load"

2009-03-29T21:21:10+00:00

SQL clause matches the clause used by get(), but
contains some parameters hardcoded.  Previously
the lazy strategy would fail with the get().  Ideally
get() would be used with the hardcoded parameters
but this would require further development.
[ticket:1357]

- An alias() of a select() will convert to a "scalar subquery"

2009-03-21T16:12:37+00:00

when used in an unambiguously scalar context, i.e. it's used
in a comparison operation.  This applies to
the ORM when using query.subquery() as well.

- Fixed missing _label attribute on Function object, others

2009-02-01T18:20:20+00:00

when used in a select() with use_labels (such as when used
in an ORM column_property()).  [ticket:1302]

- _CalculatedClause is gone

2009-01-28T01:28:20+00:00

- Function rolls the various standalone execution functionality of CC into itself,
accesses its internal state more directly
- collate just uses _BinaryExpression, don't know why it didn't do this already
- added new _Case construct, compiles directly
- the world is a happier place

- Improved the methodology to handling percent signs in column

2009-01-14T19:55:20+00:00

names from [ticket:1256].  Added more tests.  MySQL and
Postgres dialects still do not issue correct CREATE TABLE
statements for identifiers with percent signs in them.

- Columns can again contain percent signs within their

2008-12-23T01:22:54+00:00

names. [ticket:1256]

- Query() can be passed a "composite" attribute

2008-12-18T16:50:49+00:00

as a column expression and it will be expanded.
Somewhat related to [ticket:1253].
- Query() is a little more robust when passed
various column expressions such as strings,
clauselists, text() constructs (which may mean
it just raises an error more nicely).
- select() can accept a ClauseList as a column
in the same way as a Table or other selectable
and the interior expressions will be used as
column elements. [ticket:1253]
- removed erroneous FooTest from test/orm/query

-This line, and those below, will be ignored--

M    test/orm/query.py
M    test/orm/mapper.py
M    test/sql/select.py
M    lib/sqlalchemy/orm/query.py
M    lib/sqlalchemy/sql/expression.py
M    CHANGES