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
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?
if applicable, which version of SNAP or GAMMA are you using in pyroSAR? N/A
the full error message
Relevant package versions: