On Sat, Nov 09, 2024 at 12:17:32PM +0100, Paco Esteban wrote:
> Hi ports@,
> 
> This is an update of databases/py-sqlalchemy to its latest version
> 2.0.36.  Tons of changes on the software, as this is a big jump.
> 
> I need this for an update to net/gajim sent on another thread.
> 
> This update is potentially problematic, as I could not properly test all
> consumers.  Here's a summary of the ones I tested and their results:
> 
> RUN_DEPENDS
>   > databases/py-alembic,python3
>     before: all tests pass
>     after: all tests pass
>   > databases/py-flask-sqlalchemy,python3
>     before: all tests pass
>     after: all tests pass
>   > devel/codechecker
>     before: tests blow up
>     after: tests blow up just as before
>   > devel/py-buildbot/buildbot
>     before: NO_TEST
>   > mail/grommunio/admin-api
>     before: no tests found
>   > misc/py-imdb
>     before: NO_TEST
>   > productivity/yokadi
>     before: 20 failed, 83 passed, 66 warnings
>     After update and some massaging: 8 failed, 208 passed, 2 warnings
>     None of them related to sqlalchemy, but to their own internal
>     ical module.  Will send the update on a separate thread.
>   > security/wapiti
>     before: NO_TEST
> TEST_DEPENDS
>   > math/py-pandas,python3
>     before: NO_TEST
>   > sysutils/py-apscheduler,python3
>     before: 25 failed, 419 passed, 57 skipped, 7 warnings, 54 errors
>     after:  25 failed, 419 passed, 57 skipped, 7 warnings, 54 errors
>   > www/py-beaker,python3
>     before: 55 failed, 156 passed, 20 warnings
>     after:  38 failed, 173 passed, 20 warnings
>     They all seem related to backends missing,  I can reduce the number of fails
>     by installing backends.
> 
> I'm most concerned about math/py-pandas, but I don't have a meaningful
> way of testing it.  Tests on this and all the other consumers without
> tests are very welcome.
> 
> ok ? comments ?

I gave this a shot via trying the Gajim update. It seems that sqlalchemy
is missing an RDEP on py3-typing_extensions:

$ gajim                    
Traceback (most recent call last):
  File "/usr/local/bin/gajim", line 8, in <module>
    sys.exit(run())
             ^^^^^
  File "/usr/local/lib/python3.11/site-packages/gajim/main.py", line 163, in run
    _init_gui('GTK')
  File "/usr/local/lib/python3.11/site-packages/gajim/main.py", line 94, in _init_gui
    _init_gtk()
  File "/usr/local/lib/python3.11/site-packages/gajim/main.py", line 112, in _init_gtk
    from gajim.gtk import exception
  File "/usr/local/lib/python3.11/site-packages/gajim/gtk/exception.py", line 31, in <module>
    from gajim.common import app
  File "/usr/local/lib/python3.11/site-packages/gajim/common/app.py", line 40, in <module>
    from gajim.common import ged as ged_module
  File "/usr/local/lib/python3.11/site-packages/gajim/common/ged.py", line 18, in <module>
    from gajim.common.events import ApplicationEvent
  File "/usr/local/lib/python3.11/site-packages/gajim/common/events.py", line 32, in <module>
    from gajim.common.storage.archive import models as mod
  File "/usr/local/lib/python3.11/site-packages/gajim/common/storage/archive/models.py", line 12, in <module>
    import sqlalchemy as sa
  File "/usr/local/lib/python3.11/site-packages/sqlalchemy/__init__.py", line 12, in <module>
    from . import util as _util
  File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/__init__.py", line 15, in <module>
    from ._collections import coerce_generator_arg as coerce_generator_arg
  File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/_collections.py", line 39, in <module>
    from .typing import is_non_string_iterable
  File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/typing.py", line 38, in <module>
    from typing_extensions import Annotated as Annotated  # 3.8
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ModuleNotFoundError: No module named 'typing_extensions'