delta/python-packages/sqlalchemy.git/lib/sqlalchemy/init.py, branch pr/288

- create space for 1.1.0b2

2016-06-20T15:42:53+00:00

Change-Id: I8815a68dcf6e5d27f3f82b02f939f72d9a412337

Add TABLESAMPLE clause support.

2016-06-15T18:42:08+00:00

The TABLESAMPLE clause allows randomly selecting an approximate percentage
of rows from a table. At least DB2, Microsoft SQL Server and recent
Postgresql support this standard clause.

Fixes: #3718
Change-Id: I3fb8b9223e12a57100df30876b461884c58d72fa
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/277

Support "blank" schema when MetaData.schema is set

2016-05-18T15:43:38+00:00

Previously, it was impossible to have a Table that has
None for a schema name when the "schema" parameter on
MetaData was set.  A new symbol sqlalchemy.schema.BLANK_SCHEMA
is added which indicates that the schema name should unconditionally
be set to None.  In particular, this value must be passed within
cross-schema foreign key reflection, so that a Table which
is in the "default" schema can be represented properly.

Fixes: #3716
Change-Id: I3d24f99c22cded206c5379fd32a225e74edb7a8e

- Added :meth:`.Select.lateral` and related constructs to allow

2016-03-29T21:56:02+00:00

for the SQL standard LATERAL keyword, currently only supported
by Postgresql.  fixes #2857

- happy new year

2016-01-29T16:20:22+00:00

- calling str() on a core sql construct has been made more "friendly",

2016-01-19T21:47:16+00:00

when the construct contains non-standard sql elements such as
returning, array index operations, or dialect-specific or custom
datatypes.  a string is now returned in these cases rendering an
approximation of the construct (typically the postgresql-style
version of it) rather than raising an error. fixes #3631
- add within_group to top-level imports
- add eq_ignore_whitespace to sqlalchemy.testing imports

- Added :class:`.mysql.JSON` for MySQL 5.7. The JSON type provides

2016-01-06T17:47:48+00:00

persistence of JSON values in MySQL as well as basic operator support
of "getitem" and "getpath", making use of the ``JSON_EXTRACT``
function in order to refer to individual paths in a JSON structure.
fixes #3547
- Added a new type to core :class:`.types.JSON`.  This is the
base of the PostgreSQL :class:`.postgresql.JSON` type as well as that
of the new :class:`.mysql.JSON` type, so that a PG/MySQL-agnostic
JSON column may be used.  The type features basic index and path
searching support.
fixes #3619
- reorganization of migration docs etc. to try to refer both to
the fixes to JSON that helps Postgresql while at the same time
indicating these are new features of the new base JSON type.
- a rework of the Array/Indexable system some more, moving things
that are specific to Array out of Indexable.
- new operators for JSON indexing added to core so that these can
be compiled by the PG and MySQL dialects individually
- rename sqltypes.Array to sqltypes.ARRAY - as there is no generic
Array implementation, this is an uppercase type for now, consistent
with the new sqltypes.JSON type that is also not a generic implementation.
There may need to be some convention change to handle the case of
datatypes that aren't generic, rely upon DB-native implementations,
but aren't necessarily all named the same thing.

- build out a new base type for Array, as well as new any/all operators

2015-08-25T22:24:46+00:00

- any/all work for Array as well as subqueries, accepted by MySQL
- Postgresql ARRAY now subclasses Array
- fixes #3516

- Organize the tree for 1.1

2015-07-24T22:27:45+00:00

- An adjustment to the new Postgresql feature of reflecting storage

2015-07-24T16:24:18+00:00

options and USING of :ticket:`3455` released in 1.0.6,
to disable the feature for Postgresql versions < 8.2 where the
``reloptions`` column is not provided; this allows Amazon Redshift
to again work as it is based on an 8.0.x version of Postgresql.
Fix courtesy Pete Hollobon.
references #3455

delta/python-packages/sqlalchemy.git/lib/sqlalchemy/__init__.py, branch pr/288