delta/python-packages/sqlalchemy.git/lib/sqlalchemy/sql, branch pr/39

Super-minor doc fix

2013-10-28T22:26:37+00:00

Merge branch 'master' of github.com:ijl/sqlalchemy into merge_2183

2013-10-25T21:01:38+00:00

- add migration notes for [ticket:2838]

2013-10-24T20:13:32+00:00

- have TypeDecorator use process_bind_param for literal values if no
process_literal_param is set

An overhaul of expression handling for special symbols particularly

2013-10-23T21:44:52+00:00

with conjunctions, e.g.
``None`` :func:`.expression.null` :func:`.expression.true`
:func:`.expression.false`, including consistency in rendering NULL
in conjunctions, "short-circuiting" of :func:`.and_` and :func:`.or_`
expressions which contain boolean constants, and rendering of
boolean constants and expressions as compared to "1" or "0" for backends
that don't feature ``true``/``false`` constants. [ticket:2804]

- A :func:`.bindparam` construct with a "null" type (e.g. no type

2013-10-21T20:49:46+00:00

specified) is now copied when used in a typed expression, and the
new copy is assigned the actual type of the compared column.  Previously,
this logic would occur on the given :func:`.bindparam` in place.
Additionally, a similar process now occurs for :func:`.bindparam` constructs
passed to :meth:`.ValuesBase.values` for a :class:`.Insert` or
:class:`.Update` construct. [ticket:2850]

- Fixed bug where :func:`.type_coerce` would not interpret ORM

2013-10-21T19:06:41+00:00

elements with a ``__clause_element__()`` method properly.
[ticket:2849]

- The typing system now handles the task of rendering "literal bind" values,

2013-10-20T20:59:56+00:00

e.g. values that are normally bound parameters but due to context must
be rendered as strings, typically within DDL constructs such as
CHECK constraints and indexes (note that "literal bind" values
become used by DDL as of :ticket:`2742`).  A new method
:meth:`.TypeEngine.literal_processor` serves as the base, and
:meth:`.TypeDecorator.process_literal_param` is added to allow wrapping
of a native literal rendering method. [ticket:2838]
- enhance _get_colparams so that we can send flags like literal_binds into
INSERT statements
- add support in PG for inspecting standard_conforming_strings
- add a new series of roundtrip tests based on INSERT of literal plus SELECT
for basic literal rendering in dialect suite

- add a type_coerce() step within Enum, Boolean to the CHECK constraint,

2013-10-20T20:25:46+00:00

so that the custom type isn't exposed to an operation that is against the
"impl" type's constraint, [ticket:2842]
- this change showed up as some recursion overflow in pickling with labels,
add a __reduce__() there....pickling of expressions is less and less something
that's very viable...

- The :meth:`.Table.tometadata` method now produces copies of

2013-10-19T00:01:45+00:00

all :attr:`.SchemaItem.info` dictionaries from all :class:`.SchemaItem`
objects within the structure including columns, constraints,
foreign keys, etc.   As these dictionaries
are copies, they are independent of the original dictionary.
Previously, only the ``.info`` dictionary of :class:`.Column` was transferred
within this operation, and it was only linked in place, not copied.
[ticket:2716]

The ``.unique`` flag on :class:`.Index` could be produced as ``None``

2013-10-14T18:53:28+00:00

if it was generated from a :class:`.Column` that didn't specify ``unique``
(where it defaults to ``None``).  The flag will now always be ``True`` or
``False``. [ticket:2825]