[db-manager] Update sql dialog buttons status

elpaso · elpaso · commit c06c475b9cd4 · 2018-09-27T08:29:27.000+02:00
Fixes #19958 - Database manager allows one to create saved query with no name
diff --git a/python/plugins/db_manager/dlg_sql_layer_window.py b/python/plugins/db_manager/dlg_sql_layer_window.py
@@ -116,6 +116,10 @@ def __init__(self, iface, layer, parent=None):
         self.presetCombo.activated[str].connect(self.loadPreset)
         self.presetCombo.activated[str].connect(self.presetName.setText)
 
+        self.editSql.textChanged.connect(self.updatePresetButtonsState)
+        self.presetName.textChanged.connect(self.updatePresetButtonsState)
+        self.presetCombo.currentIndexChanged.connect(self.updatePresetButtonsState)
+
         self.updatePresetsCombobox()
 
         self.geomCombo.setEditable(True)
@@ -186,6 +190,12 @@ def __init__(self, iface, layer, parent=None):
     def getQueryHash(self, name):
         return 'q%s' % md5(name.encode('utf8')).hexdigest()
 
+    def updatePresetButtonsState(self, *args):
+        """Slot called when the combo box or the sql or the query name have changed:
+           sets store button state"""
+        self.presetStore.setEnabled(bool(self._getSqlQuery() and self.presetName.text()))
+        self.presetDelete.setEnabled(bool(self.presetCombo.currentIndex() != -1))
+
     def updatePresetsCombobox(self):
         self.presetCombo.clear()
 
