Development environment fails to upgrade the DB schema in regards to nodes. about privacyidea HOT 3 OPEN

Steps to reproduce:

Have a system on the previous version:

./pi-manage db stamp 5cb310101a1f

Remove nodename table from DB.

Now add the nodename table:

./pi-manage db upgrade e3a64b4ca634

Works.

Now try to add the node_uuid:

./pi-manage db upgrade d0e7144947d0

Result:

Running online
(sqlite3.OperationalError) near "ALTER": syntax error
[SQL: ALTER TABLE nodename ALTER COLUMN id TYPE VARCHAR(36)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

from privacyidea.

Unfortunately SQLite does not support ALTER TABLE statements which change the type of the column:
https://www.sqlite.org/lang_altertable.html#making_other_kinds_of_table_schema_changes
We can add render_as_batch=True to the context.configure here:

from privacyidea.

Merge migration scripts

from privacyidea.