{"action":"closed","number":150,"pull_request":{"url":"https://api.github.com/repos/smirnovvad/students_api/pulls/150","id":225405134,"node_id":"MDExOlB1bGxSZXF1ZXN0MjI1NDA1MTM0","html_url":"https://github.com/smirnovvad/students_api/pull/150","diff_url":"https://github.com/smirnovvad/students_api/pull/150.diff","patch_url":"https://github.com/smirnovvad/students_api/pull/150.patch","issue_url":"https://api.github.com/repos/smirnovvad/students_api/issues/150","number":150,"state":"closed","locked":false,"title":"Scheduled daily dependency update on wednesday","user":{"login":"pyup-bot","id":16239342,"node_id":"MDQ6VXNlcjE2MjM5MzQy","avatar_url":"https://avatars0.githubusercontent.com/u/16239342?v=4","gravatar_id":"","url":"https://api.github.com/users/pyup-bot","html_url":"https://github.com/pyup-bot","followers_url":"https://api.github.com/users/pyup-bot/followers","following_url":"https://api.github.com/users/pyup-bot/following{/other_user}","gists_url":"https://api.github.com/users/pyup-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/pyup-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pyup-bot/subscriptions","organizations_url":"https://api.github.com/users/pyup-bot/orgs","repos_url":"https://api.github.com/users/pyup-bot/repos","events_url":"https://api.github.com/users/pyup-bot/events{/privacy}","received_events_url":"https://api.github.com/users/pyup-bot/received_events","type":"User","site_admin":false},"body":"\n\n\n\n\n### Update [aniso8601](https://pypi.org/project/aniso8601) from **3.0.0** to **3.0.2**.\n\n\n*The bot wasn't able to find a changelog for this release. [Got an idea?](https://github.com/pyupio/changelogs/issues/new)*\n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/aniso8601\n  - Repo: https://bitbucket.org/nielsenb/aniso8601\n</details>\n\n\n\n\n\n### Update [click](https://pypi.org/project/click) from **6.7** to **7.0**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 7.0\n   ```\n   -----------\n\nReleased 2018-09-25\n\n-   Drop support for Python 2.6 and 3.3. (`967`_, `976`_)\n-   Wrap ``click.Choice``&#39;s missing message. (`202`_, `1000`_)\n-   Add native ZSH autocompletion support. (`323`_, `865`_)\n-   Document that ANSI color info isn&#39;t parsed from bytearrays in\n    Python 2. (`334`_)\n-   Document byte-stripping behavior of ``CliRunner``. (`334`_,\n    `1010`_)\n-   Usage errors now hint at the ``--help`` option. (`393`_, `557`_)\n-   Implement streaming pager. (`409`_, `889`_)\n-   Extract bar formatting to its own method. (`414`_)\n-   Add ``DateTime`` type for converting input in given date time\n    formats. (`423`_)\n-   ``secho``&#39;s first argument can now be ``None``, like in ``echo``.\n    (`424`_)\n-   Fixes a ``ZeroDivisionError`` in ``ProgressBar.make_step``, when the\n    arg passed to the first call of ``ProgressBar.update`` is 0.\n    (`447`_, `1012`_)\n-   Show progressbar only if total execution time is visible. (`487`_)\n-   Added the ability to hide commands and options from help. (`500`_)\n-   Document that options can be ``required=True``. (`514`_, `1022`_)\n-   Non-standalone calls to ``Context.exit`` return the exit code,\n    rather than calling ``sys.exit``. (`533`_, `667`_, `1098`_)\n-   ``click.getchar()`` returns Unicode in Python 3 on Windows,\n    consistent with other platforms. (`537`_, `821`_, `822`_,\n    `1088`_, `1108`_)\n-   Added ``FloatRange`` type. (`538`_, `553`_)\n-   Added support for bash completion of ``type=click.Choice`` for\n    ``Options`` and ``Arguments``. (`535`_, `681`_)\n-   Only allow one positional arg for ``Argument`` parameter\n    declaration. (`568`_, `574`_, `1014`_)\n-   Add ``case_sensitive=False`` as an option to Choice. (`569`_)\n-   ``click.getchar()`` correctly raises ``KeyboardInterrupt`` on &quot;^C&quot;\n    and ``EOFError`` on &quot;^D&quot; on Linux. (`583`_, `1115`_)\n-   Fix encoding issue with ``click.getchar(echo=True)`` on Linux.\n    (`1115`_)\n-   ``param_hint`` in errors now derived from param itself. (`598`_,\n    `704`_, `709`_)\n-   Add a test that ensures that when an argument is formatted into a\n    usage error, its metavar is used, not its name. (`612`_)\n-   Allow setting ``prog_name`` as extra in ``CliRunner.invoke``.\n    (`616`_, `999`_)\n-   Help text taken from docstrings truncates at the ``\\f`` form feed\n    character, useful for hiding Sphinx-style parameter documentation.\n    (`629`_, `1091`_)\n-   ``launch`` now works properly under Cygwin. (`650`_)\n-   Update progress after iteration. (`651`_, `706`_)\n-   ``CliRunner.invoke`` now may receive ``args`` as a string\n    representing a Unix shell command. (`664`_)\n-   Make ``Argument.make_metavar()`` default to type metavar. (`675`_)\n-   Add documentation for ``ignore_unknown_options``. (`684`_)\n-   Add bright colors support for ``click.style`` and fix the reset\n    option for parameters ``fg`` and ``bg``. (`703`_, `809`_)\n-   Add ``show_envvar`` for showing environment variables in help.\n    (`710`_)\n-   Avoid ``BrokenPipeError`` during interpreter shutdown when stdout or\n    stderr is a closed pipe. (`712`_, `1106`_)\n-   Document customizing option names. (`725`_, `1016`_)\n-   Disable ``sys._getframes()`` on Python interpreters that don&#39;t\n    support it. (`728`_)\n-   Fix bug in test runner when calling ``sys.exit`` with ``None``.\n    (`739`_)\n-   Clarify documentation on command line options. (`741`_, `1003`_)\n-   Fix crash on Windows console. (`744`_)\n-   Fix bug that caused bash completion to give improper completions on\n    chained commands. (`754`_, `774`_)\n-   Added support for dynamic bash completion from a user-supplied\n    callback. (`755`_)\n-   Added support for bash completions containing spaces. (`773`_)\n-   Allow autocompletion function to determine whether or not to return\n    completions that start with the incomplete argument. (`790`_,\n    `806`_)\n-   Fix option naming routine to match documentation and be\n    deterministic. (`793`_, `794`_)\n-   Fix path validation bug. (`795`_, `1020`_)\n-   Add test and documentation for ``Option`` naming: functionality.\n    (`799`_)\n-   Update doc to match arg name for ``path_type``. (`801`_)\n-   Raw strings added so correct escaping occurs. (`807`_)\n-   Fix 16k character limit of ``click.echo`` on Windows. (`816`_,\n    `819`_)\n-   Overcome 64k character limit when writing to binary stream on\n    Windows 7. (`825`_, `830`_)\n-   Add bool conversion for &quot;t&quot; and &quot;f&quot;. (`842`_)\n-   ``NoSuchOption`` errors take ``ctx`` so that ``--help`` hint gets\n    printed in error output. (`860`_)\n-   Fixed the behavior of Click error messages with regards to Unicode\n    on 2.x and 3.x. Message is now always Unicode and the str and\n    Unicode special methods work as you expect on that platform.\n    (`862`_)\n-   Progress bar now uses stderr by default. (`863`_)\n-   Add support for auto-completion documentation. (`866`_, `869`_)\n-   Allow ``CliRunner`` to separate stdout and stderr. (`868`_)\n-   Fix variable precedence. (`873`_, `874`_)\n-   Fix invalid escape sequences. (`877`_)\n-   Fix ``ResourceWarning`` that occurs during some tests. (`878`_)\n-   When detecting a misconfigured locale, don&#39;t fail if the ``locale``\n    command fails. (`880`_)\n-   Add ``case_sensitive=False`` as an option to ``Choice`` types.\n    (`887`_)\n-   Force stdout/stderr writable. This works around issues with badly\n    patched standard streams like those from Jupyter. (`918`_)\n-   Fix completion of subcommand options after last argument (`919`_,\n    `930`_)\n-   ``_AtomicFile`` now uses the ``realpath`` of the original filename\n    so that changing the working directory does not affect it.\n    (`920`_)\n-   Fix incorrect completions when defaults are present (`925`_,\n    `930`_)\n-   Add copy option attrs so that custom classes can be re-used.\n    (`926`_, `994`_)\n-   &quot;x&quot; and &quot;a&quot; file modes now use stdout when file is ``&quot;-&quot;``.\n    (`929`_)\n-   Fix missing comma in ``__all__`` list. (`935`_)\n-   Clarify how parameters are named. (`949`_, `1009`_)\n-   Stdout is now automatically set to non blocking. (`954`_)\n-   Do not set options twice. (`962`_)\n-   Move ``fcntl`` import. (`965`_)\n-   Fix Google App Engine ``ImportError``. (`995`_)\n-   Better handling of help text for dynamic default option values.\n    (`996`_)\n-   Fix ``get_winter_size()`` so it correctly returns ``(0,0)``.\n    (`997`_)\n-   Add test case checking for custom param type. (`1001`_)\n-   Allow short width to address cmd formatting. (`1002`_)\n-   Add details about Python version support. (`1004`_)\n-   Added deprecation flag to commands. (`1005`_)\n-   Fixed issues where ``fd`` was undefined. (`1007`_)\n-   Fix formatting for short help. (`1008`_)\n-   Document how ``auto_envvar_prefix`` works with command groups.\n    (`1011`_)\n-   Don&#39;t add newlines by default for progress bars. (`1013`_)\n-   Use Python sorting order for ZSH completions. (`1047`_, `1059`_)\n-   Document that parameter names are converted to lowercase by default.\n    (`1055`_)\n-   Subcommands that are named by the function now automatically have\n    the underscore replaced with a dash. If you register a function\n    named ``my_command`` it becomes ``my-command`` in the command line\n    interface.\n-   Hide hidden commands and options from completion. (`1058`_,\n    `1061`_)\n-   Fix absolute import blocking Click from being vendored into a\n    project on Windows. (`1068`_, `1069`_)\n-   Fix issue where a lowercase ``auto_envvar_prefix`` would not be\n    converted to uppercase. (`1105`_)\n\n.. _202: https://github.com/pallets/click/issues/202\n.. _323: https://github.com/pallets/click/issues/323\n.. _334: https://github.com/pallets/click/issues/334\n.. _393: https://github.com/pallets/click/issues/393\n.. _409: https://github.com/pallets/click/issues/409\n.. _414: https://github.com/pallets/click/pull/414\n.. _423: https://github.com/pallets/click/pull/423\n.. _424: https://github.com/pallets/click/pull/424\n.. _447: https://github.com/pallets/click/issues/447\n.. _487: https://github.com/pallets/click/pull/487\n.. _500: https://github.com/pallets/click/pull/500\n.. _514: https://github.com/pallets/click/issues/514\n.. _533: https://github.com/pallets/click/pull/533\n.. _535: https://github.com/pallets/click/issues/535\n.. _537: https://github.com/pallets/click/issues/537\n.. _538: https://github.com/pallets/click/pull/538\n.. _553: https://github.com/pallets/click/pull/553\n.. _557: https://github.com/pallets/click/pull/557\n.. _568: https://github.com/pallets/click/issues/568\n.. _569: https://github.com/pallets/click/issues/569\n.. _574: https://github.com/pallets/click/issues/574\n.. _583: https://github.com/pallets/click/issues/583\n.. _598: https://github.com/pallets/click/issues/598\n.. _612: https://github.com/pallets/click/pull/612\n.. _616: https://github.com/pallets/click/issues/616\n.. _629: https://github.com/pallets/click/pull/629\n.. _650: https://github.com/pallets/click/pull/650\n.. _651: https://github.com/pallets/click/issues/651\n.. _664: https://github.com/pallets/click/pull/664\n.. _667: https://github.com/pallets/click/issues/667\n.. _675: https://github.com/pallets/click/pull/675\n.. _681: https://github.com/pallets/click/pull/681\n.. _684: https://github.com/pallets/click/pull/684\n.. _703: https://github.com/pallets/click/issues/703\n.. _704: https://github.com/pallets/click/issues/704\n.. _706: https://github.com/pallets/click/pull/706\n.. _709: https://github.com/pallets/click/pull/709\n.. _710: https://github.com/pallets/click/pull/710\n.. _712: https://github.com/pallets/click/pull/712\n.. _719: https://github.com/pallets/click/issues/719\n.. _725: https://github.com/pallets/click/issues/725\n.. _728: https://github.com/pallets/click/pull/728\n.. _739: https://github.com/pallets/click/pull/739\n.. _741: https://github.com/pallets/click/issues/741\n.. _744: https://github.com/pallets/click/issues/744\n.. _754: https://github.com/pallets/click/issues/754\n.. _755: https://github.com/pallets/click/pull/755\n.. _773: https://github.com/pallets/click/pull/773\n.. _774: https://github.com/pallets/click/pull/774\n.. _790: https://github.com/pallets/click/issues/790\n.. _793: https://github.com/pallets/click/issues/793\n.. _794: https://github.com/pallets/click/pull/794\n.. _795: https://github.com/pallets/click/issues/795\n.. _799: https://github.com/pallets/click/pull/799\n.. _801: https://github.com/pallets/click/pull/801\n.. _806: https://github.com/pallets/click/pull/806\n.. _807: https://github.com/pallets/click/pull/807\n.. _809: https://github.com/pallets/click/pull/809\n.. _816: https://github.com/pallets/click/pull/816\n.. _819: https://github.com/pallets/click/pull/819\n.. _821: https://github.com/pallets/click/issues/821\n.. _822: https://github.com/pallets/click/issues/822\n.. _825: https://github.com/pallets/click/issues/825\n.. _830: https://github.com/pallets/click/pull/830\n.. _842: https://github.com/pallets/click/pull/842\n.. _860: https://github.com/pallets/click/issues/860\n.. _862: https://github.com/pallets/click/issues/862\n.. _863: https://github.com/pallets/click/pull/863\n.. _865: https://github.com/pallets/click/pull/865\n.. _866: https://github.com/pallets/click/issues/866\n.. _868: https://github.com/pallets/click/pull/868\n.. _869: https://github.com/pallets/click/pull/869\n.. _873: https://github.com/pallets/click/issues/873\n.. _874: https://github.com/pallets/click/pull/874\n.. _877: https://github.com/pallets/click/pull/877\n.. _878: https://github.com/pallets/click/pull/878\n.. _880: https://github.com/pallets/click/pull/880\n.. _883: https://github.com/pallets/click/pull/883\n.. _887: https://github.com/pallets/click/pull/887\n.. _889: https://github.com/pallets/click/pull/889\n.. _918: https://github.com/pallets/click/pull/918\n.. _919: https://github.com/pallets/click/issues/919\n.. _920: https://github.com/pallets/click/pull/920\n.. _925: https://github.com/pallets/click/issues/925\n.. _926: https://github.com/pallets/click/issues/926\n.. _929: https://github.com/pallets/click/pull/929\n.. _930: https://github.com/pallets/click/pull/930\n.. _935: https://github.com/pallets/click/pull/935\n.. _949: https://github.com/pallets/click/issues/949\n.. _954: https://github.com/pallets/click/pull/954\n.. _962: https://github.com/pallets/click/pull/962\n.. _965: https://github.com/pallets/click/pull/965\n.. _967: https://github.com/pallets/click/pull/967\n.. _976: https://github.com/pallets/click/pull/976\n.. _990: https://github.com/pallets/click/pull/990\n.. _991: https://github.com/pallets/click/pull/991\n.. _993: https://github.com/pallets/click/pull/993\n.. _994: https://github.com/pallets/click/pull/994\n.. _995: https://github.com/pallets/click/pull/995\n.. _996: https://github.com/pallets/click/pull/996\n.. _997: https://github.com/pallets/click/pull/997\n.. _999: https://github.com/pallets/click/pull/999\n.. _1000: https://github.com/pallets/click/pull/1000\n.. _1001: https://github.com/pallets/click/pull/1001\n.. _1002: https://github.com/pallets/click/pull/1002\n.. _1003: https://github.com/pallets/click/pull/1003\n.. _1004: https://github.com/pallets/click/pull/1004\n.. _1005: https://github.com/pallets/click/pull/1005\n.. _1007: https://github.com/pallets/click/pull/1007\n.. _1008: https://github.com/pallets/click/pull/1008\n.. _1009: https://github.com/pallets/click/pull/1009\n.. _1010: https://github.com/pallets/click/pull/1010\n.. _1011: https://github.com/pallets/click/pull/1011\n.. _1012: https://github.com/pallets/click/pull/1012\n.. _1013: https://github.com/pallets/click/pull/1013\n.. _1014: https://github.com/pallets/click/pull/1014\n.. _1016: https://github.com/pallets/click/pull/1016\n.. _1020: https://github.com/pallets/click/pull/1020\n.. _1022: https://github.com/pallets/click/pull/1022\n.. _1027: https://github.com/pallets/click/pull/1027\n.. _1047: https://github.com/pallets/click/pull/1047\n.. _1055: https://github.com/pallets/click/pull/1055\n.. _1058: https://github.com/pallets/click/pull/1058\n.. _1059: https://github.com/pallets/click/pull/1059\n.. _1061: https://github.com/pallets/click/pull/1061\n.. _1068: https://github.com/pallets/click/issues/1068\n.. _1069: https://github.com/pallets/click/pull/1069\n.. _1088: https://github.com/pallets/click/issues/1088\n.. _1091: https://github.com/pallets/click/pull/1091\n.. _1098: https://github.com/pallets/click/pull/1098\n.. _1105: https://github.com/pallets/click/pull/1105\n.. _1106: https://github.com/pallets/click/pull/1106\n.. _1108: https://github.com/pallets/click/pull/1108\n.. _1115: https://github.com/pallets/click/pull/1115\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/click\n  - Changelog: https://pyup.io/changelogs/click/\n  - Homepage: https://palletsprojects.com/p/click/\n</details>\n\n\n\n\n\n### Update [Flask-JWT-Extended](https://pypi.org/project/Flask-JWT-Extended) from **3.10.0** to **3.13.1**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 3.13.1\n   ```\n   * Include tests in MANIFEST.in (197)\n   ```\n   \n  \n  \n   ### 3.13.0\n   ```\n   * Add support for custom encode and decode keys (91). There are now two new callbacks that can be registered: `decode_key_loader` and `encode_key_loader`. The decode callback is passed in the **unverified**  JWT claims, and must return a string that will be used to decode and verify the JWT. The encode callback is passed in the identity (as passed in to the `create_access_token` or `create_refresh_token` functions) and must return a string that will be used to encode a JWT. If unset, the `JWT_SECRET_KEY`, `JWT_PUBLIC_KEY`, or `JWT_PRIVATE_KEY` will still be used as appropriate.\n   ```\n   \n  \n  \n   ### 3.12.1\n   ```\n   * Requires cryptography &gt;= 2.3 in response to https://nvd.nist.gov/vuln/detail/CVE-2018-10903\n   ```\n   \n  \n  \n   ### 3.12.0\n   ```\n   * Add ability to get the JWT from the JSON body of the request (173). Thanks luord!!\n   ```\n   \n  \n  \n   ### 3.11.0\n   ```\n   * Adds new `JWT_ERROR_MESSAGE_KEY` option to change the JSON key on the default error messages (160)\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/flask-jwt-extended\n  - Changelog: https://pyup.io/changelogs/flask-jwt-extended/\n  - Repo: https://github.com/vimalloc/flask-jwt-extended\n</details>\n\n\n\n\n\n### Update [gunicorn](https://pypi.org/project/gunicorn) from **19.8.1** to **19.9.0**.\n\n\n*The bot wasn't able to find a changelog for this release. [Got an idea?](https://github.com/pyupio/changelogs/issues/new)*\n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/gunicorn\n  - Changelog: https://pyup.io/changelogs/gunicorn/\n  - Homepage: http://gunicorn.org\n</details>\n\n\n\n\n\n### Update [itsdangerous](https://pypi.org/project/itsdangerous) from **0.24** to **1.0.0**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 1.0.0\n   ```\n   -------------\n\nReleased 2018-10-18\n\n-   Drop support for Python 2.6 and 3.3.\n-   Refactor code from a single module to a package. Any object in the\n    API docs is still importable from the top-level ``itsdangerous``\n    name, but other imports will need to be changed. A future release\n    will remove many of these compatibility imports. (`107`_)\n-   Optimize how timestamps are serialized and deserialized. (`13`_)\n-   ``base64_decode`` raises ``BadData`` when it is passed invalid data.\n    (`27`_)\n-   Ensure value is bytes when signing to avoid a ``TypeError`` on\n    Python 3. (`29`_)\n-   Add a ``serializer_kwargs`` argument to ``Serializer``, which is\n    passed to ``dumps`` during ``dump_payload``. (`36`_)\n-   More compact JSON dumps for unicode strings. (`38`_)\n-   Use the full timestamp rather than an offset, allowing dates before\n    2011. (`46`_)\n-   Detect a ``sep`` character that may show up in the signature itself\n    and raise a ``ValueError``. (`62`_)\n-   Use a consistent signature for keyword arguments for\n    ``Serializer.load_payload`` in subclasses. (`74`_, `75`_)\n-   Change default intermediate hash from SHA-1 to SHA-512. (`80`_)\n-   Convert JWS exp header to an int when loading. (`99`_)\n\n.. _13: https://github.com/pallets/itsdangerous/pull/13\n.. _27: https://github.com/pallets/itsdangerous/pull/27\n.. _29: https://github.com/pallets/itsdangerous/issues/29\n.. _36: https://github.com/pallets/itsdangerous/pull/36\n.. _38: https://github.com/pallets/itsdangerous/issues/38\n.. _46: https://github.com/pallets/itsdangerous/issues/46\n.. _62: https://github.com/pallets/itsdangerous/issues/62\n.. _74: https://github.com/pallets/itsdangerous/issues/74\n.. _75: https://github.com/pallets/itsdangerous/pull/75\n.. _80: https://github.com/pallets/itsdangerous/pull/80\n.. _99: https://github.com/pallets/itsdangerous/pull/99\n.. _107: https://github.com/pallets/itsdangerous/pull/107\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/itsdangerous\n  - Changelog: https://pyup.io/changelogs/itsdangerous/\n  - Homepage: https://palletsprojects.com/p/itsdangerous/\n  - Docs: https://pythonhosted.org/itsdangerous/\n</details>\n\n\n\n\n\n### Update [marshmallow](https://pypi.org/project/marshmallow) from **3.0.0b11** to **3.0.0b18**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 3.0.0b18\n   ```\n   +++++++++++++++++++++\n\nBug fixes:\n\n- Fix ``Date`` deserialization when using custom format (:issue:`1001`). Thanks\n  :user:`Ondkloss` for reporting.\n\nDeprecations/Removals:\n\n- ``prefix`` parameter or ``Schema`` class is removed (:issue:`991`). The same\n  can be achieved using a ``post_dump`` method.\n   ```\n   \n  \n  \n   ### 3.0.0b17\n   ```\n   +++++++++++++++++++++\n\nFeatures:\n\n- Add ``format`` option to ``Date`` field (:pr:`869`).\n- *Backwards-incompatible*: Rename ``DateTime``&#39;s ``dateformat`` Meta option\n  to ``datetimeformat``. ``dateformat`` now applies to ``Date`` (:pr:`869`).\n  Thanks :user:`knagra` for implementing these changes.\n- Enforce ISO 8601 when deserializing date and time (:issue:`899`).\n  Thanks :user:`dushr` for the report and the work on the PR.\n- *Backwards-incompatible*: Raise ``ValueError`` on ``Schema`` instantiation in\n  case of ``attribute`` or ``data_key`` collision (:pr:`992`).\n\nBug fixes:\n\n- Fix inconsistencies in field inference by refactoring the inference feature\n  into a dedicated field (:issue:`809`). Thanks :user:`taion` for the PR.\n- When ``unknown`` is not passed to ``Nested``, default to nested ``Schema``\n  ``unknown`` meta option rather than ``RAISE`` (:pr:`963`).\n  Thanks :user:`vgavro` for the PR.\n- Fix loading behavior of ``fields.Pluck`` (:pr:`990`).\n- Includes bug fix from 2.16.0.\n   ```\n   \n  \n  \n   ### 3.0.0b16\n   ```\n   +++++++++++++++++++++\n\nBug fixes:\n\n- Fix ``root`` attribute for nested container fields\n  on inheriting schemas (:issue:`956`). Thanks :user:`bmcbu`\n  for reporting.\n   ```\n   \n  \n  \n   ### 3.0.0b15\n   ```\n   +++++++++++++++++++++\n\nBug fixes:\n\n- Raise ``ValidationError`` instead of ``TypeError`` when non-iterable types are\n  validated with ``many=True`` (:issue:`851`).\n- ``many=True`` no longer iterates over ``str`` and ``collections.Mapping`` objects and instead\n  raises a ``ValidationError`` with ``{&#39;_schema&#39;: [&#39;Invalid input type.&#39;]}`` (:issue:`930`).\n- Return ``[]`` as ``ValidationError.valid_data`` instead of ``{}`` when\n  ``many=True`` (:issue:`907`).\n\nThanks :user:`tuukkamustonen` for implementing these changes.\n   ```\n   \n  \n  \n   ### 3.0.0b14\n   ```\n   +++++++++++++++++++++\n\nFeatures:\n\n- Add ``fields.Pluck`` for serializing a single field from a nested object\n  (:issue:`800`). Thanks :user:`timc13` for the feedback and :user:`deckar01`\n  for the implementation.\n- *Backwards-incompatible*: Passing a string argument as ``only`` to\n  ``fields.Nested`` is no longer supported. Use ``fields.Pluck`` instead\n  (:issue:`800`).\n- Raise a `StringNotCollectionError` if ``only`` or ``exclude`` is\n  passed as a string to ``fields.Nested`` (:pr:`931`).\n- *Backwards-incompatible*: ``Float`` takes an ``allow_nan`` parameter to\n  explicitly allow serializing and deserializing special values (``nan``,\n  ``inf`` and ``-inf``). ``allow_nan`` defaults to ``False``.\n\nOther changes:\n\n- *Backwards-incompatible*: ``Nested`` field now defaults to ``unknown=RAISE``\n  instead of ``EXCLUDE``. This harmonizes behavior with ``Schema`` that\n  already defaults to ``RAISE`` (:issue:`908`). Thanks :user:`tuukkamustonen`.\n- Tested against Python 3.7.\n   ```\n   \n  \n  \n   ### 3.0.0b13\n   ```\n   +++++++++++++++++++++\n\nBug fixes:\n\n- Errors reported by a schema-level validator for a field in a ``Nested`` field\n  are stored under corresponding field name, not ``_schema`` key (:pr:`862`).\n- Includes bug fix from 2.15.4.\n\nOther changes:\n\n- *Backwards-incompatible*: The ``unknown`` option now defaults to ``RAISE``\n  (`524 (comment) &lt;https://github.com/marshmallow-code/marshmallow/issues/524issuecomment-397165731&gt;`_,\n  :issue:`851`).\n- *Backwards-incompatible*: When a schema error is raised with a ``dict`` as\n  payload, the ``dict`` overwrites any existing error list. Before this change,\n  it would be appended to the list.\n- Raise a `StringNotCollectionError` if ``only`` or ``exclude`` is\n  passed as a string (:issue:`316`). Thanks :user:`paulocheque` for\n  reporting.\n   ```\n   \n  \n  \n   ### 3.0.0b12\n   ```\n   +++++++++++++++++++++\n\nFeatures:\n\n- The behavior to apply when encountering unknown fields while deserializing\n  can be controlled with the ``unknown`` option (:issue:`524`,\n  :issue:`747`, :issue:`127`).\n  It makes it possible to either &quot;include&quot;, &quot;exclude&quot;, or &quot;raise&quot;.\n  Thanks :user:`tuukkamustonen` for the suggestion and thanks\n  :user:`ramnes` for the PR.\n\n.. warning::\n\n  The default for ``unknown`` will be changed to ``RAISE`` in the\n  next release.\n\nOther changes:\n\n- *Backwards-incompatible*: Pre/Post-processors MUST return modified data.\n  Returning ``None`` does not imply data were mutated (:issue:`347`). Thanks\n  :user:`tdevelioglu` for reporting.\n- *Backwards-incompatible*: ``only`` and ``exclude`` are bound by\n  declared and additional fields. A ``ValueError`` is raised if invalid\n  fields are passed (:issue:`636`). Thanks :user:`jan-23` for reporting.\n  Thanks :user:`ikilledthecat` and :user:`deckar01` for the PRs.\n- Format code using pre-commit (:pr:`855`).\n\nDeprecations/Removals:\n\n- ``ValidationError.fields`` is removed (:issue:`840`). Access field\n  instances from ``Schema.fields``.\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/marshmallow\n  - Changelog: https://pyup.io/changelogs/marshmallow/\n  - Repo: https://github.com/marshmallow-code/marshmallow\n</details>\n\n\n\n\n\n### Update [marshmallow-sqlalchemy](https://pypi.org/project/marshmallow-sqlalchemy) from **0.14.0** to **0.14.1**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 0.14.1\n   ```\n   +++++++++++++++++++\n\nBug fixes:\n\n- Fix behavior of ``exclude`` with marshmallow 3.0 (:issue:`131`).\n  Thanks :user:`yaheath` for reporting and thanks :user:`deckar01` for\n  the fix.\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/marshmallow-sqlalchemy\n  - Changelog: https://pyup.io/changelogs/marshmallow-sqlalchemy/\n  - Repo: https://github.com/marshmallow-code/marshmallow-sqlalchemy\n</details>\n\n\n\n\n\n### Update [mysqlclient](https://pypi.org/project/mysqlclient) from **1.3.12** to **1.3.13**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 1.3.13\n   ```\n   ======================\n\nSupport build with MySQL 8\n\nFix decoding tiny/medium/long blobs (215)\n\nRemove broken row_seek() and row_tell() APIs (220)\n\nReduce callproc roundtrip time (223)\n\n\n======================\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/mysqlclient\n  - Changelog: https://pyup.io/changelogs/mysqlclient/\n  - Repo: https://github.com/PyMySQL/mysqlclient-python\n</details>\n\n\n\n\n\n### Update [PyMySQL](https://pypi.org/project/PyMySQL) from **0.8.1** to **0.9.2**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 0.9.1\n   ```\n   Release date: 2018-07-03\n\n* Fixed caching_sha2_password and sha256_password raise TypeError on PY2\n  (700, 702)\n   ```\n   \n  \n  \n   ### 0.9.0\n   ```\n   Release date: 2018-06-27\n\n* Change default charset from latin1 to utf8mb4.  (because MySQL 8 changed) (692)\n* Support sha256_password and caching_sha2_password auth method (682)\n* Add cryptography dependency, because it&#39;s needed for new auth methods.\n* Remove deprecated `no_delay` option (694)\n* Support connection attributes (679)\n* Map LOCK_DEADLOCK to OperationalError (693)\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/pymysql\n  - Changelog: https://pyup.io/changelogs/pymysql/\n  - Repo: https://github.com/PyMySQL/PyMySQL/\n</details>\n\n\n\n\n\n### Update [pytz](https://pypi.org/project/pytz) from **2018.4** to **2018.6**.\n\n\n*The bot wasn't able to find a changelog for this release. [Got an idea?](https://github.com/pyupio/changelogs/issues/new)*\n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/pytz\n  - Homepage: http://pythonhosted.org/pytz\n  - Docs: https://pythonhosted.org/pytz/\n</details>\n\n\n\n\n\n### Update [SQLAlchemy](https://pypi.org/project/SQLAlchemy) from **1.2.8** to **1.2.12**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 1.2.12\n   ```\n   :released: September 19, 2018\n\n    .. change::\n        :tags: bug, postgresql\n        :tickets: 4325\n\n        Fixed bug in PostgreSQL dialect where compiler keyword arguments such as\n        ``literal_binds=True`` were not being propagated to a DISTINCT ON\n        expression.\n\n    .. change::\n        :tags: bug, ext\n        :tickets: 4328\n\n        Fixed issue where :class:`.BakedQuery` did not include the specific query\n        class used by the :class:`.Session` as part of the cache key, leading to\n        incompatibilities when using custom query classes, in particular the\n        :class:`.ShardedQuery` which has some different argument signatures.\n\n    .. change::\n        :tags: bug, postgresql\n        :tickets: 4324\n\n        Fixed the :func:`.postgresql.array_agg` function, which is a slightly\n        altered version of the usual :func:`.functions.array_agg` function, to also\n        accept an incoming &quot;type&quot; argument without forcing an ARRAY around it,\n        essentially the same thing that was fixed for the generic function in 1.1\n        in :ticket:`4107`.\n\n    .. change::\n        :tags: bug, postgresql\n        :tickets: 4323\n\n        Fixed bug in PostgreSQL ENUM reflection where a case-sensitive, quoted name\n        would be reported by the query including quotes, which would not match a\n        target column during table reflection as the quotes needed to be stripped\n        off.\n\n\n    .. change::\n       :tags: bug, orm\n\n       Added a check within the weakref cleanup for the :class:`.InstanceState`\n       object to check for the presence of the ``dict`` builtin, in an effort to\n       reduce error messages generated when these cleanups occur during interpreter\n       shutdown.  Pull request courtesy Romuald Brunet.\n\n    .. change::\n        :tags: bug, orm, declarative\n        :tickets: 4326\n\n        Fixed bug where the declarative scan for attributes would receive the\n        expression proxy delivered by a hybrid attribute at the class level, and\n        not the hybrid attribute itself, when receiving the descriptor via the\n        ``declared_attr`` callable on a subclass of an already-mapped class. This\n        would lead to an attribute that did not report itself as a hybrid when\n        viewed within :attr:`.Mapper.all_orm_descriptors`.\n\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4334\n        :versions: 1.3.0b1\n\n        Fixed bug where use of :class:`.Lateral` construct in conjunction with\n        :meth:`.Query.join` as well as :meth:`.Query.select_entity_from` would not\n        apply clause adaption to the right side of the join.   &quot;lateral&quot; introduces\n        the use case of the right side of a join being correlatable.  Previously,\n        adaptation of this clause wasn&#39;t considered.   Note that in 1.2 only,\n        a selectable introduced by :meth:`.Query.subquery` is still not adapted\n        due to :ticket:`4304`; the selectable needs to be produced by the\n        :func:`.select` function to be the right side of the &quot;lateral&quot; join.\n\n    .. change::\n       :tags: bug, oracle\n       :tickets: 4335\n\n       Fixed issue for cx_Oracle 7.0 where the behavior of Oracle param.getvalue()\n       now returns a list, rather than a single scalar value, breaking\n       autoincrement logic throughout the Core and ORM. The dml_ret_array_val\n       compatibility flag is used for cx_Oracle 6.3 and 6.4 to establish compatible\n       behavior with 7.0 and forward, for cx_Oracle 6.2.1 and prior a version\n       number check falls back to the old logic.\n\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4327\n\n        Fixed 1.2 regression caused by :ticket:`3472` where the handling of an\n        &quot;updated_at&quot; style column within the context of a post-update operation\n        would also occur for a row that is to be deleted following the update,\n        meaning both that a column with a Python-side value generator would show\n        the now-deleted value that was emitted for the UPDATE before the DELETE\n        (which was not the previous behavor), as well as that a SQL- emitted value\n        generator would have the attribute expired, meaning the previous value\n        would be unreachable due to the row having been deleted and the object\n        detached from the session.The &quot;postfetch&quot; logic that was added as part of\n        :ticket:`3472` is now skipped entirely for an object that ultimately is to\n        be deleted.\n\n.. changelog::\n   ```\n   \n  \n  \n   ### 1.2.11\n   ```\n   :released: August 20, 2018\n\n    .. change::\n        :tags: bug, py3k\n\n        Started importing &quot;collections&quot; from &quot;collections.abc&quot; under Python 3.3 and\n        greater for Python 3.8 compatibility.  Pull request courtesy Nathaniel\n        Knight.\n\n    .. change::\n        :tag: bug, sqlite\n\n        Fixed issue where the &quot;schema&quot; name used for a SQLite database within table\n        reflection would not quote the schema name correctly.  Pull request\n        courtesy Phillip Cloud.\n\n    .. change::\n        :tags: bug, sql\n        :tickets: 4320\n\n        Fixed issue that is closely related to :ticket:`3639` where an expression\n        rendered in a boolean context on a non-native boolean backend would\n        be compared to 1/0 even though it is already an implcitly boolean\n        expression, when :meth:`.ColumnElement.self_group` were used.  While this\n        does not affect the user-friendly backends (MySQL, SQLite) it was not\n        handled by Oracle (and possibly SQL Server).   Whether or not the\n        expression is implicitly boolean on any database is now determined\n        up front as an additional check to not generate the integer comparison\n        within the compliation of the statement.\n\n    .. change::\n        :tags: bug, oracle\n        :tickets: 4309\n\n        For cx_Oracle, Integer datatypes will now be bound to &quot;int&quot;, per advice\n        from the cx_Oracle developers.  Previously, using cx_Oracle.NUMBER caused a\n        loss in precision within the cx_Oracle 6.x series.\n\n\n    .. change::\n        :tags: bug, orm, declarative\n        :tickets: 4321\n\n        Fixed issue in previously untested use case, allowing a declarative mapped\n        class to inherit from a classically-mapped class outside of the declarative\n        base, including that it accommodates for unmapped intermediate classes. An\n        unmapped intermediate class may specify ``__abstract__``, which is now\n        interpreted correctly, or the intermediate class can remain unmarked, and\n        the classically mapped base class will be detected within the hierarchy\n        regardless. In order to anticipate existing scenarios which may be mixing\n        in classical mappings into existing declarative hierarchies, an error is\n        now raised if multiple mapped bases are detected for a given class.\n\n    .. change::\n        :tags: bug, sql\n        :tickets: 4322\n\n        Added missing window function parameters\n        :paramref:`.WithinGroup.over.range_` and :paramref:`.WithinGroup.over.rows`\n        parameters to the :meth:`.WithinGroup.over` and\n        :meth:`.FunctionFilter.over` methods, to correspond to the range/rows\n        feature added to the &quot;over&quot; method of SQL functions as part of\n        :ticket:`3049` in version 1.1.\n\n    .. change::\n        :tags: bug, sql\n        :tickets: 4313\n\n        Fixed bug where the multi-table support for UPDATE and DELETE statements\n        did not consider the additional FROM elements as targets for correlation,\n        when a correlated SELECT were also combined with the statement.  This\n        change now includes that a SELECT statement in the WHERE clause for such a\n        statement will try to auto-correlate back to these additional tables in the\n        parent UPDATE/DELETE or unconditionally correlate if\n        :meth:`.Select.correlate` is used.  Note that auto-correlation raises an\n        error if the SELECT statement would have no FROM clauses as a result, which\n        can now occur if the parent UPDATE/DELETE specifies the same tables in its\n        additional set of tables; specify :meth:`.Select.correlate` explicitly to\n        resolve.\n\n.. changelog::\n   ```\n   \n  \n  \n   ### 1.2.10\n   ```\n   :released: July 13, 2018\n\n    .. change::\n        :tags: bug, sql\n        :tickets: 4300\n\n        Fixed bug where a :class:`.Sequence` would be dropped explicitly before any\n        :class:`.Table` that refers to it, which breaks in the case when the\n        sequence is also involved in a server-side default for that table, when\n        using :meth:`.MetaData.drop_all`.   The step which processes sequences\n        to be dropped via non server-side column default functions is now invoked\n        after the table itself is dropped.\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4295\n\n        Fixed bug in :class:`.Bundle` construct where placing two columns of the\n        same name would be de-duplicated, when the :class:`.Bundle` were used as\n        part of the rendered SQL, such as in the ORDER BY or GROUP BY of the statement.\n\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4298\n\n        Fixed regression in 1.2.9 due to :ticket:`4287` where using a\n        :class:`.Load` option in conjunction with a string wildcard would result\n        in a TypeError.\n\n.. changelog::\n   ```\n   \n  \n  \n   ### 1.2.9\n   ```\n   :released: June 29, 2018\n\n    .. change::\n        :tags: bug, mysql\n\n        Fixed percent-sign doubling in mysql-connector-python dialect, which does\n        not require de-doubling of percent signs.   Additionally, the  mysql-\n        connector-python driver is inconsistent in how it passes the column names\n        in cursor.description, so a workaround decoder has been added to\n        conditionally decode these randomly-sometimes-bytes values to unicode only\n        if needed.  Also improved test support for mysql-connector-python, however\n        it should be noted that this driver still has issues with unicode that\n        continue to be unresolved as of yet.\n\n\n    .. change::\n        :tags: bug, mssql\n        :tickets: 4288\n\n        Fixed bug in MSSQL reflection where when two same-named tables in different\n        schemas had same-named primary key constraints, foreign key constraints\n        referring to one of the tables would have their columns doubled, causing\n        errors.   Pull request courtesy Sean Dunn.\n\n    .. change::\n        :tags: bug, sql\n        :tickets: 4279\n\n        Fixed regression in 1.2 due to :ticket:`4147` where a :class:`.Table` that\n        has had some of its indexed columns redefined with new ones, as would occur\n        when overriding columns during reflection or when using\n        :paramref:`.Table.extend_existing`, such that the :meth:`.Table.tometadata`\n        method would fail when attempting to copy those indexes as they still\n        referred to the replaced column.   The copy logic now accommodates for this\n        condition.\n\n\n    .. change::\n        :tags: bug, mysql\n        :tickets: 4293\n\n        Fixed bug in index reflection where on MySQL 8.0 an index that includes\n        ASC or DESC in an indexed column specfication would not be correctly\n        reflected, as MySQL 8.0 introduces support for returning this information\n        in a table definition string.\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 3505\n\n        Fixed issue where chaining multiple join elements inside of\n        :meth:`.Query.join` might not correctly adapt to the previous left-hand\n        side, when chaining joined inheritance classes that share the same base\n        class.\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4287\n\n        Fixed bug in cache key generation for baked queries which could cause a\n        too-short cache key to be generated for the case of eager loads across\n        subclasses.  This could in turn cause the eagerload query to be cached in\n        place of a non-eagerload query, or vice versa, for a polymorhic &quot;selectin&quot;\n        load, or possibly for lazy loads or selectin loads as well.\n\n    .. change::\n        :tags: bug, sqlite\n\n        Fixed issue in test suite where SQLite 3.24 added a new reserved word that\n        conflicted with a usage in TypeReflectionTest.  Pull request courtesy Nils\n        Philippsen.\n\n    .. change::\n        :tags: feature, oracle\n        :tickets: 4290\n        :versions: 1.3.0b1\n\n        Added a new event currently used only by the cx_Oracle dialect,\n        :meth:`.DialectEvents.setiputsizes`.  The event passes a dictionary of\n        :class:`.BindParameter` objects to DBAPI-specific type objects that will be\n        passed, after conversion to parameter names, to the cx_Oracle\n        ``cursor.setinputsizes()`` method.  This allows both visibility into the\n        setinputsizes process as well as the ability to alter the behavior of what\n        datatypes are passed to this method.\n\n        .. seealso::\n\n            :ref:`cx_oracle_setinputsizes`\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4286\n\n        Fixed bug in new polymorphic selectin loading where the BakedQuery used\n        internally would be mutated by the given loader options, which would both\n        inappropriately mutate the subclass query as well as carry over the effect\n        to subsequent queries.\n\n    .. change::\n        :tags: bug, py3k\n        :tickets: 4291\n\n        Replaced the usage of inspect.formatargspec() with a vendored version\n        copied from the Python standard library, as inspect.formatargspec()\n        is deprecated and as of Python 3.7.0 is emitting a warning.\n\n    .. change::\n        :tags: feature, ext\n        :tickets: 4243\n        :versions: 1.3.0b1\n\n        Added new attribute :attr:`.Query.lazy_loaded_from` which is populated\n        with an :class:`.InstanceState` that is using this :class:`.Query` in\n        order to lazy load a relationship.  The rationale for this is that\n        it serves as a hint for the horizontal sharding feature to use, such that\n        the identity token of the state can be used as the default identity token\n        to use for the query within id_chooser().\n\n    .. change::\n        :tags: bug, mysql\n        :tickets: 4283\n\n        Fixed bug in MySQLdb dialect and variants such as PyMySQL where an\n        additional &quot;unicode returns&quot; check upon connection makes explicit use of\n        the &quot;utf8&quot; character set, which in MySQL 8.0 emits a warning that utf8mb4\n        should be used.  This is now replaced with a utf8mb4 equivalent.\n        Documentation is also updated for the MySQL dialect to specify utf8mb4 in\n        all examples.  Additional changes have been made to the test suite to use\n        utf8mb3 charsets and databases (there seem to be collation issues in some\n        edge cases with utf8mb4), and to support configuration default changes made\n        in MySQL 8.0 such as explicit_defaults_for_timestamp as well as new errors\n        raised for invalid MyISAM indexes.\n\n\n\n    .. change::\n        :tags: bug, mysql\n        :tickets: 3645\n\n        The :class:`.Update` construct now accommodates a :class:`.Join` object\n        as supported by MySQL for UPDATE..FROM.  As the construct already\n        accepted an alias object for a similar purpose, the feature of UPDATE\n        against a non-table was already implied so this has been added.\n\n    .. change::\n        :tags: bug, mssql, py3k\n        :tickets: 4273\n\n        Fixed issue within the SQL Server dialect under Python 3 where when running\n        against a non-standard SQL server database that does not contain either the\n        &quot;sys.dm_exec_sessions&quot; or &quot;sys.dm_pdw_nodes_exec_sessions&quot; views, leading\n        to a failure to fetch the isolation level, the error raise would fail due\n        to an UnboundLocalError.\n\n\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4269\n\n        Fixed regression caused by :ticket:`4256` (itself a regression fix for\n        :ticket:`4228`) which breaks an undocumented behavior which converted for a\n        non-sequence of entities passed directly to the :class:`.Query` constructor\n        into a single-element sequence.  While this behavior was never supported or\n        documented, it&#39;s already in use so has been added as a behavioral contract\n        to :class:`.Query`.\n\n    .. change::\n        :tags: bug, orm\n        :tickets: 4270\n\n        Fixed an issue that was both a performance regression in 1.2 as well as an\n        incorrect result regarding the &quot;baked&quot; lazy loader, involving the\n        generation of cache keys from the original :class:`.Query` object&#39;s loader\n        options.  If the loader options were built up in a &quot;branched&quot; style using\n        common base elements for multiple options, the same options would be\n        rendered into the cache key repeatedly, causing both a performance issue as\n        well as generating the wrong cache key.  This is fixed, along with a\n        performance improvement when such &quot;branched&quot; options are applied via\n        :meth:`.Query.options` to prevent the same option objects from being\n        applied repeatedly.\n\n    .. change::\n        :tags: bug, oracle, mysql\n        :tickets: 4275\n\n        Fixed INSERT FROM SELECT with CTEs for the Oracle and MySQL dialects, where\n        the CTE was being placed above the entire statement as is typical with\n        other databases, however Oracle and MariaDB 10.2 wants the CTE underneath\n        the &quot;INSERT&quot; segment. Note that the Oracle and MySQL dialects don&#39;t yet\n        work when a CTE is applied to a subquery inside of an UPDATE or DELETE\n        statement, as the CTE is still applied to the top rather than inside the\n        subquery.\n\n\n.. changelog::\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/sqlalchemy\n  - Changelog: https://pyup.io/changelogs/sqlalchemy/\n  - Homepage: http://www.sqlalchemy.org\n</details>\n\n\n\n\n\n","created_at":"2018-10-24T13:33:26Z","updated_at":"2018-10-25T13:33:34Z","closed_at":"2018-10-25T13:33:34Z","merged_at":null,"merge_commit_sha":"3cd189663f950ee4aaee755f07129a41921316fe","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/smirnovvad/students_api/pulls/150/commits","review_comments_url":"https://api.github.com/repos/smirnovvad/students_api/pulls/150/comments","review_comment_url":"https://api.github.com/repos/smirnovvad/students_api/pulls/comments{/number}","comments_url":"https://api.github.com/repos/smirnovvad/students_api/issues/150/comments","statuses_url":"https://api.github.com/repos/smirnovvad/students_api/statuses/271ea7752e909a471a1d5c003f56ad02e740deb9","head":{"label":"smirnovvad:pyup/scheduled-update-2018-10-24","ref":"pyup/scheduled-update-2018-10-24","sha":"271ea7752e909a471a1d5c003f56ad02e740deb9","user":{"login":"smirnovvad","id":6020823,"node_id":"MDQ6VXNlcjYwMjA4MjM=","avatar_url":"https://avatars2.githubusercontent.com/u/6020823?v=4","gravatar_id":"","url":"https://api.github.com/users/smirnovvad","html_url":"https://github.com/smirnovvad","followers_url":"https://api.github.com/users/smirnovvad/followers","following_url":"https://api.github.com/users/smirnovvad/following{/other_user}","gists_url":"https://api.github.com/users/smirnovvad/gists{/gist_id}","starred_url":"https://api.github.com/users/smirnovvad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smirnovvad/subscriptions","organizations_url":"https://api.github.com/users/smirnovvad/orgs","repos_url":"https://api.github.com/users/smirnovvad/repos","events_url":"https://api.github.com/users/smirnovvad/events{/privacy}","received_events_url":"https://api.github.com/users/smirnovvad/received_events","type":"User","site_admin":false},"repo":{"id":132038644,"node_id":"MDEwOlJlcG9zaXRvcnkxMzIwMzg2NDQ=","name":"students_api","full_name":"smirnovvad/students_api","private":false,"owner":{"login":"smirnovvad","id":6020823,"node_id":"MDQ6VXNlcjYwMjA4MjM=","avatar_url":"https://avatars2.githubusercontent.com/u/6020823?v=4","gravatar_id":"","url":"https://api.github.com/users/smirnovvad","html_url":"https://github.com/smirnovvad","followers_url":"https://api.github.com/users/smirnovvad/followers","following_url":"https://api.github.com/users/smirnovvad/following{/other_user}","gists_url":"https://api.github.com/users/smirnovvad/gists{/gist_id}","starred_url":"https://api.github.com/users/smirnovvad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smirnovvad/subscriptions","organizations_url":"https://api.github.com/users/smirnovvad/orgs","repos_url":"https://api.github.com/users/smirnovvad/repos","events_url":"https://api.github.com/users/smirnovvad/events{/privacy}","received_events_url":"https://api.github.com/users/smirnovvad/received_events","type":"User","site_admin":false},"html_url":"https://github.com/smirnovvad/students_api","description":null,"fork":false,"url":"https://api.github.com/repos/smirnovvad/students_api","forks_url":"https://api.github.com/repos/smirnovvad/students_api/forks","keys_url":"https://api.github.com/repos/smirnovvad/students_api/keys{/key_id}","collaborators_url":"https://api.github.com/repos/smirnovvad/students_api/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/smirnovvad/students_api/teams","hooks_url":"https://api.github.com/repos/smirnovvad/students_api/hooks","issue_events_url":"https://api.github.com/repos/smirnovvad/students_api/issues/events{/number}","events_url":"https://api.github.com/repos/smirnovvad/students_api/events","assignees_url":"https://api.github.com/repos/smirnovvad/students_api/assignees{/user}","branches_url":"https://api.github.com/repos/smirnovvad/students_api/branches{/branch}","tags_url":"https://api.github.com/repos/smirnovvad/students_api/tags","blobs_url":"https://api.github.com/repos/smirnovvad/students_api/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/smirnovvad/students_api/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/smirnovvad/students_api/git/refs{/sha}","trees_url":"https://api.github.com/repos/smirnovvad/students_api/git/trees{/sha}","statuses_url":"https://api.github.com/repos/smirnovvad/students_api/statuses/{sha}","languages_url":"https://api.github.com/repos/smirnovvad/students_api/languages","stargazers_url":"https://api.github.com/repos/smirnovvad/students_api/stargazers","contributors_url":"https://api.github.com/repos/smirnovvad/students_api/contributors","subscribers_url":"https://api.github.com/repos/smirnovvad/students_api/subscribers","subscription_url":"https://api.github.com/repos/smirnovvad/students_api/subscription","commits_url":"https://api.github.com/repos/smirnovvad/students_api/commits{/sha}","git_commits_url":"https://api.github.com/repos/smirnovvad/students_api/git/commits{/sha}","comments_url":"https://api.github.com/repos/smirnovvad/students_api/comments{/number}","issue_comment_url":"https://api.github.com/repos/smirnovvad/students_api/issues/comments{/number}","contents_url":"https://api.github.com/repos/smirnovvad/students_api/contents/{+path}","compare_url":"https://api.github.com/repos/smirnovvad/students_api/compare/{base}...{head}","merges_url":"https://api.github.com/repos/smirnovvad/students_api/merges","archive_url":"https://api.github.com/repos/smirnovvad/students_api/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/smirnovvad/students_api/downloads","issues_url":"https://api.github.com/repos/smirnovvad/students_api/issues{/number}","pulls_url":"https://api.github.com/repos/smirnovvad/students_api/pulls{/number}","milestones_url":"https://api.github.com/repos/smirnovvad/students_api/milestones{/number}","notifications_url":"https://api.github.com/repos/smirnovvad/students_api/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/smirnovvad/students_api/labels{/name}","releases_url":"https://api.github.com/repos/smirnovvad/students_api/releases{/id}","deployments_url":"https://api.github.com/repos/smirnovvad/students_api/deployments","created_at":"2018-05-03T19:08:29Z","updated_at":"2018-05-03T22:00:13Z","pushed_at":"2018-10-25T13:33:25Z","git_url":"git://github.com/smirnovvad/students_api.git","ssh_url":"git@github.com:smirnovvad/students_api.git","clone_url":"https://github.com/smirnovvad/students_api.git","svn_url":"https://github.com/smirnovvad/students_api","homepage":null,"size":22,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":null,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"smirnovvad:develop","ref":"develop","sha":"2a667adfa03dff7b7efb4a9a528ca426fc4f0c26","user":{"login":"smirnovvad","id":6020823,"node_id":"MDQ6VXNlcjYwMjA4MjM=","avatar_url":"https://avatars2.githubusercontent.com/u/6020823?v=4","gravatar_id":"","url":"https://api.github.com/users/smirnovvad","html_url":"https://github.com/smirnovvad","followers_url":"https://api.github.com/users/smirnovvad/followers","following_url":"https://api.github.com/users/smirnovvad/following{/other_user}","gists_url":"https://api.github.com/users/smirnovvad/gists{/gist_id}","starred_url":"https://api.github.com/users/smirnovvad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smirnovvad/subscriptions","organizations_url":"https://api.github.com/users/smirnovvad/orgs","repos_url":"https://api.github.com/users/smirnovvad/repos","events_url":"https://api.github.com/users/smirnovvad/events{/privacy}","received_events_url":"https://api.github.com/users/smirnovvad/received_events","type":"User","site_admin":false},"repo":{"id":132038644,"node_id":"MDEwOlJlcG9zaXRvcnkxMzIwMzg2NDQ=","name":"students_api","full_name":"smirnovvad/students_api","private":false,"owner":{"login":"smirnovvad","id":6020823,"node_id":"MDQ6VXNlcjYwMjA4MjM=","avatar_url":"https://avatars2.githubusercontent.com/u/6020823?v=4","gravatar_id":"","url":"https://api.github.com/users/smirnovvad","html_url":"https://github.com/smirnovvad","followers_url":"https://api.github.com/users/smirnovvad/followers","following_url":"https://api.github.com/users/smirnovvad/following{/other_user}","gists_url":"https://api.github.com/users/smirnovvad/gists{/gist_id}","starred_url":"https://api.github.com/users/smirnovvad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smirnovvad/subscriptions","organizations_url":"https://api.github.com/users/smirnovvad/orgs","repos_url":"https://api.github.com/users/smirnovvad/repos","events_url":"https://api.github.com/users/smirnovvad/events{/privacy}","received_events_url":"https://api.github.com/users/smirnovvad/received_events","type":"User","site_admin":false},"html_url":"https://github.com/smirnovvad/students_api","description":null,"fork":false,"url":"https://api.github.com/repos/smirnovvad/students_api","forks_url":"https://api.github.com/repos/smirnovvad/students_api/forks","keys_url":"https://api.github.com/repos/smirnovvad/students_api/keys{/key_id}","collaborators_url":"https://api.github.com/repos/smirnovvad/students_api/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/smirnovvad/students_api/teams","hooks_url":"https://api.github.com/repos/smirnovvad/students_api/hooks","issue_events_url":"https://api.github.com/repos/smirnovvad/students_api/issues/events{/number}","events_url":"https://api.github.com/repos/smirnovvad/students_api/events","assignees_url":"https://api.github.com/repos/smirnovvad/students_api/assignees{/user}","branches_url":"https://api.github.com/repos/smirnovvad/students_api/branches{/branch}","tags_url":"https://api.github.com/repos/smirnovvad/students_api/tags","blobs_url":"https://api.github.com/repos/smirnovvad/students_api/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/smirnovvad/students_api/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/smirnovvad/students_api/git/refs{/sha}","trees_url":"https://api.github.com/repos/smirnovvad/students_api/git/trees{/sha}","statuses_url":"https://api.github.com/repos/smirnovvad/students_api/statuses/{sha}","languages_url":"https://api.github.com/repos/smirnovvad/students_api/languages","stargazers_url":"https://api.github.com/repos/smirnovvad/students_api/stargazers","contributors_url":"https://api.github.com/repos/smirnovvad/students_api/contributors","subscribers_url":"https://api.github.com/repos/smirnovvad/students_api/subscribers","subscription_url":"https://api.github.com/repos/smirnovvad/students_api/subscription","commits_url":"https://api.github.com/repos/smirnovvad/students_api/commits{/sha}","git_commits_url":"https://api.github.com/repos/smirnovvad/students_api/git/commits{/sha}","comments_url":"https://api.github.com/repos/smirnovvad/students_api/comments{/number}","issue_comment_url":"https://api.github.com/repos/smirnovvad/students_api/issues/comments{/number}","contents_url":"https://api.github.com/repos/smirnovvad/students_api/contents/{+path}","compare_url":"https://api.github.com/repos/smirnovvad/students_api/compare/{base}...{head}","merges_url":"https://api.github.com/repos/smirnovvad/students_api/merges","archive_url":"https://api.github.com/repos/smirnovvad/students_api/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/smirnovvad/students_api/downloads","issues_url":"https://api.github.com/repos/smirnovvad/students_api/issues{/number}","pulls_url":"https://api.github.com/repos/smirnovvad/students_api/pulls{/number}","milestones_url":"https://api.github.com/repos/smirnovvad/students_api/milestones{/number}","notifications_url":"https://api.github.com/repos/smirnovvad/students_api/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/smirnovvad/students_api/labels{/name}","releases_url":"https://api.github.com/repos/smirnovvad/students_api/releases{/id}","deployments_url":"https://api.github.com/repos/smirnovvad/students_api/deployments","created_at":"2018-05-03T19:08:29Z","updated_at":"2018-05-03T22:00:13Z","pushed_at":"2018-10-25T13:33:25Z","git_url":"git://github.com/smirnovvad/students_api.git","ssh_url":"git@github.com:smirnovvad/students_api.git","clone_url":"https://github.com/smirnovvad/students_api.git","svn_url":"https://github.com/smirnovvad/students_api","homepage":null,"size":22,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":null,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/smirnovvad/students_api/pulls/150"},"html":{"href":"https://github.com/smirnovvad/students_api/pull/150"},"issue":{"href":"https://api.github.com/repos/smirnovvad/students_api/issues/150"},"comments":{"href":"https://api.github.com/repos/smirnovvad/students_api/issues/150/comments"},"review_comments":{"href":"https://api.github.com/repos/smirnovvad/students_api/pulls/150/comments"},"review_comment":{"href":"https://api.github.com/repos/smirnovvad/students_api/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/smirnovvad/students_api/pulls/150/commits"},"statuses":{"href":"https://api.github.com/repos/smirnovvad/students_api/statuses/271ea7752e909a471a1d5c003f56ad02e740deb9"}},"author_association":"CONTRIBUTOR","merged":false,"mergeable":true,"rebaseable":true,"mergeable_state":"clean","merged_by":null,"comments":1,"review_comments":0,"maintainer_can_modify":false,"commits":11,"additions":11,"deletions":11,"changed_files":1}}
{"actor":{"display_login":"pyup-bot"}}