delta/python-packages/sqlalchemy.git/test/sql/test_query.py, branch origin

Add SQL Server CI coverage

2017-08-31T21:20:26+00:00

Change-Id: Ida0d01ae9bcc0573b86e24fddea620a38c962822

Add new "expanding" feature to bindparam()

2017-04-07T19:53:49+00:00

Added a new kind of :func:`.bindparam` called "expanding".  This is
for use in ``IN`` expressions where the list of elements is rendered
into individual bound parameters at statement execution time, rather
than at statement compilation time.  This allows both a single bound
parameter name to be linked to an IN expression of multiple elements,
as well as allows query caching to be used with IN expressions.  The
new feature allows the related features of "select in" loading and
"polymorphic in" loading to make use of the baked query extension
to reduce call overhead.   This feature should be considered to be
**experimental** for 1.2.

Fixes: #3953
Change-Id: Ie708414a3ab9c0af29998a2c7f239ff7633b1f6e

Add "empty in" strategies; default to "static"

2017-03-14T21:01:07+00:00

The longstanding behavior of the :meth:`.Operators.in_` and
:meth:`.Operators.not_in_` operators emitting a warning when
the right-hand condition is an empty sequence has been revised;
a new flag :paramref:`.create_engine.empty_in_strategy` allows an
empty "IN" expression to generate a simple boolean expression, or
to invoke the previous behavior of dis-equating the expression to
itself, with or without a warning.  The default behavior is now
to emit the simple boolean expression, allowing an empty IN to
be evaulated without any performance penalty.

Change-Id: I65cc37f2d7cf65a59bf217136c42fee446929352
Fixes: #3907

Make all tests to be PEP8 compliant

2017-02-07T16:21:56+00:00

tested using pycodestyle version 2.2.0

Fixes: #3885
Change-Id: I5df43adc3aefe318f9eeab72a078247a548ec566
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/343

Support python3.6

2017-01-13T15:57:41+00:00

Corrects some warnings and adds tox config.  Adds DeprecationWarning
to the error category.   Large sweep for string literals w/ backslashes
as this is common in docstrings

Co-authored-by: Andrii Soldatenko
Fixes: #3886
Change-Id: Ia7c838dfbbe70b262622ed0803d581edc736e085
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/337

- break out critical aspects of test_query into their own tests

2015-09-27T16:09:24+00:00

finally, test_resultset and test_insert_exec.   Update all
idioms within these.

- Fixed regression where new methods on :class:`.ResultProxy` used

2015-07-19T20:32:31+00:00

by the ORM :class:`.Query` object (part of the performance
enhancements of :ticket:`3175`) would not raise the "this result
does not return rows" exception in the case where the driver
(typically MySQL) fails to generate cursor.description correctly;
an AttributeError against NoneType would be raised instead.
fixes #3481

- pg8000 very annoyingly complaining here, use total literal

2015-07-19T20:01:02+00:00

- Fixed regression where :meth:`.ResultProxy.keys` would return

2015-07-19T16:20:00+00:00

un-adjusted internal symbol names for "anonymous" labels, which
are the "foo_1" types of labels we see generated for SQL functions
without labels and similar.  This was a side effect of the
performance enhancements implemented as part of references #918.
fixes #3483

- ensure that the keys we put into the parameters dictionary

2015-04-08T16:14:56+00:00

for an insert from select are the string names, and not
the Column objects.  The MSSQL dialect in particular relies upon
checking for these keys in params to know if identity insert
should be on.  references #3360