{"action":"created","issue":{"url":"https://api.github.com/repos/aio-libs/aiohttp_admin/issues/392","repository_url":"https://api.github.com/repos/aio-libs/aiohttp_admin","labels_url":"https://api.github.com/repos/aio-libs/aiohttp_admin/issues/392/labels{/name}","comments_url":"https://api.github.com/repos/aio-libs/aiohttp_admin/issues/392/comments","events_url":"https://api.github.com/repos/aio-libs/aiohttp_admin/issues/392/events","html_url":"https://github.com/aio-libs/aiohttp_admin/pull/392","id":363140885,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE3NjUyMTU2","number":392,"title":"Scheduled weekly dependency update for week 38","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},"labels":[{"id":775602346,"node_id":"MDU6TGFiZWw3NzU2MDIzNDY=","url":"https://api.github.com/repos/aio-libs/aiohttp_admin/labels/deps-update","name":"deps-update","color":"1BB0CE","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-09-24T13:14:31Z","updated_at":"2018-09-24T16:06:29Z","closed_at":null,"author_association":"COLLABORATOR","pull_request":{"url":"https://api.github.com/repos/aio-libs/aiohttp_admin/pulls/392","html_url":"https://github.com/aio-libs/aiohttp_admin/pull/392","diff_url":"https://github.com/aio-libs/aiohttp_admin/pull/392.diff","patch_url":"https://github.com/aio-libs/aiohttp_admin/pull/392.patch"},"body":"\n\n\n\n\n### Update [pytest](https://pypi.org/project/pytest) from **3.6.1** to **3.8.1**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 3.8.1\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- `3286 &lt;https://github.com/pytest-dev/pytest/issues/3286&gt;`_: ``.pytest_cache`` directory is now automatically ignored by Git. Users who would like to contribute a solution for other SCMs please consult/comment on this issue.\n\n\n- `3749 &lt;https://github.com/pytest-dev/pytest/issues/3749&gt;`_: Fix the following error during collection of tests inside packages::\n\n      TypeError: object of type &#39;Package&#39; has no len()\n\n\n- `3941 &lt;https://github.com/pytest-dev/pytest/issues/3941&gt;`_: Fix bug where indirect parametrization would consider the scope of all fixtures used by the test function to determine the parametrization scope, and not only the scope of the fixtures being parametrized.\n\n\n- `3973 &lt;https://github.com/pytest-dev/pytest/issues/3973&gt;`_: Fix crash of the assertion rewriter if a test changed the current working directory without restoring it afterwards.\n\n\n- `3998 &lt;https://github.com/pytest-dev/pytest/issues/3998&gt;`_: Fix issue that prevented some caplog properties (for example ``record_tuples``) from being available when entering the debugger with ``--pdb``.\n\n\n- `3999 &lt;https://github.com/pytest-dev/pytest/issues/3999&gt;`_: Fix ``UnicodeDecodeError`` in python2.x when a class returns a non-ascii binary ``__repr__`` in an assertion which also contains non-ascii text.\n\n\n\nImproved Documentation\n----------------------\n\n- `3996 &lt;https://github.com/pytest-dev/pytest/issues/3996&gt;`_: New `Deprecations and Removals &lt;https://docs.pytest.org/en/latest/deprecations.html&gt;`_ page shows all currently\n  deprecated features, the rationale to do so, and alternatives to update your code. It also list features removed\n  from pytest in past major releases to help those with ancient pytest versions to upgrade.\n\n\n\nTrivial/Internal Changes\n------------------------\n\n- `3955 &lt;https://github.com/pytest-dev/pytest/issues/3955&gt;`_: Improve pre-commit detection for changelog filenames\n\n\n- `3975 &lt;https://github.com/pytest-dev/pytest/issues/3975&gt;`_: Remove legacy code around im_func as that was python2 only\n   ```\n   \n  \n  \n   ### 3.8.0\n   ```\n   =========================\n\nDeprecations and Removals\n-------------------------\n\n- `2452 &lt;https://github.com/pytest-dev/pytest/issues/2452&gt;`_: ``Config.warn`` and ``Node.warn`` have been\n  deprecated, see `&lt;https://docs.pytest.org/en/latest/deprecations.htmlconfig-warn-and-node-warn&gt;`_ for rationale and\n  examples.\n\n- `3936 &lt;https://github.com/pytest-dev/pytest/issues/3936&gt;`_: ``pytest.mark.filterwarnings`` second parameter is no longer regex-escaped,\n  making it possible to actually use regular expressions to check the warning message.\n\n  **Note**: regex-escaping the match string was an implementation oversight that might break test suites which depend\n  on the old behavior.\n\n\n\nFeatures\n--------\n\n- `2452 &lt;https://github.com/pytest-dev/pytest/issues/2452&gt;`_: Internal pytest warnings are now issued using the standard ``warnings`` module, making it possible to use\n  the standard warnings filters to manage those warnings. This introduces ``PytestWarning``,\n  ``PytestDeprecationWarning`` and ``RemovedInPytest4Warning`` warning types as part of the public API.\n\n  Consult `the documentation &lt;https://docs.pytest.org/en/latest/warnings.htmlinternal-pytest-warnings&gt;`_ for more info.\n\n\n- `2908 &lt;https://github.com/pytest-dev/pytest/issues/2908&gt;`_: ``DeprecationWarning`` and ``PendingDeprecationWarning`` are now shown by default if no other warning filter is\n  configured. This makes pytest more compliant with\n  `PEP-0506 &lt;https://www.python.org/dev/peps/pep-0565/recommended-filter-settings-for-test-runners&gt;`_. See\n  `the docs &lt;https://docs.pytest.org/en/latest/warnings.htmldeprecationwarning-and-pendingdeprecationwarning&gt;`_ for\n  more info.\n\n\n- `3251 &lt;https://github.com/pytest-dev/pytest/issues/3251&gt;`_: Warnings are now captured and displayed during test collection.\n\n\n- `3784 &lt;https://github.com/pytest-dev/pytest/issues/3784&gt;`_: ``PYTEST_DISABLE_PLUGIN_AUTOLOAD`` environment variable disables plugin auto-loading when set.\n\n\n- `3829 &lt;https://github.com/pytest-dev/pytest/issues/3829&gt;`_: Added the ``count`` option to ``console_output_style`` to enable displaying the progress as a count instead of a percentage.\n\n\n- `3837 &lt;https://github.com/pytest-dev/pytest/issues/3837&gt;`_: Added support for &#39;xfailed&#39; and &#39;xpassed&#39; outcomes to the ``pytester.RunResult.assert_outcomes`` signature.\n\n\n\nBug Fixes\n---------\n\n- `3911 &lt;https://github.com/pytest-dev/pytest/issues/3911&gt;`_: Terminal writer now takes into account unicode character width when writing out progress.\n\n\n- `3913 &lt;https://github.com/pytest-dev/pytest/issues/3913&gt;`_: Pytest now returns with correct exit code (EXIT_USAGEERROR, 4) when called with unknown arguments.\n\n\n- `3918 &lt;https://github.com/pytest-dev/pytest/issues/3918&gt;`_: Improve performance of assertion rewriting.\n\n\n\nImproved Documentation\n----------------------\n\n- `3566 &lt;https://github.com/pytest-dev/pytest/issues/3566&gt;`_: Added a blurb in usage.rst for the usage of -r flag which is used to show an extra test summary info.\n\n\n- `3907 &lt;https://github.com/pytest-dev/pytest/issues/3907&gt;`_: Corrected type of the exceptions collection passed to ``xfail``: ``raises`` argument accepts a ``tuple`` instead of ``list``.\n\n\n\nTrivial/Internal Changes\n------------------------\n\n- `3853 &lt;https://github.com/pytest-dev/pytest/issues/3853&gt;`_: Removed ``&quot;run all (no recorded failures)&quot;`` message printed with ``--failed-first`` and ``--last-failed`` when there are no failed tests.\n   ```\n   \n  \n  \n   ### 3.7.4\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- `3506 &lt;https://github.com/pytest-dev/pytest/issues/3506&gt;`_: Fix possible infinite recursion when writing ``.pyc`` files.\n\n\n- `3853 &lt;https://github.com/pytest-dev/pytest/issues/3853&gt;`_: Cache plugin now obeys the ``-q`` flag when ``--last-failed`` and ``--failed-first`` flags are used.\n\n\n- `3883 &lt;https://github.com/pytest-dev/pytest/issues/3883&gt;`_: Fix bad console output when using ``console_output_style=classic``.\n\n\n- `3888 &lt;https://github.com/pytest-dev/pytest/issues/3888&gt;`_: Fix macOS specific code using ``capturemanager`` plugin in doctests.\n\n\n\nImproved Documentation\n----------------------\n\n- `3902 &lt;https://github.com/pytest-dev/pytest/issues/3902&gt;`_: Fix pytest.org links\n   ```\n   \n  \n  \n   ### 3.7.3\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- `3033 &lt;https://github.com/pytest-dev/pytest/issues/3033&gt;`_: Fixtures during teardown can again use ``capsys`` and ``capfd`` to inspect output captured during tests.\n\n\n- `3773 &lt;https://github.com/pytest-dev/pytest/issues/3773&gt;`_: Fix collection of tests from ``__init__.py`` files if they match the ``python_files`` configuration option.\n\n\n- `3796 &lt;https://github.com/pytest-dev/pytest/issues/3796&gt;`_: Fix issue where teardown of fixtures of consecutive sub-packages were executed once, at the end of the outer\n  package.\n\n\n- `3816 &lt;https://github.com/pytest-dev/pytest/issues/3816&gt;`_: Fix bug where ``--show-capture=no`` option would still show logs printed during fixture teardown.\n\n\n- `3819 &lt;https://github.com/pytest-dev/pytest/issues/3819&gt;`_: Fix ``stdout/stderr`` not getting captured when real-time cli logging is active.\n\n\n- `3843 &lt;https://github.com/pytest-dev/pytest/issues/3843&gt;`_: Fix collection error when specifying test functions directly in the command line using ``test.py::test`` syntax together with ``--doctest-modules``.\n\n\n- `3848 &lt;https://github.com/pytest-dev/pytest/issues/3848&gt;`_: Fix bugs where unicode arguments could not be passed to ``testdir.runpytest`` on Python 2.\n\n\n- `3854 &lt;https://github.com/pytest-dev/pytest/issues/3854&gt;`_: Fix double collection of tests within packages when the filename starts with a capital letter.\n\n\n\nImproved Documentation\n----------------------\n\n- `3824 &lt;https://github.com/pytest-dev/pytest/issues/3824&gt;`_: Added example for multiple glob pattern matches in ``python_files``.\n\n\n- `3833 &lt;https://github.com/pytest-dev/pytest/issues/3833&gt;`_: Added missing docs for ``pytester.Testdir``.\n\n\n- `3870 &lt;https://github.com/pytest-dev/pytest/issues/3870&gt;`_: Correct documentation for setuptools integration.\n\n\n\nTrivial/Internal Changes\n------------------------\n\n- `3826 &lt;https://github.com/pytest-dev/pytest/issues/3826&gt;`_: Replace broken type annotations with type comments.\n\n\n- `3845 &lt;https://github.com/pytest-dev/pytest/issues/3845&gt;`_: Remove a reference to issue `568 &lt;https://github.com/pytest-dev/pytest/issues/568&gt;`_ from the documentation, which has since been\n  fixed.\n   ```\n   \n  \n  \n   ### 3.7.2\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- `3671 &lt;https://github.com/pytest-dev/pytest/issues/3671&gt;`_: Fix ``filterwarnings`` not being registered as a builtin mark.\n\n\n- `3768 &lt;https://github.com/pytest-dev/pytest/issues/3768&gt;`_, `3789 &lt;https://github.com/pytest-dev/pytest/issues/3789&gt;`_: Fix test collection from packages mixed with normal directories.\n\n\n- `3771 &lt;https://github.com/pytest-dev/pytest/issues/3771&gt;`_: Fix infinite recursion during collection if a ``pytest_ignore_collect`` hook returns ``False`` instead of ``None``.\n\n\n- `3774 &lt;https://github.com/pytest-dev/pytest/issues/3774&gt;`_: Fix bug where decorated fixtures would lose functionality (for example ``mock.patch``).\n\n\n- `3775 &lt;https://github.com/pytest-dev/pytest/issues/3775&gt;`_: Fix bug where importing modules or other objects with prefix ``pytest_`` prefix would raise a ``PluginValidationError``.\n\n\n- `3788 &lt;https://github.com/pytest-dev/pytest/issues/3788&gt;`_: Fix ``AttributeError`` during teardown of ``TestCase`` subclasses which raise an exception during ``__init__``.\n\n\n- `3804 &lt;https://github.com/pytest-dev/pytest/issues/3804&gt;`_: Fix traceback reporting for exceptions with ``__cause__`` cycles.\n\n\n\nImproved Documentation\n----------------------\n\n- `3746 &lt;https://github.com/pytest-dev/pytest/issues/3746&gt;`_: Add documentation for ``metafunc.config`` that had been mistakenly hidden.\n   ```\n   \n  \n  \n   ### 3.7.1\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- `3473 &lt;https://github.com/pytest-dev/pytest/issues/3473&gt;`_: Raise immediately if ``approx()`` is given an expected value of a type it doesn&#39;t understand (e.g. strings, nested dicts, etc.).\n\n\n- `3712 &lt;https://github.com/pytest-dev/pytest/issues/3712&gt;`_: Correctly represent the dimensions of an numpy array when calling ``repr()`` on ``approx()``.\n\n- `3742 &lt;https://github.com/pytest-dev/pytest/issues/3742&gt;`_: Fix incompatibility with third party plugins during collection, which produced the error ``object has no attribute &#39;_collectfile&#39;``.\n\n- `3745 &lt;https://github.com/pytest-dev/pytest/issues/3745&gt;`_: Display the absolute path if ``cache_dir`` is not relative to the ``rootdir`` instead of failing.\n\n\n- `3747 &lt;https://github.com/pytest-dev/pytest/issues/3747&gt;`_: Fix compatibility problem with plugins and the warning code issued by fixture functions when they are called directly.\n\n\n- `3748 &lt;https://github.com/pytest-dev/pytest/issues/3748&gt;`_: Fix infinite recursion in ``pytest.approx`` with arrays in ``numpy&lt;1.13``.\n\n\n- `3757 &lt;https://github.com/pytest-dev/pytest/issues/3757&gt;`_: Pin pathlib2 to ``&gt;=2.2.0`` as we require ``__fspath__`` support.\n\n\n- `3763 &lt;https://github.com/pytest-dev/pytest/issues/3763&gt;`_: Fix ``TypeError`` when the assertion message is ``bytes`` in python 3.\n   ```\n   \n  \n  \n   ### 3.7.0\n   ```\n   =========================\n\nDeprecations and Removals\n-------------------------\n\n- `2639 &lt;https://github.com/pytest-dev/pytest/issues/2639&gt;`_: ``pytest_namespace`` has been `deprecated &lt;https://docs.pytest.org/en/latest/deprecations.htmlpytest-namespace&gt;`_.\n\n\n- `3661 &lt;https://github.com/pytest-dev/pytest/issues/3661&gt;`_: Calling a fixture function directly, as opposed to request them in a test function, now issues a ``RemovedInPytest4Warning``. See `the documentation for rationale and examples &lt;https://docs.pytest.org/en/latest/deprecations.htmlcalling-fixtures-directly&gt;`_.\n\n\n\nFeatures\n--------\n\n- `2283 &lt;https://github.com/pytest-dev/pytest/issues/2283&gt;`_: New ``package`` fixture scope: fixtures are finalized when the last test of a *package* finishes. This feature is considered **experimental**, so use it sparingly.\n\n\n- `3576 &lt;https://github.com/pytest-dev/pytest/issues/3576&gt;`_: ``Node.add_marker`` now supports an ``append=True/False`` parameter to determine whether the mark comes last (default) or first.\n\n\n- `3579 &lt;https://github.com/pytest-dev/pytest/issues/3579&gt;`_: Fixture ``caplog`` now has a ``messages`` property, providing convenient access to the format-interpolated log messages without the extra data provided by the formatter/handler.\n\n\n- `3610 &lt;https://github.com/pytest-dev/pytest/issues/3610&gt;`_: New ``--trace`` option to enter the debugger at the start of a test.\n\n\n- `3623 &lt;https://github.com/pytest-dev/pytest/issues/3623&gt;`_: Introduce ``pytester.copy_example`` as helper to do acceptance tests against examples from the project.\n\n\n\nBug Fixes\n---------\n\n- `2220 &lt;https://github.com/pytest-dev/pytest/issues/2220&gt;`_: Fix a bug where fixtures overridden by direct parameters (for example parametrization) were being instantiated even if they were not being used by a test.\n\n\n- `3695 &lt;https://github.com/pytest-dev/pytest/issues/3695&gt;`_: Fix ``ApproxNumpy`` initialisation argument mixup, ``abs`` and ``rel`` tolerances were flipped causing strange comparsion results.\n  Add tests to check ``abs`` and ``rel`` tolerances for ``np.array`` and test for expecting ``nan`` with ``np.array()``\n\n\n- `980 &lt;https://github.com/pytest-dev/pytest/issues/980&gt;`_: Fix truncated locals output in verbose mode.\n\n\n\nImproved Documentation\n----------------------\n\n- `3295 &lt;https://github.com/pytest-dev/pytest/issues/3295&gt;`_: Correct the usage documentation of ``--last-failed-no-failures`` by adding the missing ``--last-failed`` argument in the presented examples, because they are misleading and lead to think that the missing argument is not needed.\n\n\n\nTrivial/Internal Changes\n------------------------\n\n- `3519 &lt;https://github.com/pytest-dev/pytest/issues/3519&gt;`_: Now a ``README.md`` file is created in ``.pytest_cache`` to make it clear why the directory exists.\n   ```\n   \n  \n  \n   ### 3.6.4\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- Invoke pytest using ``-mpytest`` so ``sys.path`` does not get polluted by packages installed in ``site-packages``. (`742 &lt;https://github.com/pytest-dev/pytest/issues/742&gt;`_)\n\n\nImproved Documentation\n----------------------\n\n- Use ``smtp_connection`` instead of ``smtp`` in fixtures documentation to avoid possible confusion. (`3592 &lt;https://github.com/pytest-dev/pytest/issues/3592&gt;`_)\n\n\nTrivial/Internal Changes\n------------------------\n\n- Remove obsolete ``__future__`` imports. (`2319 &lt;https://github.com/pytest-dev/pytest/issues/2319&gt;`_)\n\n- Add CITATION to provide information on how to formally cite pytest. (`3402 &lt;https://github.com/pytest-dev/pytest/issues/3402&gt;`_)\n\n- Replace broken type annotations with type comments. (`3635 &lt;https://github.com/pytest-dev/pytest/issues/3635&gt;`_)\n\n- Pin ``pluggy`` to ``&lt;0.8``. (`3727 &lt;https://github.com/pytest-dev/pytest/issues/3727&gt;`_)\n   ```\n   \n  \n  \n   ### 3.6.3\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- Fix ``ImportWarning`` triggered by explicit relative imports in\n  assertion-rewritten package modules. (`3061\n  &lt;https://github.com/pytest-dev/pytest/issues/3061&gt;`_)\n\n- Fix error in ``pytest.approx`` when dealing with 0-dimension numpy\n  arrays. (`3593 &lt;https://github.com/pytest-dev/pytest/issues/3593&gt;`_)\n\n- No longer raise ``ValueError`` when using the ``get_marker`` API. (`3605\n  &lt;https://github.com/pytest-dev/pytest/issues/3605&gt;`_)\n\n- Fix problem where log messages with non-ascii characters would not\n  appear in the output log file.\n  (`3630 &lt;https://github.com/pytest-dev/pytest/issues/3630&gt;`_)\n\n- No longer raise ``AttributeError`` when legacy marks can&#39;t be stored in\n  functions. (`3631 &lt;https://github.com/pytest-dev/pytest/issues/3631&gt;`_)\n\n\nImproved Documentation\n----------------------\n\n- The description above the example for ``pytest.mark.skipif`` now better\n  matches the code. (`3611\n  &lt;https://github.com/pytest-dev/pytest/issues/3611&gt;`_)\n\n\nTrivial/Internal Changes\n------------------------\n\n- Internal refactoring: removed unused ``CallSpec2tox ._globalid_args``\n  attribute and ``metafunc`` parameter from ``CallSpec2.copy()``. (`3598\n  &lt;https://github.com/pytest-dev/pytest/issues/3598&gt;`_)\n\n- Silence usage of ``reduce`` warning in Python 2 (`3609\n  &lt;https://github.com/pytest-dev/pytest/issues/3609&gt;`_)\n\n- Fix usage of ``attr.ib`` deprecated ``convert`` parameter. (`3653\n  &lt;https://github.com/pytest-dev/pytest/issues/3653&gt;`_)\n   ```\n   \n  \n  \n   ### 3.6.2\n   ```\n   =========================\n\nBug Fixes\n---------\n\n- Fix regression in ``Node.add_marker`` by extracting the mark object of a\n  ``MarkDecorator``. (`3555\n  &lt;https://github.com/pytest-dev/pytest/issues/3555&gt;`_)\n\n- Warnings without ``location`` were reported as ``None``. This is corrected to\n  now report ``&lt;undetermined location&gt;``. (`3563\n  &lt;https://github.com/pytest-dev/pytest/issues/3563&gt;`_)\n\n- Continue to call finalizers in the stack when a finalizer in a former scope\n  raises an exception. (`3569\n  &lt;https://github.com/pytest-dev/pytest/issues/3569&gt;`_)\n\n- Fix encoding error with ``print`` statements in doctests (`3583\n  &lt;https://github.com/pytest-dev/pytest/issues/3583&gt;`_)\n\n\nImproved Documentation\n----------------------\n\n- Add documentation for the ``--strict`` flag. (`3549\n  &lt;https://github.com/pytest-dev/pytest/issues/3549&gt;`_)\n\n\nTrivial/Internal Changes\n------------------------\n\n- Update old quotation style to parens in fixture.rst documentation. (`3525\n  &lt;https://github.com/pytest-dev/pytest/issues/3525&gt;`_)\n\n- Improve display of hint about ``--fulltrace`` with ``KeyboardInterrupt``.\n  (`3545 &lt;https://github.com/pytest-dev/pytest/issues/3545&gt;`_)\n\n- pytest&#39;s testsuite is no longer runnable through ``python setup.py test`` --\n  instead invoke ``pytest`` or ``tox`` directly. (`3552\n  &lt;https://github.com/pytest-dev/pytest/issues/3552&gt;`_)\n\n- Fix typo in documentation (`3567\n  &lt;https://github.com/pytest-dev/pytest/issues/3567&gt;`_)\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/pytest\n  - Changelog: https://pyup.io/changelogs/pytest/\n  - Homepage: https://docs.pytest.org/en/latest/\n</details>\n\n\n\n\n\n### Update [aiohttp-security](https://pypi.org/project/aiohttp-security) from **0.2.0** to **0.3.0**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 0.3.0\n   ```\n   ------------------\n\n- Deprecate ``login_required`` and ``has_permission`` decorators.\n  Use ``check_authorized`` and ``check_permission`` helper functions instead.\n\n- Bump supported ``aiohttp`` version to 3.0+\n\n- Enable strong warnings mode for test suite, clean-up all deprecation\n  warnings.\n\n- Polish documentation\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/aiohttp-security\n  - Changelog: https://pyup.io/changelogs/aiohttp-security/\n  - Repo: https://github.com/aio-libs/aiohttp_security/\n</details>\n\n\n\n\n\n### Update [aiohttp-session](https://pypi.org/project/aiohttp-session) from **2.5.1** to **2.6.0**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 2.6.0\n   ```\n   ------------------\n\n* Create a new session if `NaClCookieStorage` cannot decode a\n  corrupted cookie 317\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/aiohttp-session\n  - Changelog: https://pyup.io/changelogs/aiohttp-session/\n  - Repo: https://github.com/aio-libs/aiohttp_session/\n</details>\n\n\n\n\n\n### Update [aiohttp](https://pypi.org/project/aiohttp) from **3.3.1** to **3.4.4**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 3.4.4\n   ```\n   ==================\n\n- Fix installation from sources when compiling toolkit is not available (`3241 &lt;https://github.com/aio-libs/aiohttp/pull/3241&gt;`_)\n   ```\n   \n  \n  \n   ### 3.4.3\n   ```\n   ==================\n\n- Add ``app.pre_frozen`` state to properly handle startup signals in sub-applications. (`3237 &lt;https://github.com/aio-libs/aiohttp/pull/3237&gt;`_)\n   ```\n   \n  \n  \n   ### 3.4.2\n   ```\n   ==================\n\n- Fix ``iter_chunks`` type annotation (`3230 &lt;https://github.com/aio-libs/aiohttp/pull/3230&gt;`_)\n   ```\n   \n  \n  \n   ### 3.4.1\n   ```\n   ==================\n\n- Fix empty header parsing regression. (`3218 &lt;https://github.com/aio-libs/aiohttp/pull/3218&gt;`_)\n- Fix BaseRequest.raw_headers doc. (`3215 &lt;https://github.com/aio-libs/aiohttp/pull/3215&gt;`_)\n- Fix documentation building on ReadTheDocs (`3221 &lt;https://github.com/aio-libs/aiohttp/pull/3221&gt;`_)\n   ```\n   \n  \n  \n   ### 3.4.0\n   ```\n   ==================\n\nFeatures\n--------\n\n- Add type hints (`3049 &lt;https://github.com/aio-libs/aiohttp/pull/3049&gt;`_)\n- Add ``raise_for_status`` request parameter (`3073 &lt;https://github.com/aio-libs/aiohttp/pull/3073&gt;`_)\n- Add type hints to HTTP client (`3092 &lt;https://github.com/aio-libs/aiohttp/pull/3092&gt;`_)\n- Minor server optimizations (`3095 &lt;https://github.com/aio-libs/aiohttp/pull/3095&gt;`_)\n- Preserve the cause when `HTTPException` is raised from another exception. (`3096 &lt;https://github.com/aio-libs/aiohttp/pull/3096&gt;`_)\n- Add `close_boundary` option in `MultipartWriter.write` method. Support streaming (`3104 &lt;https://github.com/aio-libs/aiohttp/pull/3104&gt;`_)\n- Added a ``remove_slash`` option to the ``normalize_path_middleware`` factory. (`3173 &lt;https://github.com/aio-libs/aiohttp/pull/3173&gt;`_)\n- The class `AbstractRouteDef` is importable from `aiohttp.web`. (`3183 &lt;https://github.com/aio-libs/aiohttp/pull/3183&gt;`_)\n\n\nBugfixes\n--------\n\n- Prevent double closing when client connection is released before the\n  last ``data_received()`` callback. (`3031 &lt;https://github.com/aio-libs/aiohttp/pull/3031&gt;`_)\n- Make redirect with `normalize_path_middleware` work when using url encoded paths. (`3051 &lt;https://github.com/aio-libs/aiohttp/pull/3051&gt;`_)\n- Postpone web task creation to connection establishment. (`3052 &lt;https://github.com/aio-libs/aiohttp/pull/3052&gt;`_)\n- Fix ``sock_read`` timeout. (`3053 &lt;https://github.com/aio-libs/aiohttp/pull/3053&gt;`_)\n- When using a server-request body as the `data=` argument of a client request, iterate over the content with `readany` instead of `readline` to avoid `Line too long` errors. (`3054 &lt;https://github.com/aio-libs/aiohttp/pull/3054&gt;`_)\n- fix `UrlDispatcher` has no attribute `add_options`, add `web.options` (`3062 &lt;https://github.com/aio-libs/aiohttp/pull/3062&gt;`_)\n- correct filename in content-disposition with multipart body (`3064 &lt;https://github.com/aio-libs/aiohttp/pull/3064&gt;`_)\n- Many HTTP proxies has buggy keepalive support.\n  Let&#39;s not reuse connection but close it after processing every response. (`3070 &lt;https://github.com/aio-libs/aiohttp/pull/3070&gt;`_)\n- raise 413 &quot;Payload Too Large&quot; rather than raising ValueError in request.post()\n  Add helpful debug message to 413 responses (`3087 &lt;https://github.com/aio-libs/aiohttp/pull/3087&gt;`_)\n- Fix `StreamResponse` equality, now that they are `MutableMapping` objects. (`3100 &lt;https://github.com/aio-libs/aiohttp/pull/3100&gt;`_)\n- Fix server request objects comparison (`3116 &lt;https://github.com/aio-libs/aiohttp/pull/3116&gt;`_)\n- Do not hang on `206 Partial Content` response with `Content-Encoding: gzip` (`3123 &lt;https://github.com/aio-libs/aiohttp/pull/3123&gt;`_)\n- Fix timeout precondition checkers (`3145 &lt;https://github.com/aio-libs/aiohttp/pull/3145&gt;`_)\n\n\nImproved Documentation\n----------------------\n\n- Add a new FAQ entry that clarifies that you should not reuse response\n  objects in middleware functions. (`3020 &lt;https://github.com/aio-libs/aiohttp/pull/3020&gt;`_)\n- Add FAQ section &quot;Why is creating a ClientSession outside of an event loop dangerous?&quot; (`3072 &lt;https://github.com/aio-libs/aiohttp/pull/3072&gt;`_)\n- Fix link to Rambler (`3115 &lt;https://github.com/aio-libs/aiohttp/pull/3115&gt;`_)\n- Fix TCPSite documentation on the Server Reference page. (`3146 &lt;https://github.com/aio-libs/aiohttp/pull/3146&gt;`_)\n- Fix documentation build configuration file for Windows. (`3147 &lt;https://github.com/aio-libs/aiohttp/pull/3147&gt;`_)\n- Remove no longer existing lingering_timeout parameter of Application.make_handler from documentation. (`3151 &lt;https://github.com/aio-libs/aiohttp/pull/3151&gt;`_)\n- Mention that ``app.make_handler`` is deprecated, recommend to use runners\n  API instead. (`3157 &lt;https://github.com/aio-libs/aiohttp/pull/3157&gt;`_)\n\n\nDeprecations and Removals\n-------------------------\n\n- Drop ``loop.current_task()`` from ``helpers.current_task()`` (`2826 &lt;https://github.com/aio-libs/aiohttp/pull/2826&gt;`_)\n- Drop ``reader`` parameter from ``request.multipart()``. (`3090 &lt;https://github.com/aio-libs/aiohttp/pull/3090&gt;`_)\n   ```\n   \n  \n  \n   ### 3.3.2\n   ```\n   ==================\n\n- Many HTTP proxies has buggy keepalive support. Let&#39;s not reuse connection but\n  close it after processing every response. (`3070 &lt;https://github.com/aio-libs/aiohttp/pull/3070&gt;`_)\n\n- Provide vendor source files in tarball (`3076 &lt;https://github.com/aio-libs/aiohttp/pull/3076&gt;`_)\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/aiohttp\n  - Changelog: https://pyup.io/changelogs/aiohttp/\n  - Repo: https://github.com/aio-libs/aiohttp\n</details>\n\n\n\n\n\n### Update [aiomysql](https://pypi.org/project/aiomysql) from **0.0.16** to **0.0.19**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 0.0.17\n   ```\n   ^^^^^^^^^^^^^^^^^^^\n\n* Pinned version of PyMySQL\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/aiomysql\n  - Changelog: https://pyup.io/changelogs/aiomysql/\n  - Repo: https://github.com/aio-libs/aiomysql\n</details>\n\n\n\n\n\n### Update [aiopg](https://pypi.org/project/aiopg) from **0.14.0** to **0.15.0**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 0.15.0\n   ```\n   ^^^^^^^^^^^^^^^^^^^\n\n* Support Python 3.7 (437)\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/aiopg\n  - Changelog: https://pyup.io/changelogs/aiopg/\n  - Docs: https://aiopg.readthedocs.io\n</details>\n\n\n\n\n\n### Update [docker](https://pypi.org/project/docker) from **3.3.0** to **3.4.1**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 3.4.0\n   ```\n   -----\n\n[List of PRs / issues for this release](https://github.com/docker/docker-py/milestone/51?closed=1)\n\n Features\n\n* The `APIClient` and `DockerClient` constructors now accept a `credstore_env`\n  parameter. When set, values in this dictionary are added to the environment\n  when executing the credential store process.\n\n Bugfixes\n\n* `DockerClient.networks.prune` now properly returns the operation&#39;s result\n* Fixed a bug that caused custom Dockerfile paths in a subfolder of the build\n  context to be invalidated, preventing these builds from working\n* The `plugin_privileges` method can now be called for plugins requiring\n  authentication to access\n* Fixed a bug that caused attempts to read a data stream over an unsecured TCP\n  socket to crash on Windows clients\n* Fixed a bug where using the `read_only` parameter when creating a service using\n  the `DockerClient` was being ignored\n* Fixed an issue where `Service.scale` would not properly update the service&#39;s\n  mode, causing the operation to fail silently\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/docker\n  - Changelog: https://pyup.io/changelogs/docker/\n  - Repo: https://github.com/docker/docker-py\n</details>\n\n\n\n\n\n### Update [motor](https://pypi.org/project/motor) from **1.2.2** to **2.0.0**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 2.0\n   ```\n   including multi-document transactions, and change stream notifications on entire\ndatabases or entire MongoDB servers. It adds support for Python 3.7. This\nversion of Motor requires PyMongo 3.7 or later.\n\nThis is a major release that removes previously deprecated APIs.\n\nTo support multi-document transactions, Motor had to make breaking changes to\nthe session API and release a major version bump. Since this is a major release\nit also deletes many helper methods and APIs that had been deprecated over the\ntime since Motor 1.0, most notably the old CRUD methods ``insert``, ``update``,\n``remove``, and ``save``, and the original callback-based API. Read the\n:doc:`migrate-to-motor-2` carefully to upgrade your existing Motor application.\n\nDocumentation is updated to warn about obsolete TLS versions, see\n:doc:`configuration`. Motor is now tested on Travis in addition to MongoDB&#39;s\n`Evergreen &lt;https://github.com/evergreen-ci/evergreen&gt;`_ system.\n\nAdded support for `aiohttp`_ 3.0 and later, and dropped older aiohttp versions.\nThe aiohttp integration now requires Python 3.5+.\n\nThe ``MotorDatabase.add_user`` and ``MotorDatabase.remove_user`` methods are\ndeleted. Manage user accounts with four database commands: createUser_,\nusersInfo_, updateUser_, and dropUser_. You can run any database command with\nthe :meth:`MotorDatabase.command` method.\n\n.. _createUser: https://docs.mongodb.com/manual/reference/command/createUser/\n.. _usersInfo: https://docs.mongodb.com/manual/reference/command/usersInfo/\n.. _updateUser: https://docs.mongodb.com/manual/reference/command/updateUser/\n.. _dropUser: https://docs.mongodb.com/manual/reference/command/createUser/\n\nThe deprecated GridFS classes ``MotorGridFS`` and ``AsyncIOMotorGridFS`` are\ndeleted in favor of :class:`~motor.motor_tornado.MotorGridFSBucket` and\n:class:`~motor.motor_asyncio.AsyncIOMotorGridFSBucket`, which conform to driver\nspecs for GridFS.\n\nAdditional changes:\n\n- New methods for retrieving batches of raw BSON:\n\n  - :meth:`MotorCollection.find_raw_batches`\n  - :meth:`MotorCollection.aggregate_raw_batches`\n\n- Motor adds its name, version, and Tornado&#39;s version (if appropriate) to the\n  client data logged by the MongoDB server when Motor connects, in addition to\n  the data added by PyMongo.\n- Calling :meth:`~MotorCommandCursor.batch_size` on a cursor returned from\n  :meth:`~MotorCollection.aggregate` no longer raises ``AttributeError``.\n   ```\n   \n  \n  \n   ### 1.3.1\n   ```\n   -----------\n\nFix a Python 3.7 compatibility bug caused by importing &quot;async&quot;, which is a\nkeyword in Python 3.7. Drop support for Python 3.4.3 and older.\n   ```\n   \n  \n  \n   ### 1.3.0\n   ```\n   -----------\n\nDeprecate Motor&#39;s old callback-based async API in preparation for removing it in\nMotor 2.0. Raise ``DeprecationWarning`` whenever a callback is passed.\n\nSee the :doc:`migrate-to-motor-2`.\n   ```\n   \n  \n  \n   ### 1.2.5\n   ```\n   -----------\n\nFix a Python 3.7 compatibility bug caused by importing &quot;async&quot;, which is a\nkeyword in Python 3.7. Drop support for Python 3.4.3 and older.\n   ```\n   \n  \n  \n   ### 1.2.4\n   ```\n   -----------\n\nFix a Python 3.7 compatibility bug in the :class:`MotorChangeStream` class\nreturned by :meth:`MotorCollection.watch`. It is now possible to use change\nstreams in ``async for`` loops in Python 3.7.\n   ```\n   \n  \n  \n   ### 1.2.3\n   ```\n   -----------\n\nCompatibility with latest Sphinx and document how to use the latest TLS\nprotocols.\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/motor\n  - Changelog: https://pyup.io/changelogs/motor/\n  - Repo: https://github.com/mongodb/motor/\n</details>\n\n\n\n\n\n### Update [pytest-cov](https://pypi.org/project/pytest-cov) from **2.5.1** to **2.6.0**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 2.6.0\n   ```\n   ------------------\n\n* Dropped support for Python &lt; 3.4, Pytest &lt; 3.5 and Coverage &lt; 4.4.\n* Fixed some documentation formatting. Contributed by Jean Jordaan and Julian.\n* Added an example with ``addopts`` in documentation. Contributed by Samuel Giffard in\n  `195 &lt;https://github.com/pytest-dev/pytest-cov/pull/195&gt;`_.\n* Fixed ``TypeError: &#39;NoneType&#39; object is not iterable`` in certain xdist configurations. Contributed by Jeremy Bowman in\n  `213 &lt;https://github.com/pytest-dev/pytest-cov/pull/213&gt;`_.\n* Added a ``no_cover`` marker and fixture. Fixes\n  `78 &lt;https://github.com/pytest-dev/pytest-cov/issues/78&gt;`_.\n* Fixed broken ``no_cover`` check when running doctests. Contributed by Terence Honles in\n  `200 &lt;https://github.com/pytest-dev/pytest-cov/pull/200&gt;`_.\n* Fixed various issues with path normalization in reports (when combining coverage data from parallel mode). Fixes\n  `130 &lt;https://github.com/pytest-dev/pytest-cov/issues/161&gt;`_.\n  Contributed by Ryan Hiebert &amp; Ionel Cristian Mărieș in\n  `178 &lt;https://github.com/pytest-dev/pytest-cov/pull/178&gt;`_.\n* Report generation failures don&#39;t raise exceptions anymore. A warning will be logged instead. Fixes\n  `161 &lt;https://github.com/pytest-dev/pytest-cov/issues/161&gt;`_.\n* Fixed multiprocessing issue on Windows (empty env vars are not passed). Fixes\n  `165 &lt;https://github.com/pytest-dev/pytest-cov/issues/165&gt;`_.\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/pytest-cov\n  - Changelog: https://pyup.io/changelogs/pytest-cov/\n  - Repo: https://github.com/pytest-dev/pytest-cov\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### 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 [sphinx](https://pypi.org/project/sphinx) from **1.7.5** to **1.8.1**.\n\n\n<details>\n  <summary>Changelog</summary>\n  \n  \n   ### 1.8.1\n   ```\n   =====================================\n\nIncompatible changes\n--------------------\n\n* LaTeX ``\\pagestyle`` commands have been moved to the LaTeX template. No\n  changes in PDF, except possibly if ``\\sphinxtableofcontents``, which\n  contained them, had been customized in :file:`conf.py`. (refs: 5455)\n\nBugs fixed\n----------\n\n* 5418: Incorrect default path for sphinx-build -d/doctrees files\n* 5421: autodoc emits deprecation warning for :confval:`autodoc_default_flags`\n* 5422: lambda object causes PicklingError on storing environment\n* 5417: Sphinx fails to build with syntax error in Python 2.7.5\n* 4911: add latexpdf to make.bat for non make-mode\n* 5436: Autodoc does not work with enum subclasses with properties/methods\n* 5437: autodoc: crashed on modules importing eggs\n* 5433: latex: ImportError: cannot import name &#39;DEFAULT_SETTINGS&#39;\n* 5431: autodoc: ``autofunction`` emits a warning for callable objects\n* 5457: Fix TypeError in error message when override is prohibited\n* 5453: PDF builds of &#39;howto&#39; documents have no page numbers\n* 5463: mathbase: math_role and MathDirective was disappeared in 1.8.0\n* 5454: latex: Index has disappeared from PDF for Japanese documents\n* 5432: py domain: ``:type:`` field can&#39;t process ``:term:`` references\n* 5426: py domain: TypeError has been raised for class attribute\n   ```\n   \n  \n  \n   ### 1.8.0\n   ```\n   =====================================\n\nDependencies\n------------\n   ```\n   \n  \n  \n   ### 1.8.0b2\n   ```\n   * html: search box overrides to other elements if scrolled\n* i18n: warnings for translation catalogs have wrong line numbers (refs: 5321)\n* 5325: latex: cross references has been broken by multiply labeled objects\n* C++, fixes for symbol addition and lookup. Lookup should no longer break\n  in partial builds. See also 5337.\n* 5348: download reference to remote file is not displayed\n* 5282: html theme: ``pygments_style`` of theme was overrided by ``conf.py``\n  by default\n* 4379: toctree shows confusible warning when document is excluded\n* 2401: autodoc: ``:members:`` causes ``:special-members:`` not to be shown\n* autodoc: ImportError is replaced by AttributeError for deeper module\n* 2720, 4034: Incorrect links with ``:download:``, duplicate names, and\n  parallel builds\n* 5290: autodoc: failed to analyze source code in egg package\n* 5399: Sphinx crashes if unknown po file exists\n   ```\n   \n  \n  \n   ### 1.8.0b1\n   ```\n   * 5083: Fix wrong make.bat option for internationalization.\n* 5115: napoleon: add admonitions added by 4613 to the docs.\n   ```\n   \n  \n  \n   ### 1.7.10\n   ```\n   ===============================\n\nDependencies\n------------\n\nIncompatible changes\n--------------------\n\nDeprecated\n----------\n\nFeatures added\n--------------\n\nBugs fixed\n----------\n\nTesting\n--------\n   ```\n   \n  \n  \n   ### 1.7.9\n   ```\n   =====================================\n\nFeatures added\n--------------\n\n* 5359: Make generated texinfo files reproducible by sorting the anchors\n\nBugs fixed\n----------\n\n* 5361: crashed on incremental build if document uses include directive\n   ```\n   \n  \n  \n   ### 1.7.8\n   ```\n   =====================================\n\nIncompatible changes\n--------------------\n\n* The type of ``env.included`` has been changed to dict of set\n\nBugs fixed\n----------\n\n* 5320: intersphinx: crashed if invalid url given\n* 5326: manpage: crashed when invalid docname is specified as ``man_pages``\n* 5322: autodoc: ``Any`` typehint causes formatting error\n* 5327: &quot;document isn&#39;t included in any toctree&quot; warning on rebuild with\n  generated files\n* 5335: quickstart: escape sequence has been displayed with MacPorts&#39; python\n   ```\n   \n  \n  \n   ### 1.7.7\n   ```\n   =====================================\n\nBugs fixed\n----------\n\n* 5198: document not in toctree warning when including files only for parallel\n  builds\n* LaTeX: reduce &quot;Token not allowed in a PDF string&quot; hyperref warnings in latex\n  console output (refs: 5236)\n* LaTeX: suppress &quot;remreset Warning: The remreset package is obsolete&quot; in latex\n  console output with recent LaTeX (refs: 5237)\n* 5234: PDF output: usage of PAPER environment variable is broken since Sphinx\n  1.5\n* LaTeX: fix the :confval:`latex_engine` documentation regarding Latin Modern\n  font with XeLaTeX/LuaLateX (refs: 5251)\n* 5280: autodoc: Fix wrong type annotations for complex typing\n* autodoc: Optional types are wrongly rendered\n* 5291: autodoc crashed by ForwardRef types\n* 5211: autodoc: No docs generated for functools.partial functions\n* 5306: autodoc: ``getargspec()`` raises NameError for invalid typehints\n* 5298: imgmath: math_number_all causes equations to have two numbers in html\n* 5294: sphinx-quickstart blank prompts in PowerShell\n   ```\n   \n  \n  \n   ### 1.7.6\n   ```\n   =====================================\n\nBugs fixed\n----------\n\n* 5037: LaTeX ``\\sphinxupquote{}`` breaks in Russian\n* sphinx.testing uses deprecated pytest API; ``Node.get_marker(name)``\n* 5016: crashed when recommonmark.AutoStrictify is enabled\n* 5022: latex: crashed with docutils package provided by Debian/Ubuntu\n* 5009: latex: a label for table is vanished if table does not have a caption\n* 5048: crashed with numbered toctree\n* 2410: C, render empty argument lists for macros.\n* C++, fix lookup of full template specializations with no template arguments.\n* 4667: C++, fix assertion on missing references in global scope when using\n  intersphinx. Thanks to Alan M. Carroll.\n* 5019: autodoc: crashed by Form Feed Character\n* 5032: autodoc: loses the first staticmethod parameter for old styled classes\n* 5036: quickstart: Typing Ctrl-U clears the whole of line\n* 5066: html: &quot;relations&quot; sidebar is not shown by default\n* 5091: latex: curly braces in index entries are not handled correctly\n* 5070: epub: Wrong internal href fragment links\n* 5104: apidoc: Interface of ``sphinx.apidoc:main()`` has changed\n* 4272: PDF builds of French projects have issues with XeTeX\n* 5076: napoleon raises RuntimeError with python 3.7\n* 5125: sphinx-build: Interface of ``sphinx:main()`` has changed\n* sphinx-build: ``sphinx.cmd.build.main()`` refers ``sys.argv`` instead of given\n  argument\n* 5146: autosummary: warning is emitted when the first line of docstring ends\n  with literal notation\n* autosummary: warnings of autosummary indicates wrong location (refs: 5146)\n* 5143: autodoc: crashed on inspecting dict like object which does not support\n  sorting\n* 5139: autodoc: Enum argument missing if it shares value with another\n* 4946: py domain: rtype field could not handle &quot;None&quot; as a type\n* 5176: LaTeX: indexing of terms containing `, ``!``, or ``&quot;`` fails\n* 5161: html: crashes if copying static files are failed\n* 5167: autodoc: Fix formatting type annotations for tuples with more than two\n  arguments\n* 3329: i18n: crashed by auto-symbol footnote references\n* 5158: autosummary: module summary has been broken when it starts with heading\n   ```\n   \n  \n</details>\n\n\n \n\n<details>\n  <summary>Links</summary>\n  \n  - PyPI: https://pypi.org/project/sphinx\n  - Changelog: https://pyup.io/changelogs/sphinx/\n  - Homepage: http://sphinx-doc.org/\n</details>\n\n\n\n\n\n"},"comment":{"url":"https://api.github.com/repos/aio-libs/aiohttp_admin/issues/comments/424030492","html_url":"https://github.com/aio-libs/aiohttp_admin/pull/392#issuecomment-424030492","issue_url":"https://api.github.com/repos/aio-libs/aiohttp_admin/issues/392","id":424030492,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNDAzMDQ5Mg==","user":{"login":"codecov[bot]","id":22429695,"node_id":"MDM6Qm90MjI0Mjk2OTU=","avatar_url":"https://avatars2.githubusercontent.com/in/254?v=4","gravatar_id":"","url":"https://api.github.com/users/codecov%5Bbot%5D","html_url":"https://github.com/marketplace/codecov","followers_url":"https://api.github.com/users/codecov%5Bbot%5D/followers","following_url":"https://api.github.com/users/codecov%5Bbot%5D/following{/other_user}","gists_url":"https://api.github.com/users/codecov%5Bbot%5D/gists{/gist_id}","starred_url":"https://api.github.com/users/codecov%5Bbot%5D/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codecov%5Bbot%5D/subscriptions","organizations_url":"https://api.github.com/users/codecov%5Bbot%5D/orgs","repos_url":"https://api.github.com/users/codecov%5Bbot%5D/repos","events_url":"https://api.github.com/users/codecov%5Bbot%5D/events{/privacy}","received_events_url":"https://api.github.com/users/codecov%5Bbot%5D/received_events","type":"Bot","site_admin":false},"created_at":"2018-09-24T16:06:29Z","updated_at":"2018-09-24T16:06:29Z","author_association":"NONE","body":"# [Codecov](https://codecov.io/gh/aio-libs/aiohttp_admin/pull/392?src=pr&el=h1) Report\n> Merging [#392](https://codecov.io/gh/aio-libs/aiohttp_admin/pull/392?src=pr&el=desc) into [master](https://codecov.io/gh/aio-libs/aiohttp_admin/commit/0ca23749e1f24eaaf7a5f576ac793ccf1a6b7101?src=pr&el=desc) will **not change** coverage.\n> The diff coverage is `n/a`.\n\n[![Impacted file tree graph](https://codecov.io/gh/aio-libs/aiohttp_admin/pull/392/graphs/tree.svg?width=650&token=hi9C1pKqnW&height=150&src=pr)](https://codecov.io/gh/aio-libs/aiohttp_admin/pull/392?src=pr&el=tree)\n\n```diff\n@@           Coverage Diff           @@\n##           master     #392   +/-   ##\n=======================================\n  Coverage   80.96%   80.96%           \n=======================================\n  Files          13       13           \n  Lines         604      604           \n  Branches       92       92           \n=======================================\n  Hits          489      489           \n  Misses        103      103           \n  Partials       12       12\n```\n\n\n\n------\n\n[Continue to review full report at Codecov](https://codecov.io/gh/aio-libs/aiohttp_admin/pull/392?src=pr&el=continue).\n> **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta)\n> `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`\n> Powered by [Codecov](https://codecov.io/gh/aio-libs/aiohttp_admin/pull/392?src=pr&el=footer). Last update [0ca2374...2591cff](https://codecov.io/gh/aio-libs/aiohttp_admin/pull/392?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).\n"}}
{"actor":{"display_login":"codecov"}}