def pgUri(self):
"""QgsDataSourceURI for selected PostGIS DB"""
key = u"/PostgreSQL/connections/" + \
self.ui.cbDbConnections.currentText()
settings = QSettings()
settings.beginGroup(key)
uri = QgsDataSourceUri()
uri.setConnection(
settings.value("host", type=str), settings.value("port", type=str),
settings.value("database", type=str),
settings.value("username", type=str),
settings.value("password", type=str),
QgsDataSourceUri.SslMode(settings.value("sslmode", type=int)))
uri.setUseEstimatedMetadata(
settings.value("estimatedMetadata", type=bool))
return uri
