sqlite3.OperationalError: no such function: spatialite_version

[maawoo]

• which operating system are you using?
  macOS Ventura 13.3.1

• which environment is pyroSAR running in?
  Completely fresh conda environment (created with Mambaforge)

• which version of pyroSAR are you using?
  0.22.2 installed via conda-forge

• which function of pyroSAR did you call with which parameters?

from pyroSAR.drivers import Archive
db_name = 'test.db'
fname = 'S1B_IW_GRDH_1SDV_20211114T190500_20211114T190525_029588_0387F4_527F.zip'
with Archive(db_name) as db:
     db.insert(fname)
     files = db.select(sensor='S1B')

• if applicable, which version of SNAP or GAMMA are you using in pyroSAR?
  N/A

• the full error message

Python 3.10.13 | packaged by conda-forge | (main, Oct 26 2023, 18:09:17) [Clang 16.0.6 ] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> from pyroSAR.drivers import Archive
>>> db_name = 'test.db'
>>> fname = 'S1B_IW_GRDH_1SDV_20211114T190500_20211114T190525_029588_0387F4_527F.zip'
>>> with Archive(db_name) as db:
...     db.insert(fname)
...     files = db.select(sensor='S1B')
...
Traceback (most recent call last):
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
    self.dialect.do_execute(
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such function: spatialite_version

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/pyroSAR/drivers.py", line 2374, in __init__
    version = conn.execute('SELECT spatialite_version();')
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1370, in execute
    return self._exec_driver_sql(
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1674, in _exec_driver_sql
    ret = self._execute_context(
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
    self._handle_dbapi_exception(
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
    util.raise_(
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
    self.dialect.do_execute(
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such function: spatialite_version
[SQL: SELECT spatialite_version();]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/marcowo/mambaforge/envs/test_pyrosar/lib/python3.10/site-packages/pyroSAR/drivers.py", line 2377, in __init__
    raise RuntimeError('could not load spatialite extension')
RuntimeError: could not load spatialite extension

Relevant package versions:

libspatialite             5.1.0                h5b80306_1    conda-forge
libsqlite                 3.44.0               h091b4b1_0    conda-forge
postgresql                16.1                 hc6ab77f_0    conda-forge
sqlalchemy                1.4.49          py310hd125d64_1    conda-forge
sqlalchemy-utils          0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-arrow    0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-babel    0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-base     0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-color    0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-encrypted 0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-intervals 0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-password 0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-pendulum 0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-phone    0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-timezone 0.41.1             pyhd8ed1ab_0    conda-forge
sqlalchemy-utils-url      0.41.1             pyhd8ed1ab_0    conda-forge
sqlite                    3.44.0               hf2abe2d_0    conda-forge