delta/python-packages/sqlalchemy.git/test/sql/query.py, branch 2020_tutorial

- 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.

- Further fixes to the "percent signs and spaces in column/table

2009-01-18T17:08:28+00:00

names" functionality. [ticket:1284]
- Still doesn't work for PG/MySQL, which unfortunately would require
post_process_text() calls all over the place.  Perhaps % escaping
can be assembled into IdentifierPreparer.quote() since that's where
identifier names are received.

- 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.

- mysql, postgres: "%" signs in text() constructs are automatically escaped to "%%".

2009-01-02T21:24:17+00:00

Because of the backwards incompatible nature of this change,
a warning is emitted if '%%' is detected in the string.  [ticket:1267]

- RowProxy objects can be used in place of dictionary arguments

2008-12-28T20:58:38+00:00

sent to connection.execute() and friends.  [ticket:935]

Major refactoring of the MSSQL dialect. Thanks zzzeek.

2008-12-22T20:20:55+00:00

Includes simplifying the IDENTITY handling and the exception handling. Also
includes a cleanup of the connection string handling for pyodbc to favor
the DSN syntax.

- _execute_clauseelement() goes back to being

2008-12-17T23:09:51+00:00

a private method.  Subclassing Connection
is not needed now that ConnectionProxy
is available.
- tightened the interface for the various _execute_XXX()
methods to reduce ambiguity
- __distill_params() no longer creates artificial [{}] entry,
blank dict is no longer passed through to do_execute()
in any case unless explicitly sent from the outside
as in connection.execute("somestring"), {})
- fixed a few old sql.query tests which were doing that
- removed needless do_execute() from mysql dialect
- fixed charset param not properly being sent to
_compat_fetchone() in mysql

Modified fails_on testing decorator to take a reason for the failure.

2008-12-12T03:41:05+00:00

This should assist with helping to document the reasons for testing failures.
Currently unspecified failures are defaulted to 'FIXME: unknown'.

Global propigate -> propagate change to correct spelling. Additionally found a couple of insures that should be ensure.

2008-11-09T01:53:08+00:00