7.10.0

Two major problems have been solved with this version of Model Baker and its underlying components. Support for translation models and the ability to handle tables with multiple geometry columns on GeoPackage. In addition, the dataset/basket manager has been improved so that you no longer need to edit (or view) these technical tables directly.

Tables having multiple geometries on GeoPackages

Finally. Multiple geometries per table are possible in GeoPackage, just like in PostgreSQL. Actually, we are building on the great work done on GDAL and ili2db. This concerns models with multiple geometry attributes in one class like KbS_V1_5, Nutzungsplanung_V310 and others.

The setting for gpkgMultiGeomPerTable on Schema Import

If this parameter is set, ili2db creates multiple geometry columns per table in a GeoPackage.

This only works with a sufficient GDAL version * Otherwise it's invisible and false.

Generating QGIS Project

If we have a sufficient GDAL version *, we can create a QGIS project, but need to warn, that others reading this project may have problems.

If the schema was created with the gpkgMultiGeomPerTable and it contains tables with multiple geometry columns, but the current GDAL version is not sufficient, we block the creation of a QGIS Project.

* Sufficient GDAL Version 3.8

The functionality to read such tables with multiple geometry columns is not standardized and does only work with GDAL Version >= 3.8

When a schema is created with this parameter gpkgMultiGeomPerTable and the Model contains multiple geometries per table, it can neither create a project on QGIS with GDAL<3.8 nor read a project that has been created on a QGIS with GDAL >= 3.8.

If no multiple geometries per table, it still can create a project from it by GDAL<3.8 or open such a project.

As well we need to be aware, that GeoPackages are not that powerful than PostgreSQL. Those not-standardized implementations have been tested with the testmodels, KbS_V1_5 and Nutzungsplanung_V310. But there is no guarantee given that it works in every case.

Sponsors

Financed by the QGIS Model Baker Group

TRANSLATION OF

For TRANSLATION OF model, the database schema is created in it's original language (otherwise you would have to pass the parameter --nameLang manually), but on project generation Model Baker parses the meta table (t_ili2db_nls) and creates the GUI in the selected language.

The result is a translated GUI.

Sponsors

Financed by the Canton of Neuchâtel and the QGIS Model Baker Group

Superpower Dataset Manager

The Dataset Manager has existed for quite some time, but it was still not possible to edit baskets and delete datasets. This had to be done via the technical tables t_ili2db_datasets and t_ili2db_baskets. Not anymore. With the new Dataset Manager you can do everything like adding, modifying or deleting datasets and baskets.

Particularly useful are functions that delete depending children. This means that if you delete a dataset, the referencing baskets and all the data in this basket are also deleted. Of course, you will be warned if you do such critical things.

Sponsors

Financed by the QGIS Model Baker Group

Support non-password DB connections

This mainly concerns solutions with Active Directories and technologies such as Kerberos. There, authentication is performed on the server side, which means that Model Baker should attempt requests without a password.

And if no user name is defined in the connection settings, Model Baker uses the user name of the operating system as a “fallback” (obtained by QgsApplication.userLoginName()).

Sponsors

Financed by the Canton of Schaffhausen

Other things

• Show warning message in TID manager when OIDs cannot be found in #954
• Translation (Transifex) Guide in Documentation in #959
• [export] Hide superuser checkbox on PG export and make it possible to run PG export with authConfig and no superuser in #962
• Topping Exporter: Consider the layer type for style categories in #966 and load style for raster layers as well in opengisch/QgisModelBakerLibrary#105
• Fix on DB Manager: Get db type from settings and read the settings accordingly in #968
• Concern superuser login on receiving schema in #969

ili2db

Using ili2db version 5.2.0

Library

Using modelbaker library 1.9.0