Schematisation editor compatibility with schema version 216

[leendertvanwolfswinkel]

• [x] Change required schema version to 216

• [x] The table v2_global_settings has a new field vegetation_drag_settings_id. Include this in the import/export routines. Hide this field in the attribute table & attribute form

• [x] Add the following fields to the layers Pipe, Channel and Manhole, but hide them in the attribute table & attribute form

  • exchange_thickness = Column(Float)
  • hydraulic_conductivity_in = Column(Float)
  • hydraulic_conductivity_out = Column(Float)

• [x] A new table v2_vegetation_drag has been added. This table should be imported/exported, but not added to the QGIS project. This table has the following columns: sa.Column('id', sa.Integer(), nullable=False), sa.Column('display_name', sa.String(length=255), nullable=True), sa.Column('height', sa.Float(), nullable=True), sa.Column('height_file', sa.String(length=255), nullable=True), sa.Column('stem_count', sa.Float(), nullable=True), sa.Column('stem_count_file', sa.String(length=255), nullable=True), sa.Column('stem_diameter', sa.Float(), nullable=True), sa.Column('stem_diameter_file', sa.String(length=255), nullable=True), sa.Column('drag_coefficient', sa.Float(), nullable=True), sa.Column('drag_coefficient_file', sa.String(length=255), nullable=True),

FYI threedi-schema now includes a list of BETA_COLUMNS (https://github.com/nens/threedi-schema/blob/master/threedi_schema/beta_features.py#L33). Columns in this list should be hidden in the attribute table & attribute form. Probably not practical to import this list as threedi-schema is not a schematisation editor dependency.

[leendertvanwolfswinkel]

@ldebek If add a record to the vegetation_drag table and try to export to spatialite, I get this error:

EDIT: After I removed the row and tried to export again, the error was still there

EDIT 2: error also occurs when I do not touch the vegetation drag table at all, so this is an important one to fix

[leendertvanwolfswinkel]

I also get another error:

How to reproduce:

• Use a schematisation with schema version < 216
• Load from spatialite
• When asked do you want to migrate to 216, click YES

I also tested this with the production version of all the plugins, and that works fine

[ldebek]

@leendertvanwolfswinkel vegetation_drag table export should be fixed now. In terms of the migration error - I wasn't able to repoduce that one. Migration via Schematisation Editor works just fine for me.