Allow to use a different pg service (or none) for substitution in project

[w0pr]

As of now, the pg service name used for installation is automatically set inside QGIS project file.

However, I use a service name (with prefix "SU") that has postgres superuser configured for installation/upgrade via TMMT, and a separate service name configured with tww_user for use in QGIS project, so I do not need to edit service config after installation.

It should be possible to have separate dropdown for configuring pg service for use in QGIS project file.

[ponceta]

@w0pr if you add a pg_tww_user configuration with user credentials, can you still download the project with the pg_tww_user set?

If not it means that you have for now to CTRL+H (search and replace pg_tww by pg_tww_user) in the project.

[ponceta]

Great enhancement proposal!

[ponceta]

Actually it is already possible with the current tool.

What is missing is maybe to edit a pg_service configuration directly from oQtopus/TMMT because otherwise you have to define your pg_tww_user configuration first then access to tww and download the project asset with the pg_tww_user selected but when you switch pg_service, it will switch the pg_service set into the QGIS project on download.

[w0pr]

Actually it is already possible with the current tool.

What is missing is maybe to edit a pg_service configuration directly from oQtopus/TMMT because otherwise you have to define your pg_tww_user configuration first then access to tww and download the project asset with the pg_tww_user selected but when you switch pg_service, it will switch the pg_service set into the QGIS project on download.

Interesting! But it is surprising and not obvious at all that you would need to change database connection after module install before clicking "Install template project" button...

I agree that TMMT is not for average user, but an explicit configuration option would make it obvious what is happening.

[ponceta]

I think if we tweak a bit the UI of the interface, we may set it more obvious. Main idea was not to set multiple time the same parameter / configuration.

You can do it any time (even before datamodel initialization) but as you mentioned in other issues the connection is maybe not the only parameter that datamodel, plugin and project could use (SRID would be a nice other example).

[w0pr]

I think if we tweak a bit the UI of the interface, we may set it more obvious. Main idea was not to set multiple time the same parameter / configuration.

You can do it any time (even before datamodel initialization) but as you mentioned in other issues the connection is maybe not the only parameter that datamodel, plugin and project could use (SRID would be a nice other example).

Yes, in plugin, it is possible to override default SRID in settings; you could enable and preset this setting to the SRID given in TMMT.
QGIS project is more involved, because not only "srid=xxxx" in layer datasource needs to be set, but also layer CRS (and probably project CRS).