delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/postgresql, branch review/mike_bayer/tutorial20 github.com: zzzeek/sqlalchemy.git Apply underscore naming to several more operators 2020-10-30T14:02:29+00:00 jonathan vanasco jonathan@2xlp.com 2020-10-28T18:35:39+00:00 9ddbd585a62ff1ad56e9ee6fef5898ced1932a88 The operator changes are: * `isfalse` is now `is_false` * `isnot_distinct_from` is now `is_not_distinct_from` * `istrue` is now `is_true` * `notbetween` is now `not_between` * `notcontains` is now `not_contains` * `notendswith` is now `not_endswith` * `notilike` is now `not_ilike` * `notlike` is now `not_like` * `notmatch` is now `not_match` * `notstartswith` is now `not_startswith` * `nullsfirst` is now `nulls_first` * `nullslast` is now `nulls_last` Because these are core operators, the internal migration strategy for this change is to support legacy terms for an extended period of time -- if not indefinitely -- but update all documentation, tutorials, and internal usage to the new terms. The new terms are used to define the functions, and the legacy terms have been deprecated into aliases of the new terms. Fixes: #5435 Change-Id: Ifbd7cb1cdda5981990243c4fc4b4ff467dc132ac 
The operator changes are:

* `isfalse` is now `is_false`
* `isnot_distinct_from` is now `is_not_distinct_from`
* `istrue` is now `is_true`
* `notbetween` is now `not_between`
* `notcontains` is now `not_contains`
* `notendswith` is now `not_endswith`
* `notilike` is now `not_ilike`
* `notlike` is now `not_like`
* `notmatch` is now `not_match`
* `notstartswith` is now `not_startswith`
* `nullsfirst` is now `nulls_first`
* `nullslast` is now `nulls_last`

Because these are core operators, the internal migration strategy for this
change is to support legacy terms for an extended period of time -- if not
indefinitely -- but update all documentation, tutorials, and internal usage
to the new terms.  The new terms are used to define the functions, and
the legacy terms have been deprecated into aliases of the new terms.

Fixes: #5435
Change-Id: Ifbd7cb1cdda5981990243c4fc4b4ff467dc132ac
Ensure no compiler visit method tries to access .statement 2020-10-19T17:13:15+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-10-19T14:19:29+00:00 3e49b8d0519aa024842206a2fb664a4ad83796d6 Fixed structural compiler issue where some constructs such as MySQL / PostgreSQL "on conflict / on duplicate key" would rely upon the state of the :class:`_sql.Compiler` object being fixed against their statement as the top level statement, which would fail in cases where those statements are branched from a different context, such as a DDL construct linked to a SQL statement. Fixes: #5656 Change-Id: I568bf40adc7edcf72ea6c7fd6eb9d07790de189e 
Fixed structural compiler issue where some constructs such as MySQL /
PostgreSQL "on conflict / on duplicate key" would rely upon the state of
the :class:`_sql.Compiler` object being fixed against their statement as
the top level statement, which would fail in cases where those statements
are branched from a different context, such as a DDL construct linked to a
SQL statement.

Fixes: #5656
Change-Id: I568bf40adc7edcf72ea6c7fd6eb9d07790de189e
Ensure escaping of percent signs in columns, parameters 2020-10-17T17:15:57+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-10-17T15:39:56+00:00 296c84313ab29bf9599634f38caaf7dd092e4e23 Improved support for column names that contain percent signs in the string, including repaired issues involving anoymous labels that also embedded a column name with a percent sign in it, as well as re-established support for bound parameter names with percent signs embedded on the psycopg2 dialect, using a late-escaping process similar to that used by the cx_Oracle dialect. * Added new constructor for _anonymous_label() that ensures incoming string tokens based on column or table names will have percent signs escaped; abstracts away the format of the label. * generalized cx_Oracle's quoted_bind_names facility into the compiler itself, and leveraged this for the psycopg2 dialect's issue with percent signs in names as well. the parameter substitution is now integrated with compiler.construct_parameters() as well as the recently reworked set_input_sizes(), reducing verbosity in the cx_Oracle dialect. Fixes: #5653 Change-Id: Ia2ad13ea68b4b0558d410026e5a33f5cb3fbab2c 
Improved support for column names that contain percent signs in the string,
including repaired issues involving anoymous labels that also embedded a
column name with a percent sign in it, as well as re-established support
for bound parameter names with percent signs embedded on the psycopg2
dialect, using a late-escaping process similar to that used by the
cx_Oracle dialect.

* Added new constructor for _anonymous_label() that ensures incoming
  string tokens based on column or table names will have percent
  signs escaped; abstracts away the format of the label.

* generalized cx_Oracle's quoted_bind_names facility into the compiler
  itself, and leveraged this for the psycopg2 dialect's issue with
  percent signs in names as well.  the parameter substitution is now
  integrated with compiler.construct_parameters() as well as the
  recently reworked set_input_sizes(), reducing verbosity in the
  cx_Oracle dialect.

Fixes: #5653

Change-Id: Ia2ad13ea68b4b0558d410026e5a33f5cb3fbab2c
Genericize setinputsizes and support pyodbc 2020-10-16T18:28:04+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-10-15T22:18:03+00:00 87c24c498cb660e7a8d7d4dd5f630b967f79d3c8 Reworked the "setinputsizes()" set of dialect hooks to be correctly extensible for any arbirary DBAPI, by allowing dialects individual hooks that may invoke cursor.setinputsizes() in the appropriate style for that DBAPI. In particular this is intended to support pyodbc's style of usage which is fundamentally different from that of cx_Oracle. Added support for pyodbc. Fixes: #5649 Change-Id: I9f1794f8368bf3663a286932cfe3992dae244a10 
Reworked the "setinputsizes()" set of dialect hooks to be correctly
extensible for any arbirary DBAPI, by allowing dialects individual hooks
that may invoke cursor.setinputsizes() in the appropriate style for that
DBAPI.   In particular this is intended to support pyodbc's style of usage
which is fundamentally different from that of cx_Oracle.  Added support
for pyodbc.

Fixes: #5649
Change-Id: I9f1794f8368bf3663a286932cfe3992dae244a10
typo 2020-10-12T22:29:20+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-10-12T22:29:20+00:00 501c5dff8ea12aaac44f1dee6bca2db6a468d89c Change-Id: I0a753a2b48ed932c3209b93df0a96efe90af17c5 
Change-Id: I0a753a2b48ed932c3209b93df0a96efe90af17c5
changelog edits for 1.3.20 2020-10-12T22:22:01+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-10-12T22:22:01+00:00 6bf0e4ce35c0929e7e8dcb7c25fabe7f7c599f38 Change-Id: Ic053a30e9f0e6c99b638a0629e1192336bff3f76 
Change-Id: Ic053a30e9f0e6c99b638a0629e1192336bff3f76
Deprecate duplicated column names in Table definition 2020-10-12T17:52:06+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-09-03T18:14:39+00:00 9e82f32f274e649b04740c819d21ba232c89cfff The :class:`_schema.Table` class now raises a deprecation warning when columns with the same name are defined. To replace a column a new parameter :paramref:`_schema.Table.append_column.replace_existing` was added to the :meth:`_schema.Table.append_column` method. The :meth:`_expression.ColumnCollection.contains_column` will now raises an error when called with a string, suggesting the caller to use ``in`` instead. Co-authored-by: Federico Caselli <cfederico87@gmail.com> Change-Id: I1d58c8ebe081079cb669e7ead60886ffc1b1a7f5 
The :class:`_schema.Table` class now raises a deprecation warning
when columns with the same name are defined. To replace a column a new
parameter :paramref:`_schema.Table.append_column.replace_existing` was
added to the :meth:`_schema.Table.append_column` method.

The :meth:`_expression.ColumnCollection.contains_column` will now
raises an error when called with a string, suggesting the caller
to use ``in`` instead.

Co-authored-by: Federico Caselli <cfederico87@gmail.com>
Change-Id: I1d58c8ebe081079cb669e7ead60886ffc1b1a7f5
repair pg8000 and pin to 1.16.6 min version 2020-10-12T16:03:40+00:00 Mike Bayer mike_mp@zzzcomputing.com 2020-10-12T15:14:14+00:00 b2f2bf1acc5799221981d30c2bf9ed29d5ca6312 Due to https://github.com/tlocke/pg8000/commit/3a2e7439ae3613367ec231218d7e0f541466d1e5 we no longer decode the description. pin to 1.16.6 as minimum version so that we don't need to track version changes in code. Change-Id: I192c851eb2337f37467560a3cbb87f7235884788 
Due to https://github.com/tlocke/pg8000/commit/3a2e7439ae3613367ec231218d7e0f541466d1e5
we no longer decode the description.  pin to 1.16.6 as minimum version
so that we don't need to track version changes in code.

Change-Id: I192c851eb2337f37467560a3cbb87f7235884788
Drop python 3.5 support 2020-10-08T19:32:09+00:00 Federico Caselli cfederico87@gmail.com 2020-10-08T19:01:19+00:00 9b3812a0c646ee14a6f102e6dc87298d5c255cec Fixes: #5634 Change-Id: Ie8d4076ee35234b535a04e6fb9321096df3f648b 
Fixes: #5634
Change-Id: Ie8d4076ee35234b535a04e6fb9321096df3f648b
Fetch first support 2020-10-02T19:34:24+00:00 Federico Caselli cfederico87@gmail.com 2020-09-29T20:49:09+00:00 34e6b732a1672c62184db06dcd11074a51319c68 Add support to ``FETCH {FIRST | NEXT} [ count ] {ROW | ROWS} {ONLY | WITH TIES}`` in the select for the supported backends, currently PostgreSQL, Oracle and MSSQL. Fixes: #5576 Change-Id: Ibb5871a457c0555f82b37e354e7787d15575f1f7 
Add support to ``FETCH {FIRST | NEXT} [ count ] {ROW | ROWS}
 {ONLY | WITH TIES}`` in the select for the supported backends,
currently PostgreSQL, Oracle and MSSQL.

Fixes: #5576
Change-Id: Ibb5871a457c0555f82b37e354e7787d15575f1f7