]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/log
thirdparty/sqlalchemy/sqlalchemy.git
8 years agoUse schema_name() for SQL Server default schema
Mike Bayer [Tue, 4 Oct 2016 15:32:20 +0000 (11:32 -0400)] 
Use schema_name() for SQL Server default schema

Changed the query used to get "default schema name", from one that
queries the database principals table to using the
"schema_name()" function, as issues have been reported that the
former system was unavailable on the Azure Data Warehouse edition.
It is hoped that this will finally work across all SQL Server
versions and authentication styles.

Change-Id: Ic11bd4162c0d6a60432ae44876e86512703c1f81
Fixes: #3810
(cherry picked from commit 562e37ee7eaab8b19a9f081d4b170b95fce4f619)

8 years agoUse SQL Server SERVERPROPERTY for version info w/ pyodbc
Mike Bayer [Tue, 4 Oct 2016 15:17:26 +0000 (11:17 -0400)] 
Use SQL Server SERVERPROPERTY for version info w/ pyodbc

Updated the server version info scheme for pyodbc to use SQL Server
SERVERPROPERTY(), rather than relying upon pyodbc.SQL_DBMS_VER, which
continues to be unreliable particularly with FreeTDS.

Change-Id: I4ff49ae13c8ff51bd764980131d41c18d73d87ce
Fixes: #3814
(cherry picked from commit f0ea9e37f94bd39fa4f0785dbdcd0ee1759c4a11)

8 years ago- make sure dispose() is mentioned as a strategy for
Mike Bayer [Sat, 1 Oct 2016 23:01:19 +0000 (19:01 -0400)] 
- make sure dispose() is mentioned as a strategy for
dealing with os.fork().

Change-Id: I6d85f330327e79c353e191096d71528d8300f22f
(cherry picked from commit a02a75588d87fcbec84b4689ee8ed462c631838c)

8 years ago- some documentation hits
Mike Bayer [Sat, 1 Oct 2016 13:42:21 +0000 (09:42 -0400)] 
- some documentation hits

Change-Id: I468fe70168804b08cf0d5e8b57e235bca904b1ff
(cherry picked from commit 9bfd0289383bfcaf650fe516862df545dcf95c2e)

8 years agoRemove extra "return" statement in orm.ext.declared_attr.cascading examples
Dmitry Bogun [Sat, 1 Oct 2016 13:22:06 +0000 (09:22 -0400)] 
Remove extra "return" statement in orm.ext.declared_attr.cascading examples

Also improves some naming in the examples.

Change-Id: I51e5b1d9a730885aed10e5e6ade2123f5e736359
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/306
(cherry picked from commit dce32062236001ed89258cfe60c89bbca5db18c5)

8 years ago- improve documentation for SessionTransaction re: parent
Mike Bayer [Sat, 24 Sep 2016 04:49:22 +0000 (00:49 -0400)] 
- improve documentation for SessionTransaction re: parent
and nested attributes and what these mean
- improve linking for after_transaction_create() / after_transaction_end()
events
- add public .parent attribute to detect top-level transaction within
these events

Change-Id: Ie7382bc8fe5de226160dcb6a5019e19fcc5af38e
(cherry picked from commit e9b2625753fba02358d9cb4ef1d9dd07b8761d21)

8 years ago- clarify documentation on timezone flag, since Oracle has both
Mike Bayer [Thu, 22 Sep 2016 15:08:09 +0000 (11:08 -0400)] 
- clarify documentation on timezone flag, since Oracle has both
DATE / TIMESTAMP separately the timezone flag will not bump the
type to TIMESTAMP WITH TIMEZONE on that backend.

Change-Id: I185992093472e1620b8cf84872631a4d48f8edc3
(cherry picked from commit 0cc8267286f848f3cc3ab46c1e543956866a561e)

8 years agoEnsure mapper.polymorphic_on is polymorphic_prop.columns[0]
Mike Bayer [Wed, 21 Sep 2016 21:55:39 +0000 (17:55 -0400)] 
Ensure mapper.polymorphic_on is polymorphic_prop.columns[0]

Fixed bug where joined eager loading would fail for a polymorphically-
loaded mapper, where the polymorphic_on was set to an un-mapped
expression such as a CASE expression.

Change-Id: Iffe68196aaac592165c89684f09f4c06cd78ce54
Fixes: #3800
(cherry picked from commit 97b294093617eca7298a2fe97bd23bd6dc3b59bf)

8 years ago- disable two phase testing for mysql entirely, build servers
Mike Bayer [Tue, 20 Sep 2016 17:56:17 +0000 (13:56 -0400)] 
- disable two phase testing for mysql entirely, build servers
have no time to deal with MySQL 5.7's issues

Change-Id: Ic5f4e5b0aff1b4b5210bc7b5da203f536561e585
(cherry picked from commit 0c90cac2c37453a6688d9c1da62bbfb0bfa13d02)

8 years agoFix ArgumentError access in Session._add_bind
Mike Bayer [Wed, 14 Sep 2016 19:11:13 +0000 (15:11 -0400)] 
Fix ArgumentError access in Session._add_bind

Fixes: #3798
Change-Id: Ib4e6344b599e871f9d46d36a5aeb7ba3104dc99b
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/293
(cherry picked from commit 7ea54611516147a1af917691c60e1823b77c7ecf)

8 years agoAdd "message 20017" (unexpected EOF from the server) to mssql.
Ken Robbins [Wed, 14 Sep 2016 19:13:30 +0000 (15:13 -0400)] 
Add "message 20017" (unexpected EOF from the server) to mssql.

Fixes: #3791
Change-Id: I0dade4fe0ecbb53b4a66881594f362986ba73ae8
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/89
(cherry picked from commit 285d7bbb3e11abdc9a931e35e4ee08ef611af5d4)

8 years ago- latest mysql 5.7 also crashing on XA recovery, disable
Mike Bayer [Fri, 16 Sep 2016 16:55:33 +0000 (12:55 -0400)] 
- latest mysql 5.7 also crashing on XA recovery, disable
XA recovery for all MySQL

Change-Id: I4f77de521cd80c09fdf97e5bbe5dfd1c830dc3cb
(cherry picked from commit 65d8deac95b63ea5702a9ce6b5d9a6c9a6a60991)

8 years agoRepair foreign_keys population for Join._refresh_for_new_column
Mike Bayer [Thu, 15 Sep 2016 04:50:17 +0000 (00:50 -0400)] 
Repair foreign_keys population for Join._refresh_for_new_column

Fixed bug where setting up a single-table inh subclass of a joined-table
subclass which included an extra column would corrupt the foreign keys
collection of the mapped table, thereby interfering with the
initialization of relationships.

Change-Id: I04a0cf98fd456d12d5a5b9e77a46a01246969a63
Fixes: #3797
(cherry picked from commit 8967099c3ba8b04fa20536bc0a026f6adc8e096f)

8 years ago- placeholder for 1.0.16
Mike Bayer [Thu, 15 Sep 2016 04:51:31 +0000 (00:51 -0400)] 
- placeholder for 1.0.16

Change-Id: I33405513dc216ad33c5ec4796bff73f75d5866c4

8 years ago- also caveats for update() / delete() regarding single
Mike Bayer [Mon, 12 Sep 2016 22:36:01 +0000 (18:36 -0400)] 
- also caveats for update() / delete() regarding single
table inheritance

Change-Id: If1511812a22a53537409f902f73e2e52ae3e4a3d

8 years ago- add caveat for bulk deletes that they are generally not feasible
Mike Bayer [Mon, 12 Sep 2016 22:17:18 +0000 (18:17 -0400)] 
- add caveat for bulk deletes that they are generally not feasible
for joined inheritance

Change-Id: I043a5842401d586aa3ff96d05e06b443ff03fa60
(cherry picked from commit 2cd53196ea2df7b9006dcc48fb79555eb533f5cc)

8 years ago- 1.0.15 rel_1_0_15
Mike Bayer [Thu, 1 Sep 2016 17:10:50 +0000 (13:10 -0400)] 
- 1.0.15

8 years agoSupport all MySQL/Connector int/bool arguments
Mike Bayer [Thu, 1 Sep 2016 13:34:33 +0000 (09:34 -0400)] 
Support all MySQL/Connector int/bool arguments

Added support for parsing MySQL/Connector boolean and integer
arguments within the URL query string: connection_timeout,
connect_timeout, pool_size, get_warnings,
raise_on_warnings, raw, consume_results, ssl_verify_cert, force_ipv6,
pool_reset_session, compress, allow_local_infile, use_pure.

Change-Id: I2a1a17d13d47d56871bff32e94fdbed8bc003ad7
Fixes: #3787
(cherry picked from commit 16dcc8bec1218835590766f0cb2a019a1b30e340)

8 years agoCorrects typo
Edouard Berthe [Wed, 31 Aug 2016 06:52:48 +0000 (16:52 +1000)] 
Corrects typo

This example doesn't work with 'back_populates' because 'parent_associations' and 'child_associations' are not defined in Parent and Child classes respectively.
Alternatively, we could create 'parent_associations' and 'child_associations' into the classes.
(cherry picked from commit 53c3119ebb6801cbfcaf2841311d117eba250444)

8 years agoFix table reference in PostgreSQL documentation
Michael Williamson [Sun, 28 Aug 2016 11:22:42 +0000 (12:22 +0100)] 
Fix table reference in PostgreSQL documentation
(cherry picked from commit 2b0fa0f8a190a65aea5a284e4f7d0a22488ae560)

8 years agoFix documentation basic example (missing imports)
Romuald Brunet [Thu, 11 Aug 2016 15:24:05 +0000 (17:24 +0200)] 
Fix documentation basic example (missing imports)

(cherry picked from commit 096a74d7c5bea560ab68423e2d7293af22afbfa3)

8 years agoRework _apply_joins(), _prep_for_joins() totally
Mike Bayer [Mon, 15 Aug 2016 20:39:12 +0000 (16:39 -0400)] 
Rework _apply_joins(), _prep_for_joins() totally

The approach here is still error prone
and hard to follow.  Reorganize the whole
thing to take a pretty blunt approach to
the structure of to_join().  Also fix some never-called
code (!) in _prep_for_joins() and ensure we re-use
an aliased object.

Fixes: #3774
Change-Id: Ie6319415ae7213b4a33eac2ab70803ad2880d340
(cherry picked from commit 323e6e7f9f6a731103cfd19d774024f7f0f84377)

8 years agoMerge "Ensure final link in subqueryload join is correct" into rel_1_0
mike bayer [Sat, 13 Aug 2016 14:40:02 +0000 (10:40 -0400)] 
Merge "Ensure final link in subqueryload join is correct" into rel_1_0

8 years ago- fill in forwards-ports for 1.1 in 1.0 changelog
Mike Bayer [Sat, 13 Aug 2016 03:39:49 +0000 (23:39 -0400)] 
- fill in forwards-ports for 1.1 in 1.0 changelog

Change-Id: I8d44b90bb9d05275de19d3ce2d9124050add5f01
(cherry picked from commit 14154b2910087a7879ca23cf7995026a79a215c2)

8 years agoEnsure final link in subqueryload join is correct
Mike Bayer [Sat, 13 Aug 2016 03:35:40 +0000 (23:35 -0400)] 
Ensure final link in subqueryload join is correct

Fixed bug in subquery eager loading where a subqueryload
of an "of_type()" object linked to a second subqueryload of a plain
mapped class would fail to link the joins correctly.

Change-Id: I4be89e6f5e492438464a2ded01eb9c84d7ff7d4e
Fixes: #3773
(cherry picked from commit b07eb3cb45d1a344759a2eee9d2166fbf3e44888)

8 years ago- add another example for chained polymorphic eager loading
Mike Bayer [Thu, 11 Aug 2016 16:03:38 +0000 (12:03 -0400)] 
- add another example for chained polymorphic eager loading

Change-Id: I87918ab4cd294d4b4a87a377c7b6b21105f4fd55

8 years ago- small updates to polymorphic eager loading, cross-link from
Mike Bayer [Thu, 11 Aug 2016 15:45:03 +0000 (11:45 -0400)] 
- small updates to polymorphic eager loading, cross-link from
loading documentation

Change-Id: I3ce7e2cc521c4dd155195819a919017d4cc63b3c
(cherry picked from commit 09cf0376524dc0bac6c1ab05d3c43cdd29c362b1)

9 years agoWarn that bulk save groups inserts/updates by type
brln [Tue, 2 Aug 2016 22:37:35 +0000 (18:37 -0400)] 
Warn that bulk save groups inserts/updates by type

Users who pass many different object types to bulk_save_objects
may be surprised that the INSERT/UPDATE batches must necessarily
be broken up by type.  Add this to the list of caveats.

Co-authored-by: Mike Bayer
Change-Id: I8390c1c971ced50c41268b479a9dcd09c695b135
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/294
(cherry picked from commit ce1492ef3aae692a3dc10fff400e178e7b2edff8)

9 years agoFix typo
Jeff Widman [Tue, 26 Jul 2016 02:07:19 +0000 (19:07 -0700)] 
Fix typo
(cherry picked from commit 4aad91f687e905ef58132ab21af1ae60e56a9c8c)

9 years agoFix reference to _declarative_constructor in docstring
Michael Williamson [Mon, 25 Jul 2016 13:08:43 +0000 (13:08 +0000)] 
Fix reference to _declarative_constructor in docstring
(cherry picked from commit 924a47fc4fd0012bad151af5a99e5faea41bad8b)

9 years ago- Document how SQL Server does MAX with VARCHAR, NVARCHAR
Mike Bayer [Wed, 27 Jul 2016 14:04:52 +0000 (10:04 -0400)] 
- Document how SQL Server does MAX with VARCHAR, NVARCHAR
Fixes #3760

Change-Id: I0613eb66bfdc9d7118688c74e29c8da322c3b4db
(cherry picked from commit 0d92f79fd86073203a2a956460140c311c85a396)

9 years agoAllow Table._reset_exported to silently pass
Mike Bayer [Sun, 24 Jul 2016 21:37:25 +0000 (17:37 -0400)] 
Allow Table._reset_exported to silently pass

Fixed bug in :class:`.Table` where the internal method
``_reset_exported()`` would corrupt the state of the object.  This
method is intended for selectable objects and is called by the ORM
in some cases; an erroneous mapper configuration would could lead the
ORM to call this on on a :class:`.Table` object.

Change-Id: I63fa34ee0cdf16358bb125c556390df79758bcbc
Fixes: #3755
(cherry picked from commit 149fb5f55a5df3f31f6575919a5a5a2e5ba9cb0c)

9 years ago- a variety of test adjustments to accomodate for MySQL 5.7
Mike Bayer [Sun, 24 Jul 2016 20:36:27 +0000 (16:36 -0400)] 
- a variety of test adjustments to accomodate for MySQL 5.7

Change-Id: Ied4245433d0d7b469dae6e7394c4931d8405f387
(cherry picked from commit 02190234a25bb5ed2b07d25e6adcece2f5bba763)

9 years agoFix issue with unbaking subqueries
Mark Hahnenberg [Tue, 12 Jul 2016 18:07:52 +0000 (14:07 -0400)] 
Fix issue with unbaking subqueries

Fix improper capture of a loop variable inside a lambda during unbaking
of subquery eager loaders, which would cause the incorrect query
to be invoked.

Fixes: #3743
Change-Id: I995110deb8ee2dae8540486729e1ae64578d28fc
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/290
(cherry picked from commit bfa57063d49bcf355b00caaeb5e58d0b9d23acb3)

9 years ago- 1.0.15 for dev
Mike Bayer [Tue, 12 Jul 2016 18:04:40 +0000 (14:04 -0400)] 
- 1.0.15 for dev

Change-Id: I2d75b6d9ca533e662bc8160cf5fc52355e5e549e

9 years agoUpdate index.rst
Shige Takeda [Mon, 11 Jul 2016 22:58:43 +0000 (15:58 -0700)] 
Update index.rst
(cherry picked from commit 2045689ff27708292d8effa782777ec55a8477d0)

9 years agoUpdate index.rst
Shige Takeda [Mon, 11 Jul 2016 22:56:12 +0000 (15:56 -0700)] 
Update index.rst
(cherry picked from commit b5bf8632170d2d3ee5382c0de153829ee6857518)

9 years ago- fix typo
Mike Bayer [Thu, 7 Jul 2016 20:07:08 +0000 (16:07 -0400)] 
- fix typo

Change-Id: Ie66d419a5188529a64fcb2e2463c15c26863889f

9 years agoAdd additional documentation re: JSONEncodedDict
Mike Bayer [Thu, 7 Jul 2016 20:00:18 +0000 (16:00 -0400)] 
Add additional documentation re: JSONEncodedDict

Add an example of how to use coerce_compared_value()
specific to JSONEncodedDict, as this example class
is frequently dropped into applications.

Change-Id: I61639ac03dc5a37673ee8201b99a3c36ab944f00
Fixes: #3742
(cherry picked from commit b33caa64189f3fdbbabe4b381460b7610025aa6b)

9 years ago- 1.0.14 rel_1_0_14
Mike Bayer [Wed, 6 Jul 2016 21:10:19 +0000 (17:10 -0400)] 
- 1.0.14

9 years agoAdapt "FOR UPDATE OF" with Oracle limit/offset
Mike Bayer [Tue, 5 Jul 2016 16:48:41 +0000 (12:48 -0400)] 
Adapt "FOR UPDATE OF" with Oracle limit/offset

This modifies the Oracle ROWNUM limit/offset approach
to accommodate for the "OF" clause in a "FOR UPDATE"
phrase.  The column expressions must be added to the selected
subquery if necessary and adapted on the outside.

Change-Id: Ia71b5fc4df6d326e73863f8ae9f96e8f1a5acfc1
Fixes: #3741
(cherry picked from commit d23797943786914cced58ed71ffb7b749e64c449)

9 years agoRepair PG BIGSERIAL w/ TypeDecorator, Variant
Mike Bayer [Mon, 4 Jul 2016 20:37:26 +0000 (16:37 -0400)] 
Repair PG BIGSERIAL w/ TypeDecorator, Variant

Some of the dialect impl memoization for TypeDecorator
necessarily keeps the top-level TypeDecorator type
around, since a user-defined type will have bind and result
set processing behavior.  For both TypeDecorator and Variant,
PG dialect needs to ensure it's looking at the SQLAlchemy
type to check for SmallInteger / BigInteger.

Fixes: 3739
Change-Id: I2d45fb997f17c6272d6bb826a77d2dba665adae7

9 years ago- add backports
Mike Bayer [Fri, 1 Jul 2016 18:57:49 +0000 (14:57 -0400)] 
- add backports

Change-Id: Iee0bf9e60a5991bedbe29b305803b4c79ac5c511

9 years agoPreserve type for math negation
Mike Bayer [Fri, 1 Jul 2016 16:44:47 +0000 (12:44 -0400)] 
Preserve type for math negation

Fixed issue in SQL math negation operator where the type of the
expression would no longer be the numeric type of the original.
This would cause issues where the type determined result set
behaviors.

Change-Id: If0e339614a3686e251235fc94b6f59310c4630a5
Fixes: #3735
(cherry picked from commit 5c60aaefd32a7bdee611fb340911409e0b8223ed)

9 years ago- revert the RTD reqs workaround, we are self-hosting now
Mike Bayer [Fri, 1 Jul 2016 14:39:05 +0000 (10:39 -0400)] 
- revert the RTD reqs workaround, we are self-hosting now

Change-Id: Ie11361147d497c6eb6418cdc850ed277dfbd1de4
(cherry picked from commit f8781840aff51058bc8b1180012eed2a722a3e6f)

9 years agoRepair pickling for Properties object
Pieter Mulder [Wed, 29 Jun 2016 15:15:44 +0000 (11:15 -0400)] 
Repair pickling for Properties object

Fixed bug whereby the ``__getstate__`` / ``__setstate__``
methods for sqlalchemy.util.Properties were
non-working due to the transition in the 1.0 series to ``__slots__``.
The issue potentially impacted some third-party applications.
Pull request courtesy Pieter Mulder.

Fixes: #3728
Change-Id: I01ebd425bbfe145747fea2edd0d2d412c74fd84d
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/286
(cherry picked from commit cab57e9bab04fbdea44690c08dff379a29eaab32)

9 years ago- update alembic link
Mike Bayer [Sat, 18 Jun 2016 13:35:54 +0000 (09:35 -0400)] 
- update alembic link

Change-Id: I5ac6ba8234873fdd19bee6c1decd311a9cb4d55e
(cherry picked from commit 13f9578082ae669734d65a38cb6058e21df88362)

9 years ago- dont use id() to test identity as these can be recycled
Mike Bayer [Wed, 15 Jun 2016 22:15:46 +0000 (18:15 -0400)] 
- dont use id() to test identity as these can be recycled

Change-Id: Ie4cb4924909d55c5962f66e36cd5325e8e8f0538
(cherry picked from commit e5bdf96bc0b1503c4e4c8461748cd061f624e346)

9 years ago- flake8
Mike Bayer [Wed, 15 Jun 2016 22:10:46 +0000 (18:10 -0400)] 
- flake8

Change-Id: I74e369d1d71c98cb0af58dde80b7d535d17cbdf7
(cherry picked from commit 345cc1e304f3dc75bf5362e6c9f1975230a94753)

9 years agoDeprecate FromClause.count() (pending for 1.1)
Mike Bayer [Mon, 13 Jun 2016 19:18:13 +0000 (15:18 -0400)] 
Deprecate FromClause.count() (pending for 1.1)

count() here is misleading in that it not only
counts from an arbitrary column in the table, it also
does not make accommodations for DISTINCT, JOIN, etc.
as the ORM-level function does.  Core should not be
attempting to provide a function like this.

Change-Id: I9916fc51ef744389a92c54660ab08e9695b8afc2
Fixes: #3724
9 years agoEnsure CTE internals are handled during clone
Mike Bayer [Fri, 10 Jun 2016 21:24:36 +0000 (17:24 -0400)] 
Ensure CTE internals are handled during clone

The CTE construct was missing a _copy_internals() method
which would handle CTE-specific structures including _cte_alias,
_restates during a clone operation.

Change-Id: I9aeac9cd24d8f7ae6b70e52650d61f7c96cb6d7e
Fixes: #3722
(cherry picked from commit 7189d0bc82598c2d6dcbb55b054837416db2ee7d)

9 years ago- use a mock here, do away with timing problems for good. need to do this
Mike Bayer [Thu, 2 Jun 2016 22:40:46 +0000 (18:40 -0400)] 
- use a mock here, do away with timing problems for good.  need to do this
for the rest of the timing tests

Change-Id: I06a815b1500222126a4dbc2a9a5da3ef7847e321
(cherry picked from commit 74ca7f627ea8f31a8312f965d5249ce1f701d627)

9 years agoMerge "Skip UniqueConstraint marked by unique=True in tometadata" into rel_1_0
mike bayer [Fri, 3 Jun 2016 14:56:33 +0000 (10:56 -0400)] 
Merge "Skip UniqueConstraint marked by unique=True in tometadata" into rel_1_0

9 years ago- limit oracle DB reaps to identifiers generated from this
Mike Bayer [Thu, 2 Jun 2016 21:42:51 +0000 (17:42 -0400)] 
- limit oracle DB reaps to identifiers generated from this
run to prevent race conditions against concurrent runs

Change-Id: I065d1cec346ea7af03792c3cc2f30766f73c2bd3
(cherry picked from commit eb28ebb0f8a48ba57f68f21d64479b56bf689d24)

9 years agoSkip UniqueConstraint marked by unique=True in tometadata
Mike Bayer [Thu, 2 Jun 2016 17:52:27 +0000 (13:52 -0400)] 
Skip UniqueConstraint marked by unique=True in tometadata

Fixes an issue where a Column would be copied with unique=True
and at the same time the UniqueConstraint would also be copied,
leading to duplicate UniqueConstraints in the target table,
when tometadata() is used.   Imitates the same logic used
by index=True/Index to avoid duplicates.  For some reason
a fix was implemented for Index long ago but never for
UniqueConstraint.

Change-Id: Ie622ee912a6fb8bf0ea900a8b09d78c7ebc79fc0
Fixes: #3721
(cherry picked from commit afb466fb8bd9c2f8709e79fd0fce422b83ff1d6b)

9 years agoConvert readthedocs link for their .org -> .io migration for hosted projects
Adam Chainz [Sun, 29 May 2016 13:28:55 +0000 (14:28 +0100)] 
Convert readthedocs link for their .org -> .io migration for hosted projects

As per their email ‘Changes to project subdomains’:

> Starting today, Read the Docs will start hosting projects from subdomains on the domain readthedocs.io, instead of on readthedocs.org. This change addresses some security concerns around site cookies while hosting user generated data on the same domain as our dashboard.

Test Plan: Manually visited all the links I’ve modified.

(cherry picked from commit 513a045395b4cb5d8e1a9deb69bc9761d79eee37)

9 years agoSpelling fixes: "an SQL" -> "a SQL", see #266
Ville Skyttä [Thu, 5 May 2016 06:02:07 +0000 (09:02 +0300)] 
Spelling fixes: "an SQL" -> "a SQL", see #266

(cherry picked from commit 61f9e3761245a55f8997ec40b6983bb0770fdec4)

9 years agoSpelling fixes: "the a"
Ville Skyttä [Thu, 5 May 2016 06:00:28 +0000 (09:00 +0300)] 
Spelling fixes: "the a"

(cherry picked from commit 7a1e2dd92f28ad1b43e0e487b4fbc8088364713f)

9 years agoFix typo in config result.py docs
vytotas [Mon, 16 May 2016 11:02:30 +0000 (13:02 +0200)] 
Fix typo in config result.py docs
(cherry picked from commit ff71283e535b078b294f05e056f01f354c08ccdb)

9 years agoRepair dictlike-polymorphic
Mike Bayer [Tue, 24 May 2016 20:23:37 +0000 (16:23 -0400)] 
Repair dictlike-polymorphic

dictlike-polymorphic was broken by the change
in 1714e0d6ef28411e9c6633018564af1cae58c3d9.  Use the new
style of inheritance.

Fixes: #3704
Change-Id: I3509ef4bf7772dd6994daf600accf4a2c5eb6973
(cherry picked from commit 4cec791774b859a4800ed6e607bfa6838b1ab6af)

9 years agoSupport "blank" schema when MetaData.schema is set
Mike Bayer [Wed, 18 May 2016 15:07:02 +0000 (11:07 -0400)] 
Support "blank" schema when MetaData.schema is set

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
(cherry picked from commit c124fa36d5af2c85c87c51d24e92387adffbe3d2)

9 years ago- 1.0.13 rel_1_0_13
Mike Bayer [Mon, 16 May 2016 19:52:07 +0000 (15:52 -0400)] 
- 1.0.13

9 years agoMerge "Fix TypeError during cx_Oracle connection" into rel_1_0
mike bayer [Mon, 16 May 2016 17:18:49 +0000 (13:18 -0400)] 
Merge "Fix TypeError during cx_Oracle connection" into rel_1_0

9 years agoAccommodate "callable" bound param in evaluator
Mike Bayer [Mon, 16 May 2016 14:32:07 +0000 (10:32 -0400)] 
Accommodate "callable" bound param in evaluator

Fixed bug in "evaluate" strategy of :meth:`.Query.update` and
:meth:`.Query.delete` which would fail to accommodate a bound
parameter with a "callable" value, as which occurs when filtering
by a many-to-one equality expression along a relationship.

Change-Id: I47758d3f5d8b9ea1a07e23166780d5f3c32b17f1
Fixes: #3700
(cherry picked from commit a51ab916622dd016ce51d6be0969112817cc42ad)

9 years agoFix formatting on test_evaluator
Mike Bayer [Mon, 16 May 2016 14:26:08 +0000 (10:26 -0400)] 
Fix formatting on test_evaluator

Change-Id: Idcd77a570b19f1b022a74d67fa8253d922dadc67
(cherry picked from commit 1873d8107ac8cf4258440914d68f12332220e244)

9 years agoFix TypeError during cx_Oracle connection
John Vandenberg [Thu, 5 May 2016 13:26:00 +0000 (09:26 -0400)] 
Fix TypeError during cx_Oracle connection

cx_Oracle connection parameters user, password and dsn must be
either a string or NULL.  When they are passed a Python None object,
"TypeError: expecting string, unicode or buffer object" is raised.

Fixes: #3705
Change-Id: I8da5d8a227ca12c9bf17a6127460e413841951fb
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/271
(cherry picked from commit a60328473f78d68b65cc376c21aa8f50df867d26)

9 years agoHandle `SSL error: decryption failed or bad record mac`
Iuri de Silvio [Sat, 14 May 2016 01:20:54 +0000 (21:20 -0400)] 
Handle `SSL error: decryption failed or bad record mac`

This is another psycopg2 error message representing an
unusable connection.

Fixes #3715
Change-Id: Ida6e212963e9c7336bf2944e7ef928619ac3a0e7
(cherry picked from commit 8ecad78ba3473d97df8ed4f20f28ddf966ce0277)
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/85

9 years agochange "psotgresql" to 'postgresql' in decorator
Mark Sandan [Sat, 7 May 2016 01:26:31 +0000 (18:26 -0700)] 
change "psotgresql" to 'postgresql' in decorator
(cherry picked from commit ba3d4aa5baebacfef8a56de66a5c06cd1372e893)

9 years agotypo in glossary#release: s/proces/process/
Frank Carnovale [Thu, 12 May 2016 16:54:50 +0000 (17:54 +0100)] 
typo in glossary#release: s/proces/process/

(cherry picked from commit fb289799f4595b70c2dfc8620a10967c981ff4b0)

9 years agotypo in glossary#FROMclause: s/incicates/indicates/
Frank Carnovale [Thu, 12 May 2016 16:51:03 +0000 (17:51 +0100)] 
typo in glossary#FROMclause: s/incicates/indicates/

(cherry picked from commit 1d81219aec83317208cc85333256499636b19cf8)

9 years agotypo in glossary#instrumentation: s/behviors/behaviors/
Frank Carnovale [Wed, 11 May 2016 16:42:59 +0000 (17:42 +0100)] 
typo in glossary#instrumentation: s/behviors/behaviors/

(cherry picked from commit 2774113dab7d20ebe8879fdc6efaebf72ea9f770)

9 years agoAdd close_with_result to pessimistic connection example
Mike Bayer [Thu, 12 May 2016 11:54:14 +0000 (07:54 -0400)] 
Add close_with_result to pessimistic connection example

For connectionless execution, the recipe here will fail unless
the should_close_with_result flag is temporarily set to False.

Change-Id: Ib77b4439e8361b24478108c413b1ba720a68350f
Fixes: #3712
(cherry picked from commit 7f08d8c93af1b574d1cc11af38baf26d9d59058f)

9 years agoFix label referencing in SQL Server OFFSET logic
Mike Bayer [Tue, 10 May 2016 16:49:56 +0000 (12:49 -0400)] 
Fix label referencing in SQL Server OFFSET logic

Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711
(cherry picked from commit a4be7c92393e08607dc46f318e97803519052a93)

9 years agoCheck for duplicate calls to register_attribute_impl
Mike Bayer [Tue, 10 May 2016 15:05:30 +0000 (11:05 -0400)] 
Check for duplicate calls to register_attribute_impl

Fixed bug whereby the event listeners used for backrefs could
be inadvertently applied multiple times, when using a deep class
inheritance hierarchy in conjunction with mutiple mapper configuration
steps.

Change-Id: I712beaf4674e2323bf5b282922658020a6d00b53
Fixes: #3710
(cherry picked from commit 743e9d4589946f1a29cdec7f2f1a2e4ec0853db7)

9 years agoRepair _orm_columns() to accommodate text()
Mike Bayer [Thu, 5 May 2016 21:07:40 +0000 (17:07 -0400)] 
Repair _orm_columns() to accommodate text()

Fixed bug whereby passing a :func:`.text` construct to the
:meth:`.Query.group_by` method would raise an error, instead
of intepreting the object as a SQL fragment.

Change-Id: I5fc2f590b76508d52e23b5fa9cf037ddea8080c3
fixes: #3706
(cherry picked from commit 9bdd6f2b1f6b34a82b77849ec05811aa0279931d)

9 years agoCorrects typo: plural of vertex is vertices.
Jeffrey Finkelstein [Wed, 4 May 2016 01:09:36 +0000 (21:09 -0400)] 
Corrects typo: plural of vertex is vertices.

(cherry picked from commit 792083d23b37a58c136c97a9efd5cebc04e7d27b)

9 years agoAdds parentheses around print statements in docs.
Jeffrey Finkelstein [Wed, 4 May 2016 01:02:29 +0000 (21:02 -0400)] 
Adds parentheses around print statements in docs.

(cherry picked from commit c31833e9973ef3b9fd4528e19eec0458bc8d51ee)

Change-Id: Id46745a1e8869430a7979e593c257ed38e08afeb

9 years agoCorrects some references in ORM documentation.
Jeffrey Finkelstein [Wed, 4 May 2016 00:46:20 +0000 (20:46 -0400)] 
Corrects some references in ORM documentation.

(cherry picked from commit e6251c3e40e623aaadc7356c0b3c94101710079c)

9 years agoLet logging format messages on demand, use warning instead of deprecated warn
Ville Skyttä [Tue, 3 May 2016 15:29:41 +0000 (18:29 +0300)] 
Let logging format messages on demand, use warning instead of deprecated warn

(cherry picked from commit 1322edc7b1effb5bad411742b997cb2103eedfc2)

9 years agoFix pymssql sample URL
Mike Bayer [Wed, 27 Apr 2016 20:08:31 +0000 (15:08 -0500)] 
Fix pymssql sample URL

A slash is required before building out the query string portion.

Change-Id: Ie97fd3d07047d78e17cbaffed4ff54960a2b956e
Fixes: #3696
9 years agoAdds parentheses around prints in documentation
jfinkels [Wed, 27 Apr 2016 06:35:55 +0000 (02:35 -0400)] 
Adds parentheses around prints in documentation

This makes the docstring example code compatible with both Python 2 and Python 3.
(cherry picked from commit 8aa7369125f831a74c9f024ce5dde73ecf812e63)

9 years agoDon't double-process ResultMetaData for BufferedColumnResultProxy
Mike Bayer [Wed, 27 Apr 2016 16:37:58 +0000 (11:37 -0500)] 
Don't double-process ResultMetaData for BufferedColumnResultProxy

Fixed a bug in the result proxy used mainly by Oracle when binary and
other LOB types are in play, such that when query / statement caching
were used, the type-level result processors, notably that required by
the binary type itself but also any other processor, would become lost
after the first run of the statement due to it being removed from the
cached result metadata.

Change-Id: I751940866cffb4f48de46edc8137482eab59790c
Fixes: #3699
(cherry picked from commit f3bc60bdd809235cbeb3f414717ac0e273269cf9)

9 years agoSimplify directed graph example
Mike Bayer [Wed, 27 Apr 2016 00:00:43 +0000 (19:00 -0500)] 
Simplify directed graph example

Changed the "directed graph" example to no longer consider
integer identifiers of nodes as significant; the "higher" / "lower"
references now allow mutual edges in both directions.

Change-Id: Ibfd5b420f0451a6fc746f0bcbbbb062f8f88dc1d
Fixes: #3698
9 years ago - don't use --dropfirst when we are using ad-hoc DBs. dropfirst
Mike Bayer [Sun, 24 Apr 2016 18:46:27 +0000 (14:46 -0400)] 
 - don't use --dropfirst when we are using ad-hoc DBs.   dropfirst
   is unnecessary and causes collisions against other CI runs

Change-Id: I47e9bc98cd6ef4ab90be25bae45897dabae16308

9 years agoFix result set handling for case insensitive dupe cols
Mike Bayer [Thu, 21 Apr 2016 14:36:19 +0000 (10:36 -0400)] 
Fix result set handling for case insensitive dupe cols

Fixed bug where when using ``case_sensitive=False`` with an
:class:`.Engine`, the result set would fail to correctly accomodate
for duplicate column names in the result set, causing an error
when the statement is executed in 1.0, and preventing the
"ambiguous column" exception from functioning in 1.1.

Change-Id: If582bb9fdd057e4da3ae42f7180b17d1a1a2d98e
Fixes: #3690
(cherry picked from commit 1f3e5d9826fe989f2212745f6b3592b2ef9b5e32)

9 years agoUpdate tutorial.rst
Ethan [Wed, 20 Apr 2016 15:20:06 +0000 (10:20 -0500)] 
Update tutorial.rst

Fix very minor typo

9 years ago- default branch rel_1_0
Mike Bayer [Tue, 12 Apr 2016 21:29:38 +0000 (17:29 -0400)] 
- default branch rel_1_0

Change-Id: I3f42b9f9571ad7f75e1f4b5fac6944ea2f186b4b

9 years agoMention the correct way of adding multiple attributes which refer to the same column
Eoghan Murray [Thu, 7 Apr 2016 10:57:14 +0000 (11:57 +0100)] 
Mention the correct way of adding multiple attributes which refer to the same column

(cherry picked from commit 2880f24d93a774d02cde83dbabfd80ad279cbb05)

9 years agoFix typo from "addreses" to "addresses"
Rachid Belaid [Thu, 7 Apr 2016 03:41:14 +0000 (20:41 -0700)] 
Fix typo from "addreses" to "addresses"

(cherry picked from commit c8db0862c102281da617d395b1826ff523af302e)

9 years agoFix some broken links in docs
Ville Skyttä [Mon, 4 Apr 2016 10:46:07 +0000 (13:46 +0300)] 
Fix some broken links in docs

(cherry picked from commit b1c9b3bd384fc40e1c411abef12eaf04b574612f)

9 years ago- Move review to gerrit.sqlalchemy.org
Mike Bayer [Wed, 6 Apr 2016 13:35:18 +0000 (09:35 -0400)] 
- Move review to gerrit.sqlalchemy.org

Change-Id: Id6e9014cfa8ad558b2f3e90815616f9c26dc884d
(cherry picked from commit be7322b3da8e412bd2376c3ce836ead589d1ad31)

9 years ago- Add a git review file
Mike Bayer [Thu, 31 Mar 2016 19:24:14 +0000 (15:24 -0400)] 
- Add a git review file

Change-Id: Ib19e9ee0854f0d123ea625fb976f1a398cf88c87
(cherry picked from commit fdb6ab6a1d5d55d900c388e039835c6433032977)

9 years ago- move all resultproxy tests intio test_resultset, adapted from
Mike Bayer [Wed, 30 Mar 2016 21:44:04 +0000 (17:44 -0400)] 
- move all resultproxy tests intio test_resultset, adapted from
03d35a833cff68013781640b1192d079ab7e1154 in master (not cherry-picked)

9 years agoDocstring Fix
Patrick [Wed, 30 Mar 2016 20:45:40 +0000 (21:45 +0100)] 
Docstring Fix

Change the docstring in short_selects example to match the code

(cherry picked from commit 4a3205df84b737f5fe55914fe22eef7264f20764)

9 years agoredundant "using the by changing" -> "using the"
NestorTejero [Wed, 30 Mar 2016 06:48:48 +0000 (08:48 +0200)] 
redundant "using the by changing" -> "using the"
(cherry picked from commit 9bdbf19d54174c1077689bc472dc088c9b06aa24)

9 years agoReST fix: missing backtick
Marius Gedminas [Mon, 21 Mar 2016 10:00:49 +0000 (12:00 +0200)] 
ReST fix: missing backtick

Fixes a misrendering at http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#nullability:
(cherry picked from commit e3abb63293be80379d20b4c3f0d1cd093459a9eb)

9 years ago- Fixed bug where the negation of an EXISTS expression would not
Mike Bayer [Mon, 21 Mar 2016 14:57:40 +0000 (10:57 -0400)] 
- Fixed bug where the negation of an EXISTS expression would not
be properly typed as boolean in the result, and also would fail to be
anonymously aliased in a SELECT list as is the case with a
non-negated EXISTS construct.
fixes #3682

(cherry picked from commit 07a4b6cbcda6e6ee6e67893c5a5d2fd01e5f125f)

9 years agoFix typo
Benjamin Dopplinger [Wed, 16 Mar 2016 03:30:04 +0000 (14:30 +1100)] 
Fix typo
(cherry picked from commit 732c613eeb890e7b7cbd04750468dac584151a31)

9 years ago- ensure engine is restored even if we had a failure in cleanup
Mike Bayer [Tue, 15 Mar 2016 22:01:23 +0000 (18:01 -0400)] 
- ensure engine is restored even if we had a failure in cleanup
for stray connection

(cherry picked from commit edbb32649960db29761e765fc74c025e9999c7dd)

9 years ago- backport doc improvements from 31f96c27a5fea302358ba580313a2f742c12b83d re:
Mike Bayer [Tue, 15 Mar 2016 21:21:05 +0000 (17:21 -0400)] 
- backport doc improvements from 31f96c27a5fea302358ba580313a2f742c12b83d re:
isolation_level settings for postgresql, mysql