[BUGFIX][DbManager] SQL Layer: fix unique combo setting in QGIS 3

rldhont · rldhont · commit 2eb22d93ff0c · 2018-10-25T09:30:59.000+02:00
When opening Update SQL layer, the unique combobox is not well set specifically with oracle. It's a forward porting of #7872 Funded by Ifremer
diff --git a/python/plugins/db_manager/dlg_sql_layer_window.py b/python/plugins/db_manager/dlg_sql_layer_window.py
@@ -177,9 +177,8 @@ def __init__(self, iface, layer, parent=None):
                         item.setCheckState(Qt.Checked)
             else:
                 keyColumn = uri.keyColumn()
-                for item in self.uniqueModel.findItems("*", Qt.MatchWildcard):
-                    if item.data() == keyColumn:
-                        self.uniqueCombo.setCurrentIndex(self.uniqueModel.indexFromItem(item).row())
+                if self.uniqueModel.findItems(keyColumn):
+                    self.uniqueCombo.setEditText(keyColumn)
 
         # Finally layer name, filter and selectAtId
         self.layerNameEdit.setText(layer.name())
