delta/python-packages/sqlalchemy.git/lib/sqlalchemy/engine/reflection.py, branch pr_github_383 github.com: zzzeek/sqlalchemy.git Ensure Oracle index w/ col DESC etc. is reflected 2017-08-14T05:18:06+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-08-11T19:52:28+00:00 1a990ee33239aa275567cb926a5b421b2087294b Fixed bug where an index reflected under Oracle with an expression like "column DESC" would not be returned, if the table also had no primary key, as a result of logic that attempts to filter out the index implicitly added by Oracle onto the primary key columns. Reworked the "filter out the primary key index" logic in oracle get_indexes() to be clearer. This changeset also adds an internal check to ColumnCollection to accomodate for the case of a column being added twice, as well as adding a private _table argument to Index such that reflection can specify the Table explicitly. The _table argument can become part of public API in a later revision or release if needed. Change-Id: I745711e03b3e450b7f31185fc70e10d3823063fa Fixes: #4042 
Fixed bug where an index reflected under Oracle with an expression like
"column DESC" would not be returned, if the table also had no primary
key, as a result of logic that attempts to filter out the
index implicitly added by Oracle onto the primary key columns.

Reworked the "filter out the primary key index" logic in oracle
get_indexes() to be clearer.

This changeset also adds an internal check to ColumnCollection
to accomodate for the case of a column being added twice,
as well as adding a private _table argument to Index such that
reflection can specify the Table explicitly.  The _table
argument can become part of public API in a later revision
or release if needed.

Change-Id: I745711e03b3e450b7f31185fc70e10d3823063fa
Fixes: #4042
Implement comments for tables, columns 2017-03-17T18:02:15+00:00 Frazer McLean frazer@frazermclean.co.uk 2016-06-11T19:47:33+00:00 fadb8d61babb76ef7bdbc98279096a8900c7328d Added support for SQL comments on :class:`.Table` and :class:`.Column` objects, via the new :paramref:`.Table.comment` and :paramref:`.Column.comment` arguments. The comments are included as part of DDL on table creation, either inline or via an appropriate ALTER statement, and are also reflected back within table reflection, as well as via the :class:`.Inspector`. Supported backends currently include MySQL, Postgresql, and Oracle. Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com> Fixes: #1546 Change-Id: Ib90683850805a2b4ee198e420dc294f32f15d35d 
Added support for SQL comments on :class:`.Table` and :class:`.Column`
objects, via the new :paramref:`.Table.comment` and
:paramref:`.Column.comment` arguments.   The comments are included
as part of DDL on table creation, either inline or via an appropriate
ALTER statement, and are also reflected back within table reflection,
as well as via the :class:`.Inspector`.   Supported backends currently
include MySQL, Postgresql, and Oracle.

Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Fixes: #1546
Change-Id: Ib90683850805a2b4ee198e420dc294f32f15d35d
Accept FetchedValue, text() for column "default" value 2017-02-01T22:00:42+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-02-01T21:25:31+00:00 388d8db68d0db6f38e72d60386023c9eef263034 Fixed bug whereby the :meth:`.DDLEvents.column_reflect` event would not allow a non-textual expression to be passed as the value of the "default" for the new column, such as a :class:`.FetchedValue` object to indicate a generic triggered default or a :func:`.sql.expression.text` construct. Clarified the documentation in this regard as well. Fixes: #3905 Change-Id: I829796c3e9f87f375149bebee7eef133a6876d4d 
Fixed bug whereby the :meth:`.DDLEvents.column_reflect` event would not
allow a non-textual expression to be passed as the value of the
"default" for the new column, such as a :class:`.FetchedValue`
object to indicate a generic triggered default or a
:func:`.sql.expression.text` construct.  Clarified the documentation
in this regard as well.

Fixes: #3905

Change-Id: I829796c3e9f87f375149bebee7eef133a6876d4d
update for 2017 copyright 2017-01-04T17:39:24+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-01-04T17:39:24+00:00 64e72b58fd74db0c5c87407c824d08ad699e5e8e Change-Id: I4e8c2aa8fe817bb2af8707410fa0201f938781de 
Change-Id: I4e8c2aa8fe817bb2af8707410fa0201f938781de
Add _extend_on deduplicating set for metadata.reflect() 2016-11-23T15:31:56+00:00 Mike Bayer mike_mp@zzzcomputing.com 2016-11-23T14:14:02+00:00 55ad10370f9eb50795e136aac595193168982e92 The "extend_existing" option of :class:`.Table` reflection would cause indexes and constraints to be doubled up in the case that the parameter were used with :meth:`.MetaData.reflect` (as the automap extension does) due to tables being reflected both within the foreign key path as well as directly. A new de-duplicating set is passed through within the :meth:`.MetaData.reflect` sequence to prevent double reflection in this way. Change-Id: Ibf6650c1e76a44ccbe15765fd79df2fa53d6bac7 Fixes: #3861 
The "extend_existing" option of :class:`.Table` reflection would
cause indexes and constraints to be doubled up in the case that the parameter
were used with :meth:`.MetaData.reflect` (as the automap extension does)
due to tables being reflected both within the foreign key path as well
as directly.  A new de-duplicating set is passed through within the
:meth:`.MetaData.reflect` sequence to prevent double reflection in this
way.

Change-Id: Ibf6650c1e76a44ccbe15765fd79df2fa53d6bac7
Fixes: #3861
spelling: Postgresql -> PostgreSQL 2016-10-08T17:42:50+00:00 Ville Skyttä ville.skytta@iki.fi 2016-10-07T10:18:58+00:00 8c2c464cb8e1b40f90f544295afbf9a83b372eb7 






Implemented CHECK constraint reflection for SQLite and PostgreSQL
2016-06-01T16:57:36+00:00

Alex Grönholm
alex.gronholm@nextday.fi

2016-04-11T21:01:42+00:00

a8e7bb8782ca8fd858ac036082104b4ac2991cfc

Co-Authored-By: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: Ie6cf2d2958d1c567324db9e08fef2d3186e97350
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/80





Co-Authored-By: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: Ie6cf2d2958d1c567324db9e08fef2d3186e97350
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/80







Support "blank" schema when MetaData.schema is set
2016-05-18T15:43:38+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-05-18T15:07:02+00:00

c124fa36d5af2c85c87c51d24e92387adffbe3d2

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





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







- happy new year
2016-01-29T16:20:22+00:00

Mike Bayer
mike_mp@zzzcomputing.com

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

859379e2fcc4506d036700ba1eca4c0ae526a8ee












- reorganize schema_translate_map to be succinct and gain the performance
2016-01-11T21:44:28+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-01-11T19:35:56+00:00

6fbfadc7388dad4576ad99ce597e0878ee1d297f

back by using an attrgetter for the default case





back by using an attrgetter for the default case