doc: Updated net/djbdnscurve6 to 44d

(schmonz)

djbdnscurve6: update to 44d. Changes:

- root.c frees now &text.

(schmonz)

doc: Updated net/fehqlibs to 23

(schmonz)

fehqlibs: update to 23. Changes:

- More documentation for dns resolver routines.
- Added function stralloc_free() which was alreday in the header.

(schmonz)

doc: Updated devel/mise to 2024.4.0

(schmonz)

mise: update to 2024.4.0. Changes:

2024.4.0:

### Bug Fixes

* (python) install python when pip is disabled outside virtualenv

### Other Changes

* Move logic to set current directory before loading other config

2024.3.11:

### Features

* (task) extend mise tasks output

2024.3.10:

### Bug Fixes

* use correct type for --cd

### Refactor

* completions command

### Documentation

* improve CHANGELOG
* improve CHANGELOG
* remove duplicate PR labels in CHANGELOG

2024.3.9:

### Bug Fixes

* (task) script tasks don't pick up alias from comments

pkgsrc changes:

* Disable self-update

(schmonz)

doc: Updated emulators/nono to 0.7.1

(jun)

0.7.1 (2024/03/28)

m88k(Update): "Set good m88100, m88200 mask version. It makes OpenBSD/luna88k faster 10~20%."
vm(Update): "Change canonical machine name from virt68k to virt-m68k. (vmtype=virt68k can also be used.)"
vm(Update): "Support VirtIO's indirect descriptor."
vm(Update): "Adjust VirtIO Network's queue size."
vm(New): "Implement VirtIO Entropy device."
vm(Fix): "Fix Goldfish timer to raise an interrupt immediately if the specified time is in the past."
vm(Fix): "Fix CRTC accesses on X68030 broken since ver 0.7.0."

(jun)

fixed incorrect username for myself

(ktnb)

updated to use my NetBSD address

(ktnb)

py-semver: Fix PYTHON_VERSIONS_INCOMPATIBLE.

(jperkin)

doc/TODO: add some

+ PageEdit-2.1.0, SDL2-2.30.2, Sigil-2.1.0, libX11-1.8.8 [wait for
  1.8.9], qt6-6.7.

(wiz)

ImageMagick6: make pango optional.

(nia)

doc: Added cross/libdragon-binutils version 2.42

(js)

Add cross/libdragon-binutils

(js)

archivers/xz: Fix download URL

https://github.com/tukaani-project/xz/releases/download/v5.6.1/xz-5.4.6.tar.bz2
is not a valid URL. It's an HTML (probably an error message because GitHub has
suspended the repo), despite it surprisingly returning HTTP 200.

(js)

Updated sysutils/xentools418 to 20231116nb1
Updated sysutils/xentools415 to 4.15.5nb4

(bouyer)

xentools415, xentools418: fix bug in BSD symbol table support for i386:
When computing the size of the ELF symbol table, the code use
sizeof(Elf64_Shdr) or sizeof(Elf32_Shdr) depending on the kernel being
loaded. But later when computing offsets, the code uses
sizeof(struct elf_sym_header) which contains a union of both Shdr. This result
in an overflow of 64 bytes. Fortunably the code checks the size being copied
with the allocated size and silently ignores the copy if there isn't enough
space. Fortunably as well, the allocated size is rounded up to the next page
boundary, so most of the time there is enough space. Unfortunably, the official
i386 GENERIC kernel from the 10.0 release has the right size to trigger
this bug.
Bump PKGREVISION.

(bouyer)

sysutils/libpciaccess: Unbreak DragonFly build

(charlotte)

doc: Updated chat/matrix-synapse to 1.104.0

(js)

Update chat/matrix-synapse to 1.104.0

# Synapse 1.104.0 (2024-04-02)

### Bugfixes

- Fix regression when using OIDC provider. Introduced in v1.104.0rc1. ([\#17031](https://github.com/element-hq/synapse/issues/17031))

# Synapse 1.104.0rc1 (2024-03-26)

### Features

- Add an OIDC config to specify extra parameters for the authorization grant URL. IT can be useful to pass an ACR value for example. ([\#16971](https://github.com/element-hq/synapse/issues/16971))
- Add support for OIDC provider returning JWT. ([\#16972](https://github.com/element-hq/synapse/issues/16972), [\#17031](https://github.com/element-hq/synapse/issues/17031))

### Bugfixes

- Fix a bug which meant that, under certain circumstances, we might never retry sending events or to-device messages over federation after a failure. ([\#16925](https://github.com/element-hq/synapse/issues/16925))
- Fix various long-standing bugs which could cause incorrect state to be returned from `/sync` in certain situations. ([\#16949](https://github.com/element-hq/synapse/issues/16949))
- Fix case in which `m.fully_read` marker would not get updated. Contributed by @SpiritCroc. ([\#16990](https://github.com/element-hq/synapse/issues/16990))
- Fix bug which did not retract a user's pending knocks at rooms when their account was deactivated. Contributed by @hanadi92. ([\#17010](https://github.com/element-hq/synapse/issues/17010))

### Updates to the Docker image

- Updated `start.py` to generate config using the correct user ID when running as root (fixes [\#16824](https://github.com/element-hq/synapse/issues/16824), [\#15202](https://github.com/element-hq/synapse/issues/15202)). ([\#16978](https://github.com/element-hq/synapse/issues/16978))

### Improved Documentation

- Add a query to force a refresh of a remote user's device list to the "Useful SQL for Admins" documentation page. ([\#16892](https://github.com/element-hq/synapse/issues/16892))
- Minor grammatical corrections to the upgrade documentation. ([\#16965](https://github.com/element-hq/synapse/issues/16965))
- Fix the sort order for the documentation version picker, so that newer releases appear above older ones. ([\#16966](https://github.com/element-hq/synapse/issues/16966))
- Remove recommendation for a specific poetry version from contributing guide. ([\#17002](https://github.com/element-hq/synapse/issues/17002))

### Internal Changes

- Improve lock performance when a lot of locks are all waiting for a single lock to be released. ([\#16840](https://github.com/element-hq/synapse/issues/16840))
- Update power level default for public rooms. ([\#16907](https://github.com/element-hq/synapse/issues/16907))
- Improve event validation. ([\#16908](https://github.com/element-hq/synapse/issues/16908))
- Multi-worker-docker-container: disable log buffering. ([\#16919](https://github.com/element-hq/synapse/issues/16919))
- Refactor state delta calculation in `/sync` handler. ([\#16929](https://github.com/element-hq/synapse/issues/16929))
- Clarify docs for some room state functions. ([\#16950](https://github.com/element-hq/synapse/issues/16950))
- Specify IP subnets in canonical form. ([\#16953](https://github.com/element-hq/synapse/issues/16953))
- As done for SAML mapping provider, let's pass the module API to the OIDC one so the mapper can do more logic in its code. ([\#16974](https://github.com/element-hq/synapse/issues/16974))
- Allow containers building on top of Synapse's Complement container is use the included PostgreSQL cluster. ([\#16985](https://github.com/element-hq/synapse/issues/16985))
- Raise poetry-core version cap to 1.9.0. ([\#16986](https://github.com/element-hq/synapse/issues/16986))
- Patch the db conn pool sooner in tests. ([\#17017](https://github.com/element-hq/synapse/issues/17017))

### Updates to locked dependencies

* Bump anyhow from 1.0.80 to 1.0.81. ([\#17009](https://github.com/element-hq/synapse/issues/17009))
* Bump black from 23.10.1 to 24.2.0. ([\#16936](https://github.com/element-hq/synapse/issues/16936))
* Bump cryptography from 41.0.7 to 42.0.5. ([\#16958](https://github.com/element-hq/synapse/issues/16958))
* Bump dawidd6/action-download-artifact from 3.1.1 to 3.1.2. ([\#16960](https://github.com/element-hq/synapse/issues/16960))
* Bump dawidd6/action-download-artifact from 3.1.2 to 3.1.4. ([\#17008](https://github.com/element-hq/synapse/issues/17008))
* Bump jinja2 from 3.1.2 to 3.1.3. ([\#17005](https://github.com/element-hq/synapse/issues/17005))
* Bump log from 0.4.20 to 0.4.21. ([\#16977](https://github.com/element-hq/synapse/issues/16977))
* Bump mypy from 1.5.1 to 1.8.0. ([\#16901](https://github.com/element-hq/synapse/issues/16901))
* Bump netaddr from 0.9.0 to 1.2.1. ([\#17006](https://github.com/element-hq/synapse/issues/17006))
* Bump pydantic from 2.6.0 to 2.6.4. ([\#17004](https://github.com/element-hq/synapse/issues/17004))
* Bump pyo3 from 0.20.2 to 0.20.3. ([\#16962](https://github.com/element-hq/synapse/issues/16962))
* Bump ruff from 0.1.14 to 0.3.2. ([\#16994](https://github.com/element-hq/synapse/issues/16994))
* Bump serde from 1.0.196 to 1.0.197. ([\#16963](https://github.com/element-hq/synapse/issues/16963))
* Bump serde_json from 1.0.113 to 1.0.114. ([\#16961](https://github.com/element-hq/synapse/issues/16961))
* Bump types-jsonschema from 4.21.0.20240118 to 4.21.0.20240311. ([\#17007](https://github.com/element-hq/synapse/issues/17007))
* Bump types-psycopg2 from 2.9.21.16 to 2.9.21.20240311. ([\#16995](https://github.com/element-hq/synapse/issues/16995))
* Bump types-pyopenssl from 23.3.0.0 to 24.0.0.20240311. ([\#17003](https://github.com/element-hq/synapse/issues/17003))

# Synapse 1.103.0 (2024-03-19)

No significant changes since 1.103.0rc1.

# Synapse 1.103.0rc1 (2024-03-12)

### Features

- Add a new [List Accounts v3](https://element-hq.github.io/synapse/v1.103/admin_api/user_admin_api.html#list-accounts-v3) Admin API with improved deactivated user filtering capabilities. ([\#16874](https://github.com/element-hq/synapse/issues/16874))
- Include `Retry-After` header by default per [MSC4041](https://github.com/matrix-org/matrix-spec-proposals/pull/4041). Contributed by @clokep. ([\#16947](https://github.com/element-hq/synapse/issues/16947))

### Bugfixes

- Fix joining remote rooms when a module uses the `on_new_event` callback. This callback may now pass partial state events instead of the full state for remote rooms. Introduced in v1.76.0. ([\#16973](https://github.com/element-hq/synapse/issues/16973))
- Fix performance issue when joining very large rooms that can cause the server to lock up. Introduced in v1.100.0. Contributed by @ggogel. ([\#16968](https://github.com/element-hq/synapse/issues/16968))

### Improved Documentation

- Add HAProxy example for single port operation to reverse proxy documentation. Contributed by Georg Pfuetzenreuter (@tacerus). ([\#16768](https://github.com/element-hq/synapse/issues/16768))
- Improve the documentation around running Complement tests with new configuration parameters. ([\#16946](https://github.com/element-hq/synapse/issues/16946))
- Add docs on upgrading from a very old version. ([\#16951](https://github.com/element-hq/synapse/issues/16951))

### Updates to locked dependencies

* Bump JasonEtco/create-an-issue from 2.9.1 to 2.9.2. ([\#16934](https://github.com/element-hq/synapse/issues/16934))
* Bump anyhow from 1.0.79 to 1.0.80. ([\#16935](https://github.com/element-hq/synapse/issues/16935))
* Bump dawidd6/action-download-artifact from 3.0.0 to 3.1.1. ([\#16933](https://github.com/element-hq/synapse/issues/16933))
* Bump furo from 2023.9.10 to 2024.1.29. ([\#16939](https://github.com/element-hq/synapse/issues/16939))
* Bump pyopenssl from 23.3.0 to 24.0.0. ([\#16937](https://github.com/element-hq/synapse/issues/16937))
* Bump types-netaddr from 0.10.0.20240106 to 1.2.0.20240219. ([\#16938](https://github.com/element-hq/synapse/issues/16938))

(js)

BasiliskII: Allow building without the macosx interface on older releases

(nia)

GraphicsMagick: requires strnlen

(nia)

Updated archivers/zstd, devel/blosc2

(adam)

blosc2: updated to 2.14.0

Changes from 2.13.2 to 2.14.0

Fixed a bug preventing buffers to be appended to empty (0-sized) b2nd arrays.

New acceleration path for b2nd_append(). This new path is much faster (up to 4x) than the previous one, specially for large arrays. See bench/bench_stack_append.c for the bench of use.

New examples for using the b2nd_set_slice_cbuffer() and b2nd_append() functions for adding data into existing b2nd arrays. See examples/example_stack_images.c.

Now, python3 is used for finding plugins instead of python. This is because many linux distros do not have python as a symlink to python3 anymore.

New round of fixing warnings. Now, C-Blosc2 should be relatively free of them.

Small performance tweak for clevel 1 in BloscLZ codec.

Fixed a leak in frame code.

Disable shuffle repeat in filters pipeline. This was broken since the initial implemented, and it was never documented. Also, compression ratios do not seem to be improved in our experiments, so this capability has been removed completely.

Support for new Intel compilers (2023.0.1 and on).

(adam)

zlib-ng: add buildlink3.mk

(adam)

zstd: updated to 1.5.6

V1.5.6 (Mar 2024)
api: Promote `ZSTD_c_targetCBlockSize` to Stable API
api: new `ZSTD_d_maxBlockSize` experimental parameter, to reduce streaming decompression memory,
perf: improve performance of param `ZSTD_c_targetCBlockSize`,
perf: improved compression of arrays of integers at high compression,
lib: reduce binary size with selective built-time exclusion,
lib: improved huffman speed on small data and linux kernel,
lib: accept dictionaries with partial literal tables,
lib: fix CCtx size estimation with external sequence producer,
lib: fix corner case decoder behaviors,
lib: fix zdict prototype mismatch in static_only mode,
lib: fix several bugs in magicless-format decoding,
cli: add common compressed file types to `--exclude-compressed``
cli: fix mixing `-c` and `-o` commands with `--rm`,
cli: fix erroneous exclusion of hidden files with `--output-dir-mirror`
cli: improved time accuracy on BSD,
cli: better errors on argument parsing,
tests: better compatibility with older versions of `grep`,
tests: lorem ipsum generator as default backup content,
build: cmake improvements
build: bazel support,
build: fix cross-compiling for AArch64 with lld
build: fix Apple platform compatibility,
build: fix Visual 2012 and lower compatibility,
build: improve win32 support,
build: better C90 compliance for zlibWrapper,
port: make: fat binaries on macos,
port: ARM64EC compatibility for Windows,
port: QNX support
port: MSYS2 and Cygwin makefile installation and test support,
port: risc-v support validation in CI,
port: sparc64 support validation in CI,
port: AIX compatibility,
port: HP-UX compatibility,
doc: Improved specification accuracy,
bug: Fix and deprecate ZSTD_generateSequences

(adam)

doc: Updated sysutils/rsftch to 0.3.7

(pin)

sysutils/rsftch: update to 0.3.7

- main.rs split for easier maintenance
- fix major bug in distros without /etc/lsb-release
- update fn.rs
- fix broken get_os_release_pretty_name function
- made -t mode more visually appealing
- major visual overhaul
- fix amd gpus not fetching
- re-add -nc option, change some if statements to match for some added speed,
  revamped variable declaration and make uptime more prettier
- add Cargo.lock for pkgsrc

(pin)

doc: Updated net/slumber to 0.16.0

(pin)

Updated www/py-respx, devel/py-urwid

(adam)

net/slumber: update to 0.16.0

[0.16.0] - 2024-04-01
Added
- Add support for custom keybindings (#137)

Fixed
- Fix request body not updating in UI when changing recipe

(pin)

py-urwid: updated to 2.6.10

2.6.10

New features
ScrollBar: fully support __length_hint__ if not Sized

Other Changes
Support PEP424 API as marker for limited size of ListBox body

(adam)

doc: Updated finance/rex to 0.1.16

(pin)

finance/rex: update to 0.1.16

Updates
- All amount fields now recognize 'k' and 'm' number suffixes as a thousand
  and a million allowing usage of 1k, 5m.
- The initial page text layout has been updated.
- The Home page now has two more rows in the Balance section highlighting
  daily income and expense amount.
- Pressing 'v' on a selected transaction/activity will show the full
  transaction details. Useful in case the detail is too large.
- The chart page now has the option to enable/disable TX methods from the
  chart on the 'space' press.
- All popups have been updated and now can be scrolled using the Arrow Up
  or Down keys.
- The Add Transaction page now shows the transaction impact as the fields
  are filled up.
- The number animation system has been improved with reduced/minimal freezing.
- All dependencies and Rust have been updated to the latest version.

Changes
- Recognize number suffix by @TheRustyPickle in #76
- Revamp initial page by @TheRustyPickle in #77
- Add daily income and expense rows by @TheRustyPickle in #79
- Show tx details on V key press by @TheRustyPickle in #81
- Add chart point selection by @TheRustyPickle in #83
- Add scrolling to all popup by @TheRustyPickle in #84
- Fix number suffix crash by @TheRustyPickle in #85
- Show balance change from a tx on add tx page by @TheRustyPickle in #86
- Dependency updates by @TheRustyPickle in #87
- Update version by @TheRustyPickle in #88

(pin)

py-respx: updated to 0.21.1

0.21.1

Fixed

- Fix `files` pattern not handling `str` and `BytesIO`, thanks @pierremonico for input

Added

- Add support for `None` values in `data` pattern, thanks @slingshotvfx for issue

(adam)

Updated devel/py-build, net/py-apache-libcloud

(adam)

py-apache-libcloud: updated to 3.8.0

Changes in Apache Libcloud 3.8.0
--------------------------------

Compute
~~~~~~~

- Remove obsolete compute driver where the provider is either dead or not
  offering those services anymore: Bluebox, bsnlcloud, Cloudwatt, Enomaly,
  ElasticHosts, ElasticStack, GoGrid, Gridspot, HostVirtual, Joyent, Med-1,
  Nephoscale, 1on1, ProfitBricks, ServerLove, SkaliCloud, Softlayer, Voxel.

- [Outscale] Fix ``list_nodes()`` and ``list_volumes()`` method.

- [Azure ARM] Implement pagination in the ``list_nodes()`` method. This fixes a
  bug which would result in sometimes not all the nodes being returned.

- [Azure ARM] Implement pagination in the ``list_volumes()`` method. This fixes a
  bug which would result in sometimes not all the volumes nodes being returned.

- [Azure ARM] Bump DISK_API_VERSION from ``2018-06-01`` to ``2023-01-02`` to
  support premium v2 SSDs.

- [AWS EC2] Add support for the following new arguments to the
  ``ex_register_image()`` method:
  * ``boot_mode`` - control bios vs uefi boot
  * ``tpm_support`` - enable a tpm
  * ``uefi_data`` - provide NV UEFI vars
  * ``imds_support`` - require IMDSv2.

Storage
~~~~~~~

- Optimize ``read_in_chunks()`` function implementation.

  This should result in large performance speedups and lower memory usage when
  uploading or downloading a large file with a mismatching chunk size.

  Keep in mind that this only affects code paths where the function is called
  with ``fill_size=True`` argument (such as in the S3 driver, etc).

- [Aliyun OSS] Fix ``upload_object()`` function.

- [S3] Support all available storage classes. Previously only "standard" and
  "reduced_redundancy" were supported.

- [CloudFiles] Fix ``get_endpoint_url()`` throwing an exception when being used
  with ``use_internal_url=True`` argument.

- [CloudFiles] Update OpenStack connection handling code to only re-connect in
  case connection details (scheme, host, port) have changed.

  This should result in significant performance improvements when downloading
  objects since the underlying HTTP connection will be properly re-used.

- [Backblaze B2] Fix a bug which would result in an exception when passing
  ``extra={"meta_data": {}}`` argument to the ``upload_object()`` method.

Other
~~~~~

- Move Python tooling (pytest, bandit, pylint, mypy, coverage) config options
  from separate config files into single pyproject.yaml config files.

  NOTE: This change only affects development process and nothing else.

- Fix minor typos in the code using codespell package and enforce this check as
  part of our GHA CI system.

- Indicate we also support Python 3.12 (beta).

- Remove unused ``libcloud.security.SSL_VERSION`` constant / module level
  variable. This variable has been unused and had no affect on the behavior
  since we switched to the ``requests`` library for making HTTP(s) requests in
  2016.

- Packaging related metadata has been migrated from ``setup.py`` to
  ``pyproject.yaml`` file.

- Deprecated and unsafe ``setup.py test`` convenience alias for running tests
  using pytest has been removed in favor of running pytest directly.

- Script for building release artifacts has been updated to utilize ``build``
  Python package to build release artifacts (sdist + wheel) in an isolated
  environment.

(adam)

py-build: updated to 1.2.1

1.2.1 (2024-03-28)

- Avoid error when terminal width is undetectable on Python < 3.11

1.2.0 (2024-03-27)

- Add ``--installer`` option, supporting ``pip`` and ``uv``. Added ``uv``
  extra.
- Improve console output and provide ``-v`` for dependency installation
- Avoid compiling unused bytecode when using ``pip``
- Dropped support for Python 3.7

(adam)

doc: Added lang/oorexx version 5.0.0

(rhialto)

lang/oorexx: added, version 5.0.0-12583.

(rhialto)

Updated devel/py-flexmock, devel/py-jaraco.classes, databases/py-mongo, net/py-unearth

(adam)

py-unearth: updated to 0.15.1

0.15.1
Bug Fixes
Close local files after read

(adam)

doc: Updated print/xpdf4 to 4.05

(rhialto)

Lots of changes (given in source in CHANGES at the end) including several PDF
object loops (CVE-2018-7453, CVE-2018-16369, CVE-2022-36561, CVE-2022-41844,
CVE-2023-2663, CVE-2023-2664), a deadlock and an integer overflow.

(rhialto)

py-mongo: updated to 4.6.3

4.6.3
Unknown changes

(adam)

py-jaraco.classes: updated to 3.4.0

v3.4.0

Features

- Better type hints for NonDataProperty.

(adam)

py-flexmock: updated to 0.12.1

Release 0.12.1

Fixed

- Flexmock Pytest plugin entrypoint missing from `setup.py`.

Release 0.12.0

Added

- Add Python 3.12 and 3.13 support.

Changed

- Add tox.ini to sdist to make the downstream testing easier.

Removed

- Drop Python 3.6 and 3.7 support.
- Drop Pytest 5.x support.

Fixed

- Fixed the pytest integration by switching from wrapping of the test runner to
the pytest plugin system.

(adam)

Updated databases/py-sqlalchemy, databases/py-sqlalchemy-utils

(adam)

py-sqlalchemy-utils: updated to 0.41.2

0.41.2 (2024-03-22)

- Fix breaking change introduced on SQLAlchemy 2.0.22 changes to `attributes.AttributeImpl` constructor

(adam)

py-sqlalchemy: updated to 2.0.29

2.0.29

Released: March 23, 2024
orm

[orm] [usecase]

Added support for the PEP 695 TypeAliasType construct as well as the python 3.12 native type keyword to work with ORM Annotated Declarative form when using these constructs to link to a PEP 593 Annotated container, allowing the resolution of the Annotated to proceed when these constructs are used in a Mapped typing container.

[orm] [bug]

Fixed Declarative issue where typing a relationship using Relationship rather than Mapped would inadvertently pull in the 窶彭ynamic窶� relationship loader strategy for that attribute.

[orm] [bug]

Fixed issue in ORM annotated declarative where using mapped_column() with an mapped_column.index or mapped_column.unique setting of False would be overridden by an incoming Annotated element that featured that parameter set to True, even though the immediate mapped_column() element is more specific and should take precedence. The logic to reconcile the booleans has been enhanced to accommodate a local value of False as still taking precedence over an incoming True value from the annotated element.

[orm] [bug] [regression]

Fixed regression from version 2.0.28 caused by the fix for 11085 where the newer method of adjusting post-cache bound parameter values would interefere with the implementation for the subqueryload() loader option, which has some more legacy patterns in use internally, when the additional loader criteria feature were used with this loader option.

engine

[engine] [bug]

Fixed issue in 窶廬nsert Many Values窶� Behavior for INSERT statements feature where using a primary key column with an 窶彿nline execute窶� default generator such as an explicit Sequence with an explcit schema name, while at the same time using the Connection.execution_options.schema_translate_map feature would fail to render the sequence or the parameters properly, leading to errors.

[engine] [bug]

Made a change to the adjustment made in version 2.0.10 for 9618, which added the behavior of reconciling RETURNING rows from a bulk INSERT to the parameters that were passed to it. This behavior included a comparison of already-DB-converted bound parameter values against returned row values that was not always 窶徭ymmetrical窶� for SQL column types such as UUIDs, depending on specifics of how different DBAPIs receive such values versus how they return them, necessitating the need for additional 窶徭entinel value resolver窶� methods on these column types. Unfortunately this broke third party column types such as UUID/GUID types in libraries like SQLModel which did not implement this special method, raising an error 窶廚an窶冲 match sentinel values in result set to parameter sets窶�. Rather than attempt to further explain and document this implementation detail of the 窶彿nsertmanyvalues窶� feature including a public version of the new method, the approach is intead revised to
no longer need this extra conversion step, and the logic that does the comparison now works on the pre-converted bound parameter value compared to the post-result-processed value, which should always be of a matching datatype. In the unusual case that a custom SQL column type that also happens to be used in a 窶徭entinel窶� column for bulk INSERT is not receiving and returning the same value type, the 窶廚an窶冲 match窶� error will be raised, however the mitigation is straightforward in that the same Python datatype should be passed as that returned.

sql

[sql] [bug] [regression]

Fixed regression from the 1.4 series where the refactor of the TypeEngine.with_variant() method introduced at 窶忤ith_variant()窶� clones the original TypeEngine rather than changing the type failed to accommodate for the .copy() method, which will lose the variant mappings that are set up. This becomes an issue for the very specific case of a 窶徭chema窶� type, which includes types such as Enum and ARRAY, when they are then used in the context of an ORM Declarative mapping with mixins where copying of types comes into play. The variant mapping is now copied as well.

typing

[typing] [bug]

Fixed typing issue allowing asyncio run_sync() methods to correctly type the parameters according to the callable that was passed, making use of PEP 612 ParamSpec variables. Pull request courtesy Francisco R. Del Roio.

postgresql

[postgresql] [usecase]

The PostgreSQL dialect now returns DOMAIN instances when reflecting a column that has a domain as type. Previously, the domain data type was returned instead. As part of this change, the domain reflection was improved to also return the collation of the text types. Pull request courtesy of Thomas Stephenson.

tests

[tests] [bug]

Backported to SQLAlchemy 2.0 an improvement to the test suite with regards to how asyncio related tests are run, now using the newer Python 3.11 asyncio.Runner or a backported equivalent, rather than relying on the previous implementation based on asyncio.get_running_loop(). This should hopefully prevent issues with large suite runs on CPU loaded hardware where the event loop seems to become corrupted, leading to cascading failures.

(adam)

doc: Updated lang/rexx-regina to 3.9.5

(rhialto)

lang/rexx-regina: update to 3.9.5

Changes since 3.0.1 (2002-2022) are too many to list but are given in the
source archive: README.31 ... README.395.

(rhialto)

doc: Updated shells/fish to 3.7.1

(ktnb)

doc: Updated textproc/uncrustify to 0.78.1

(ktnb)

Updated security/py-asn1, security/py-asn1-modules, devel/py-frozendict, devel/py-filelock

(adam)

py-filelock: updated to 3.13.3

3.13.3
Make singleton class instance dict unique per subclass

3.13.2
Fixed small typo in _unix.py
Update SECURITY.md to reflect Python 3.7 support dropoff
Update index.rst to improve the demo usage
[BugFix] fix permission denied error when lock file is placed in /tmp

(adam)

py-frozendict: updated to 2.4.1

frozendict v2.4.1

In deepfreeze, prefer registered conversions
Some little fixing to typing
Documentation typo

(adam)

py-asn1-modules: updated to 0.4.0

Revision 0.4.0, released 26-03-2024

- Added support for Python 3.11, 3.12
- Removed support for EOL Pythons 2.7, 3.6, 3.7

(adam)

py-asn1: updated to 0.6.0

Revision 0.6.0, released 26-03-2024

- Added support for previously missing `RELATIVE-OID` construct
- Updated link to Layman's Guide
  Now it provides a link to links to a formatted PDF version of the paper,
  at a stable domain (researchgate), using https
- Removed support for EOL Python 2.7, 3.6, 3.7

(adam)

Updated devel/py-pyobjc, devel/cmake

(adam)

cmake: updated to 3.29.0

CMake 3.29 Release Notes
************************

Changes made since CMake 3.28 include the following.

New Features
============

Command-Line
------------

* "cmake(1)" "-E cat" can now print the standard input by passing the
  "-" argument.

Generators
----------

* Visual Studio Generators now support selecting between the Intel
  oneAPI Fortran compiler ("ifx") and the Intel classic Fortran
  compiler ("ifort") using a "fortran=" field in
  "CMAKE_GENERATOR_TOOLSET".

File-Based API
--------------

* The "cmake-file-api(7)" "codemodel" version 2 "version" field has
  been updated to 2.7.

* The "cmake-file-api(7)" "codemodel" version 2 "target" object gained
  a new "launchers" field.

Compilers
---------

* The LLVM/Clang GNU-like frontend on Windows ("clang++") may now be
  used to compile "CUDA" language sources.

* Compilers targeting the GNU ABI on Windows (MinGW) may now be used
  to compile Objective C ("OBJC") and Objective C++ ("OBJCXX").  These
  include GNU compilers ("gcc" and "g++") and the LLVM/Clang GNU-like
  frontends ("clang" and "clang++").

* TI Clang-based compilers are now supported with compiler id
  "TIClang".

Commands
--------

* The add_custom_command(TARGET) signature now supports adding build
  events through Alias Targets.

* The "cmake_language(EXIT)" sub-command was added to terminate "cmake
  -P" scripts with a specified exit code.

* The "export(SETUP)" sub-command was added to configure export sets.
  Its "TARGET" option's "XCFRAMEWORK_LOCATION" setting specifies the
  location of a ".xcframework" that can be substituted for an
  installed target.

* The "if()" command gained new tests "IS_READABLE", "IS_WRITABLE" and
  "IS_EXECUTABLE" to check file or directory permissions.

Variables
---------

* The "CMAKE_INSTALL_PREFIX" environment variable was added to provide
  a default value for the "CMAKE_INSTALL_PREFIX" variable.

* The "CMAKE_LINKER_TYPE" variable and corresponding "LINKER_TYPE"
  target property were added to specify what linker to use with some
  toolchains.

* The "CMAKE_<LANG>_COMPILER_LINKER",
  "CMAKE_<LANG>_COMPILER_LINKER_ID",
  "CMAKE_<LANG>_COMPILER_LINKER_VERSION" and
  "CMAKE_<LANG>_COMPILER_LINKER_FRONTEND_VARIANT" variables were added
  to describe the linker used by the language's link step.

* The "CMAKE_PROJECT_INCLUDE", "CMAKE_PROJECT_INCLUDE_BEFORE",
  "CMAKE_PROJECT_<PROJECT-NAME>_INCLUDE", and "CMAKE_PROJECT_<PROJECT-
  NAME>_INCLUDE_BEFORE" variables learned to support a semicolon-
  separated list of CMake language files to be included sequentially.
  These variables can also reference module names to be found in
  "CMAKE_MODULE_PATH" or builtin to CMake.

* The "CMAKE_SKIP_TEST_ALL_DEPENDENCY" variable was added to control
  whether the "test" (or "RUN_TESTS") buildsystem target depends on
  the "all" (or "ALL_BUILD") target.

* A "CMAKE_TEST_LAUNCHER" variable and corresponding "TEST_LAUNCHER"
  target property were added to specify a launcher to be used by
  executable targets when invoked by tests added by the "add_test()"
  command.

Properties
----------

* The "CROSSCOMPILING_EMULATOR" target property now supports
  "generator expressions".

* The "UNITY_BUILD" target property now supports the Objective C
  ("OBJC") and Objective C++ ("OBJCXX") languages.

* The "XCODE_EMBED_XPC_SERVICES" target property was added to tell the
  "Xcode" generator what targets to put in the "Embed XPC Resources"
  build phase.

Modules
-------

* The "CMakePackageConfigHelpers" module gained new
  "generate_apple_platform_selection_file()" and
  "generate_apple_architecture_selection_file()" functions, which can
  be used to generate a file that includes another Apple-platform-
  specific file or the includes an architecture-specific
  implementation of a package for an Apple platform, respectively.

* The "FindOpenGL" module learned to find a GLU include directory
  different than the GL include directory.  A new
  "OPENGL_INCLUDE_DIRS" result variable provides all include
  directories.

CTest
-----

* "ctest(1)" gained a "--http-header" option to add custom headers on
  submission to CDash.

* "ctest(1)" gained the "--tests-from-file" and "--exclude-from-file"
  options to run or exclude tests named in a file.

* "ctest(1)" now supports job server integration on POSIX systems.

* The "ctest -j" option may now be given without a value to let ctest
  choose a default level of parallelism, or with "0" to let ctest use
  unbounded parallelism.  The corresponding "CTEST_PARALLEL_LEVEL"
  environment variable, if set to the empty string, is now equivalent
  to passing "-j" with no value.

* The "ctest_test()" command gained options "INCLUDE_FROM_FILE" and
  "EXCLUDE_FROM_FILE" to run or exclude tests named in a file.

CPack
-----

* The "CPack DEB Generator" "CPACK_DEBIAN_FILE_NAME" variable may now
  be set without any suffix, and the ".deb" suffix will be added
  automatically.

* The "CPack RPM Generator" "CPACK_RPM_FILE_NAME" variable may now be
  set without any suffix, and the ".rpm" suffix will be added
  automatically.

* The "CPack WIX Generator" gained a new variable,
  "CPACK_WIX_INSTALL_SCOPE", to control the "InstallScope" property of
  WiX MSI installers.

Other Changes
=============

* CMake learned to de-duplicate libraries on link lines based on
  linker capabilities.  See policy "CMP0156".

* The "add_test()" command now honors "CMAKE_CROSSCOMPILING_EMULATOR"
  only when cross-compiling. See policy "CMP0158".

* On Windows, when targeting the MSVC ABI, the "find_library()"
  command now accepts ".a" file names after first considering ".lib".
  This is symmetric with existing behavior when targeting the GNU ABI,
  in which the command accepts ".lib" file names after first
  considering ".a".

* On Windows, when targeting the MSVC ABI, the "find_library()"
  command now considers ".dll.lib" file names before ".lib".  This is
  the default suffix for DLL import libraries created by Rust
  toolchains for the MSVC ABI.

* The "Ninja" and "NMake Makefiles" generators now use the
  "-external:I" flag for system includes when using IntelLLVM as of
  version 2021.4. The "-external:W0" flag is also used as of version
  2022.2.

* The "create_test_sourcelist()" command now provides a full path to
  the generated driver source file.

* The "CPACK_PRODUCTBUILD_DOMAINS" variable now defaults to true. See
  policy "CMP0161".

* The "CPack WIX Generator" now produces WiX MSI installers that
  create start menu and uninstall entries for all users by default, as
  documented by the "CPACK_WIX_INSTALL_SCOPE" variable "perMachine"
  value.  Previously, without a custom WiX template, it produced
  installers that would only create start menu and uninstall entries
  for the current user, even though they install for all users.

(adam)

uncrustify: update to 0.78.1

0.78.0 -> 0.78.1:
Improve line splitting logic to avoid awkward splits

0.77.1 -> 0.78.0:
Added:
  - align_nl_cont_spaces
  - sp_after_bit_colon
  - sp_before_bit_colon
  - sp_between_ptr_ref
  - nl_min_after_func_body
  - sp_before_keyword_ptr_star
  - sp_before_global_scope_ptr_star
  - sp_before_scope_ptr_star
  - sp_before_operator_ptr_star
  - sp_before_qualifier_ptr_star
  - debug_use_the_exit_function_pop
  - nl_max_after_func_body
  - sp_cpp_lambda_argument_list_empty
  - align_func_proto_span_ignore_cont_lines
Removed:
  - sp_before_keyword_ptr_star

0.77.0 -> 0.77.1:
No information provided.

0.76.0 -> 0.77.0:
Added:
  - sp_cmt_cpp_pvs
  - sp_inside_rparen
  - sp_func_call_user_inside_rparen
  - sp_inside_rparens
  - sp_cmt_cpp_lint
  - sp_qualifier_ptr_star_trailing
  - sp_qualifier_unnamed_ptr_star
  - sp_qualifier_ptr_star_func
  - mod_add_force_c_closebrace_comment

https://github.com/uncrustify/uncrustify/blob/uncrustify-0.78.1/ChangeLog

(ktnb)

py-pyobjc*: updated to 10.2

Version 10.2
Fix a number of warnings found by adding -Wpendantic to the CFLAGS for pyobjc-core

Fix undefined behaviour warnings:

Suppress the undefined behaviour warning about out of range values in double to (unsigned) long long in the OC_PythonNumber implementation as these are unavoidable when matching NSNumber behaviour.
Switch to using memcpy instead of direct assignment in converting plain C values to/from Python because “packed” structs might result in accessing values through unaligned pointers.
Updated bindings for the macOS 14.4 SDK (Xcode 15.3)

Added bindings for the “BrowserEngineKit” framework on macOS 14.4 or later.

Add obj.registerPathType() to register a Python type as a path like type with PyObjC. By default only pathlib.Path is registered as such.

A minor backward compatibility issue is that instances of the registered types will be written to NSArchive and NSKeyArchive archives as instances of NSURL and won’t roundtrip back to the original Python type. This might change in future versions of PyObjC, at least for pathlib.Path.

Instances of pathlib.Path (and other types registered with objc.registerPathType) are bridged into Objective-C as instances of NSURL.

This means that these types can be used as values passed to APIs expecting a filesystem URL, e.g.:

```python

path = pathlib.Path(“/Applications/Numbers.app”) bundle = NSBundle.bundleWithURL_(path) ```

Fix some warnings in pyobjc-core when testing with Python 3.13a4.

Add support for NSBezierPathElementQuadraticCurveTo in NSBezierPath.elementAtIndex_associatedPoints_.

Fix compilation error in pyobjc-framework-Cocoa with a recent deployment target.

(adam)

shells/fish: update to 3.7.1

- Deleting the last history entry via history delete works again
- Wildcards (*) will no longer sometimes generate paths that did not
  exist
- Fixed crash when trying to run an ELF program with a missing interpreter
- funced will now always source the file after it has written it,
  even if the contents did not change.
- Added completions for: cobra-cli, dmidecode, mycli, ollama, pstree
- Some improvements to documentation and completions.

(ktnb)

go122: Implement syscall.Mkfifo() on illumos.

(jperkin)

go-bin: pkglint autofix.

(jperkin)

go-bin: Update the illumos bootstrap kit.

(jperkin)

go121: Implement syscall.Mkfifo() on illumos.

(jperkin)

Updated databases/p5-DBD-MariaDB to 1.23

(wen)

Update to 1.23

Upstream changes:
1.23 2023-09-10
- Add a missing break
  (https://github.com/perl5-dbi/DBD-MariaDB/issues/163)
- Signal error if mariadb_db_async_result() fails
  (https://github.com/perl5-dbi/DBD-MariaDB/issues/162)
- Update links to project website, issues and years
- Fix compilation with some MariaDB client library 10.2 and 10.3 versions
- Fix mariadb_use_result attribute
  (https://github.com/perl5-dbi/DBD-MariaDB/issues/173)
- Fix statements with multiple result sets in asynchronous mode
- Fix mariadb_sockfd attribute for Windows
- Croaks when changing AutoCommit attribute fails
  (https://github.com/perl5-dbi/dbi/issues/104)
- Various documentation and tests fixes
- Fix support for MariaDB Connector/C prior to 3.1.3 version
- Fix usage of Win32::GetShortPathName() in Makefile.PL
- Build release tarball in TAR format (instead of PAX)
- Allow to query and change mariadb_multi_statements attribute
- Add connect option mariadb_auth_plugin for specifying auth plugin
- Fix support for MySQL 8.0+ client library
  (https://github.com/perl5-dbi/DBD-MariaDB/issues/191)
  (https://github.com/perl5-dbi/DBD-mysql/issues/329)
- Add Github Actions CI and Cirrus CI (FreeBSD) for automated testing

1.22 2022-04-22
- Disable usage of libmysqld.a from MySQL 8.x series
- Install README.pod into DBD/MariaDB/ subdirectory
  (https://github.com/perl5-dbi/DBD-MariaDB/issues/146)
- Do not export driver private C functions
- Fix typo in error message
- Fix compatibility with new MariaDB client and server versions
  (https://github.com/perl5-dbi/DBD-MariaDB/issues/164)
  (https://github.com/perl5-dbi/DBD-MariaDB/issues/167)
  (https://github.com/perl5-dbi/DBD-mysql/issues/333)

(wen)

Updated sysutils/ansible-core, sysutils/ansible, graphics/py-Pillow, devel/py-cython

(adam)

py-cython: updated to 3.0.10

3.0.10 (2024-03-30)
===================

Bugs fixed
----------

* Cython generated incorrect self-casts when directly calling final methods of subtypes.
  Patch by Lisandro Dalcin.  (Github issue :issue:`2747`)

* Internal C names generated from C function signatures could become too long for MSVC.
  (Github issue :issue:`6052`)

* The ``noexcept`` warnings could be misleading in some cases.
  Patch by Gonzalo Tornar鱈a.  (Github issue :issue:`6087`)

* The ``@cython.ufunc`` implementation could generate incomplete C code.
  (Github issue :issue:`6064`)

* The ``libcpp.complex`` declarations could result in incorrect C++ code.
  Patch by Raffi Enficiaud.  (Github issue :issue:`6037`)

* Several tests were adapted to work with both NumPy 1.x and 2.0.
  Patch by Matti Picus.  (Github issues :issue:`6076`, :issue:`6100`)

* C compiler warnings when the freelist implementation is disabled (e.g. on PyPy) were fixed.
  It can now be disabled explicitly with the C macro guard ``CYTHON_USE_FREELISTS=0``.
  (Github issue :issue:`6099`)

* Some C macro guards for feature flags were missing from the NOGIL Python configuration.

* Some recently added builtins were unconditionally looked up at module import time
  (if used by user code) that weren't available on all Python versions and could thus
  fail the import.

* A performance hint regarding exported pxd declarations was improved.
  (Github issue :issue:`6001`)

(adam)

py-Pillow: updated to 10.3.0

10.3.0 (2024-04-01)

- CVE-2024-28219: Use ``strncpy`` to avoid buffer overflow
- Deprecate ``eval()``, replacing it with ``lambda_eval()`` and ``unsafe_eval()``
- Raise ``ValueError`` if seeking to greater than offset-sized integer in TIFF
- Add ``--report`` argument to ``__main__.py`` to omit supported formats
- Added RGB to I;16, I;16L, I;16B and I;16N conversion
- Fix editable installation with custom build backend and configuration options
- Fix putdata() for I;16N on big-endian
- Determine MPO size from markers, not EXIF data
- Improved conversion from RGB to RGBa, LA and La
- Support FITS images with GZIP_1 compression
- Use I;16 mode for 9-bit JPEG 2000 images
- Raise ValueError if kmeans is negative
- Remove TIFF tag OSUBFILETYPE when saving using libtiff
- Raise ValueError for negative values when loading P1-P3 PPM images
- Added reading of JPEG2000 palettes
- Added alpha_quality argument when saving WebP images
- Fixed joined corners for ImageDraw rounded_rectangle() non-integer dimensions
- Stop reading EPS image at EOF marker
- PSD layer co-ordinates may be negative
- Use subprocess with CREATE_NO_WINDOW flag in ImageShow WindowsViewer
- When saving GIF frame that restores to background color, do not fill identical pixels
- Fixed reading PNG iCCP compression method
- Allow writing IFDRational to UNDEFINED tag
- Fix logged tag name when loading Exif data
- Use maximum frame size in IHDR chunk when saving APNG images
- Prevent opening P TGA images without a palette
- Use palette when loading ICO images
- Use consistent arguments for load_read and load_seek
- Turn off nullability warnings for macOS SDK
- Fix shift-sign issue in Convert.c
- Open 16-bit grayscale PNGs as I;16
- Handle truncated chunks at the end of PNG images
- Match mask size to pasted image size in GifImagePlugin
- Release GIL while calling ``WebPAnimDecoderGetNext``
- Fixed reading FLI/FLC images with a prefix chunk
- Update wl-paste handling and return None for some errors in grabclipboard() on Linux
- Remove execute bit from ``setup.py``
- Do not support using test-image-results to upload images after test failures
- Changed ImageMath.ops to be static
- Fix APNG info after seeking backwards more than twice
- Deprecate ImageCms constants and versions() function
- Added PerspectiveTransform
- Add support for reading and writing grayscale PFM images
- Add LCMS2 flags to ImageCms
- Rename x64 to AMD64 in winbuild

(adam)

ansible: updated to 9.4.0

9.4.0

Minor changes

(adam)

ansible-core: updated to 2.16.5

v2.16.5
=======

Minor Changes
-------------

- ansible-test - Add a work-around for permission denied errors when using ``pytest >= 8`` on multi-user systems with an installed version of ``ansible-test``.

Bugfixes
--------

- Fix an issue when setting a plugin name from an unsafe source resulted in ``ValueError: unmarshallable object`` (https://github.com/ansible/ansible/issues/82708)
- Harden python templates for respawn and ansiballz around str literal quoting
- ansible-test - The ``libexpat`` package is automatically upgraded during remote bootstrapping to maintain compatibility with newer Python packages.
- template - Fix error when templating an unsafe string which corresponds to an invalid type in Python (https://github.com/ansible/ansible/issues/82600).
- winrm - does not hang when attempting to get process output when stdin write failed

(adam)

security/p11-kit: Add DragonFly support

(charlotte)

textproc/the_silver_searcher: Lint.

(charlotte)

Updated time/p5-Calendar-Simple to 2.0.3

(wen)

Update to 2.0.3

Upstream changes:
## [2.0.3] 2023-08-01

### Added

- Improvements to `pcal`

## [2.0.2] 2023-07-27

### Fixed

- Regenerated package so it includes repo and bugtracker info

(wen)

devel/fossil: Add option to disable OpenSSL

This is useful for QNX, as OpenSSL dropped QNX support in OpenSSL 3.

(js)

Updated www/p5-URI to 5.28

(wen)

Update to 5.28

Upstream changes:
5.28      2024-03-27 01:49:44Z
    - Using Scalar::Util::reftype instead of just ref(), but mindful this time
      about definedness to avoid warnings (GH#140) (Jacques Deguest)

(wen)

devel/glib2: Unbreak DragonFly build

The need for `environ` to be a weak symbol is true for DragonFly, too --
not just FreeBSD.

(charlotte)

bootstrap: Confirm pkgsrc's status on DragonFly

(charlotte)

lang/python312: Add DragonFly support

(charlotte)

lang/python311: Add DragonFly support

(charlotte)

doc: Added devel/py-semver version 3.0.2

(wiz)

devel/Makefile: + py-semver

(wiz)

devel/py-semver: import py-semver-3.0.2

Packaged by K.I.A.Derouiche, khorben@ and myself for wip.

Python helper for Semantic Versioning (http://semver.org/)

(wiz)