7.7.0
Pre-releaseMain feature of this release is all about OIDs, a pain point that has existed for quite some time. First thing is the OIDs generated for the single objects, means the TID (or t_ili_tid in the physical database) what is done with default value expressions. The second thing is the OIDs generated for basket-objects, means the BID (and as well t_ili_tid in the physical database), when creating baskets, what now can be controlled by the user as well.
Improvements
TID (OID) Generation for Objects
Often the models definition requires a cross-system unique identificator. The so called OID.
Model Baker detects the OID domain (like UUIDOID
, I32OID
, STANDARDOID
, ANYOID
or user defined OID) and suggests default value expressions used in the t_ili_tid
fields.
Since the user have to be able to edit those values, they are provided in the GUI.
See documentation
In the wizard
There is an additional page after the generation of the QGIS project.
You can use the QGIS Expression Dialog to edit the default value expression for the t_ili_tid
field of each layer.
See documentation
On existing projects
Find the TID (OID) Manager via the Database > Model Baker menu.
If you need a counter in the expressions, you can use the t_id
field, that has a schema-wide sequence counting up. This sequence can be reset as well by the user, but be carefull not to set it lower than already existing t_id
s in your project.
Sponsors
This feature has been financed in a crowdfunding project by geostandards.ch, Canton of Schaffhausen and the QGIS Model Baker Group
Basket Generation with BID (OID)
In case you create a new dataset (e.g. the Baseset
that is created by Model Baker automatically) and you want to collect fresh data in QGIS (no import of existing data), the baskets have to be created as well.
Here the BID
definition needs to be considered.
In the wizard
There is an additional page after the schema import when the Baseset
is created.
Reasonable BIDs are suggested, but of course some of them (like STANDARDOID
) need editing by the user.
As well Model Baker suggests what baskets should be created or not (it sees it as relevant in case it's not extended by other topics).
See documentation
In the Dataset Manager
Of course you might want to create additional Datasets and with it the Baskets. Here is a new option Manage baskets of selected dataset to create the baskets you want.
See documentation
Sponsors
This feature has been financed in a crowdfunding project by geostandards.ch, Canton of Schaffhausen and the QGIS Model Baker Group
Schema section in drop down
On PostgreSQL connections you are now able to select your schema.
Sponsors
This feature has been financed by the Canton of Schaffhausen
ili2db
Using ili2db version 5.0.1
Library
Using modelbaker library 1.6.0