1. Mike Bayer
  2. sqlalchemy

Branches

rel_0_9

View source
rel_0_9
Author Commit Message Date Builds
250+ commits behind master.
Ethan
Update tutorial.rst Fix very minor typo (cherry picked from commit fc68a7145d086de21005b4ccaa93847d4b889dba)
Mike Bayer
- default branch rel_0_9 Change-Id: Ib20281d6ea595d6507ec8568b26a0235c88a41a7
Rachid Belaid
Fix typo from "addreses" to "addresses" (cherry picked from commit c8db0862c102281da617d395b1826ff523af302e)
Ville Skyttä
Fix some broken links in docs (cherry picked from commit b1c9b3bd384fc40e1c411abef12eaf04b574612f)
Mike Bayer
- Move review to gerrit.sqlalchemy.org Change-Id: Id6e9014cfa8ad558b2f3e90815616f9c26dc884d (cherry picked from commit be7322b3da8e412bd2376c3ce836ead589d1ad31)
Mike Bayer
- Add a git review file Change-Id: Ib19e9ee0854f0d123ea625fb976f1a398cf88c87 (cherry picked from commit fdb6ab6a1d5d55d900c388e039835c6433032977)
NestorTejero
redundant "using the by changing" -> "using the" (cherry picked from commit 9bdbf19d54174c1077689bc472dc088c9b06aa24)
Marius Gedminas
ReST fix: missing backtick Fixes a misrendering at http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#nullability: (cherry picked from commit e3abb63293be80379d20b4c3f0d1cd093459a9eb)
Mike Bayer
- backport doc improvements from 31f96c27a5fea302358ba580313a2f742c12b83d re: isolation_level settings for postgresql, mysql (cherry picked from commit 49eb39366a0ca54ce973147802864fd7c359adb3)
Mike Bayer
- add notes for pyodbc limitations with rowcount fixes #3675 (cherry picked from commit 8bc370ed382a45654101fa34bac4a2886ce089c3)
jfinkels
Adds documentation to Query.slice(). (cherry picked from commit 6e5e64e27ef2c6a86c9aebdcefdf2cd726f1476a)
Андрій Попович
Update cascades.rst (cherry picked from commit f61194cb865db8b29cc65e47782bb72e54b14ada)
Mike Bayer
- further edit the unnest() example to suit PG's esoteric requirements exactly (cherry picked from commit c97aa63789036fc145503f03123275253ae02d2c)
Mike Bayer
- use same colname as the alias we give to the PG function here, fixes #3652 (cherry picked from commit e310a8e423d9a4eeb511b7b84dbeccc90c234a1f)
Mike Bayer
- add more documentation to MutableDict explaining that this structure is only intended to track additions and removals from the dictionary, not recursive tracking of embedded changes. fixes #3646. (cherry picked from commit 5497b1086f9fe44e0594079b036ea939fbc3c479)
Mike Bayer
- fully hyperlink the docstring for make_transient - establish make_transient and make_transient_to_detached as special-use, advanced use only functions - list all conditions under make_transient() under which an attribute will not be loaded and establish that make_transient() does not attempt to load all attributes before detaching the object from its session, fixes #3640 (cherry picked from commit 7eff4e8f3e3999d9eb914647d8776e6e5b7ee88e)
Ruilin Huang
fix %x string format to compatible with Python 3.5 (cherry picked from commit 4b9f6f407ceedde247982501a6ae406242c80b4a)
Ruilin Huang
fix %x string format to compatible with Python 3.5 (cherry picked from commit 324e532d6081d9b9ea90bf3945cecfc792264f8d)
Mike Bayer
- restate the "secondary" / AssociationProxy warning more strongly. references #3638 (cherry picked from commit 67a69da3aa86c8b2b560ed79a9c91408ad704879)
Mike Bayer
- native unicode expectations are too difficult to maintain w/ the number of drivers /DBURIs / python versions (cherry picked from commit d18d6d9baf4c98c47af70c0a7c796423396a51c1) (cherry picked from commit 341a52015bad4051ddd01396582488106f826118)
Mike Bayer
- move out match compiler test to test_compiler - test_query isn't assertscompiledsql (cherry picked from commit 269313218ddd06a21387085295c553becbd00e46) (cherry picked from commit cd3ea1d56bdec8b5b00cd10c5ecc6017bb99bcdd)
Mike Bayer
- documenation updates to clarify specific SQLite versions that have problems with right-nested joins and UNION column keys; references #3633 references #3634. backport from 1.1 to 0.9 announcing 1.1 as where these behaviors will be retired based on version-specific checks - fix test_resultset so that it passes when SQLite 3.10.0 is present, references #3633 (cherry picked from commit 89fa08792e98b9e31452aa3c949d9b909b10e7cd)
Mike Bayer
- generalize the verbiage on LargeBinary so that it doesn't create confusion for inherited classes such as BYTEA, fixes (cherry picked from commit 47d8858c54401cdf10285b7935049faf87432f55)
Mike Bayer
- update oracle JDBC driver URL, fixes #3554 (cherry picked from commit 24dba714cb56e1f5a4dca5453cc5f442e6ee08ab)
Mike Bayer
- cross link for concrete helper classes - remove redundant concrete helper docs from declarative docs, two places is enough (cherry picked from commit a53bd6f74b4f41fd04c8cde1f8b58bbb766fe18d)
Mike Bayer
- typo
Mike Bayer
- redo the docs for concrete inheritance to more strongly favor declarative, fixes #2890 (cherry picked from commit 632c4f21fa3cab353b801f585183494c529c6896)
Mike Bayer
- clarify the "Adding" section also illustrates updates, fixes #2942 (cherry picked from commit 02271efd8976154f855646478b5438db078f7101)
Mike Bayer
- add a note that the literal_binds flag should be used when cross-compiling from DDL to SQL, fixes #3615 (cherry picked from commit 165fa15b0f9dbca50539aa7da377c5da5ac0fc79)
Mike Bayer
- fix People -> Person , fixes #3628 (cherry picked from commit 66560cef7457d69f56cd2ca3bab93cb033a61a84)
Mike Bayer
- fix some old verbiage that refers to text() as an "implicit" thing for SQL fragments; we've deprecated that in 1.0 and its a good idea to document like this for 0.9 as well. (cherry picked from commit d5d7284bdd0ffc96e7a79354944627cf9b5d8e4d)
Mike Bayer
- fix link to types in metadata, fixes #3618 - fix "version" got whacked into "f" in core tutorial - fix short underline in automap - fix unmatched boldface in session events (cherry picked from commit d03477d4b761132f44c48417be09d622ad9adfd3)
Jeff Widman
Update SQLAlchemy-Migrate link to the new repo (cherry picked from commit 56b76ce7a823a076bd91490f940df95ad409db61)
thiefmaster
Fix typo in session docs (cherry picked from commit bb294497558f96c92253a4a68129a7c7984d3af9)
jvanasco
some spelling fixes (cherry picked from commit 738d515b95f1ff94d7dfd265883237d247d1c153)
Mike Bayer
Revert "some spelling fixes" - unfortunately dml.py got whacked / pushed by accident This reverts commit db706d92ef0e5ebb4c0ba5e7036dc6c0c8f06280.
jvanasco
some spelling fixes (cherry picked from commit 738d515b95f1ff94d7dfd265883237d247d1c153)
Mike Bayer
- write a real inline documentation section for from_self(), building on the example of query.join(). Ideally all the methods in Query would have this kind of thing. fixes #3544 (cherry picked from commit 8fa62d652b8d1834e23ba36e56c7bd711cc37e37)
Mike Bayer
- and NLS_LANG.... (cherry picked from commit 077f26af5f6fefdc98f6720ab5e02b0fad6eff7a)
Mike Bayer
- add ORACLE_HOME to passenv allowing oracle to work w/ tox 2.0 (cherry picked from commit 7f423e875669ee549b1f53f90d2db340b6c957cd)
Mike Bayer
Merge remote-tracking branch 'origin/pr/214' (cherry picked from commit 38e043a475db210143c46588fca70838c9c47c8a)
Sven Schliesing
fix typo: Explcitly -> Explicitly (cherry picked from commit 887edc431a4c5198bb4f842419d729aed42a6ce8)
Mike Bayer
- fix ambiguous documentation re: after_flush_postexec(), the looping nature of it only occurs within the context of a commit. (cherry picked from commit 5d8bb1f4a65c8932c0dcb39d241b521bd95db681)
Mike Bayer
- fix broken link to loader behavior (cherry picked from commit 2d54e3819f34e5f886b8d85f5525b83abdf8bc5a)
Mike Bayer
- cross-linking for pool recycle feature (cherry picked from commit 07a199d929aa920b5b2b5d8b2d7008626a731f1f)
Mike Bayer
- add a JSON warning for coerce_compared_value (cherry picked from commit 98c1dcc6bcade313a254fe11e8efa3c5b5ad959e)
Thomas Grainger
Link to maintained redshift dialect (cherry picked from commit e4bfe2aa4b5246207837b0b1c3ac99483e20498b)
Mike Bayer
- repair laziness about setting time zone here, which is leaking out depending on connection pool state (cherry picked from commit 2a8a06e33af60705faf3e7601ec7b3e31e44f8fb) (cherry picked from commit 48ad282e379d49cf6d6eb97dc0739fa0f29f5464) Conflicts: test/dialect/postgresql/test_query.py
peterdemin
Update base.py Docstring typo keysowrds => keywords (cherry picked from commit f8eb7c2858443649190b735c587c190ae90b6106)
Mike Bayer
- add an additional note regarding select_from, fixes #3546 (cherry picked from commit d84dea62de3a9c83ad539a5cf2ff4be2c0685a94)
Mike Bayer
- remove ambiguous use of the phrase "joined together by AND" as this may be construed as the Python "and" keyword - add notes to ORM tutorial for beginners that Python "and" keyword is not to be used fixes #3545 (cherry picked from commit ac08920284935e7e7519ce77ba369703390155dc)
Mike Bayer
- fix incorrect example in inheritance docs (cherry picked from commit 7eb34baf99179eec966ddd8b3607a6d8cfdfba21)
Mike Bayer
- add new entry for sharing of Engine across process boundaries (cherry picked from commit fe41e39b9b776c18a03dde0540a45e1f0100d44b)
Mike Bayer
- call it deque, since you can really pop from either side
Mike Bayer
- add a new FAQ recipe for "walk all objects", replacing the need to use mapper.cascade_iterator() for this purpose as it was not really designed for that use case. Add docs to cascade_iterator() pointing to the recipe. fixes #3498 (cherry picked from commit 03797b78475bec9fb9c15f8e926414f3720a273c)
Jason Myers
Correcting the Hybrid Property Example Fixes #3528 Signed-off-by: Jason Myers <jason@jasonamyers.com> Conflicts: lib/sqlalchemy/ext/hybrid.py
Ben Smithgall
fix typo in session events docs (cherry picked from commit 2fb3bb31ef897ee48748908524288067c53df4e1)
David Beitey
Minor grammar fix for capitalisation in session docs (cherry picked from commit 3bd58fac7b607007cb42ab7e41d2e2d01fc390e2)
Mike Bayer
- update moved link, fixes #3351 (cherry picked from commit 176ac6ab0915f99d378c7d9be67e9c0a73ab1800)
Mike Bayer
- add new documentation that applies to all modern SQLA versions, detailing ORM event recipes across the board. (cherry picked from commit 8be93c23ee566de7cefd7d1b8ef044324132a70f) Conflicts: doc/build/orm/events.rst
Mike Bayer
- add a note about DISTINCT in query w/ ORDER BY, references #3518 (cherry picked from commit 6d0c0994e9a08cf5d149af0314970d5f6e25b159)
Mike Bayer
- use consistent and descriptive language in all cases where we refer to the "weak_identity_map" option, and add additional exposition in the session documentation which refers to it. fixes #3517 (cherry picked from commit 956907a4b15f6dcc492582a7ad03706ff62d96fb) Conflicts: lib/sqlalchemy/orm/identity.py
Mike Bayer
- reword and update documentation on passive_updates=False; as virtually all DBs now support ON UPDATE CASCADE other than Oracle, there's no need to try to reimplement more functionality here and users should be encouraged to forego natural PKs unless their target platform supports them. references #2666 (cherry picked from commit d459afa8dbf73b8d9d620d09dede97e3461b6b3f)
Mike Bayer
- re-document and fully cross link all of configure_mappers(), mapper_configured(), after_configured(), and before_configured(). (cherry picked from commit 0127ac668e405584d74c92768a9f0dc7913798fe)
Mike Bayer
- rework the "controlling DDL sequences" documentation to refer mostly to the DDL object; this system is primarily useful in that case, and not for built-in objects. Reference that the built-in case is not really viable right now. References #3442.
Mike Bayer
- fix missing ANY symbol
Mike Bayer
- add tests for InstanceEvents.init, InstanceEvents.init_failure - ensure that kwargs can be modified in-place within InstanceEvents.init and that these take effect for the __init__ method. - improve documentation for these and related events, including that kwargs can be modified in-place. (cherry picked from commit b00b430e87512d721ad30c81fdcb35a5253dfc0a)
halfcrazy
fix typo int->into (cherry picked from commit 51870ddaef8abf61ee4c8d6337a72db5395a0a85)
Leonardo Rochael Almeida
Remove useless code `to_unicode` variable was created but was not used. (cherry picked from commit 69fcabb335130bd0f6e9889c5b191c68192559b5)
Mike Bayer
- add a note clarifying query.with_labels(), fixes #3506 (cherry picked from commit 292f5bec1cbfcaa9d16af8fe4149c7191f194f11)
Mike Bayer
- Fixed support for cx_Oracle version 5.2, which was tripping up SQLAlchemy's version detection under Python 3 and inadvertently not using the correct unicode mode for Python 3. This would cause issues such as bound variables mis-interpreted as NULL and rows silently not being returned. fixes #3491 (cherry picked from commit d8efa2257ec650b345ec6e840984387263a957a6)
Mike Bayer
- using text().columns() for ORM matching won't work well until ticket #3501, so remove this from pre-1.1 tutorials (cherry picked from commit 7240262adb5d74ec49abdd8561fca58b632c5e8e)
Mike Bayer
- work to bridge between core/ORM tutorials regarding the text() construct (cherry picked from commit 4f51fa947ffa0cadeab7ad7dcab649ce3fbcf970) Conflicts: doc/build/core/tutorial.rst
Mike Bayer
- add an example of text.columns - correct the scalar() example output
Mike Bayer
- categorize this correctly
Mike Bayer
- Fixed critical issue whereby the pool "checkout" event handler may be called against a stale connection without the "connect" event handler having been called, in the case where the pool attempted to reconnect after being invalidated and failed; the stale connection would remain present and would be used on a subsequent attempt. This issue has a greater impact in the 1.0 series subsequent to 1.0.2, as it also delivers a blanked-out ``.info`` dictionary to the event handler; prior to 1.0.2 the ``.info`` dictionary is still the previous one. fixes #3497 (cherry picked from commit 4096ad0f0980f6940be57aaee85791df8f975cd7)
Mike Bayer
0.9.10
Mike Bayer
- Fixed bug in SQLite dialect where reflection of UNIQUE constraints that included non-alphabetic characters in the names, like dots or spaces, would not be reflected with their name. fixes #3495 (cherry picked from commit f39e692d1249aeffb4de85987f6a74303fc5dcc5) Conflicts: lib/sqlalchemy/dialects/sqlite/base.py
Mike Bayer
- try to note under insert.values(), if you need "multiple parameter sets" there is a much more common case which works equally well for INSERT/UPDATE/DELETE e.g. executemany(). reference #3476
Mike Bayer
- add a warning suggesting to use the dictionary form of access if the name of the attribute being accessed is non-specific, thereby avoiding collisions on names like items, values, keys. fixes #3475 (cherry picked from commit 6fcc5d4a07e5c409a7d8438582598d0e90562ea0)
Mike Bayer
- fix the link here fixes 3473 (cherry picked from commit cf21497f02e64b6ddec82e12a7c26b9476616b00)
Yuri Baida
Fix code examples in automap's documentation Fix camelize_classname and pluralize_collection functions as they didn't work as expected. (cherry picked from commit 5717186122d5538e53205268846beb7143a3d4cc)
Mike Bayer
- edits to this section (cherry picked from commit 00656ae4930620bc8c0c4be6a82853f01c90f758)
Mike Bayer
- add a new FAQ on re-reading of data within a transaction, since this is definitely something that is asked regularly. (cherry picked from commit be2b35f7f2156c4b723df9e7be389e6575afedc4)
Mike Bayer
- more edits, references #3461 (cherry picked from commit 7aa2100db3e6f768a280b4dfdb675d6709f94625)
Mike Bayer
- fix the bullets - tone down the "never dispose an engine" language - refer to NullPool for the "I don't like pooling" use case references #3461 (cherry picked from commit a1b6e9f324eec04ff69f2ac5347ad3df5b931dd5)
Mike Bayer
- add explciit section on engine disposal, fixes #3461 (cherry picked from commit 3d78705cf4981e460d6d1b5bb08870286fc3fe93)
Mike Bayer
- automap is stable (cherry picked from commit 370b237ddb6af0ba62f0ce5b1bedfe7556c6ccf3)
Mike Bayer
- add a subsection on how to use Sequence with server_default, fixes #3453 (cherry picked from commit b861b7537c29349da00793fc828226a68cded62d)
Mike Bayer
- add an 0.9 migration note regarding TypeEngine's default constructor removal; fixes #3446
Mike Bayer
- add a comment, also I think we want to expire before we do the new begin, as begin_nested() does a flush (cherry picked from commit 8f1130672d5a54dee311a11041857abfe85aa8a5)
Charles-Axel Dein
Expire session in testing transaction handling (cherry picked from commit d1dc39d55d111cdeffa663deec773d8bb67d237e)
Mike Bayer
- document SQlite dotted name issue, fixes #3441 (cherry picked from commit 4c90f355fd552e70009ffcdf3fdde9f3653e337e)
Allen, Timothy
Update to correct TDS version; FreeTDS only supports up to 7.3. 8.0 is not a valid version (Microsoft released the spec late). (cherry picked from commit 19571e2f8f4b621f3a1eaea198a8556497178015)
Éric Araujo
Fix typo in directive (cherry picked from commit 6245d003f2ce404daedfba9101bb1e4f098b4c66)
Jochen Van de Velde
Remove spaces around kwargs in metadata.rst (cherry picked from commit 1bc7881171e02a80bcdb45191be6c6d83b6f01fd)
Mike Bayer
- break out binary insert against None, disable for freetds for now (cherry picked from commit 0198d9aa5fee96c7523cc3e827baaba442c0ba02) - backport no freetds rule
Mike Bayer
- autopep8 (cherry picked from commit 96f49085b8dd05062b97c4f9c892c071042dad66)
Mike Bayer
- liberalize list.remove() regexp as recent Pypy versions format this message differently than cpython (cherry picked from commit 1bb9c99ea9f3e36e5d4a9f1d4f21f1d0a252db4a)
Mike Bayer
- document fully how to use autoincrement w/ SQLite including non-Integer column types, fixes #2075
Mike Bayer
flake8 some tests (cherry picked from commit 164f2ad2f433b3d297df709d617a1fc421495921)
Pierre Rochard
Correcting typo in introspection (cherry picked from commit 9434356da63006b3bfbb7833bb62def4cda17189)
Mike Bayer
- Added official support for a CTE used by the SELECT present inside of :meth:`.Insert.from_select`. This behavior worked accidentally up until 0.9.9, when it no longer worked due to unrelated changes as part of ticket`3248`. Note that this is the rendering of the WITH clause after the INSERT, before the SELECT; the full functionality of CTEs rendered at the top level of INSERT, UPDATE, DELETE is a new feature targeted for a later release. fixes #3418 (cherry picked from commit eb1bb84fbc10c801c7269a3d38c9e0235327857e)
Mike Bayer
- plead with RTD to please please use the correct version (cherry picked from commit 6d7901fa7d3feb5c7894e31a48d249b445557f20)
Mike Bayer
RTD doesn't seem to want to refresh on a git tag so go back to using release numbers
Mike Bayer
- re-tag zzzeeksphinx w/ new version supporting sphinx 1.3 (cherry picked from commit 4f31db82100bee20284d8e9273ac9c6d147a32e3)
Mike Bayer
- bump zs version due to not yet diagnosed error (cherry picked from commit ae4c2b6cbee0f993b3937237411df7fb8e66592d)
Mike Bayer
- fix typo MANYTOONE -> MANYTOMANY, fixes #3415 (cherry picked from commit be81cb200d9efb45c3bf331315c54dff778b5de6)
Mike Bayer
- Repair _reinstall_default_lookups to also flip the _extended flag off again so that test fixtures setup/teardown instrumentation as expected - clean up test_extendedattr.py and fix it to no longer leak itself outside by ensuring _reinstall_default_lookups is always called, part of #3408 - Fixed bug where when using extended attribute instrumentation system, the correct exception would not be raised when :func:`.class_mapper` were called with an invalid input that also happened to not be weak referencable, such as an integer. fixes #3408 (cherry picked from commit 95949db715ff54be01bfd260a51903ede60597ae)
Mike Bayer
- Fixed an import that prevented "pypy setup.py test" from working correctly. fixes #3406
Mike Bayer
- Repaired / added to tests yet more expressions that were reported as failing with the new 'entity' key value added to :attr:`.Query.column_descriptions`, the logic to discover the "from" clause is again reworked to accommodate columns from aliased classes, as well as to report the correct value for the "aliased" flag in these cases. fixes #3409 (cherry picked from commit 24d6ea362e757c79b3bada663cf6fc9f262dae4f)
Mike Bayer
- Fixed regression from 0.9.10 prior to release due to ticket`3349` where the check for query state on :meth:`.Query.update` or :meth:`.Query.delete` compared the empty tuple to itself using ``is``, which fails on Pypy to produce ``True`` in this case; this would erronously emit a warning in 0.9 and raise an exception in 1.0. fixes #3405 (cherry picked from commit 681276b5b4ae48924c85a1c26af3f9bde3d77b5f)
Mike Bayer
- Fixed regression from as yet unreleased 0.9.10 where the new addition of ``entity`` to the :attr:`.Query.column_descriptions` accessor would fail if the target entity was produced from a core selectable such as a :class:`.Table` or :class:`.CTE` object. fixes #3403 references #3320 (cherry picked from commit 20e3df602846bb1d8940b5138f21ef203c99bade)
Mike Bayer
- add boldface for "viable" plus a note describing that this refers to the table having a primary key. fixes #3398 (cherry picked from commit 93b5eae9843d423378f68be928a4f1e6fcacfb87)
Ernest Walzel
Fix typo in 'Relationships API' docs exprssed -> expressed (cherry picked from commit da327d0349b2af88700808c8e0041eda4c57882f)
Mike Bayer
- try pinning a tag here to for RTD to please build correctly (cherry picked from commit 6833669469b646fbd332b9ce4bd59a1122d3aa99)
Mike Bayer
- add a warning to SingletonThreadPool that it isn't for general use (cherry picked from commit 732fb99fc0afbeb69d684b2bfa6d0be6250919a3)
Mike Bayer
- Added the string value ``"none"`` to those accepted by the :paramref:`.Pool.reset_on_return` parameter as a synonym for ``None``, so that string values can be used for all settings, allowing .ini file utilities like :func:`.engine_from_config` to be usable without issue. fixes #3375 (cherry picked from commit c2e3002503242331fc8f2b314e0d4f3c65de9d73)
Eric Streeper
PEP8 cleanup in /test/aaa_profiling (cherry picked from commit 45876612d2342250b73a9d3d9afd2bd6008db4c6)
Eric Streeper
PEP8 cleanup in /test/engine (cherry picked from commit 0f0e305d25b6da1d42259e53ebd48712dfae5f40)
Eric Streeper
PEP8 cleanup in /test/sql (cherry picked from commit e467db9edba1e629ba45704047fa76ecd08922ff)
Mike Bayer
- adjust for "0" (cherry picked from commit fc702c9d809878c5a5d85876bfa23e17177940c2)
Mike Bayer
- remove errant 1.0 migration doc from 0.9 branch
Mike Bayer
- Fixed issue where a :class:`.MetaData` object that used a naming convention would not properly work with pickle. The attribute was skipped leading to inconsistencies and failures if the unpickled :class:`.MetaData` object were used to base additional tables from. fixes #3362 (cherry picked from commit 55c26710a1f6d6c6f87a9752035bc160f93b38d0)
Mike Bayer
- add test support for MySQLdb with use_unicode=1 or using mysqlclient on py3k (cherry picked from commit ffec6ab936a73f5cbe63d9409beb12f1f0307d0b)
Mike Bayer
- add some teardown for connections that are held open after tests in some cases, interfering with tests that check pool._refs (cherry picked from commit 44a9820b4e02f65b3884fa2c016efce9663e4910)
Mike Bayer
- make sure this is 1.0.0 backported to 0.9
Mike Bayer
- Fixed a long-standing bug where the :class:`.Enum` type as used with the psycopg2 dialect in conjunction with non-ascii values and ``native_enum=False`` would fail to decode return results properly. This stemmed from when the PG :class:`.postgresql.ENUM` type used to be a standalone type without a "non native" option. fixes #3354 cherry pick from ecd7b31d5eaed138e699293719f70260da3c978d
Mike Bayer
- Fixed bug where the state tracking within multiple, nested :meth:`.Session.begin_nested` operations would fail to propagate the "dirty" flag for an object that had been updated within the inner savepoint, such that if the enclosing savepoint were rolled back, the object would not be part of the state that was expired and therefore reverted to its database state. fixes #3352 (cherry picked from commit 359f471a1203cafd5dc99b5b078ba7d788b67cec)
Mike Bayer
- :class:`.Query` doesn't support joins, subselects, or special FROM clauses when using the :meth:`.Query.update` or :meth:`.Query.delete` methods; instead of silently ignoring these fields if methods like :meth:`.Query.join` or :meth:`.Query.select_from` has been called, a warning is emitted. In 1.0.0b5 this will raise an error. Partial cherry pick from 5302bcebb8e18fdad7448ffb60d2a2017eab26c8. fixes #3349 - don't realy need _no_select_modifiers anymore
Ernest Walzel
Fix typos agaisnt -> against 'a Alias' -> 'an Alias' (cherry picked from commit a518b31f3b131ae8304026109cd826e38c2afc26)
Mike Bayer
fdb drivers seem to be no longer available (cherry picked from commit 422fca43f8af1bfba0c2a2d24aa2eca7fc3bd558)
Mike Bayer
- merge recent commits from master which reorganize and clarify MySQL unicode documentation, bringing it up-to-date with current DBAPI support
Mike Bayer
- add a note that we aren't really doing zxjdbc right now even though these files are present. (cherry picked from commit ffddfe1b17b5c09dcb6289f807200f7c8279190e)
Mike Bayer
- Fixed unicode support for PyMySQL when using an "executemany" operation with unicode parameters. SQLAlchemy now passes both the statement as well as the bound parameters as unicode objects, as PyMySQL generally uses string interpolation internally to produce the final statement, and in the case of executemany does the "encode" step only on the final statement. fixes #3337 (cherry picked from commit dcf5408f7d315b4d9ddec5d0d696eb364d763099) Conflicts: lib/sqlalchemy/dialects/mysql/pymysql.py
Mike Bayer
- changelog for #3333, fixes #3333 (cherry picked from commit 2feb40d0a48dd424c38a37e70a63a6bcf3c00c02)
David Marin
fix Python 2-specific byte conversion (cherry picked from commit 00f37f3984c35fc4a2ee5687e798c5ca36953d6c)
Mike Bayer
- fix typo, fixes #3325 (cherry picked from commit 138293c246fbf8c6693044a89fe788d0d0446113)
Mike Bayer
- remove now-misleading comment that SQLite doesn't support MATCH, since they've apparently added something for it
Mike Bayer
- call this 1.0.0b1 (cherry picked from commit 64b7a50cbd64b44fa8ee8413213e9eae73483515)
Mike Bayer
- repair forwards-port directives
Mike Bayer
- Fixed regression from 0.9.9 where the :func:`.as_declarative` symbol was removed from the ``sqlalchemy.ext.declarative`` namespace. fixes #3324
Mike Bayer
- fix quantize recipe, fixes #3322 (cherry picked from commit e42d8184ac087e12e463f938e6a07759cc6392ca)
Mike Bayer
- try to document how to get columns from constraints. unfortunately Sphinx refuses to work correctly for the columns attribute so we just add a lame message to contains_column(). (cherry picked from commit f211ad254d53b85aae319b41cc7b206f3e693660)
Mike Bayer
0.9.10 bump
Mike Bayer
- Added a new entry ``"entity"`` to the dictionaries returned by :attr:`.Query.column_descriptions`. This refers to the primary ORM mapped class or aliased class that is referred to by the expression. Compared to the existing entry for ``"type"``, it will always be a mapped entity, even if extracted from a column expression, or None if the given expression is a pure core expression. references #3320 (cherry picked from commit b815e9483319b93f98bef11c7d47378441f78d21)
Mike Bayer
- feature, not enhancement
Mike Bayer
- 0.9.9
Mike Bayer
- copyright 2015
Mike Bayer
- repair doclevel
Mike Bayer
- changelog and docs for pullreq bitbucket:45 (cherry picked from commit 5d1206c10a96b6685e57baa9ae09f04f00cf425b) Conflicts: lib/sqlalchemy/dialects/postgresql/base.py
Iuri de Silvio
Dialect option `postgresql_concurrently` to `Index` construct. (cherry picked from commit 955576fcf6e7aff7fe924ec3b33bb6d243ddd312)
Mike Bayer
- changelog for pr github:154 (cherry picked from commit 78874d3679fe45275d44dda40f4f1bae9a0558b7)
Gilles Dartiguelongue
Fix slice addressing of _AssociationList with python3 (cherry picked from commit 9fee9cb87e0d13db4426664f5758c1ddad0533e3)
Mike Bayer
- changelog / doc for sqlite partial indexes (cherry picked from commit 6ac0555eaa6363ac9d0ad6566248dd294ad61d9e)
Kai Groner
Test for partial index support in sqlite dialects. (cherry picked from commit 4a42bd5a2cba23782df7b6f98cadb7382d22498e)
Kai Groner
Partial index support with sqlite dialects. From https://www.sqlite.org/partialindex.html > Partial indexes have been supported in SQLite since version 3.8.0. Reflection does not expose the predicate of partial indexes. The postgresql dialect does detect such indexes and issue a warning. I looked into matching this level of support, but the sqlite pragma index_info does not expose the predicate. Getting this data would probably require …
jocmeh
minor docstring fix in MappedCollection class (cherry picked from commit 34cb52e8d9f9bf345904315f16fb87ca9310d9cb)
jheld
Update migration_09.rst typo fix: indivdual -> individual. (cherry picked from commit c5edbc6fdc611d3c812735d83fe056fbb7d113f5)
Mike Bayer
- Fixed bugs in ORM object comparisons where comparison of many-to-one ``!= None`` would fail if the source were an aliased class, or if the query needed to apply special aliasing to the expression due to aliased joins or polymorphic querying; also fixed bug in the case where comparing a many-to-one to an object state would fail if the query needed to apply special aliasing due to aliased joins or polymorphic querying. fixes #3310 (cherry picked from commit 305ea84004fe604f461cd3c9438fbc84e3d790b2)
Mike Bayer
- Fixed bug where internal assertion would fail in the case where an ``after_rollback()`` handler for a :class:`.Session` incorrectly adds state to that :class:`.Session` within the handler, and the task to warn and remove this state (established by ticket`2389`) attempts to proceed. fixes #3309 (cherry picked from commit ad66266d3d275a6129e3270eaacdad171bc10817)
Mike Bayer
- autopep8 (cherry picked from commit b86b239c87528cfd898b8b1c66fe1c78f127cccc)
Mike Bayer
- add a new section regarding multiprocessing (cherry picked from commit 94d57374c44b49dce8531a0b0ed3116e52530c3b)
Mike Bayer
- flake8 (cherry picked from commit 03038f7e75500e7d5388dedd79d9b35e01b3a677)
Mike Bayer
- test + changelog (cherry picked from commit 7b9134be7129346e486a5caca7bdc87de7ccf015) Conflicts: lib/sqlalchemy/orm/query.py
malthe
It's the 'kwargs' which are iterable, not 'keys' (cherry picked from commit 02c072edbb1eaa826632e70174eb96915bb725b5)
Mike Bayer
- update test for newer API of _connection_for_bind
Mike Bayer
- Fixed bug in :class:`.Connection` and pool where the :meth:`.Connection.invalidate` method, or an invalidation due to a database disconnect, would fail if the ``isolation_level`` parameter had been used with :meth:`.Connection.execution_options`; the "finalizer" that resets the isolation level would be called on the no longer opened connection. fixes #3302 (cherry picked from commit 068f9a1531c8114360d5fcd964c27fe6a21f4679)
Mike Bayer
- A warning is emitted if the ``isolation_level`` parameter is used with :meth:`.Connection.execution_options` when a :class:`.Transaction` is in play; DBAPIs and/or SQLAlchemy dialects such as psycopg2, MySQLdb may implicitly rollback or commit the transaction, or not change the setting til next transaction, so this is never safe. - Added new parameter :paramref:`.Session.connection.execution_options` which may be used to set up execution options on a :class:`.Connection` when it is first checked out, before the transaction has begun. This is used to set up options such as isolation level on the connection before the transaction starts. - added new documentation section detailing best practices for setting transaction isolation with sessions. fixes #3296 (cherry picked from commit 9cbe235810b7c0c24d2556b4bb581b0207812e2d) Conflicts: test/orm/test_bind.py
Mike Bayer
- Fixed bug in lazy loading SQL construction whereby a complex primaryjoin that referred to the same "local" column multiple times in the "column that points to itself" style of self-referential join would not be substituted in all cases. The logic to determine substitutions here has been reworked to be more open-ended. fixes #3300 Conflicts: test/orm/test_relationships.py
Mike Bayer
- Repaired support for Postgresql UUID types in conjunction with the ARRAY type when using psycopg2. The psycopg2 dialect now employs use of the psycopg2.extras.register_uuid() hook so that UUID values are always passed to/from the DBAPI as UUID() objects. The :paramref:`.UUID.as_uuid` flag is still honored, except with psycopg2 we need to convert returned UUID objects back into strings when this is disabled. fixes #2940 (cherry picked from commit b2189da65019ed2f44e77933a122619489319c5a)
Kevin Deldycke
Add unit test for UUID arrays in PostgreSQL. (cherry picked from commit cf4e421248e3175b97170d0c6930b360ff326c06)
Mike Bayer
- Added support for the :class:`postgresql.JSONB` datatype when using psycopg2 2.5.4 or greater, which features native conversion of JSONB data so that SQLAlchemy's converters must be disabled; additionally, the newly added psycopg2 extension ``extras.register_default_jsonb`` is used to establish a JSON deserializer passed to the dialect via the ``json_deserializer`` argument. Also repaired the Postgresql integration tests which weren't actually round-tripping the JSONB type as opposed to the JSON type. Pull request courtesy Mateusz Susik. - Repaired the use of the "array_oid" flag when registering the HSTORE type with older psycopg2 versions < 2.4.3, which does not support this flag, as well as use of the native json serializer hook "register_default_json" with user-defined ``json_deserializer`` on psycopg2 versions < 2.5, which does not include native json. (cherry picked from commit bf70f556b382dc376783efbcb598e0fab71ee235)
Mateusz Susik
Psycopg2 JSONB support. (cherry picked from commit e7d61d594b8a89535696436a667a526bd2999fb2)
Mike Bayer
- Fixed bug in 0.9's foreign key setup system, such that the logic used to link a :class:`.ForeignKey` to its parent could fail when the foreign key used "link_to_name=True" in conjunction with a target :class:`.Table` that would not receive its parent column until later, such as within a reflection + "useexisting" scenario, if the target column in fact had a key value different from its name, as would occur in reflection if column reflect events were used to alter the .key of reflected :class:`.Column` objects so that the link_to_name becomes significant. Also repaired support for column type via FK transmission in a similar way when target columns had a different key and were referenced using link_to_name. fixes #3298 (cherry picked from commit 3712e35c329cc3b5106f026be90e04f65412586d)
Mike Bayer
- fix link to non_primary flag - rewrite the multiple mappers section
Mike Bayer
- Added new user-space accessors for viewing transaction isolation levels; :meth:`.Connection.get_isolation_level`, :attr:`.Connection.default_isolation_level`. - enhance documentation inter-linkage between new accessors, existing isolation_level parameters, as well as in the dialect-level methods which should be fully covered by Engine/Connection level APIs now. (cherry picked from commit c3d898e8d06c7e549bb273fc8654f5d24fab2204)
Mike Bayer
- enhance detail here regarding the difference between Connection.connection and engine.raw_connection() (cherry picked from commit 4032aaf097a9268bc331e4b4815d77b19ba3febb)
Mike Bayer
formatting (cherry picked from commit 10dd5fe81062347905492ef66e6f0453479cc03b)
Mike Bayer
- add an exclusion here that helps with the case of 3rd party test suite redefining an existing test in test_suite Conflicts: lib/sqlalchemy/testing/plugin/pytestplugin.py
Mike Bayer
- Fixed bug where Postgresql dialect would fail to render an expression in an :class:`.Index` that did not correspond directly to a table-bound column; typically when a :func:`.text` construct was one of the expressions within the index; or could misinterpret the list of expressions if one or more of them were such an expression. fixes #3174 (cherry picked from commit 79fa69f1f37fdbc0dfec6bdea1e07f52bfe18f7b)
Mike Bayer
- add new section to ORM referring to runtime inspection API, more links, attempt to fix #3290
Mike Bayer
- The "wildcard" loader options, in particular the one set up by the :func:`.orm.load_only` option to cover all attributes not explicitly mentioned, now takes into account the superclasses of a given entity, if that entity is mapped with inheritance mapping, so that attribute names within the superclasses are also omitted from the load. Additionally, the polymorphic discriminator column is unconditionally included in the list, just in the same way that primary key columns are, so that even with load_only() set up, polymorphic loading of subtypes continues to function correctly. fixes #3287 (cherry picked from commit b63aae2c232f980a47aa2a635c35dfa45390f451) Conflicts: lib/sqlalchemy/orm/mapper.py
Mike Bayer
- this will be 0.9.9
Mike Bayer
- changelog for pr 41 (cherry picked from commit 5f1d34c4c86263684d5a79c8d8f9db8d1e3afccb)
Dimitris Theodorou
Add native_enum flag to Enum's repr() result Needed for alembic autogenerate rendering. (cherry picked from commit f4b7b02e31e6b49195c21da7221bcbda0bad02b9) Conflicts: test/sql/test_types.py
Mike Bayer
- add a close here
Mike Bayer
- Fixed bug where if an exception were thrown at the start of a :class:`.Query` before it fetched results, particularly when row processors can't be formed, the cursor would stay open with results pending and not actually be closed. This is typically only an issue on an interpreter like Pypy where the cursor isn't immediately GC'ed, and can in some circumstances lead to transactions/ locks being open longer than is desirable. fixes #3285 Conflicts: lib/sqlalchemy/orm/loading.py
Mike Bayer
- make a new page that introduces mapping a little better for the "mapping" section, contrasts declarative and classical some more Conflicts: doc/build/orm/mapper_config.rst
Mike Bayer
- fix some RST whitespace syntactical issues in toctrees - have the topmost toctree only include page names - add glossary to toctree, remove search by itself (cherry picked from commit 87a1af4efe5bb515d9e687e2f7dfc84dfb8ee522) Conflicts: doc/build/changelog/index.rst
Mike Bayer
- see if we can get RTD to use this for now
Mike Bayer
bump (cherry picked from commit 1cb24b37421d413045daccfc819d9fa0e61dd4c4)
Mike Bayer
bump (cherry picked from commit 60368fdd9f278492099f7c8108456ecbb44c76ef)
Mike Bayer
- fix links for loading, add a redirect page bump foo (cherry picked from commit 0bd632804eae635d793175a959294f49f3538806)
Mike Bayer
- another bump (cherry picked from commit d11c7a197e556eda873b267d20a03e317477e510)
Mike Bayer
- remove private superclasses from docs in favor of fixing zzzeeksphinx to omit these from warning
Mike Bayer
remove pipe... (cherry picked from commit 3ccae267894804b104171f2fee9355cd292e0dbf)
Mike Bayer
no hassuffixes in 0.9
Mike Bayer
corrections (cherry picked from commit 5343d24fee5219de002a8efba8bc882f8b3d4b5b)
Mike Bayer
- corrections - attempt to add a script to semi-automate the fixing of links (cherry picked from commit 544e72bcb6af1ca657b1762f105634372eca3bc0)
Mike Bayer
- squash-merge the improve_toc branch, which moves all the Sphinx styling and extensions into an external library, and also reorganizes most large documentation pages into many small areas to reduce scrolling and better present the context into a more fine-grained hierarchy. (cherry picked from commit 9561321d0328df270c4ff0360dc7a035db627949) - manually port previous differences between 0.9 and 1.0 docs to the cherry-pick.
Mike Bayer
- typo fixes #3269 (cherry picked from commit ef6dc0cf2ef581e7cb53dcb4840f678aa1fa5ba6)
Mike Bayer
- ouch, this needs to be in dbapi, not module level!
Mike Bayer
- make the google deprecation messages more specific, use full URL format - add an extra doc to MySQLdb - changelog (cherry picked from commit 182553b7409cfa6673483d03f29bc4c462336577)
rob_b
Update gaerdbms to highlight improved connection method (cherry picked from commit 0d15791a6e3ec35e3c2e297026d8396742e30a34)
Priit Laes
Maul the evaulate & friends typo (cherry picked from commit 8ae47dc6e0a98b359247040236be0810b9086f40) Conflicts: doc/build/changelog/changelog_10.rst doc/build/changelog/migration_10.rst lib/sqlalchemy/ext/declarative/base.py
Mike Bayer
- Fixed bug where using a :class:`.TypeDecorator` that implemented a type that was also a :class:`.TypeDecorator` would fail with Python's "Cannot create a consistent method resolution order (MRO)" error, when any kind of SQL comparison expression were used against an object using this type. (cherry picked from commit d1ac6cb33af3b105db7cdb51411e10ac3bafff1f)
Mike Bayer
- Added a version check to the MySQLdb dialect surrounding the check for 'utf8_bin' collation, as this fails on MySQL server < 5.0. fixes #3274 (cherry picked from commit 00aaaa4bd4aa150ff9964bf2c00b1404d2e8a140)
Mike Bayer
- automap isn't new anymore
Mike Bayer
- Added new method :meth:`.Session.invalidate`, functions similarly to :meth:`.Session.close`, except also calls :meth:`.Connection.invalidate` on all connections, guaranteeing that they will not be returned to the connection pool. This is useful in situations e.g. dealing with gevent timeouts when it is not safe to use the connection further, even for rollbacks. references #3258 (cherry picked from commit cf7981f60d485f17465f44c6ff651ae283ade377)
Mike Bayer
- fix up query update /delete documentation, make warnings a lot clearer, partial fixes for #3252 (cherry picked from commit 3c70f609507ccc6775495cc533265aeb645528cd) Conflicts: lib/sqlalchemy/orm/query.py
Yuval Langer
Removing unneeded space. (cherry picked from commit c86c593ec3b913361999a1970efae3e6f3d831fa)
Mike Bayer
pep8 (cherry picked from commit 95cd2003bbe1b5da2d3c78ac845855126e03de2f)
Mike Bayer
- pep8 (cherry picked from commit ec6214457ed71f0ae87d83076e084214650aae5d) Conflicts: test/dialect/test_sqlite.py
Mike Bayer
- pep8 cleanup (cherry picked from commit 6e53e866dea4eba630128e856573ca1076b91611)
Mike Bayer
- Updated the :ref:`examples_versioned_history` example such that mapped columns are re-mapped to match column names as well as grouping of columns; in particular, this allows columns that are explicitly grouped in a same-column-named joined inheritance scenario to be mapped in the same way in the history mappings, avoiding warnings added in the 0.9 series regarding this pattern and allowing the same view of attribute keys. (cherry picked from commit de62497b03274c860ea2554dfbacb3064ce02c19)
Mike Bayer
- formatting (cherry picked from commit a88be57fb7ef96e914d8a7fb90de375ec7f0befd)
Jon Nelson
- fix minor spelling error (cherry picked from commit 5fd779df0c958dc1ec2766f55d80b3090d2427eb)
jvanasco
added docs to clarify that sql statement is already in a dialect (cherry picked from commit 0f5a400b77862d2ae8f5d1a326fe9571da8fc0cb)
Mike Bayer
- add an order_by here (cherry picked from commit fb06fa9d6e6f6da8eee5b7dfc196c3e12761da61)
Mike Bayer
- Fixed a bug in the examples/generic_assocaitions/discriminator_on_association.py example, where the subclasses of AddressAssociation were not being mapped as "single table inheritance", leading to problems when trying to use the mappings further. (cherry picked from commit 2098001ad3e0a40aa909a347ec91c12fab04a657)
Mike Bayer
- Fixed a leak which would occur in the unsupported and highly non-recommended use case of replacing a relationship on a fixed mapped class many times, referring to an arbitrarily growing number of target mappers. A warning is emitted when the old relationship is replaced, however if the mapping were already used for querying, the old relationship would still be referenced within some registries. fixes #3251
Mike Bayer
- Fixed issue where the columns from a SELECT embedded in an INSERT, either through the values clause or as a "from select", would pollute the column types used in the result set produced by the RETURNING clause when columns from both statements shared the same name, leading to potential errors or mis-adaptation when retrieving the returning rows. fixes #3248
Mike Bayer
- we aren't changing .key behavior yet here, this is just documentation
Mike Bayer
- in lieu of adding a new system of translating bound parameter names for psycopg2 and others, encourage users to take advantage of positional styles by documenting "paramstyle". A section is added to psycopg2 specifically as this is a pretty common spot for named parameters that may be unusually named. fixes #3246.
Mike Bayer
- edits to the subqueryload ordering merge
Jack Zhou
Added documentation about interaction between `subqueryload` and LIMIT/OFFSET.
Mike Bayer
- missing import
Mike Bayer
- Fixed bug regarding expression mutations which could express itself as a "Could not locate column" error when using :class:`.Query` to select from multiple, anonymous column entities when querying against SQLite, as a side effect of the "join rewriting" feature used by the SQLite dialect. fixes #3241
Mike Bayer
- added new backend for pysqlcipher, as we will probably get requests for it soon.
Mike Bayer
- Fixed bug where the ON clause for :meth:`.Query.join`, and :meth:`.Query.outerjoin` to a single-inheritance subclass using ``of_type()`` would not render the "single table criteria" in the ON clause if the ``from_joinpoint=True`` flag were set. fixes #3232 Conflicts: test/orm/inheritance/test_single.py
Mike Bayer
- repair documenation for object_session(), returns None if no session, and refer to InstanceState.session. Add note about objects that are deleted within an ongoing transaction.
Mike Bayer
- flake8 Conflicts: test/orm/test_relationships.py
mozillazg
Fixed typo
Mike Bayer
0.9.8
Mike Bayer
- additional issues fixed in mysqlconnector 2.0.1
Mike Bayer
- this test passes now in more recent mysqlconnector
Mike Bayer
- Mysqlconnector as of version 2.0, probably as a side effect of the python 3 merge, now does not expect percent signs (e.g. as used as the modulus operator and others) to be doubled, even when using the "pyformat" bound parameter format (this change is not documented by Mysqlconnector). The dialect now checks for py2k and for mysqlconnector less than version 2.0 when detecting if the modulus operator should be rendered as ``%%`` or ``%``. - Unicode SQL is now passed for MySQLconnector version 2.0 and above; for Py2k and MySQL < 2.0, strings are encoded. Note that mysqlconnector as of 2.0.1 appears to have a bug with unicode DDL on py2k, so the tests here are skipping until we observe it's fixed. - take out profiling on mysqlconnector, callcounts vary too much with its current developme… Conflicts: test/profiles.txt
Mike Bayer
- embedding an existing predicate into a new one only seems to be used by test_oracle->test_coerce_to_unicode(). The predicate here should treat as a lambda based on enabled_for_config. not sure why this test is not failing on jenkins
Mike Bayer
- Fixed long-standing bug in Oracle dialect where bound parameter names that started with numbers would not be quoted, as Oracle doesn't like numerics in bound parameter names. fixes #2138
Mike Bayer
- fix the marker here so this page can be found - clarify the note about the defaults, note that it's upcoming in 1.0
Mike Bayer
- apply patches to correct for + sign in with_hint() docs, fixes #3036
Mike Bayer
- Fixed bug where a fair number of SQL elements within the sql package would fail to ``__repr__()`` successfully, due to a missing ``description`` attribute that would then invoke a recursion overflow when an internal AttributeError would then re-invoke ``__repr__()``. fixes #3195
Mike Bayer
- clean up unicode docs and clarify that client_encoding at the engine level is not the same thing as at the connect args level.
Mike Bayer
- adjustment for ref #3200 as we need an immutabledict() here so that union() can be called, in the case of a dialect that uses execution options inside of initialize() (e.g. oursql)
Mike Bayer
- Fixed "'NoneType' object has no attribute 'concrete'" error when using :class:`.AbstractConcreteBase` in conjunction with a subclass that declares ``__abstract__``. fixes #3185 Conflicts: test/ext/declarative/test_inheritance.py
Mike Bayer
- The execution options passed to an :class:`.Engine` either via :paramref:`.create_engine.execution_options` or :meth:`.Engine.update_execution_options` are not passed to the special :class:`.Connection` used to initialize the dialect within the "first connect" event; dialects will usually perform their own queries in this phase, and none of the current available options should be applied here. In particular, the "autocommit" option was causing an attempt to…
Mike Bayer
- rework tests for attached databases into individual tests, test both memory and file-based - When selecting from a UNION using an attached database file, the pysqlite driver reports column names in cursor.description as 'dbname.tablename.colname', instead of 'tablename.colname' as it normally does for a UNION (note that it's supposed to just be 'colname' for both, but we work around it). The column translation logic here has been adjusted to retrieve the…
Mike Bayer
- A revisit to this issue first patched in 0.9.5, apparently psycopg2's ``.closed`` accessor is not as reliable as we assumed, so we have added an explicit check for the exception messages "SSL SYSCALL error: Bad file descriptor" and "SSL SYSCALL error: EOF detected" when detecting an is-disconnect scenario. We will continue to consult psycopg2's connection.closed as a first check. fixes #3021
Mike Bayer
- flake8
232 commits not shown.