[usecase] [autogenerate] Render if_exists and if_not_exists parameters in
CreateTableOp, CreateIndexOp, DropTableOp and
DropIndexOp in an autogenerate context. While Alembic does not
set these parameters during an autogenerate run, they can be enabled using
a custom Rewriter in the env.py file, where they will now be
part of the rendered Python code in revision files. Pull request courtesy
of Louis-Amaury Chaib (@lachaib).
[usecase] [environment] Enhance version_locations parsing to handle paths containing newlines.
[usecase] [operations] Added support for Operations.create_table.if_not_exists and
Operations.drop_table.if_exists, adding similar functionality
to render IF [NOT] EXISTS for table operations in a similar way as with
indexes. Pull request courtesy Aaron Griffin.
[change] [general] The pin for setuptools<69.3 in pyproject.toml has been removed.
This pin was to prevent a sudden change to PEP 625 in setuptools from
taking place which changes the file name of SQLAlchemy's source
distribution on pypi to be an all lower case name, and the change was
extended to all SQLAlchemy projects to prevent any further surprises.
However, the presence of this pin is now holding back environments that
otherwise want to use a newer setuptools, so we've decided to move forward
with this change, with the assumption that build environments will have
largely accommodated the setuptools change by now.
Black is now officially tested with Python 3.13 and provides Python 3.13
mypyc-compiled wheels. (#4436) (#4449)
Black will issue an error when used with Python 3.12.5, due to an upstream memory
safety issue in Python 3.12.5 that can cause Black's AST safety checks to fail. Please
use Python 3.12.6 or Python 3.12.4 instead. (#4447)
Black no longer supports running with Python 3.8 (#4452)
Stable style
Fix crashes involving comments in parenthesised return types or X | Y style unions.
(#4453)
Fix skipping Jupyter cells with unknown %% magic (#4462)
Preview style
Fix type annotation spacing between * and more complex type variable tuple (i.e. def fn(*args: *tuple[*Ts, T]) -> None: pass) (#4440)
Caching
Fix bug where the cache was shared between runs with and without --unstable (#4466)
Packaging
Upgrade version of mypyc used to 1.12 beta (#4450) (#4449)
blackd now requires a newer version of aiohttp. (#4451)
Output
Added Python target version information on parse error (#4378)
Add information about Black version to internal error messages (#4457)
Black is now officially tested with Python 3.13 and provides Python 3.13
mypyc-compiled wheels. (#4436) (#4449)
Black will issue an error when used with Python 3.12.5, due to an upstream memory
safety issue in Python 3.12.5 that can cause Black's AST safety checks to fail. Please
use Python 3.12.6 or Python 3.12.4 instead. (#4447)
Black no longer supports running with Python 3.8 (#4452)
Stable style
Fix crashes involving comments in parenthesised return types or X | Y style unions.
(#4453)
Fix skipping Jupyter cells with unknown %% magic (#4462)
Preview style
Fix type annotation spacing between * and more complex type variable tuple (i.e. def fn(*args: *tuple[*Ts, T]) -> None: pass) (#4440)
Caching
Fix bug where the cache was shared between runs with and without --unstable (#4466)
Packaging
Upgrade version of mypyc used to 1.12 beta (#4450) (#4449)
blackd now requires a newer version of aiohttp. (#4451)
Output
Added Python target version information on parse error (#4378)
Add information about Black version to internal error messages (#4457)
Release binary packages including PostgreSQL 17 libpq (:ticket:[#852](https://github.com/psycopg/psycopg/issues/852)).
Psycopg 3.2.2
^^^^^^^^^^^^^
Drop !TypeDef specifications as string from public modules, as they cannot
be composed by users as !typing objects previously could (:ticket:[#860](https://github.com/psycopg/psycopg/issues/860)).
Add support for integer, floating point, boolean NumPy scalar types__
(:ticket:[#332](https://github.com/psycopg/psycopg/issues/332)).
Add !timeout and !stop_after parameters to Connection.notifies()
(:ticket:340).
Allow dumpers to return !None, to be converted to NULL (:ticket:[#377](https://github.com/psycopg/psycopg/issues/377)).
Add :ref:raw-query-cursors to execute queries using placeholders in
PostgreSQL format ($1, $2...) (:tickets:[#560](https://github.com/psycopg/psycopg/issues/560), [#839](https://github.com/psycopg/psycopg/issues/839)).
Add capabilities object to :ref:inspect the libpq capabilities <capabilities> (:ticket:[#772](https://github.com/psycopg/psycopg/issues/772)).
Add ~rows.scalar_row to return scalar values from a query (:ticket:[#723](https://github.com/psycopg/psycopg/issues/723)).
Add ~Connection.cancel_safe() for encrypted and non-blocking cancellation
when using libpq v17. Use such method internally to implement
... (truncated)
Commits
ce8f073 chore: bump psycopg package version to 3.2.3
Improve ProxyHeadersMiddleware (#2468) and (#2231):
Fix the host for requests from clients running on the proxy server itself.
Fallback to host that was already set for empty x-forwarded-for headers.
Also allow specifying IP Networks as trusted hosts. This greatly simplifies deployments
on docker swarm/Kubernetes, where the reverse proxy might have a dynamic IP.
Add PathLike[str] type hint for ssl_keyfile (#2481)
0.31.0 (2024-09-27)
Added
Improve ProxyHeadersMiddleware (#2468) and (#2231):
Fix the host for requests from clients running on the proxy server itself.
Fallback to host that was already set for empty x-forwarded-for headers.
Also allow to specify IP Networks as trusted hosts. This greatly simplifies deployments
on docker swarm/kubernetes, where the reverse proxy might have a dynamic IP.
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency
- `@dependabot ignore major version` will close this group update PR and stop Dependabot creating any more for the specific dependency's major version (unless you unignore this specific dependency's major version or upgrade to it yourself)
- `@dependabot ignore minor version` will close this group update PR and stop Dependabot creating any more for the specific dependency's minor version (unless you unignore this specific dependency's minor version or upgrade to it yourself)
- `@dependabot ignore ` will close this group update PR and stop Dependabot creating any more for the specific dependency (unless you unignore this specific dependency or upgrade to it yourself)
- `@dependabot unignore ` will remove all of the ignore conditions of the specified dependency
- `@dependabot unignore ` will remove the ignore condition of the specified dependency and ignore conditions
Bumps the poetry group with 6 updates in the / directory:
1.13.21.13.324.8.024.10.03.8.04.0.13.2.23.2.30.6.70.6.90.30.60.31.1Updates
alembicfrom 1.13.2 to 1.13.3Release notes
Sourced from alembic's releases.
Commits
Updates
blackfrom 24.8.0 to 24.10.0Release notes
Sourced from black's releases.
Changelog
Sourced from black's changelog.
Commits
1b2427aPrepare release 24.10.0 (#4471)a22b1ebAdd mypyc 3.13 wheel build (#4449)b7d0e72Bump AndreMiras/coveralls-python-action from 65c1672f0b8a201702d86c81b79187df...f1a2f92Include --unstable in cache key (#4466)8d9d18cFix skipping Jupyter cells with unknown %% magic (#4462)bbfdba3Fix docs CI: use venv for uv to fix 'failed to create directory' (#4460)8fb2addUse builtin generics (#4458)2a45cecFix crashes with comments in parentheses (#4453)b4d6d86Drop Python 3.8 support (#4452)ac018c1Require newer aiohttp for blackd (#4451)Updates
pre-commitfrom 3.8.0 to 4.0.1Release notes
Sourced from pre-commit's releases.
Changelog
Sourced from pre-commit's changelog.
Commits
cc4a522v4.0.1772d7d4Merge pull request #3324 from pre-commit/migrate-config-purelib222c62bfix migrate-config for purelib yaml3d5548bMerge pull request #3323 from pre-commit/pre-commit-ci-update-config4235a87[pre-commit.ci] pre-commit autoupdatedbccd57v4.0.0d07e529Merge pull request #3320 from pre-commit/remove-python-venv801b956remove deprecated python_venv aliasa2f7b80Merge pull request #3315 from pre-commit/warn-deprecated-stage-names-on-initd317223add warning for deprecates stages for remote repos on initUpdates
psycopgfrom 3.2.2 to 3.2.3Changelog
Sourced from psycopg's changelog.
... (truncated)
Commits
ce8f073chore: bump psycopg package version to 3.2.39af9267Merge pull request #917 from psycopg/pg179c9369bdocs: mention PostgreSQL 17 in binary packages in the news filed0b1a3aci: install flex to build libpq17e8d85ci(macos): fix dylib path for postgres 17 from brewd066132ci(macos): update brew to install PostgreSQL 172cc362eci: bump to PostgreSQL 17 in binary packages810bfcfchore: add PostgreSQL 17 TRANSACTION_TIMEOUT error2a02421ci: Add PostgreSQL 17 to CI test grid, remove PostgreSQL 11bea783dfix(windows): resolve absolute path to libpqUpdates
rufffrom 0.6.7 to 0.6.9Release notes
Sourced from ruff's releases.
... (truncated)
Changelog
Sourced from ruff's changelog.
... (truncated)
Commits
975be9cBump version to 0.6.9 (#13624)99e4566MarkFURB118fix as unsafe (#13613)7ad07c2Addallow-unused-importssetting forunused-importrule (F401) (#13601)4aefe52Support ruff discovery in pip build environments (#13591)cc1f766Preserve trivia (i.e. comments) in PLR5501 (#13573)fdd0a22Move to maintained mirror of prettier (#13592)3728d5b[pyupgrade] Fix UP043 to apply tocollections.abc.Generatorand `collecti...7e3894fAvoid short circuitingB017for multiple context managers (#13609)c3b40daUse backticks for code in red-knot messages (#13599)ef45185Allow users to provide custom diagnostic messages when unwrapping calls (#13597)Updates
uvicornfrom 0.30.6 to 0.31.1Release notes
Sourced from uvicorn's releases.
Changelog
Sourced from uvicorn's changelog.
Commits
137f88eVersion 0.31.1 (#2483)27d976aAddPathLike[str]type hint forssl_keyfile(#2481)1ddd250Bump the python-packages group with 10 updates (#2478)108b1c9docs: fix configuration option for trusting forwarded IPs (#2479)a1783d8Add support for[*]in trusted hosts (#2480)6ffaaf7Update link to Hypercorn project (#2474)c7668ceUpgrade websockets to 0.13.1 (#2471)a507532Version 0.31.0 (#2469)84dd2c4Improve ProxyHeadersMiddleware (#2468)3d26ab4Bump cryptography from 42.0.8 to 43.0.1 (#2453)Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show