doc: Updated databases/py-sqlalchemy-i18n to 1.1.0

(wiz)

py-SQLAlchemy-i18n: update to 1.1.0.

1.1.0 (2021-05-23)
^^^^^^^^^^^^^^^^^^

- Added SA 1.4 support
- Drop py27, py33, py34, py35 support

(wiz)

doc: Updated databases/py-alembic to 1.13.1

(wiz)

py-alembic: update to 1.13.1.

.. changelog::
    :version: 1.13.1
    :released: December 20, 2023

    .. change::
        :tags: bug, autogenerate
        :tickets: 1337

        Fixed :class:`.Rewriter` so that more than two instances could be chained
        together correctly, also allowing multiple ``process_revision_directives``
        callables to be chained.  Pull request courtesy zrotceh.

    .. change::
        :tags: bug, environment
        :tickets: 1369

        Fixed issue where the method :meth:`.EnvironmentContext.get_x_argument`
        using the :paramref:`.EnvironmentContext.get_x_argument.as_dictionary`
        parameter would fail if an argument key were passed on the command line as
        a name alone, that is, without an equal sign ``=`` or a value. Behavior is
        repaired where this condition is detected and will return a blank string
        for the given key, consistent with the behavior where the ``=`` sign is
        present and no value.  Pull request courtesy Iuri de Silvio.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1370

        Fixed issue where the "unique" flag of an ``Index`` would not be maintained
        when generating downgrade migrations.  Pull request courtesy Iuri de
        Silvio.

    .. change::
        :tags: bug, versioning
        :tickets: 1373

        Fixed bug in versioning model where a downgrade across a revision with two
        down revisions with one down revision depending on the other, would produce
        an erroneous state in the alembic_version table, making upgrades impossible
        without manually repairing the table.  Thanks much to Saif Hakim for
        the great work on this.

    .. change::
        :tags: bug, typing
        :tickets: 1377

        Updated pep-484 typing to pass mypy "strict" mode, however including
        per-module qualifications for specific typing elements not yet complete.
        This allows us to catch specific typing issues that have been ongoing
        such as import symbols not properly exported.

.. changelog::
    :version: 1.13.0
    :released: December 1, 2023

    .. change::
        :tags: bug, commands
        :tickets: 1234

        Fixed issue where the ``alembic check`` command did not function correctly
        with upgrade structures that have multiple, top-level elements, as are
        generated from the "multi-env" environment template.  Pull request courtesy
        Neil Williams.

    .. change::
        :tags: usecase, operations
        :tickets: 1323

        Updated logic introduced in :ticket:`151` to allow ``if_exists`` and
        ``if_not_exists`` on index operations also on SQLAlchemy
        1.4 series. Previously this feature was mistakenly requiring
        the 2.0 series.

    .. change::
        :tags: usecase
        :tickets: 1339

        Replaced ``python-dateutil`` with the standard library module
        `zoneinfo <https://docs.python.org/3.11/library/zoneinfo.html#module-zoneinfo>`_.
        This module was added in Python 3.9, so previous version will been
        to install the backport of it, available by installing the ``backports.zoneinfo``
        library. The ``alembic[tz]`` option has been updated accordingly.

    .. change::
        :tags: installation, changed
        :tickets: 1359

        Alembic 1.13 now supports Python 3.8 and above.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1361

        Fixed autogenerate issue where ``create_table_comment()`` and
        ``drop_table_comment()`` rendering in a batch table modify would include
        the "table" and "schema" arguments, which are not accepted in batch as
        these are already part of the top level block.

    .. change::
        :tags: bug, postgresql
        :tickets: 1321, 1327, 1356

        Additional fixes to PostgreSQL expression index compare feature.
        The compare now correctly accommodates casts and differences in
        spacing.
        Added detection logic for operation clauses inside the expression,
        skipping the compare of these expressions.
        To accommodate these changes the logic for the comparison of the
        indexes and unique constraints was moved to the dialect
        implementation, allowing greater flexibility.

.. changelog::
    :version: 1.12.1
    :released: October 26, 2023

    .. change::
        :tags: bug, autogenerate, regression
        :tickets: 1329

        Fixed regression caused by :ticket:`879` released in 1.7.0 where the
        ".info" dictionary of ``Table`` would not render in autogenerate create
        table statements.  This can be useful for custom create table DDL rendering
        schemes so it is restored.

    .. change::
        :tags: bug, typing
        :tickets: 1325

        Improved typing in the
        :paramref:`.EnvironmentContext.configure.process_revision_directives`
        callable to better indicate that the passed-in type is
        :class:`.MigrationScript`, not the :class:`.MigrationOperation` base class,
        and added typing to the example at :ref:`cookbook_no_empty_migrations` to
        illustrate.

    .. change::
        :tags: bug, operations
        :tickets: 1335

        Repaired :class:`.ExecuteSQLOp` so that it can participate in "diff"
        operations; while this object is typically not present in a reflected
        operation stream, custom hooks may be adding this construct where it needs
        to have the correct ``to_diff_tuple()`` method.  Pull request courtesy
        Sebastian Bayer.

    .. change::
        :tags: typing, bug
        :tickets: 1058, 1277

        Improved the ``op.execute()`` method to correctly accept the
        ``Executable`` type that is the same which is used in SQLAlchemy
        ``Connection.execute()``.  Pull request courtesy Mihail Milushev.

    .. change::
        :tags: typing, bug
        :tickets: 930

        Improve typing of the revision parameter in various command functions.

    .. change::
        :tags: typing, bug
        :tickets: 1266

        Properly type the :paramref:`.Operations.create_check_constraint.condition`
        parameter of :meth:`.Operations.create_check_constraint` to accept boolean
        expressions.

    .. change::
        :tags: bug, postgresql
        :tickets: 1322

        Fixed autogen render issue where expressions inside of indexes for PG need
        to be double-parenthesized, meaning a single parens must be present within
        the generated ``text()`` construct.

    .. change::
        :tags: usecase
        :tickets: 1304

        Alembic now accommodates for Sequence and Identity that support dialect kwargs.
        This is a change that will be added to SQLAlchemy v2.1.

.. changelog::
    :version: 1.12.0
    :released: August 31, 2023

    .. change::
        :tags: bug, operations
        :tickets: 1300

        Added support for ``op.drop_constraint()`` to support PostgreSQL
        ``ExcludeConstraint`` objects, as well as other constraint-like objects
        that may be present in third party dialects, by resolving the ``type_``
        parameter to be ``None`` for this case.  Autogenerate has also been
        enhanced to exclude the ``type_`` parameter from rendering within this
        command when  ``type_`` is ``None``.  Pull request courtesy David Hills.

    .. change::
        :tags: bug, commands
        :tickets: 1299

        Fixed issue where the ``revision_environment`` directive in ``alembic.ini``
        was ignored by the ``alembic merge`` command, leading to issues when other
        configurational elements depend upon ``env.py`` being invoked within the
        command.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1302

        Fixed issue where the ``ForeignKeyConstraint.match`` parameter would not be
        rendered in autogenerated migrations.  Pull request courtesy Asib
        Kamalsada.

    .. change::
        :tags: usecase, autogenerate
        :tickets: 1248

        Change the default value of
        :paramref:`.EnvironmentContext.configure.compare_type` to ``True``.
        As Alembic's autogenerate for types was dramatically improved in
        version 1.4 released in 2020, the type comparison feature is now much
        more reliable so is now enabled by default.

    .. change::
        :tags: feature, autogenerate
        :tickets: 1275

        Added new feature to the "code formatter" function which allows standalone
        executable tools to be run against code, without going through the Python
        interpreter.  Known as the ``exec`` runner, it complements the existing
        ``console_scripts`` runner by allowing non-Python tools such as ``ruff`` to
        be used.  Pull request courtesy Mihail Milushev.

        .. seealso::

            :ref:`post_write_hooks_config`

.. changelog::
    :version: 1.11.3
    :released: August 16, 2023

    .. change::
        :tags: bug, autogenerate, postgresql
        :tickets: 1270

        Improved autogenerate compare of expression based indexes on PostgreSQL
        to produce fewer wrong detections.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1291

        Fixed issue with ``NULLS NOT DISTINCT`` detection in postgresql that
        would keep detecting changes in the index or unique constraint.

    .. change::
        :tags: bug, commands
        :tickets: 1273

        Added ``encoding="locale"`` setting to the use of Python's
        ``ConfigParser.read()``, so that a warning is not generated when using the
        recently added Python feature ``PYTHONWARNDEFAULTENCODING`` specified in
        :pep:`597`. The encoding is passed as the ``"locale"`` string under Python
        3.10 and greater, which indicates that the system-level locale should be
        used, as was the case already here.  Pull request courtesy Kevin Kirsche.

.. changelog::
    :version: 1.11.2
    :released: August 4, 2023

    .. change::
        :tags: usecase, typing
        :tickets: 1253

        Added typing to the default script mako templates.

    .. change::
        :tags: usecase, autogenerate
        :tickets: 1248

        Added support in autogenerate for ``NULLS NOT DISTINCT`` in
        the PostgreSQL dialect.

    .. change::
        :tags: bug
        :tickets: 1261

        Fixed format string logged when running a post write hook
        Pull request curtesy of Mathieu D辿fosse.

    .. change::
        :tags: feature, operations
        :tickets: 151

        Added parameters if_exists and if_not_exists for index operations.
        Pull request courtesy of Max Adrian.

.. changelog::
    :version: 1.11.1
    :released: May 17, 2023

    .. change::
        :tags: bug, autogenerate, regression
        :tickets: 1243, 1245

        As Alembic 1.11.0 is considered a major release (Alembic does not use
        semver, nor does its parent project SQLAlchemy; this has been
        :ref:`clarified <versioning_scheme>` in the documentation), change
        :ticket:`1130` modified calling signatures for most operations to consider
        all optional keyword parameters to be keyword-only arguments, to match what
        was always documented and generated by autogenerate. However, two of these
        changes were identified as possibly problematic without a more formal
        deprecation warning being emitted which were the ``table_name`` parameter
        to :meth:`.Operations.drop_index`, which was generated positionally by
        autogenerate prior to version 0.6.3 released in 2014, and ``type_`` in
        :meth:`.Operations.drop_constraint` and
        :meth:`.BatchOperations.drop_constraint`, which was documented positionally
        in one example in the batch documentation.

        These two signatures have been
        restored to allow those particular parameters to be passed positionally. A
        future change will include formal deprecation paths (with warnings) for
        these arguments where they will again become keyword-only in a future
        "Significant Minor" release.

    .. change::
        :tags: bug, typing
        :tickets: 1246

        Fixed typing use of :class:`~sqlalchemy.schema.Column` and other
        generic SQLAlchemy classes.

    .. change::
        :tags: bug, typing, regression
        :tickets: 1244

        Restored the output type of :meth:`.Config.get_section` to include
        ``Dict[str, str]`` as a potential return type, which had been changed to
        immutable ``Mapping[str, str]``. When a section is returned and the default
        is not used, a mutable dictionary is returned.

.. changelog::
    :version: 1.11.0
    :released: May 15, 2023

    .. change::
        :tags: bug, batch
        :tickets: 1237

        Added placeholder classes for :class:`~.sqla.Computed` and
        :class:`~.sqla.Identity` when older 1.x SQLAlchemy versions are in use,
        namely prior to SQLAlchemy 1.3.11 when the :class:`~.sqla.Computed`
        construct was introduced. Previously these were set to None, however this
        could cause issues with certain codepaths that were using ``isinstance()``
        such as one within "batch mode".

    .. change::
        :tags: bug, batch
        :tickets: 1221

        Correctly pass previously ignored arguments ``insert_before`` and
        ``insert_after`` in ``batch_alter_column``

    .. change::
        :tags: change, py3k
        :tickets: 1130

        Argument signatures of Alembic operations now enforce keyword-only
        arguments as passed as keyword and not positionally, such as
        :paramref:`.Operations.create_table.schema`,
        :paramref:`.Operations.add_column.type_`, etc.

    .. change::
        :tags: bug, postgresql
        :tickets: 1230

        Fix autogenerate issue with PostgreSQL :class:`.ExcludeConstraint`
        that included sqlalchemy functions. The function text was previously
        rendered as a plain string without surrounding with ``text()``.

    .. change::
        :tags: bug, mysql, regression
        :tickets: 1240

        Fixed regression caused by :ticket:`1166` released in version 1.10.0 which
        caused MySQL unique constraints with multiple columns to not compare
        correctly within autogenerate, due to different sorting rules on unique
        constraints vs. indexes, which in MySQL are shared constructs.

    .. change::
        :tags: misc
        :tickets: 1220

        Update code snippets within docstrings to use ``black`` code formatting.
        Pull request courtesy of James Addison.

    .. change::
        :tags: bug, typing
        :tickets: 1093

        Updated stub generator script to also add stubs method definitions for the
        :class:`.Operations` class and the :class:`.BatchOperations` class obtained
        from :meth:`.Operations.batch_alter_table`. As part of this change, the
        class hierarchy of :class:`.Operations` and :class:`.BatchOperations` has
        been rearranged on top of a common base class :class:`.AbstractOperations`
        in order to type correctly, as :class:`.BatchOperations` uses different
        method signatures for operations than :class:`.Operations`.

    .. change::
        :tags: bug, typing

        Repaired the return signatures for :class:`.Operations` that mostly
        return ``None``, and were erroneously referring to ``Optional[Table]``
        in many cases.

    .. change::
        :tags: usecase, commands
        :tickets: 1109

        Added quiet option to the command line, using the ``-q/--quiet``
        option. This flag will prevent alembic from logging anything
        to stdout.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1178

        Modified the autogenerate implementation for comparing "server default"
        values from user-defined metadata to not apply any quoting to the value
        before comparing it to the server-reported default, except for within
        dialect-specific routines as needed. This change will affect the format of
        the server default as passed to the
        :paramref:`.EnvironmentContext.configure.compare_server_default` hook, as
        well as for third party dialects that implement a custom
        ``compare_server_default`` hook in their alembic impl, to be passed "as is"
        and not including additional quoting.  Custom implementations which rely
        on this quoting should adjust their approach based on observed formatting.

    .. change::
        :tags: bug, api, autogenerate
        :tickets: 1235

        Fixed issue where :func:`.autogenerate.render_python_code` function did not
        provide a default value for the ``user_module_prefix`` variable, leading to
        ``NoneType`` errors when autogenerate structures included user-defined
        types. Added new parameter
        :paramref:`.autogenerate.render_python_code.user_module_prefix` to allow
        this to be set as well as to default to ``None``. Pull request courtesy
        tangkikodo.

    .. change::
        :tags: usecase, asyncio
        :tickets: 1231

        Added :meth:`.AbstractOperations.run_async` to the operation module to
        allow running async functions in the ``upgrade`` or ``downgrade`` migration
        function when running alembic using an async dialect. This function will
        receive as first argument an
        :class:`~sqlalchemy.ext.asyncio.AsyncConnection` sharing the transaction
        used in the migration context.

.. changelog::
    :version: 1.10.4
    :released: April 24, 2023

    .. change::
        :tags: postgresql, autogenerate, feature
        :tickets: 1213

        Added support for autogenerate comparison of indexes on PostgreSQL which
        include SQL sort option, such as ``ASC`` or ``NULLS FIRST``.
        The sort options are correctly detected only when defined using the
        sqlalchemy modifier functions, such as ``asc()`` or ``nulls_first()``,
        or the equivalent methods.
        Passing sort options inside the ``postgresql_ops`` dict is not supported.

    .. change::
        :tags: bug, operations
        :tickets: 1215

        Fixed issue where using a directive such as ``op.create_foreign_key()`` to
        create a self-referential constraint on a single table where the same
        column were present on both sides (e.g. within a composite foreign key)
        would produce an error under SQLAlchemy 2.0 and a warning under SQLAlchemy
        1.4 indicating that a duplicate column were being added to a table.

.. changelog::
    :version: 1.10.3
    :released: April 5, 2023

    .. change::
        :tags: bug, typing
        :tickets: 1191, 1201

        Fixed various typing issues observed with pyright, including issues
        involving the combination of :class:`.Function` and
        :meth:`.MigrationContext.begin_transaction`.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1212

        Fixed error raised by alembic when running autogenerate after removing
        a function based index.

.. changelog::
    :version: 1.10.2
    :released: March 8, 2023

    .. change::
        :tags: bug, ops
        :tickets: 1196

        Fixed regression where Alembic would not run with older SQLAlchemy 1.3
        versions prior to 1.3.24 due to a missing symbol. Workarounds have been
        applied for older 1.3 versions.

.. changelog::
    :version: 1.10.1
    :released: March 6, 2023

    .. change::
        :tags: bug, postgresql
        :tickets: 1184

        Fixed issue regarding PostgreSQL :class:`.ExcludeConstraint`, where
        constraint elements which made use of :func:`.literal_column` could not be
        rendered for autogenerate. Additionally, using SQLAlchemy 2.0.5 or greater,
        :func:`.text()` constructs are also supported within PostgreSQL
        :class:`.ExcludeConstraint` objects for autogenerate render. Pull request
        courtesy Jan Katins.

    .. change::
        :tags: bug, batch, regression
        :tickets: 1195

        Fixed regression for 1.10.0 where :class:`.Constraint` objects were
        suddenly required to have non-None name fields when using batch mode, which
        was not previously a requirement.

.. changelog::
    :version: 1.10.0
    :released: March 5, 2023

    .. change::
        :tags: bug, autogenerate
        :tickets: 1166

        Fixed issue in index detection where autogenerate change detection would
        consider indexes with the same columns but with different order as equal,
        while in general they are not equivalent in how a database will use them.

    .. change::
        :tags: feature, revisioning
        :tickets: 760

        Recursive traversal of revision files in a particular revision directory is
        now supported, by indicating ``recursive_version_locations = true`` in
        alembic.ini. Pull request courtesy ostr00000.

    .. change::
        :tags: bug, autogenerate, sqlite
        :tickets: 1165

        Fixed issue where indexes on SQLite which include SQL expressions would not
        compare correctly, generating false positives under autogenerate. These
        indexes are now skipped, generating a warning, in the same way that
        expression-based indexes on PostgreSQL are skipped and generate warnings
        when SQLAlchemy 1.x installations are in use. Note that reflection of
        SQLite expression-based indexes continues to not yet be supported under
        SQLAlchemy 2.0, even though PostgreSQL expression-based indexes have now
        been implemented.

    .. change::
        :tags: bug, mssql
        :tickets: 1187

        Properly escape constraint name on SQL Server when dropping
        a column while specifying ``mssql_drop_default=True`` or
        ``mssql_drop_check=True`` or ``mssql_drop_foreign_key=True``.

    .. change::
        :tags: usecase, autogenerate, postgresql

        Added support for autogenerate comparison of indexes on PostgreSQL which
        include SQL expressions, when using SQLAlchemy 2.0; the previous warning
        that such indexes were skipped are removed when the new functionality
        is in use.  When using SQLAlchemy versions prior to the 2.0 series,
        the indexes continue to be skipped with a warning.

.. changelog::
    :version: 1.9.4
    :released: February 16, 2023

    .. change::
        :tags: bug, mssql
        :tickets: 1177

        Ongoing fixes for SQL Server server default comparisons under autogenerate,
        adjusting for SQL Server's collapsing of whitespace between SQL function
        arguments when reporting on a function-based server default, as well as its
        arbitrary addition of parenthesis within arguments; the approach has now
        been made more aggressive by stripping the two default strings to compare
        of all whitespace, parenthesis, and quoting characters.

    .. change::
        :tags: bug, postgresql

        Fixed PostgreSQL server default comparison to handle SQL expressions
        sent as ``text()`` constructs, such as ``text("substring('name', 1, 3)")``,
        which previously would raise errors when attempting to run a server-based
        comparison.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1180

        Removed a mis-use of the
        :paramref:`.EnvironmentContext.configure.render_item` callable where the
        "server_default" renderer would be erroneously used within the server
        default comparison process, which is working against SQL expressions, not
        Python code.

    .. change::
        :tags: bug, commands

        Fixed regression introduced in 1.7.0 where the "config" object passed to
        the template context when running the :func:`.merge` command
        programmatically failed to be correctly populated. Pull request courtesy
        Brendan Gann.

.. changelog::
    :version: 1.9.3
    :released: February 7, 2023

    .. change::
        :tags: bug, autogenerate
        :tickets: 1167

        Fixed issue where rendering of user-defined types that then went onto use
        the ``.with_variant()`` method would fail to render, if using SQLAlchemy
        2.0's version of variants.

.. changelog::
    :version: 1.9.2
    :released: January 14, 2023

    .. change::
        :tags: bug, typing
        :tickets: 1146, 1147

        Fixed typing definitions for :meth:`.EnvironmentContext.get_x_argument`.

        Typing stubs are now generated for overloaded proxied methods such as
        :meth:`.EnvironmentContext.get_x_argument`.

    .. change::
        :tags: bug, autogenerate
        :tickets: 1152

        Fixed regression caused by :ticket:`1145` where the string transformations
        applied to server defaults caused expressions such as ``(getdate())`` to no
        longer compare as equivalent on SQL Server, others.

.. changelog::
    :version: 1.9.1
    :released: December 23, 2022

    .. change::
        :tags: bug, autogenerate
        :tickets: 1145

        Fixed issue where server default compare would not work for string defaults
        that contained backslashes, due to mis-rendering of these values when
        comparing their contents.

    .. change::
        :tags: bug, oracle

        Implemented basic server default comparison for the Oracle backend;
        previously, Oracle's formatting of reflected defaults prevented any
        matches from occurring.

    .. change::
        :tags: bug, sqlite

        Adjusted SQLite's compare server default implementation to better handle
        defaults with or without parens around them, from both the reflected and
        the local metadata side.

    .. change::
        :tags: bug, mssql

        Adjusted SQL Server's compare server default implementation to better
        handle defaults with or without parens around them, from both the reflected
        and the local metadata side.

.. changelog::
    :version: 1.9.0
    :released: December 15, 2022

    .. change::
        :tags: feature, commands
        :tickets: 724

        Added new Alembic command ``alembic check``. This performs the widely
        requested feature of running an "autogenerate" comparison between the
        current database and the :class:`.MetaData` that's currently set up for
        autogenerate, returning an error code if the two do not match, based on
        current autogenerate settings. Pull request courtesy Nathan Louie.

        .. seealso::

            :ref:`alembic_check`

    .. change::
        :tags: bug, tests

        Fixed issue in tox.ini file where changes in the tox 4.0 series to the
        format of "passenv" caused tox to not function correctly, in particular
        raising an error as of tox 4.0.6.

    .. change::
        :tags: bug, typing
        :tickets: 1110

        Fixed typing issue where :paramref:`.revision.process_revision_directives`
        was not fully typed; additionally ensured all ``Callable`` and ``Dict``
        arguments to :meth:`.EnvironmentContext.configure` include parameters in
        the typing declaration.

        Additionally updated the codebase for Mypy 0.990 compliance.

.. changelog::
    :version: 1.8.1
    :released: July 13, 2022

    .. change::
        :tags: bug, sqlite
        :tickets: 1065

        Fixed bug where the SQLite implementation of
        :meth:`.Operations.rename_table` would render an explicit schema name for
        both the old and new table name, which while is the standard ALTER syntax,
        is not accepted by SQLite's syntax which doesn't support a rename across
        schemas. In particular, the syntax issue would prevent batch mode from
        working for SQLite databases that made use of attached databases (which are
        treated as "schemas" in SQLAlchemy).

    .. change::
        :tags: bug, batch
        :tickets: 1021

        Added an error raise for the condition where
        :meth:`.Operations.batch_alter_table` is used in ``--sql`` mode, where the
        operation requires table reflection, as is the case when running against
        SQLite without giving it a fixed ``Table`` object. Previously the operation
        would fail with an internal error.  To get a "move and copy" batch
        operation as a SQL script without connecting to a database,
        a ``Table`` object should be passed to the
        :paramref:`.Operations.batch_alter_table.copy_from` parameter so that
        reflection may be skipped.

.. changelog::
    :version: 1.8.0
    :released: May 31, 2022

    .. change::
        :tags: feature, typing
        :tickets: 764

        :pep:`484` typing annotations have been added to the ``env.py`` and
        revision template files within migration templates. Pull request by Nikita
        Sobolev.

    .. change::
        :tags: usecase, operations
        :tickets: 1037

        The ``op.drop_table()`` operation directive will now trigger the
        ``before_drop()`` and ``after_drop()`` DDL event hooks at the table level,
        which is similar to how the ``before_create()`` and ``after_create()``
        hooks are triggered by the ``op.create_table()`` directive. Note that as
        ``op.drop_table()`` accepts only a table name and optional schema name, the
        ``Table`` object received by the event will not have any information within
        it other than the table name and schema name.

    .. change::
        :tags: installation, changed
        :tickets: 1025

        Alembic 1.8 now supports Python 3.7 and above.

    .. change::
        :tags: changed, environment
        :tickets: 987

        The "Pylons" environment template has been removed as of Alembic 1.8. This
        template was based on the very old pre-Pyramid Pylons web framework which
        has been long superseded by Pyramid.

    .. change::
        :tags: bug, revisioning
        :tickets: 1026

        Fixed issue where a downgrade using a relative revision would
        fail in case of multiple branches with a single effectively
        head due to interdependencies between revisions.

    .. change::
      :tags: usecase, commands
      :tickets: 1027

      Added new token ``epoch`` to the ``file_template`` option, which will
      populate the integer epoch as determined by ``int(create_date.timestamp())``.
      Pull request courtesy Caio Carvalho.

    .. change::
        :tags: bug, batch
        :tickets: 1034

        Fixed issue in batch mode where CREATE INDEX would not use a new column
        name in the case of a column rename.

(wiz)

shells/nushell: remove patch

No longer needed.

(pin)

doc: Updated devel/difftastic to 0.56.1

(pin)

devel/difftastic: update to 0.56.1

0.56.1 (released 5th March 2024)
Build
- Fixed an issue with building difftastic on aarch64 with rust 1.71 or earlier.

0.56 (released 5th March 2024)
Parsing
- Updated JavaScript, TypeScript, QML and Perl parsers.
- Makefile*.in is now detected as Makefile syntax.
- Improved shebang parsing with whitespace, e.g. #! /bin/bash is now detected as a shell script.
- Added support for Scheme and Smali.

Diffing
- Fixed an issue with runaway memory usage on text files with very long lines.

Display
- Fixed an issue where all files would show a permissions change when using difftastic with git difftool.
- Fixed an issue with paths not showing the containing directory when using difftastic with git difftool.
- Difftastic now correctly reports file permission changes when called from git diff.
- Fixed an issue with the experimental JSON display mode where it ignored --skip-unchanged.
- Fixed an issue with tabs not being replaced in single-column display.

(pin)

doc: Updated devel/cargo-modules to 0.15.0

(pin)

devel/cargo-modules: update to 0.15.0

[0.15.0] - 2024-03-06
  Updated dependencies:
    - mio from 0.8.10 to 0.8.11
    - env_logger from 0.11.2 to 0.11.3
    - insta from 1.35.1 to 1.36.1
    - log from 0.4.20 to 0.4.21

  Security
    - Fixed potential vulnerability in mio by upgrading it from 0.8.10 to 0.8.11.

(pin)

doc: Updated shells/nushell to 0.91.0

(pin)

shells/nushell: update to 0.91.0

This is the 0.91.0 release of Nushell. You can learn more about this release
here: https://www.nushell.sh/blog/2024-03-05-nushell_0_91_0.html

The ChangeLog is too long to reproduce here.

(pin)

Updated sysutils/salt, sysutils/salt-docs

(adam)

salt salt-docs: updated to 3006.7

SALT 3006.7 RELEASE NOTES

CHANGELOG
DEPRECATED

Deprecate and stop using salt.features

CHANGED

Change module search path priority, so Salt extensions can be overridden by syncable modules and module_dirs. You can switch back to the old logic by setting features.enable_deprecated_module_search_path_priority to true, but it will be removed in Salt 3008.

FIXED

Fix an issue with mac_shadow that was causing a command execution error when retrieving values that were not yet set. For example, retrieving last login before the user had logged in.

Fixed an issue when keys didn't match because of line endings

Corrected encoding of credentials for use with Artifactory

Use send_multipart instead of send when sending multipart message.

Fix an issue where the minion would crash on Windows if some of the grains failed to resolve

Fix issue with openscap when the error was outside the expected scope. It now returns failed with the error code and the error

Upgrade relenv to 0.15.0 to fix namespaced packages installed by salt-pip

Fix regression of fileclient re-use when rendering sls pillars and states

Fixes the s3fs backend computing the local cache's files with the wrong hash type

Fixed Salt-SSH pillar rendering and state rendering with nested SSH calls when called via saltutil.cmd or in an orchestration

Fix boto execution module loading

Removed PR 65185 changes since incomplete solution

catch only ret/ events not all returning events.

Fix nonsensical time in fileclient timeout error.

Fixes an issue when reading/modifying ini files that contain unicode characters

added https proxy to the list of proxies so that requests knows what to do with https based proxies

Ensure minion channels are closed on any master connection error.

Fixed issue where Salt can't find libcrypto when pip installed from a cloned repo

Fix RPM package systemd scriptlets to make RPM packages more universal

Fixed an issue where fileclient requests during Pillar rendering cause fileserver backends to be needlessly refreshed.

Fix exceptions being set on futures that are already done in ZeroMQ transport

Use hmac compare_digest method in hashutil module to mitigate potential timing attacks

Fix request channel default timeout regression. In 3006.5 it was changed from 60 to 30 and is now set back to 60 by default.

Upgrade relenv to 0.15.1 to fix debugpy support.

SECURITY

Bump to cryptography==42.0.0 due to https://github.com/advisories/GHSA-3ww4-gg4f-jr7f

In the process, we were also required to update to pyOpenSSL==24.0.0

Bump to cryptography==42.0.3 due to https://github.com/advisories/GHSA-3ww4-gg4f-jr7f

(adam)

Updated archivers/py-libarchive-c, math/py-pandas, misc/py-trove-classifiers, lang/py-test-mypy-testing

(adam)

py-test-mypy-testing: updated to 0.1.3

v0.1.3 (2024-03-05)

Replace usage of deprecated path argument to pytest hook pytest_collect_file() with usage of the file_path argument introduced in pytest 7

(adam)

py-trove-classifiers: updated to 2024.3.3

2024.3.3

add  "License :: OSI Approved :: NASA Open Source Agreement (NOSA)"

(adam)

py-pandas: updated to 2.2.1

What窶冱 new in 2.2.1 (February 22, 2024)

These are the changes in pandas 2.2.1. See Release notes for a full changelog including other versions of pandas.

Enhancements

Added pyarrow pip extra so users can install pandas and pyarrow with pip with pip install pandas[pyarrow] (GH 54466)
Fixed regressions

Fixed memory leak in read_csv() (GH 57039)
Fixed performance regression in Series.combine_first() (GH 55845)
Fixed regression causing overflow for near-minimum timestamps (GH 57150)
Fixed regression in concat() changing long-standing behavior that always sorted the non-concatenation axis when the axis was a DatetimeIndex (GH 57006)
Fixed regression in merge_ordered() raising TypeError for fill_method="ffill" and how="left" (GH 57010)
Fixed regression in pandas.testing.assert_series_equal() defaulting to check_exact=True when checking the Index (GH 57067)
Fixed regression in read_json() where an Index would be returned instead of a RangeIndex (GH 57429)
Fixed regression in wide_to_long() raising an AttributeError for string columns (GH 57066)
Fixed regression in DataFrameGroupBy.idxmin(), DataFrameGroupBy.idxmax(), SeriesGroupBy.idxmin(), SeriesGroupBy.idxmax() ignoring the skipna argument (GH 57040)
Fixed regression in DataFrameGroupBy.idxmin(), DataFrameGroupBy.idxmax(), SeriesGroupBy.idxmin(), SeriesGroupBy.idxmax() where values containing the minimum or maximum value for the dtype could produce incorrect results (GH 57040)
Fixed regression in CategoricalIndex.difference() raising KeyError when other contains null values other than NaN (GH 57318)
Fixed regression in DataFrame.groupby() raising ValueError when grouping by a Series in some cases (GH 57276)
Fixed regression in DataFrame.loc() raising IndexError for non-unique, masked dtype indexes where result has more than 10,000 rows (GH 57027)
Fixed regression in DataFrame.loc() which was unnecessarily throwing 窶彿ncompatible dtype warning窶� when expanding with partial row indexer and multiple columns (see PDEP6) (GH 56503)
Fixed regression in DataFrame.map() with na_action="ignore" not being respected for NumPy nullable and ArrowDtypes (GH 57316)
Fixed regression in DataFrame.merge() raising ValueError for certain types of 3rd-party extension arrays (GH 57316)
Fixed regression in DataFrame.query() with all NaT column with object dtype (GH 57068)
Fixed regression in DataFrame.shift() raising AssertionError for axis=1 and empty DataFrame (GH 57301)
Fixed regression in DataFrame.sort_index() not producing a stable sort for a index with duplicates (GH 57151)
Fixed regression in DataFrame.to_dict() with orient='list' and datetime or timedelta types returning integers (GH 54824)
Fixed regression in DataFrame.to_json() converting nullable integers to floats (GH 57224)
Fixed regression in DataFrame.to_sql() when method="multi" is passed and the dialect type is not Oracle (GH 57310)
Fixed regression in DataFrame.transpose() with nullable extension dtypes not having F-contiguous data potentially causing exceptions when used (GH 57315)
Fixed regression in DataFrame.update() emitting incorrect warnings about downcasting (GH 57124)
Fixed regression in DataFrameGroupBy.idxmin(), DataFrameGroupBy.idxmax(), SeriesGroupBy.idxmin(), SeriesGroupBy.idxmax() ignoring the skipna argument (GH 57040)
Fixed regression in DataFrameGroupBy.idxmin(), DataFrameGroupBy.idxmax(), SeriesGroupBy.idxmin(), SeriesGroupBy.idxmax() where values containing the minimum or maximum value for the dtype could produce incorrect results (GH 57040)
Fixed regression in ExtensionArray.to_numpy() raising for non-numeric masked dtypes (GH 56991)
Fixed regression in Index.join() raising TypeError when joining an empty index to a non-empty index containing mixed dtype values (GH 57048)
Fixed regression in Series.astype() introducing decimals when converting from integer with missing values to string dtype (GH 57418)
Fixed regression in Series.pct_change() raising a ValueError for an empty Series (GH 57056)
Fixed regression in Series.to_numpy() when dtype is given as float and the data contains NaNs (GH 57121)
Fixed regression in addition or subtraction of DateOffset objects with millisecond components to datetime64 Index, Series, or DataFrame (GH 57529)

Bug fixes

Fixed bug in pandas.api.interchange.from_dataframe() which was raising for Nullable integers (GH 55069)
Fixed bug in pandas.api.interchange.from_dataframe() which was raising for empty inputs (GH 56700)
Fixed bug in pandas.api.interchange.from_dataframe() which wasn窶冲 converting columns names to strings (GH 55069)
Fixed bug in DataFrame.__getitem__() for empty DataFrame with Copy-on-Write enabled (GH 57130)
Fixed bug in PeriodIndex.asfreq() which was silently converting frequencies which are not supported as period frequencies instead of raising an error (GH 56945)

(adam)

py-libarchive-c: updated to 5.1

5.1

Fix the format_name property and move it from the ArchiveEntry class to the ArchiveRead class

(adam)

Updated lang/vala, net/libnice, net/gst-plugins1-libnice, devel/SDL2

(adam)

SDL2: updated to 2.30.1

2.30.1

This is a stable bugfix release, with the following changes:

Fixed a regression causing SDL_WaitEvent() to return spurious failures
Fixed X11 cursors on the latest release of GNOME
Wayland windows automatically have OpenGL enabled again
Fixed memory corruption when converting signed 16-bit audio to float
Fixed audio artifacts when converting signed 8-bit audio to float
Fixed the clip rectangle not being updated when the viewport changes in the SDL renderer
Convert mouse wheel coordinates to the rendering view in the SDL renderer
Fixed a crash handling controllers on macOS
Fixed a crash setting a window fullscreen with Emscripten
Fixed the keyboard automatically popping up when resuming an application on Android

(adam)

libnice gst-plugins1-libnice: updated to 0.1.22

libnice 0.1.22 (2024-03-04)

API: Make nice_address_is_local() available to applications
Make padding be all zeros to conform to RFC8489
Fix interface listing on Android
Include TURN sockets in the list from nice_agent_get_sockets()
Set consent refresh timeout in line with RFC 7675
Fix ifr_ifindex build with cland and OpenBSD

(adam)

vala: updated to 0.56.15

Vala 0.56.15
============
* Various improvements and bug fixes:
  - codegen:
    + Use GWeakRef for [SingleInstance] constructors
    + Remove static mutex initialization
    + Correctly return FALSE on uncaught error in async ctor
    + Cast generic return value from g_ptr_array_index()
    + Don't use pre-assigned *_parent_iface field if an instance is given
    + Emit diagnostic pragmas for GCC 14, Clang 16 compatibility
  - vala:
    + Keep depfile empty if no dependencies were written
    + Treat negative integer/float ranks as non-compatible
    + Move formal_target_type when transforming method-call/object-creation
    + Follow the logic of GIrParser.locate_gir() to find gir files
  - girparser:
    + Don't blindly translate utf8 to string and check the ctype too
    + Issue a warning for `record` inside `transparent union`
    + Don't discard explictly given ctype of parameters
  - libvaladoc: Fix build with graphviz >= 10.0.1

* Bindings:
  - glib-2.0,posix: Define _GNU_SOURCE for sincos*()
  - gio-2.0: Fix pointer-sign errors of some uint8[]-typed paramters
  - gio-2.0,gmodule-2.0: Update from 2.79.x git
  - gmodule-2.0: Improvements and updates from 2.76
  - gtk4: Fix GLib.Value parameter in Expression.evaluate()
  - gtk4: Update to 4.13.9~f46fb7c6
  - libsoup-3.0: Don't skip uri_copy
  - v4l2: Fix FrameivalEnum.stepwise type mismatch with v4l2_frmivalenum

(adam)

doc: Updated www/gotosocial to 0.14.0

(nikita)

gotosocial: update to version 0.14.0

Changelog:

v0.14.0 Spoiled Sloth
@gotosocialorg gotosocialorg released this 06 Mar 09:41
ﾂｷ 5 commits to main since this release
v0.14.0
7bc536d

Look at that! This sloth is spoiled rotten! �洶･ �汨�

Here's GoToSocial version 0.14.0 Spoiled Sloth!
Release highlights

    Account aliasing. You can now set the alsoKnownAs field on your account via the settings panel, to indicate other accounts you own. This doesn't do much now, but it's the first step towards the Move implementation for account migration coming in v0.15.0. We originally wanted to include Move in this release but it needs more testing so we pushed it back. Hang in there :)
    Much better thread sorting. Conversation threads on both the web view and client API use a new sorting mechanism which makes them way more readable. No longer will replies in a thread be scattered all over the place.
    Better HTTP signature support. We fixed a longstanding issue with including vs not including query parameters in signed GET requests. We now try (and accept) both methods of constructing signatures. Which leads to...
    Improved thread fetching. You'll see far fewer "orphaned" statuses in your timeline now, and you'll see more replies on statuses from other instances.
    Syntax highlighting for code blocks on the web UI. When you include a code block in your markdown now, and correctly indicate the language the code is written in, it will be syntax highlighted when rendered on your profile in the web UI. This requires javascript, but it's a progressive enhancement feature. Visitors to your profile with javascript turned off will just see the code block without syntax highlighting :)
    Improved "about this instance" page, with a link to the page in the nav bar. Previously the "about this instance" page was more or less hidden. We've now surfaced it better, so you can write all your terms and conditions and instance description stuff there. Relatedly....
    Parse instance descriptions and terms and conditions as markdown. Previously it was very difficult to properly edit these fields, because you had to read + write HTML to do so. Now they're parsed as markdown. This means you can more easily include things like blockquotes, lists, etc.
    Big refactor of HTML templates + CSS. We did a serious rework of HTML templates to fix indentation. Previously if you did "view source" on a GoToSocial profile page, you'd see a mess of sloppily-indented HTML. With this refactor, the HTML is now nicely indented and much more readable. We also did an accessibility pass and tested our HTML with various screen readers to try to make the web view a bit less annoying to navigate.
    First pass at a basic spam filtering system. In light of spam waves happening on the fediverse recently we took a crack at implementing a filter to drop messages identified as spam. This is still in the experimental stage, but it's included in this release so you can try it out already. See the docs for details.

Migration notes
Upgrading

To upgrade to 0.14.0 from a previous release:
Binary/tar

    Stop GoToSocial
    Untar the new release, including the web assets and html templates.
    Edit your config.yaml file as necessary (see below).
    Start GoToSocial

Docker

    Stop GoToSocial.
    Pull the new docker container (superseriousbusiness/gotosocial:0.14.0 or superseriousbusiness/gotosocial:latest)
    Start GoToSocial.

config.yaml

The configuration file has changed since the previous release. You can see a diff of the config file here: v0.13.0...v0.14.0#diff-c071e03510b2c57e193a44503fd9528a785f0f411497cc75841a9f8d0b1ac622
Database Migrations

笞��ｸ� This release contains several database migrations which will run the first time you start up this new version. Be sure not to interrupt this migration process. This will take anywhere between a couple seconds and ten minutes (on slower hardware). Please be patient! 笞��ｸ�
Instance description, short description, and terms

Because we changed the way instance description, short description, and terms are parsed and stored, you will need to re-enter these in the admin settings panel. After you've updated to this version, you can just copy-paste your existing descriptions and ToC from the index and about web pages of your instance, and paste them in to the appropriate fields in the settings panel.
(Custom) CSS and HTML

The big refactor of CSS and HTML means that custom CSS from 0.13.x versions of GoToSocial will likely not work as expected on versions >= 0.14.0. The HTML structure changed a bunch, and some of the class names and whatnot have changed as well. Sorry about that! But it needed to be done. For an example of custom css using the new class names and HTML structure, see the following:

/* Theme colors */
:root {
  --acid-green: rgb(63, 255, 0);
  --magenta: rgb(153, 50, 204);

  /* Override */
  --orange2: var(--acid-green);
}

html, body {
  /* Funky scroll bar */
  scrollbar-color: var(--acid-green) var(--gray1);
}

/* Instance display name */
.page-header {
  grid-column: 2;
  align-self: start;
  margin: 1rem 0 1rem 0;
  background-color: var(--gray1);
  border: 0.25rem solid var(--magenta);
  border-radius: var(--br);
}

/* Header card */
.profile .profile-header {
  background-color: var(--gray1);
  border: 0.25rem solid var(--magenta);
}

/* About + Pinned posts headers */
.profile .col-header {
  background: var(--gray1);
  border: 0.25rem solid var(--magenta);
}

.profile .about-user .col-header {
  border-bottom: none;
  margin-bottom: 0;
}

/* Change about sections */
.profile .about-user .fields, .profile .about-user .bio, .profile .about-user .accountstats {
  background: var(--gray1);
  border-left: 0.25rem solid var(--magenta);
  border-right: 0.25rem solid var(--magenta);
}

/* Fiddle around with borders on about sections */
.profile .about-user .fields .field:first-child {
  border-top: 0.25rem dashed var(--magenta);
}
.profile .about-user .fields .field {
  border-bottom: 0.25rem dashed var(--magenta);
}
.profile .about-user .accountstats {
  border-top: 0.25rem dashed var(--magenta);
  border-bottom: 0.25rem solid var(--magenta);
}

/* Statuses + threads */

/* Thread column header */
.thread .col-header {
  background: var(--gray1);
  border: 0.25rem solid var(--magenta);
}

/* Main status body */
.status, .status.expanded {
  background: var(--gray1);
  border: 0.25rem solid var(--magenta);
}

/* Code snippets */
.status .text .content pre, .status .text .content code {
  background: black;
  color: var(--white2);
}

/* Block quotes */
.status .text .content blockquote {
  background-color: black;
}

/* Media wrapper for attachments */
.status .media .media-wrapper {
  background: var(--bg-nearly-opaque);
}
.status .media .media-wrapper details .unknown-attachment .placeholder {
  border: 0.2rem dashed var(--magenta);
}

/* Polls */
.status .text .poll {
  background-color: black;
  border: 0.25rem solid var(--magenta);
}

.status .text .poll .poll-info {
  background-color: black;
}

/* Status info bars */
.status .status-info, .status.expanded .status-info {
  background: black;
}

/* Back + next links */
.backnextlinks {
  background: var(--gray1);
  padding: 0.5rem;
  border: 0.25rem solid var(--magenta);
  border-radius: var(--br);
}

.page-footer {
  margin-top: 2rem;
  background-color: var(--gray1);
  border-top: 0.25rem solid var(--magenta);
}

Detailed changelog

Changelog for 0.13.0 vs 0.14.0. Some changes mentioned below may have already been included in 0.13.x releases.
Features / Performance

    [performance] simpler throttling logic by @NyaaaWhatsUpDoc in #2407
    [feature] Run ANALYZE after migrations on SQLite by @daenney in #2428
    [feature] Push status edit messages into open streams by @Sentynel in #2418
    [feature] request blocking by http headers by @NyaaaWhatsUpDoc in #2409
    [feature] Parse instance descriptors as markdown, show T&C on /about by @tsmethurst in #2481
    [feature] Allow webp emoji uploads / derefs by @tsmethurst in #2484
    [feature] Log pubKeyID for incoming http-signed requests by @tsmethurst in #2501
    [feature] Account alias / move API + db models by @tsmethurst in #2518
    [feature] Move + alias account via settings panel by @tsmethurst in #2519
    [performance] overhaul struct (+ result) caching library for simplicity, performance and multiple-result lookups by @NyaaaWhatsUpDoc in #2535
    [feature] Allow "charset=utf8" in incoming AP POST requests by @tsmethurst in #2564
    [feature] Ratelimit + serve emoji images on separate router group by @tsmethurst in #2548
    [performance] cache library performance enhancements (updates go-structr => v0.2.0) by @NyaaaWhatsUpDoc in #2575
    Improve context descendant sorting by @VyrCossont in #2579
    [feature] Try HTTP signature validation with and without query params for incoming requests by @tsmethurst in #2591
    [feature] serdes for moved/also_known_as by @tsmethurst in #2600
    [feature/performance] sqlite pragma optimize on close by @NyaaaWhatsUpDoc in #2596
    [performance] temporarily cache account status counts to reduce no. account counts by @NyaaaWhatsUpDoc in #2620
    [feature] Add metrics for instance user count, statuses count and federating instances count by @Tsuribori in #2592
    feat: add Mastodon-compatible HTTP signature fallback by @milas in #2659
    [feature] Add requested_by to relationship model by @tsmethurst in #2672
    [feature] Add "what is this" section to index template by @tsmethurst in #2680
    [feature] Add experimental instance-federation-spam-filter option by @tsmethurst in #2685
    [feature] Block Amazonbot by @daenney in #2692
    [feature/oidc] Add support for very basic RBAC by @9p4 in #2642
    [feature] add script to test import / export cycle of a gotosocial instance by @NyaaaWhatsUpDoc in #2693

Bugfixes

    [bugfix] fix poll total vote double count by @Sentynel in #2464
    [bugfix] �沽� by @NyaaaWhatsUpDoc in #2476
    [bugfix] increases sleep time before check in throttle test, to give more leeway by @NyaaaWhatsUpDoc in #2482
    [bugfix] fix check for closed poll to account for non-zero closed time by @NyaaaWhatsUpDoc in #2486
    [bugfix] Outdent placeholder from <aside> when returning unknown media attachments by @tsmethurst in #2485
    [bugfix] misc dereferencer fixes by @NyaaaWhatsUpDoc in #2475
    [bugfix] fix higher-level explicit domain rules causing issues with lower-level domain blocking by @NyaaaWhatsUpDoc in #2513
    [bugfix] Replace named unique constraint on header filter header with generic unique directive by @tsmethurst in #2525
    [bugfix] Better Postgres search case insensitivity by @tsmethurst in #2526
    [bugfix] Ensure domain block side effects skipped if allow in place (blocklist mode) by @tsmethurst in #2542
    [bugfix] Prevent URL + URI for same account being used as alias target by @tsmethurst in #2545
    [bugfix] Downgrade OTEL libraries to 1.20 by @daenney in #2546
    [bugfix/frontend] Break word on profile field names and values by @tsmethurst in #2551
    [bugfix] fix array type for also_known_as_uris by @tsmethurst in #2553
    [bugfix] Don't return Internal Server Error when searching for URIs that don't return AP JSON by @tsmethurst in #2550
    [bugfix] Don't return Account or Status if new and dereferencing failed, other small fixes by @tsmethurst in #2563
    Fix EmptyJSONObject/EmptyJSONArray by @VyrCossont in #2576
    [bugfix] Fix Postgres emoji delete, emoji category change by @tsmethurst in #2570
    [bugfix] update go-structr v0.2.0 => v0.3.0 to fix possible hash collision issues by @NyaaaWhatsUpDoc in #2586
    [bugfix] parent status replied to status not dereferenced sometimes by @NyaaaWhatsUpDoc in #2587
    [bugfix] fix possible infinite loops in media / emoji cleanup by @NyaaaWhatsUpDoc in #2590
    [bugfix] stop paged endpoints returning null for empty items by @NyaaaWhatsUpDoc in #2597
    [bugfix] Ensure activities sender always = activities actor by @tsmethurst in #2608
    [bugfix] fix postgres connection wrapping panic by @NyaaaWhatsUpDoc in #2636
    [bugfix] add stricter checks during all stages of dereferencing remote AS objects by @NyaaaWhatsUpDoc in #2639
    [bugfix] Fix dereferencing ancestors on new status create by @tsmethurst in #2652
    [bugfix] Refactor parse mention, fix local mention bug by @tsmethurst in #2657
    [bugfix] Ensure local statuses always get a threadID so they can be muted by @tsmethurst in #2665
    [bugfix] Use ptr for instance stats entries to avoid skipping 0 values by @tsmethurst in #2666
    [bugfix] use start + end line in regex when validating emoji via API by @tsmethurst in #2671
    [bugfix] fix possible mutex lockup during streaming code by @NyaaaWhatsUpDoc in #2633
    [bugfix] Fix wide images being squished when used as instance avatar by @tsmethurst in #2669
    [bugfix] 2643 bug search for account url doesnt always work when redirected by @NyaaaWhatsUpDoc in #2673
    [bugfix] Allow access to TMP directories in example AppArmor config by @tux93 in #2683
    [bugfix] Account timeline: exclude self-replies that mention other accounts by @VyrCossont in #2670
    [bugfix] check remote status permissibility (#2703)
    f487fc5 [bugfix] Sanitize incoming PropertyValue fields (#2722)
    66d9297 [bugfix/tracing] fix broken tracing due to conflicting schema url (#2712)
    ea0efb8 [bugfix] update postgresqlstmt to correctly use postgres err hook (#2711)
    fcecd0c [bugfix] unwrap boosts when checking in-reply-to status (#2702)

Chores / version bumps

    [chore] Refactor HTML templates and CSS by @tsmethurst in #2480
    [chore]: Bump modernc.org/sqlite from 1.27.0 to 1.28.0 by @dependabot in #2470
    [chore]: Bump golang.org/x/crypto from 0.16.0 to 0.17.0 by @dependabot in #2478
    [chore]: Bump github.com/google/uuid from 1.4.0 to 1.5.0 by @dependabot in #2469
    [chore]: Bump github.com/jackc/pgx/v5 from 5.5.0 to 5.5.1 by @dependabot in #2468
    [chore]: Bump github.com/minio/minio-go/v7 from 7.0.65 to 7.0.66 by @dependabot in #2467
    [chore]: Bump github.com/tdewolff/minify/v2 from 2.20.9 to 2.20.12 by @dependabot in #2509
    [chore]: Bump golang.org/x/image from 0.14.0 to 0.15.0 by @dependabot in #2506
    [chore]: Bump github.com/prometheus/client_golang from 1.17.0 to 1.18.0 by @dependabot in #2507
    Bump follow-redirects from 1.15.3 to 1.15.4 in /web/source by @dependabot in #2512
    [chore/docs] Replace specific year range of copyright notice by @tsmethurst in #2520
    [chore]: Bump golang.org/x/net from 0.19.0 to 0.20.0 by @dependabot in #2533
    [chore]: Bump github.com/jackc/pgx/v5 from 5.5.1 to 5.5.2 by @dependabot in #2532
    [chore]: Bump github.com/tdewolff/minify/v2 from 2.20.12 to 2.20.14 by @dependabot in #2530
    [chore] update bun + extras v1.1.16 -> v1.1.17 by @tsmethurst in #2534
    [chore]: Bump golang.org/x/oauth2 from 0.15.0 to 0.16.0 by @dependabot in #2531
    [chore] Move to codeberg's exif-terminator by @tsmethurst in #2536
    [chore] update viper version by @NyaaaWhatsUpDoc in #2539
    [chore] chore rationalise http return codes for activitypub handlers by @NyaaaWhatsUpDoc in #2540
    [chore] Harden up boolptr logic on Accounts, warn if not set by @tsmethurst in #2544
    [chore]: Bump github.com/KimMachineGun/automemlimit from 0.4.0 to 0.5.0 by @dependabot in #2560
    [chore]: Bump github.com/abema/go-mp4 from 1.1.1 to 1.2.0 by @dependabot in #2559
    [chore]: Bump codeberg.org/gruf/go-mutexes from 1.3.1 to 1.4.0 by @dependabot in #2562
    Update Feditext URL by @VyrCossont in #2568
    [chore] Add a couple tests for updating list entries by @tsmethurst in #2580
    [chore] bump activity dependency -> v1.6.0-gts by @tsmethurst in #2599
    [chore]: Bump github.com/yuin/goldmark from 1.6.0 to 1.7.0 by @dependabot in #2603
    [chore]: Bump github.com/google/uuid from 1.5.0 to 1.6.0 by @dependabot in #2604
    [chore]: Bump github.com/miekg/dns from 1.1.57 to 1.1.58 by @dependabot in #2606
    [chore] Move DoOnce func wrapper to util by @tsmethurst in #2613
    [chore] Allow (internal) callers to set their own freshness window for Accounts + Statuses by @tsmethurst in #2614
    [chore] Add AI check in PR template by @daenney in #2625
    [chore]: Bump golang.org/x/crypto from 0.18.0 to 0.19.0 by @dependabot in #2632
    [chore]: Bump golang.org/x/oauth2 from 0.16.0 to 0.17.0 by @dependabot in #2629
    [chore]: Bump github.com/tdewolff/minify/v2 from 2.20.14 to 2.20.16 by @dependabot in #2631
    Make GtS reported version SemVer-compatible by @VyrCossont in #2611
    [chore] also allow text/xml in place of application/xml by @NyaaaWhatsUpDoc in #2640
    [chore] Simplify the User-Agent string by @daenney in #2645
    [chore] refactor extractFromCtx a bit by @tsmethurst in #2646
    [chore] Disable Move API endpoints for now until Move is fully implemented in the backend by @tsmethurst in #2650
    [chore] Comment out silly, frequently-failing GetStatusTwice test by @tsmethurst in #2656
    [chore]: Bump github.com/tdewolff/minify/v2 from 2.20.16 to 2.20.17 by @dependabot in #2661
    [chore]: Bump github.com/minio/minio-go/v7 from 7.0.66 to 7.0.67 by @dependabot in #2662
    [chore]: Bump github.com/jackc/pgx/v5 from 5.5.2 to 5.5.3 by @dependabot in #2664
    [chore/frontend] Don't use italics for block quotes by @tsmethurst in #2667
    [chore/frontend] Use different background color for block quotes by @tsmethurst in #2668
    [chore] Rename frontend.tmpl to settings.tmpl, remove unused "lightgray" class by @tsmethurst in #2674
    [chore] Increase default max image description to 1500 chars, collapse cw char count into status by @tsmethurst in #2682
    [chore]: Bump github.com/tdewolff/minify/v2 from 2.20.17 to 2.20.18 by @dependabot in #2689
    [chore] add log line about lengthy reindex migration by @tsmethurst in #2695
    [chore]: Bump github.com/stretchr/testify from 1.8.4 to 1.9.0 (#2714)
    c7845c7 [chore]: Bump golang.org/x/crypto from 0.19.0 to 0.20.0 (#2716)
    adb4cdc [chore]: Bump modernc.org/sqlite from 1.28.0 to 1.29.2 (#2718)
    c2a691f [chore] Disable the syslog long message over Unix datagram socket test on macOS (#2700)

Docs

    [docs]: Update FAQ and ROADMAP by @OniriCorpe in #2458
    [docs] Describe how to block IPs using a firewall by @daenney in #2459
    [docs] Update roadmap for 2024 onwards by @tsmethurst in #2521
    [docs] Updates for DB, swap and HTTP/2 on nginx by @daenney in #2547
    [docs] Add a few things to the FAQ. by @mirabilos in #2557
    [docs] use latest cavage link for http signatures by @tsmethurst in #2565
    [docs] Correct wrong tracing transport option by @Tsuribori in #2566
    [docs] Fix log-timestamp-format by @daenney in #2572
    [docs] Add media attachments section to user docs by @tsmethurst in #2578
    [docs] Revamp storage migration by @daenney in #2571
    [docs] Mounting config file in container by @daenney in #2622
    [docs] Enable some new features by @daenney in #2623
    [docs] Fix a few things in the bare metal install by @daenney in #2624
    [docs] Inform new contributors to git fetch by @NoraCodes in #2637
    [docs] Add oauth token authentication workflow by @fyrfli in #2655
    [chore/docs] Various little docs updates by @tsmethurst in #2691
    0b35257 [docs] Update HTTP signature docs a bit (#2721)
    40ba936 [docs] Use human sizes for size limitations (#2706)

New Contributors

    @milas made their first contribution in #2659
    @fyrfli made their first contribution in #2655
    @tux93 made their first contribution in #2683
    @9p4 made their first contribution in #2642

(nikita)

www/wordpress: use tab instead of spaces

(taca)

python-versions-check: add missing space in usage

(wiz)

Updated devel/py-cython, devel/py-tox, devel/py-pyparsing, www/py-twill

(adam)

py-twill: updated to 3.2.3

3.2.3 (released 2024-03-05)

* Adds 'timeout' to the list of exported commends

(adam)

py-pyparsing: updated to 3.1.2

Version 3.1.2 - March, 2024
---------------------------
- Added `ieee_float` expression to `pyparsing.common`, which parses float values,
  plus "NaN", "Inf", "Infinity". PR submitted by Bob Peterson

- Updated pep8 synonym wrappers for better type checking compatibility. PR submitted
  by Ricardo Coccioli

- Fixed empty error message bug, PR submitted by InSync
  pyparsing's exception messages to a former, more helpful form. If you have code that
  parses the exception messages returned by pyparsing, this may require some code
  changes.

- Added unit tests to test for exception message contents, with enhancement to
  `pyparsing.testing.assertRaisesParseException` to accept an expected exception message.

- Updated example `select_parser.py` to use PEP8 names and added Groups for better retrieval
  of parsed values from multiple SELECT clauses.

- Added example `email_address_parser.py`, as suggested by John Byrd

- Added example `directx_x_file_parser.py` to parse DirectX template definitions, and
  generate a Pyparsing parser from a template to parse .x files.

- Some code refactoring to reduce code nesting, PRs submitted by InSync.

- All internal string expressions using '%' string interpolation and `str.format()`
  converted to f-strings.

(adam)

py-tox: updated to 4.14.0

Features - 4.14.0

Support enabling fresh subprocess for packaging build backends via fresh_subprocess
Allow plugins attaching additional information to --version via tox_append_version_info method in the plugin module

(adam)

py-cython: updated to 3.0.9

3.0.9 (2024-03-05)
==================

Features added
--------------

* Assigning ``const`` values to non-const variables now issues a warning.
  (Github issue :issue:`5639`)

* Using ``noexcept`` on a function returning Python objects now issues a warning.
  (Github issue :issue:`5661`)

* Some C-API usage was updated for the upcoming CPython 3.13.
  Patches by Victor Stinner et al.  (Github issues :issue:`6003`, :issue:`6020`)

* The deprecated ``Py_UNICODE`` type is no longer used, unless required by user code.
  (Github issue :issue:`5982`)

* ``std::string.replace()`` declarations were added to libcpp.string.
  Patch by Kieran Geary.  (Github issue :issue:`6037`)

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

* Cython generates incorrect (but harmless) self-casts when directly calling
  final methods of subtypes.  Lacking a better solution, the errors that recent
  gcc versions produce have been silenced for the time being.
  Original patch by Michał Górny.  (Github issue :issue:`2747`)

* Unused variable warnings about clineno were fixed when C lines in tracebacks are disabled.
  (Github issue :issue:`6035`)

* Subclass deallocation of extern classes could crash if the base class uses GC.
  Original patch by Jason Fried.  (Github issue :issue:`5971`)

* Type checks for Python ``memoryview`` could use an invalid C function.
  Patch by Xenia Lu.  (Github issue :issue:`5988`)

* Calling final fused functions could generate invalid C code.
  (Github issue :issue:`5989`)

* Declaring extern enums multiple times could generate invalid C code.
  (Github issue :issue:`5905`)

* ``pyximport`` used relative paths incorrectly.
  Patch by Stefano Rivera.  (Github issue :issue:`5957`)

* Running Cython with globbing characters (``[]*?``) in the module search path could fail.
  Patch by eewanco.  (Github issue :issue:`5942`)

* Literal strings that include braces could change the C code indentation.

Other changes
-------------

* The "enum class not importable" warning is now only issued once per enum type.
  (Github issue :issue:`5941`)

(adam)

net-snmp: Support long fds_bits.

(jperkin)

doc: Updated www/squid6 to 6.8

(sborrill)

squid6: update to 6.8

Changes in squid-6.8 (4 Mar 2024)

        - Bug 5344: mgr:config segfaults without logformat
        - Bug 5343: Fix build on GCC 14
        - Fix infinite recursion when parsing malformed HTTP chunks
        - Fix max-stale in default refresh_pattern
        - Fix marking of problematic cached IP addresses
        - Improved portability to MacOS
        - ... and some documentation improvements

Changes in squid-6.7 (4 Feb 2024)

        - Bug 5337: workaround for crash on startup if -a option is used
        - Bug 5274: Successful tunnels logged as TCP_TUNNEL/500
        - Fix crash when NTLM and Negotiate helpers are queried with no HTTP request
        - Fix SslBump memory leak when mimicking certificates with Authority Key Identifier
        - Fix memory leak on SslBump certificates with Authority Key Identifier extension
        - Fix a possible integer overflow in FTP Gateway
        - Extend cache_log_message to Bug 5187 and job invalidation BUGs
        - Remove incorrect beta version warning
        - MS Windows portability improvements
        - ... and some documentation improvements

(sborrill)

doc: Updated audio/ncspot to 1.1.0

(pin)

doc: Updated devel/libbsd to 0.12.1

(vins)

audio/ncspot: update to 1.1.0

[1.1.0] - 2024-03-05
Added
- Instructions for installation with winget
- Run tests in CI workflow
- Add macOS arm64 builds to CI/CD

Changed
- Switch to arboard for clipboard access as it is still maintained

Fixed
- Crash on Android (Termux) due to unknown user runtime directory
- Crash due to misconfigured or unavailable audio backend
- Missing MPRIS signal for volume changes when volume is changed from inside ncspot
- Crash when ncspot tried to update an API token that was still valid
- Panic when token update attempt fails
- Complete freeze when ncspot was running for a long time

(pin)

devel/libbsd: update to 0.12.1

# Noteworthy changes (since 0.11.8)

- Fix missing installation of err.h. Closes: #1064909
- Support for Solaris, macOS and AIX (now build and pass tests).
- Improve ABI selection handling for a more controlled ports
  ABI.
- Use -isystem instead of -I due the overlay via #include_next usage.
- Sync strtoi()/strtou() implementations from NetBSD to get the new
  error handling behavior.
- Add explicit time32 and time64 support.
- Rework ABI selection logic.
- Add closefrom(), strlcpy() and strlcat() as superseded functions
- Manual pages, documentation and build system cleanups.

(vins)

doc: Updated devel/bacon to 2.15.0

(pin)

devel/bacon: update to 2.15.0

v2.15.0 - 2024/03/05
- insert features related arguments before the -- when there's some - Fix #171
- fix offset in Windows terminal - Fix #175
- better --help with examples and main shortcuts
- rewriten execution engine

(pin)

doc: Updated lang/go122 to 1.22.1

(bsiegert)

doc: Updated lang/go121 to 1.21.8

(bsiegert)

go122: update to 1.22.1 (security)

This minor release includes 5 security fixes following the security policy:

- crypto/x509: Verify panics on certificates with an unknown public key
  algorithm

  Verifying a certificate chain which contains a certificate with an unknown
  public key algorithm will cause Certificate.Verify to panic.

  This affects all crypto/tls clients, and servers that set Config.ClientAuth
  to VerifyClientCertIfGiven or RequireAndVerifyClientCert. The default
  behavior is for TLS servers to not verify client certificates.

  Thanks to John Howard (Google) for reporting this issue.

  This is CVE-2024-24783 and Go issue https://go.dev/issue/65390.

- net/http: memory exhaustion in Request.ParseMultipartForm

  When parsing a multipart form (either explicitly with
  Request.ParseMultipartForm or implicitly with Request.FormValue,
  Request.PostFormValue, or Request.FormFile), limits on the total size of the
  parsed form were not applied to the memory consumed while reading a single
  form line. This permitted a maliciously crafted input containing very long
  lines to cause allocation of arbitrarily large amounts of memory, potentially
  leading to memory exhaustion.

  ParseMultipartForm now correctly limits the maximum size of form lines.

  Thanks to Bartek Nowotarski for reporting this issue.

  This is CVE-2023-45290 and Go issue https://go.dev/issue/65383.

- net/http, net/http/cookiejar: incorrect forwarding of sensitive headers and
  cookies on HTTP redirect

  When following an HTTP redirect to a domain which is not a subdomain match or
  exact match of the initial domain, an http.Client does not forward sensitive
  headers such as "Authorization" or "Cookie". For example, a redirect from
  foo.com to www.foo.com will forward the Authorization header, but a redirect
  to bar.com will not.

  A maliciously crafted HTTP redirect could cause sensitive headers to be
  unexpectedly forwarded.

  Thanks to Juho Nurminen of Mattermost for reporting this issue.

  This is CVE-2023-45289 and Go issue https://go.dev/issue/65065.

- html/template: errors returned from MarshalJSON methods may break template
  escaping

  If errors returned from MarshalJSON methods contain user controlled data,
  they may be used to break the contextual auto-escaping behavior of the
  html/template package, allowing for subsequent actions to inject unexpected
  content into templates.

  Thanks to RyotaK (https://ryotak.net) for reporting this issue.

  This is CVE-2024-24785 and Go issue https://go.dev/issue/65697.

- net/mail: comments in display names are incorrectly handled

  The ParseAddressList function incorrectly handles comments (text within
  parentheses) within display names. Since this is a misalignment with
  conforming address parsers, it can result in different trust decisions being
  made by programs using different parsers.

  Thanks to Juho Nurminen of Mattermost and Slonser
  (https://github.com/Slonser) for reporting this issue.

  This is CVE-2024-24784 and Go issue https://go.dev/issue/65083.

(bsiegert)

go121: update to 1.21.8 (security)

This minor release includes 5 security fixes following the security policy:

- crypto/x509: Verify panics on certificates with an unknown public key
  algorithm

  Verifying a certificate chain which contains a certificate with an unknown
  public key algorithm will cause Certificate.Verify to panic.

  This affects all crypto/tls clients, and servers that set Config.ClientAuth
  to VerifyClientCertIfGiven or RequireAndVerifyClientCert. The default
  behavior is for TLS servers to not verify client certificates.

  Thanks to John Howard (Google) for reporting this issue.

  This is CVE-2024-24783 and Go issue https://go.dev/issue/65390.

- net/http: memory exhaustion in Request.ParseMultipartForm

  When parsing a multipart form (either explicitly with
  Request.ParseMultipartForm or implicitly with Request.FormValue,
  Request.PostFormValue, or Request.FormFile), limits on the total size of the
  parsed form were not applied to the memory consumed while reading a single
  form line. This permitted a maliciously crafted input containing very long
  lines to cause allocation of arbitrarily large amounts of memory, potentially
  leading to memory exhaustion.

  ParseMultipartForm now correctly limits the maximum size of form lines.

  Thanks to Bartek Nowotarski for reporting this issue.

  This is CVE-2023-45290 and Go issue https://go.dev/issue/65383.

- net/http, net/http/cookiejar: incorrect forwarding of sensitive headers and
  cookies on HTTP redirect

  When following an HTTP redirect to a domain which is not a subdomain match or
  exact match of the initial domain, an http.Client does not forward sensitive
  headers such as "Authorization" or "Cookie". For example, a redirect from
  foo.com to www.foo.com will forward the Authorization header, but a redirect
  to bar.com will not.

  A maliciously crafted HTTP redirect could cause sensitive headers to be
  unexpectedly forwarded.

  Thanks to Juho Nurminen of Mattermost for reporting this issue.

  This is CVE-2023-45289 and Go issue https://go.dev/issue/65065.

- html/template: errors returned from MarshalJSON methods may break template
  escaping

  If errors returned from MarshalJSON methods contain user controlled data,
  they may be used to break the contextual auto-escaping behavior of the
  html/template package, allowing for subsequent actions to inject unexpected
  content into templates.

  Thanks to RyotaK (https://ryotak.net) for reporting this issue.

  This is CVE-2024-24785 and Go issue https://go.dev/issue/65697.

- net/mail: comments in display names are incorrectly handled

  The ParseAddressList function incorrectly handles comments (text within
  parentheses) within display names. Since this is a misalignment with
  conforming address parsers, it can result in different trust decisions being
  made by programs using different parsers.

  Thanks to Juho Nurminen of Mattermost and Slonser
  (https://github.com/Slonser) for reporting this issue.

  This is CVE-2024-24784 and Go issue https://go.dev/issue/65083.

(bsiegert)

Updated mail/py-aiosmtpd, time/py-time-machine

(adam)

py-time-machine: updated to 2.14.0

2.14.0 (2024-03-03)

* Fix ``utcfromtimestamp()`` warning on Python 3.12+.
* Fix class decorator for classmethod overrides.
* Avoid calling deprecated ``uuid._load_system_functions()`` on Python 3.9+.
* Support Python 3.13 alpha 4.

(adam)

py-aiosmtpd: updated to 1.4.5

1.4.5
Fixed incorrect handling of newlines.

(adam)

Updated devel/py-maturin, parallel/py-ipyparallel

(adam)

py-ipyparallel: updated to 8.7.0

8.7.0 - 2024-03-04

8.7 is a small release, with a few improvements and updates, mostly related to
compatibility with different versions of JupyterLab, Notebook, and Jupyter
Server.

Highlights:

- JupyterLab 4 compatibility for the lab extension
- Improved logging and deprecation messages for different versions of Jupyter Server and Notebook

New features added

- Update labextension to jupyterlab 4
- add `ControllerLauncher.connection_info_timeout` config

Enhancements made

- log launcher output at warning-level in case of nonzero exit code
- improve deprecation messaging around `ipcluster nbextension`

Bugs fixed

- Use pre-3.10 serialization code on PyPy3.10
- fallback import when using notebook and jupyter_server is unavailable
- don't propagate logs in IPython

(adam)

py-maturin: updated to 1.5.0

1.5.0

* Bump metadata version from 2.1 to 2.3
* Allow identical `VIRTUAL_ENV` and `CONDA_PREFIX` env vars
* Reject `-i python` when cross compiling
* Support uniffi-bindgen in cargo workspaces
* Add support for configuring `xwin` using env vars
* Add validation for crate/package name in new/init
* Add 32-bit RISC-V support
* Improve import hook changes
* Adjust cbindgen Overrides for CFFI

(adam)

doc: Updated lang/gleam to 1.0.0

(nikita)

gleam: update to version 1.0.0

Changelog:

## v1.0.0 - 2024-03-04

### Language changes

- Comments have been added to the JavaScript prelude to indicate which members
  are in the public API and which are internal.

### Build tool

- Fixed a bug where the exported package interface would not have a module's
  documentation.

## v1.0.0-rc2 - 2024-02-14

### Bug fixes

- Fixed a bug where the exhaustiveness checker could crash for some generic
  types.

### Formatter

- The format used by the formatter has been improved in some niche cases.

## v1.0.0-rc1 - 2024-02-10

### Language changes

- Using a reserved word is now a compile error, not a warning.
- Inexhaustive matches are now compile errors, not warnings.
- The warning for an unused module alias now shows how to not assign a name to
  the module.
- Type aliases with unused type parameters now emit an error.
- Type definitions with duplicate type parameters now emit an error.

### Formatter

- Now the formatter will nest pipelines and binary operators that are used as
  function arguments, list items or as tuple items.
- The format function literals used as the last argument in a function call
  on long lines has been improved.

### Build tool

- If a package contains a `todo` expression then the build tool will now refuse
  to publish it to Hex.
- The search bar in generated docs now has a darker background color.
- `gleam export` now takes a `package-interface` option to export a json file
  containing metadata about the root package.
- `gleam docs build` now creates a json file containing metadata about the root
  package.
- The order of dependencies in `manifest.toml` is now in alphabetical order.
- The search bar in generated docs now has a darker background color.
- The generated docs no longer shows whether an argument is discarded or
  not in a function signature.
- It is now possible to use `gleam run -m` to run a dependency module even if
  that dependency uses a compile target that your project does not support.

### Bug fixes

- Fixed a bug the build tool could be make to attempt to run a main function
  that does not support the current target in some circumstances.
- Fixed a bug where the exhaustiveness checker could crash when checking nested
  values inserted into the parent type using type parameters.
- Fixed a bug where `functionname(_name)` would incorrectly parse as a function
  capture instead of a syntax error.
- Fixed a bug where external only functions would "successfully" compile for a
  target they do not support, leading to a runtime error.

(nikita)

doc: Updated www/zola to 0.18.0

(nikita)

zola: Update to version 0.18.0

Changelog:

v0.18.0
Changes:

    77c87f5 Set release date
    e2f5c49 Update deps
    8ba7374 fix: taxonomies missing lang in sitemap (#2373)
    f560b48 Remove dummy file
    74b06d7 Actually remove code blocks from search index [ #2065 ]
    8b18ca0 Update changelog and deps
    4e0f941 elasticlunr-rs 3.0.2, hu language support (#2151)
    1349947 ignore kate-swp files (#2353)
    23bd03f Add apple arm (#2324)
    b1f1e64 Update deps
    8fe219a Update grass to 0.13 (#2321)
    105257b Update changelog
    24304fa Clippy
    6b0585c Avoid unnecessary checking for already checked links (#2305)
    670b882 fix: suppress highlight language warnings if highlight_code is false (#2287) [ #2280 ]
    8b2b066 Add Checking and Force Flag for Directory in Serve Command (#2265)
    841b3df template:feeds: add extra block (#2263)
    4430515 Add ignored_static to config (#2209)
    35aab56 Update deps
    9aa5162 Update edition
    cf99b5a Update changelog
    208c506 Fix LFI in zola serve (#2258)
    2cd133b Fixes #2250; Error instead of panic when root directory or config file not present (#2262)
    1de1dd5 Add attributes to base_url link in atom template (#2261)
    a1ac816 Atom template authors (#2259)
    c18a0c8 always sort assets by filename (Windows/Linux difference) (#2236)
    2532198 Prevent spans crossing line boundaries in class-based code block formatter (#2237)
    22dc32a Add support for lazy loading images (#2211)
    0a9bfa1 Hard link serve panic fix (#2210)
    448a941 Fix typo in error message
    8e37025 Add search.index_format into the serialized config (#2165) (#2196)
    d72ebb1 Fix multi-lingual json index (#2197)
    63054a9 templates: add base URL for feed content (#2190)
    c61e925 Implement replace_re filter (#2163)
    c0dd38b Speedup "zola check" command by reusing the Client (#2171)
    201d674 print error message when no config file found (#2168) [ #2195 ]
    18fbbe5 Next version
    d4d0e4b Update syntax highlighting recc
    8276551 Update syntax-highlighting.md (#2366)
    c031cc5 Update documention for using zola + Cloudflare Pages per advice in cloudflare/pages-build-image#3 (comment) (#2364)
    2774d4d Update themes gallery (#2356)
    a7ffb3b Update themes gallery (#2349)
    7d5ce5c Document author (#2347)
    152eccc Change to updated version of checkout action (#2340)
    0b46736 Add multi-stage dockerfile build example (#2327)
    9097703 Update themes gallery (#2322)
    4f9158f docs: show that base_url should contain protocol (#2328)
    6a612ca Simple console error message dialog in zola serve webpages (#2312)
    a49af5f Update themes gallery (#2309)
    0a8b2b4 Fix the link to the author's site (#2313)
    fc98caf docs: added aws s3 deployment instructions page (#2299)
    7a6ed08 docs: added peterprototypes.com (#2302)
    97d74b7 docs: update gitlab page deployment (#2292)
    e5e1a2f docs: update links to new Tera docs URL (#2289)
    e6fe81c fix broken link to Tera (#2286)
    49b56c3 docs: Update installation.md to use --locked (#2284)
    9ae7d15 Update themes gallery (#2279)
    e727f43 Fix link to tera
    08c218d Add CNAME file
    4785ab2 Start using GH pages for docs site
    74056d1 fix: styling conflict for code tags in li elements (#2273)
    695c17d Add deployment tutorial for fly.io (#2252)
    f93bd90 docs(deploy-gh-pages): add workflow permissions (#2249)
    d0ffb90 Update themes gallery (#2244)
    a6bf876 Clarify public dir in directory structure doc page (#2238) (#2240)
    8dd1b30 added aadi.net.in (#2232)
    11ca366 update zola version (#2179)
    5f4b950 Update themes gallery (#2220)
    864740a docs: correct example use of Github GraphQL (#2230) [ #2229 ]
    d149afe Shortcode documentation update (#2227)
    0f819fc Using cargo install (#2218)
    e43b27e Documented CNAME file for custom domains (#2219)
    14f695e Clarifying documentation around themes. (#1541)
    252f3b3 remove libsass from build instructions (#2217)
    321c717 Add gburghoorn example to EXAMPLES.md (#2212)
    7b095e4 Complete output for get_taxonomy in the documentation (#2204)
    2b56bcb Update themes gallery (#2203)
    3e215e6 Fix typo in page.md (#2192)
    d3fec80 docs: update expired Documents documentation (#2185)
    0113a73 Update themes gallery (#2180)
    0f21270 Update deploy action to the latest version and make version consistant (#2173)
    d626ea1 Update docs
    8ae4c62 Update snap [ #2164 ]
    b5dc5d8 minor updates to overview docs (#2158)
    ef45bb7 Update documentation for multilingual use of taxonomies (#2157)
    4e81dfb Update Metainfo (#2148)

(nikita)

R: Fix building extensions with C++.

(jperkin)

gst-plugins1-base: update and sort disabled plugins list

(wiz)

gstreamer1: explicitly disable ptp-helper

TODO: Needs rust - perhaps package separately?

(wiz)

gcc*: fix variable comparison

From RVP in PR 57998.

(wiz)

doc: Updated multimedia/gstreamer1 to 1.24.0

(wiz)