[Bug]: Setting views fails when migrating from 208 to 217

[daanvaningen]

Contact Details

daan.vaningen@nelen-schuurmans.nl

Complexity

moderate

Priority

medium prio

What happened?

threedi_schema -s ../threedigrid-builder/threedigrid_builder/tests/data/v2_bergermeer_spatialite4.sqlite migrate

The current schema revision is: 208
Running alembic upgrade script...
Traceback (most recent call last):
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/bin/threedi_schema", line 33, in <module>
    sys.exit(load_entry_point('threedi-schema', 'console_scripts', 'threedi_schema')())
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/click/decorators.py", line 33, in new_func
    return f(get_current_context(), *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/threedi_schema/scripts.py", line 38, in migrate
    schema.upgrade(
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/threedi_schema/application/schema.py", line 130, in upgrade
    self.set_views()
  File "/home/daan/code/threedigrid-builder/.venv-py3-11/lib/python3.11/site-packages/threedi_schema/application/schema.py", line 163, in set_views
    raise MigrationMissingError(
threedi_schema.application.errors.MigrationMissingError: Setting views requires schema version 217. Current version: 208.

How to Reproduce?

Python 3.11

threedi_schema -s ../threedigrid-builder/threedigrid_builder/tests/data/v2_bergermeer_spatialite4.sqlite migrate

What did you expect and what was the actual result?

Successful migrations from 208 to 217 including the views

Add screenshots, video's etc

The maximum size for files is 25MB and the maximum size for images is 10MB.

Relevant log output

No response

Additional info

Anything else you would like to share?